1 – DATA ANALYSIS IN EXCEL
- Classic Data Analysis with Excel
- Excel Pivot Tables
- Limitations of Classic Data Analysis
- Lab : Building a Classic Excel Dashboard
2 – THE EXCEL DATA MODEL
- Create Calculated Columns
- Format Data Model Data
- Create Measures
- Analyze the Data
- Lab : Explore an Excel Data Model
3 – IMPORTING DATA FROM FILES
- Importing Data into Excel
- Shaping and Transforming Data
- Loading Data
- Lab : Importing Data from a CSV File
4 – IMPORTING DATA FROM DATABASES
- Available Data Sources
- Previewing, Shaping, and Transforming Data
- Table Relationships and Hierarchies
- Loading Data
- Lab : Import Data from Multiple Sour
5 – IMPORTING DATA FROM EXCEL REPORTS
- Importing Data from Excel Reports
- Transforming Excel report Data
- Lab : Importing Data from a Report
6 – CREATING AND FORMATTING MEASURES
- DAX
- Measures
- Advanced DAX Functions
- Lab : Creating Measures using Advanced DAX Functions
7 – VISUALIZING DATA IN EXCEL
- Pivot Charts
- Cube Functions
- Charts for Cube Functions
- Lab : Data Visualization in Excel
8 – USING EXCEL WITH POWER BI
- Power BI
- Uploading Excel Data to Power BI
- Power BI Mobile App
- Lab : Creating a Power BI Dashboard with Excel