Drive Innovation
Empower your team to turn data into impactful business strategies.
Enhance Efficiency
Streamline data workflows and improve decision-making speed.
Stay Competitive
Keep your business ahead with advanced data visualization and reporting tools.
What is Power BI?
The Building Blocks of Power BI
The Power BI Desktop Interface
Important Information About Power BI Updates
The Power BI Web App
Opening Files
Saving Files
Creating a New File
Publishing to the Power BI Web App
Connecting to an Excel Workbook
Connecting to an Access Database
Viewing All Connection Options
Creating a Manual Dataset
Managing Data Sources
Power BI Data Types
Making data fitted to the Data Model
Discovering different Data Formats
Overview of Power Query
Benefits of using Power Query
Differences between Power Query and other data extraction tools
What is Data Transformation?
Role of Power Query in Data Transformation
Basic Transformation through Data types, Filters, and Removing Columns
Using Power Query functions (text, date, time, number, etc.)
Implementing custom functions in Power Query
Grouping and aggregating data
Using conditional transformations
Unpivoting and pivoting data
Dealing with large data sets and performance optimization
Consolidate Excel or CSV files using “From Folder” source
Extracting data from APIs using Power Query
Web scraping using Power Query
Extracting and Linking from PDF
Dealing with complex data structures
Using the Relationships View
Creating Relationships
Editing Relationships
Deleting Relationships
Using the Manage Relationships Dialog
Overview of DAX, its syntax, and structure
Understanding the role of DAX in data analysis and reporting
Creating a New Calculated Column
Creating a New Measure
Using DAX functions for data manipulation and aggregation
Overview of Visualization
Introduction on Report Pages
Adding Table and Matrix
Adding a Column Chart
Configuring Visualization
Introduction to Visual Interactions
Turning Interactions On and Off
Interacting by Filtering, Highlight or None
Working with Filters
The Filter pane
Slicers
Reports to Dashboards
Pin Visualizations
Refreshing Dashboard
Defining Hyperlinks
Using Bookmarks for more
Interactions
Log in to Microsoft 365 and access Power BI Service (Fabric)
Explore the Power BI Service Environment
Publishing Power BI Report
Sharing your Power BI Report
August 27 to 28
September 30 to October 1
November 25 to 26
December 19 to 20
