Professional Program in

Power BI

Case Studies & Assignments

  • Workshop Study Material (Shared with all participant, Workshop Live Case Studies and Multiple sample databases with live case studies along with real- life situations

Delivery Mode

  • Classroom Sessions & Online Sessions

 

Students Benefits

  • Key focus on Hands-on, practical, and projects
  • After every class, you will get assignments & session recordings
  • Flexibility to re-attend the Live Sessions
  • MNC’s are giving preference to those candidates who are having the knowledge of Power BI, you will create a lot of opportunities for yourself after completing this course
  • Companies are offering an average salary for a Data Analyst with Microsoft Power BI skill is Rs. 5-6 lacs / Year & on an average get a 30- 40% hike on their

Program Overview

Module 1

Module 2

Module 3

Module 4

Module 5

Module 6

Module 7

Module 8

Module 9

Business Intelligence (BI) Concepts

Microsoft Power BI (MSPBI) Introduction

Connecting Power BI with Different Data Sources

Power Query for Data Transformation

Data Modelling in Power BI

Reports in Power BI

Reports & Visualization Types in Power BI

Dashboards in Power BI

Reports & Visualization Types in Power BI

02 Hours

0.5 Hour

02 Hours

02 Hours

2.5 Hours

02 Hours

03 Hours

02 Hours

01 Hour

Module 1:

Module 2:

Business Intelligence Concepts

MSPBI Introduction

  • Introduction to Business Intelligence
  • The Importance of Business Intelligence
  • The relation between Business Intelligence and Data Warehouse
  • Tools and Technologies in Business Intelligence area
  • Power BI Architecture
  • Power BI Introduction and Overview
  • Introduction Power BI Desktop and Power BI in Excel

Module 3:

Module 4:

Connecting with Different Data Sources

Power Query for Data Transformation

  • Connect to CSV files in Power BI Desktop
  • Connect to Excel in Power BI Desktop
  • Connect to text in Power BI Desktop
  • Connect to SQL Server in Power BI Desktop
  • Connect to a Web page from Power BI Desktop
  • Connect to Direct SQL Query in Power BI Desktop
  • Power Query Introduction
  • Query Editor
  • Query Editor Interface
  • Column Transformations
  • Data Type
  • Adding Column
  • Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
  • M built-in functions

Module 5:

Module 6:

Data Modelling in Power BI

Reports in Power BI

  • Introduction to DAX
  • Calculated Columns
  • Measures Calculated Tables
  • Row Context vs Set Context
  • Advanced calculations using Calculate functions
  • Time Intelligence Functions
  • Create a new Power BI report
  • The report editor in Power BI
  • Add a page to a Power BI report
  • Add a filter to a report in Power BI
  • Save a report in Power BI
  • About filters and highlighting in Power BI reports
  • How to use report filters Analyse in Excel
  • Change how visuals interact in a report
  • Open a Power BI report in Reading View
  • Go from Reading View to Editing View in Power BI
  • Interact with a report in Editing View in Power BI
  • Aggregates (sum, average, maxi, ) in Power BI
  • Rename a report in Power BI
  • Page display settings in a Power BI report
  • Duplicate a report page in Power BI
  • Delete a page from a Power BI report
  • Rename a report page

Module 7:

Module 8:

Reports & Visualization Types in Power BI

Dashboards in Power BI

  • Types of visualization in a Power BI report
  • Custom visualization to a Power BI report
  • Download a custom visual from the gallery
  • 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
  • Histograms
  • Basic Area chart
  • Combo Chart in Power BI
  • Customize visualization title, background, and legend
  • Customize X-axis and Y-axis properties
  • Doughnut charts in Power BI
  • Enhanced Scatter charts in Power BI
  • Funnel charts in Power BI
  • KPI Visuals
  • Radial Gauge charts in Power BI
  • Scatter Charts in Power BI
  • Slicers in Power BI
  • Tree Maps in Power BI
  • Waterfall charts in Power BI

 

 

  • Create a Power BI dashboard
  • Dashboard tiles in Power BI
  • Pin a tile to a Power BI dashboard from a report
  • Power BI publisher for Excel
  • Pin an entire report page to a Power BI dashboard
  • Data alerts in Power BI service
  • Add an image, text box, video, or web code to your dashboard
  • Edit a tile — resize, move, rename, pin, delete, add hyperlink
  • Tips for designing a great Power BI dashboard
  • Print a dashboard, print a dashboard tile, print a report page
  • Display dashboards and reports in Full Screen mode (TV mode)
  • Display a dashboard tile in Focus mode
  • Featured dashboards in Power BI
  • Create a phone view of a dashboard
  • Add an image to a dashboard

Module 9:

Reports & Visualization Types in Power BI

  • Configure scheduled refresh
  • Refresh a dataset created from a Power BI Desktop file – local
  • Refresh a dataset created from a Power BI Desktop
  • file – cloud
  • Refresh a dataset created from an Excel workbook –
  • local
  • Disable privacy settings

Learning Outcomes

  • Proficient in PowerBI
  • Having good command on the Functions
  • Skilled in number and different formatting types
  • Capable of handling the large data
  • Power BI is useful to become a Master of Business intelligence
  • Transform data into decision making visualize report
  • Develop Intrinsic Understanding of How Table Calculations Work
  • Efficiently work for operation
  • Easy to learn and use of Advanced Mapping Techniques
  • Understand Data/KPIs and Importance of Business
  • Intelligence
  • Highly Interactive and Geo Map Visualization
  • Consolidate Information into One Manageable Figure
  • Any type of Charts Can Create Easily
  • Power BI works proficiently on real life business
  • problems