Data Analysis in Excel

• Classic Data Analysis with Excel
• Excel Pivot Tables
• Limitations of Classic Data Analysis
• Lab : Building a Classic Excel Dashboard
• Formatting Data
• Building a Pivot Table
• Adding pivot charts and a slicer

The Excel Data Model

• Using an Excel Data Model
• DAX
• Lab : Explore an Excel Data Model
• Create Calculated Columns
• Format Data Model Data
• Create Measures
• Analyze the Data

Importing Data from Files

• Importing Data into Excel
• Shaping and Transforming Data
• Loading Data
• Lab : Importing Data from a CSV File
• Import and Transform Data from a CSV File
• Add Data from a Folder

Importing Data from Databases

• Available Data Sources
• Previewing, Shaping, and Transforming Data
• Table Relationships and Hierarchies
• Loading Data
• Lab : Import Data from Multiple Sources
• Import Data from SQL Server
• Import Data from a CSV File
• Create a Data Table

Importing Data from Excel Reports

• Importing Data from Excel Reports
• Transforming Excel report Data
• Lab : Importing Data from a Report
• Import Data from Excel
• Transform the Excel Data
• Load the Data into an Excel Data Model

Creating and Formatting Measures

• DAX
• Measures
• Advanced DAX Functions
• Lab : Creating Measures using Advanced DAX Functions
• Last year comparison
• Year to date
• Market Share

Visualizing Data in Excel

• Pivot Charts
• Cube Functions
• Charts for Cube Functions
• Lab : Data Visualization in Excel
• Create a Tabular Report
• Create a Pivot Chart
• Add Slicers to Charts

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
• Uploading Excel Data
• Creating a Power BI Dashboard
• Using Power BI desktop