➢ Power BI
➢ Power BI for Desktop
➢ Working with Text, CSV and Excel Worksheets
➢ Connecting to the Database
➢ Merging, Grouping, Summarizing and Calculating
➢ Reporting
➢ Power BI online
Course Outline
Lesson No 1: Course Overview
- Lesson No 2: Power BI
- What is Power BI
- Examining Power BI Suite of Products
- Identifying Differences Between Products
- Understanding Power BI Updates
Lesson No 3: Power BI
- Installing Power BI for Desktop
- Exploring the Power BI for Desktop
- Utilizing File Types PBIX Vs PBT
- Examining Data Sources
- Discussing Data Refresh
- Understanding Data Types
Lesson No 4: Working with Text, CSV, Excel Sheets
- Importing Transforming and Loading Data
- Appending Operations
- Working with Folders and Files
- Using Pivot Table
Lesson No 5: Connecting to Database
- Working with Relational Data
- Understanding Relationships
- Importing from SQL Server Analysis Services Multidimensional and Tabular
Lesson No 6: Merging, Grouping, Summarizing and Calculating Data
- Understanding the issues with Merges
- Performing Merges
- Group Merges
- Summarizing & Calculating
Lesson No 7: Reporting
- Create Reports
- Utilization of the Matrix Visualization
- Utilizing the Map Visualization
- Utilizing the Card Visualization
- Utilizing the Chart Visualization
- Utilizing Slicers
- Publishing to Power BI Online
Lesson No 8: Power BI Online
- Introduction to Power BI Online
- Importing Data
- Creating Reports
- Configuring Dashboard
- Sharing Reports and Dashboard
- Exploring Power BI Mobile
