➢ 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