Course Overview

The Power BI Course is designed to provide participants with a comprehensive understanding of Microsoft Power BI, a powerful business analytics tool used to visualize and analyze data from various sources.

Course Objectives

By the end of the course, participants will be able to:

• Gain a solid understanding of Power BI concepts, components, and architecture.
• Learn how to connect to and import data from different sources into Power BI.
• Develop skills in creating visually appealing reports using Power BI's easy interface.
• Learn to use Power BI's powerful data visualization features to present data effectively.
• Learn how to publish, share reports to a broader audience.

Who Should Attend? 

• This course is suitable for individuals and professionals who want to enhance their data analysis and reporting skills, as well as those interested in leveraging Power BI for business intelligence purposes.
• Someone who has no experience with Power BI.

Prerequisites

• Basic knowledge of MS Excel.

Course Contents

Introduction to Power BI

• Overview of Power BI and its flow
• Power BI Architecture
• Power BI Components
• Power BI License
• Chapter Quiz

Getting Started with Power BI

• Installation and setup
• Connecting to data sources
• Exploring the Power BI interface

Visualizing Data with ReportsModule 1

• Creating your First Clustered Column Chart
• Exploring detailed options of Column Chart
• Working with Bar & Pie Chart & Understanding its options
• Creating Amazing Line Chart
• Pro Tip: Creating Stepped Line Style

Module 2

• Creating Cards for KPI
• Tree Map

Module 3 (Slicing and Dicing)

• Adding Interactive Slicers for Reports

Module 4

• Updating & Refreshing Data
• Understanding Edit interactions
• Adding Animated Scroller & Country Flags

Module 5

• Adding Date (Year & Quarter) Slicer
• Creating Reset Filter Button

Module 6

• Adding Decomposition Tree

Module 7

• Tables & Metrics
• Adding Conditional Formatting

Module 8

• Q&A (Use Natural Language to Explore Data)

Module 9

• Project à Creating Interactive Dashboard with Customize Background

Module 10 (Sharing and Collaboration)

• Publishing reports Online on Power BI Service
• Sharing and collaborating on reports
• Viewing Published Report on Mobile App

Module 11 (Creating Maps)

• Creating Maps
• Creating Filled Map

Module 12 (Funnel Chart)

• Pasting Data Manually without Importing
• Creating Funnel Chart

Module 13 (Understanding Filters Level)

• Visual Level
• Page Level
• Report Level

Module 14

• Getting Top 5 Employees

Module 15

• Creating Secondary Axis Chart

Module 16

• Creating Magic with Bookmarks

Module 17

• Understanding Drill through Reports

Module 18

• Creating Subscription in Power BI Service

Module 19 (Workspace)

• Creating New Workspace
• Publishing reports in Workspace

Module 20 (Power Query – Cleaning Messy Data)

• Importing Messy Data in Power Query
• Exploring Power Query Editor
• Transforming & Cleaning data with Power Query
• Common data cleansing activities with Power Query
• Combining Columns, Changing Case & Fixing Date issue
• Unpivot Data (Converting Summarized data into Flat file for detailed Analyse)
• Combining Data from Multiple tables
• Combining Multiple Files & creating reports
• Adding Conditional Column using IF Condition
• Challenging & Complex Data Cleaning Project