Module 1: Data Analysis in Excel
This module looks at the classic Excel dashboard and at ways to extend it.
Lessons
- 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
Module 2: The Excel Data Model
This module looks at the classic Excel data model and at ways to extend it.
Lessons
- Using an Excel Data Model
- DAX
Lab : Explore an Excel Data Model
- Create Calculated Columns
- Format Data Model Data
- Create Measures
- Analyze the Data
Module 3: Importing Data from Files
This module looks at pre-formatting and importing CSV files.
Lessons
- 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
Module 4: Importing Data from Databases
This module looks at how to import data into Excel from a SQL Server database.
Lessons
- 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
Module 5: Importing Data from Excel Reports
This module describes how to import data from a report.
Lessons
- 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
Module 6: Creating and Formatting Measures
This module describes how to create and format measures.
Lessons
- DAX
- Measures
- Advanced DAX Functions
Lab : Creating Measures using Advanced DAX Functions
- Last year comparison
- Year to date
- Market Share
Module 7: Visualizing Data in Excel
This module describes how to visualize data in Excel.
Lessons
- Pivot Charts
Lab : Data Visualization in Excel
- Create a Pivot Chart
- Add Slicers to Charts
Module 8: Using Excel with Power BI
This module describes how to use Excel with Power BI.
Lessons
- 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
Module 9: Introduction to Self-Service BI Solutions
Introduces business intelligence (BI) and how to self-serve with BI.
Lessons
- Introduction to business intelligence
- Introduction to data analysis
- Introduction to data visualization
- Overview of self-service B
- Considerations for self-service BI
- Microsoft tools for self-service BI
Lab : Exploring an Enterprise BI solution
- Viewing reports
- Creating a Power BI report
- Creating a Power BI dashboard
Module 10: Introducing Power BI
This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations.
Lessons
- Power BI
- The Power BI service
Lab : Creating a Power BI dashboard
- Connecting to Power BI data
- Create a Power BI dashboard
Module 11: Power BI
At the end of this module students will be able to explain the rationale and advantages of using Power BI.
Lessons
- Using Excel as a data source for Power BI
- The Power BI data model
- Using databases as a data source for Power BI
- The Power BI service
Lab : Importing data into Power BI
- Importing Excel files into Power BI
- Viewing reports from Excel files
Module 12: Shaping and Combining Data
With Power BI desktop you can shape and combine data with powerful, buil-in tools. This module introduces the tools that are available for preparing your data, and transforming it into a form ready for reporting.
Lessons
- Power BI desktop queries
- Shaping datal
- Combining data
Lab : Shaping and combining data
- Shape power BI data
- Combine Power BI data
Module 13: Interactive Data Visualizations
This module describes how to create and manage interactive data visualizations.
Lessons
- Creating Power BI reports
- Managing a Power BI solution
Lab : Creating a Power BI report
- Connecting to Power BI data
- Building Power BI reports
- Creating a Power BI dashboard
IP15BIGDATA25020016 