Microsoft Power BI Course#
A brief summary of the topics covered in this Power BI course is as below. This is 16 hours course, it is suggested to complete this course within 1 week.
Introduction and Installation#
- Power BI introduction and overview
- Key Benefits of Power BI
- Power BI Architecture
- Power BI – Building Blocks
- Power BI vs other BI tools
- Power Installation
- Overview of Power BI Desktop
- Power BI Mobile
Introduction to Interface#
- Data Sources in Power BI Desktop
- Connecting to a data Sources
- Query Editor in Power BI
- Views in Power BI
- Field Pane
- Visual Pane
- Custom Visual Option
- Filters
Connecting to Different Sources#
- Introduction to using Excel data in Power BI
- Import Power View and Power Pivot to Power BI
- Import data from various sources into PowerBI
- Exploring live connections to data with Power BI
- Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL
Building Reports in Power BI#
- Power Query Introduction
- Query Editor Interface
- Clean and Transform your data with Query Editor
- Data Type
- Column Transformations vs Adding Colums
- Text Transformations
- Cleaning irregularly formatted data -Transpose
- Date and Time Calculations
- Advance editor: Use Case
- Query Level Parameters
- Combining Data – Merging and Appending
- Time Intelligence Functions
- Types of visualization in a Power BI report
- Custom visualization to a Power BI report
- Matrices and tables
- Getting started with color formatting and axis properties
- Change how a chart is sorted in a Power BI report
- Move, resize, and pop out a visualization in a Power BI report
- Drill down in a visualization in Power BI
DAX & PowerBI#
- What is DAX?
- Why is DAX important?
- Calculated Columns
- Measures/New Quick Measures
- Calculated Tables
- Optimizing Data Models
- Row Context vs Set Context
- Cross Filter Direction
- Advanced calculations using Calculate functions
- DAX queries
- DAX Parameter Naming
- Data Acquisition and Transformation in Power BI
PowerBI Online#
- Power BI Service
- Power BI Workspace
- Power BI Publish
- Reports in Power BI Service
- Creating Dashboards
- Publishing Reports and Scheduling Data Refresh
- Security, Share PowerBI Reports, Dashboards.
- Accessing Power BI on Mobile
Comments: