Excel Data Analysis Course Content
⊕ Expand full topic list
Unit 1: Introduction to Get and Transform
- Link External Data to Power Query
- Understand the Power Query Editor
- Use the Query Settings
- Apply Query Options
- Import Data into the Data Model
- Edit an Existing Query
⊕ See more
Unit 2: Importing Data with Power Query
- Understand the Database Query Editor
- Review Data Downloaded from a Database
- Import Data from Text Files
- Import Data from a Folder
- Import Data from Excel Files
- Work with Data from the Current Workbook
- Import Data from an Access Database
- Import Data from the Web
⊕ See more
Unit 3: Transforming Data in Power Query
- Name Columns
- Remove Columns
- Split Columns
- Merge Columns
- Set Column Data Types
- Filter Rows
- Filter Row Ranges
- Remove Duplicate Values
- Filter Out Rows with Errors
- Sort Columns
- Change Values in a Table
- Use Text Transformations
- Use Fill Up and Fill Down to Replace Missing Values
- Aggregate Values
- Calculate Values in Custom Columns
- Duplicate Columns
- Unpivot Columns to Rows
- Merge Queries
⊕ See more
Unit 4: Importing Data into Power Pivot
- Load Data from a Server Database
- Preview and Filter a Table
- Write Queries to Select Data from a Database
- Load Views from a Database
- Load Tables from an Access Database
- Load Data from Text Files
- Load Data from Excel Files
- Load Data from an Excel Table
⊕ See more
Unit 5: Data Model Relationships
- Create Table Relationships (Joins)
- Manage Relationships
- View Relationships
⊕ See more
Unit 6: Transforming Data in Power Pivot
- Rename Tables
- Delete Tables
- Move a Table
- Freeze and Unfreeze Columns
- Hide Columns
- Filter Columns
- Sort Columns
- Sort a Column Based on Another Column
- Hide Tables
- Create a Hierarchy
- Alter Table Behaviour
⊕ See more
Unit 7: Power Query and Power Pivot Compared
- Understand the Difference between Power Query and Power Pivot
⊕ See more
Unit 8: DAX Calculated Columns
- Create a Concatenated Column
- Create a Calculated Column
- Use the RELATED Function
- Complete a Practice Task
- Create a Hierarchy
- Calculate across Tables
- Use the RELATEDTABLE and COUNTROWS Functions
- Use the IF and ISBLANK Functions
⊕ See more
Unit 9: DAX Measures and Metrics
- Create a Count Measure
- Create Measures across Multiple Tables
- Use the SUMX Function
- Filter with the CALCULATE Function
- Use the FILTER Function
⊕ See more
Unit 10: DAX Time Intelligence Calculations
- Create a Calendar Table
- Create Calendar Values
- Calculate Year-to-Date Sales
- Calculate Month-to-Date Sales
⊕ See more
Unit 11: Reporting on the Data Model
- Create a PivotTable from the Data Model
- Use Measures in a PivotTable
- Create a PivotChart from the Data Model
- Filter Reports with Slicers and Timelines
⊕ See more
Unit 12: 3D Maps
- Open 3D Maps
- Add Geocodes to a 3D Map
- Navigate a 3D Map
- Add Values to a 3D Map
- Add Categories to a 3D Map
- Add a Time Dimension to a 3D Map
- Filter a 3D Map
- Play a Tour
⊕ See more