What you will learn
- Master the basics of Power BI, including data loading and modelling.
- Create compelling data visualizations and interactive dashboards.
- Implement advanced data transformations using Power Query.
- Develop proficiency in DAX for complex calculations and analysis.
- Utilize Power BI Service for report sharing and collaboration.
- Integrate Power BI with external data sources and automate data refresh.
Beneficial for
- Data Analysts
- Business Intelligence Professionals
- Data Scientists
- Anyone looking to harness the power of Power BI for data visualization.
Course Pre-requisite
- Familiarity with Microsoft Excel is beneficial.
- Basic understanding of data analysis concepts.
Course Outline
Overview of Power BI and its components
Setting up Power BI Desktop and Power BI Service
Understanding the Power BI ecosystem
What is Power BI?
Examining Power BI Suite of Products
Identifying Differences Between Products
Understanding Power BI Update
Installing Power BI Desktop
Exploring the Power BI Desktop Interface
Utilizing File Types; PBIX vs PBIT
Examining Data Sources
Discussing Data Refresh
Understanding Data Types
Importing, Transforming, and Loading Data
Appending Operations
Working with Folders and Files
Using Pivot Tables
Working with Relational Data
Understanding Relationships
Importing from SQL Server Analysis Services Multidimensional and Tabular
Understanding the Issues with Merges
Performing Merges
Grouping Options
Summarizing
Calculating
Creating Reports
Utilizing the Matrix Visualization
Utilizing the Map Visualization
Utilizing the Card Visualization
Utilizing the Chart Visualization
Utilizing Slicers
Publishing to Power BI Online
Introduction to Power BI Online
Importing Data
Creating Reports
Configuring Dashboards
Sharing Reports and Dashboards
Exploring Power BI Mobile
