Course Outline for Microsoft Power BI

Goal:

The goal of this Microsoft Power BI course is to provide a sound understanding of business intelligence, data analytics, data modelling, dashboard creation, and reporting using Power BI.

Audience:

This course is designed for learners who want to gain knowledge and build a career in business intelligence, data analytics, reporting, and dashboard development.

Pre-requisites:

Any graduate or postgraduate can enroll. No prior coding experience is required.

Duration:

40 hours

Course Content

Introduction to Power BI

• Introduction to Business Intelligence (BI)
• Stages of Business Intelligence
• Use cases of BI
• Overview of various BI tools
• Tableau vs. Power BI
• Introduction to Power BI
• Why Power BI?
• Power BI components
• Power BI pricing structure
• Building blocks of Power BI
• Architecture of Power BI
• Introduction to Power BI Desktop
• Installation of Power BI Desktop

Data Extraction

• Overview of Power BI Desktop
• Data sources in Power BI
• Using files such as Excel, PDF, CSV, and text files as data sources
• Using SaaS connectors
• Extracting data from folders and databases

Data Transformation: Shaping and Combining Data

• Introduction to Power Query Editor
• Formatting data
• Transforming data
• Understanding data types
• Working with parameters
• Merging queries
• Appending queries
• Transposing data
• Using fill options
• Pivoting and unpivoting data
• Creating custom columns
• Creating conditional columns
• Replacing data in tables
• Splitting column values
• Moving columns and sorting data
• Detecting data types, counting rows, and reversing rows
• Promoting rows as column headers
• Introduction to M Query

Data Modelling and DAX

• Introduction to relationships
• Creating relationships
• Understanding cardinality
• Cross-filter direction
• Using inactive relationships
• Introduction to DAX
• Why DAX is used
• DAX syntax
• DAX functions
• Understanding context in DAX
• Calculated columns using DAX
• Measures using DAX
• Calculated tables using DAX
• Table, information, logical, text, and iterator functions
• Time intelligence functions such as YTD, QTD, and MTD
• Cumulative values, ranking, and ranking over groups
• Date and time functions
• Identifying poorly performing measures, relationships, and visuals
• Advanced DAX features

Data Visualization

• Creating maps
• Changing report backgrounds
• Creating India maps
• Creating Australia maps
• Using tables and matrices
• Adding subtotals and totals in matrices
• Creating charts in Power BI Desktop
• Using cards and filters
• Using slicers in Power BI
• Creating advanced charts in Power BI

Power BI Service

• Introduction to Power BI Service
• Introduction to workspaces
• Creating dashboards
• Configuring dashboards
• Applying dashboard themes
• Publishing reports to Power BI Service
• Sharing reports and dashboards
• Managing permissions and access
• Scheduled refresh overview

Advanced Power BI

• Introduction to Data Gateway
• Installation and configuration of data gateways
• Introduction to Power BI Embedded
• Introduction to Power BI API
• Introduction to Power BI Mobile
• Power BI use cases
• Final dashboard project