Corporate Training for Power BI - Online class

Module 1:- Introduction to Power BI

What is Data Analytics & Data Visualization
- Introduction to Data Analysis
- Introduction to Data Visualization
- What is Business Intelligence?
- Overview of Self-Service Business Intelligence (SSBI) Tools
- Leading Self-service tools
- Comparison of Leading Visualization Tools
Getting Started with Power BI
- Introduction to Microsoft Power BI
- Why Power BI
- Power BI Elements
- Basic Components of Power BI
- Building Blocks of Power BI
- Key Benefits of Power BI
Hands-On
- Power BI Installation
Skills Gained
- Understanding of Data Analysis & Visualizations
- Concepts of Business Intelligence
- Installing Power BI on the System
- Elements and Building Blocks of Power BI

Module 2:- Getting Data from Different Data Sources

Power Bi Desktop (Getting Data)
- What is Power BI Desktop
- Quick Walk-through Power BI Interface
- Views in Power BI Desktop
- Report View
- Data view
- Model view
- Understanding ETL Concepts: Extract, Transform & Load
- Data Sources in Power BI Desktop
- Connecting and Getting data from different sources in Power BI
- Getting data from Excel, CSV, Access, etc
- Saving Workfile
Hands-On
- Identifying and retrieving data from different data sources
- Extracting and Loading data into Power BI
- Preparing Data
Skills Gained
- Concepts of ETL tool
- Getting data from multiple sources

Module 3:- Clean, Transform and Load the Data

Shaping Data using Power Query
- Loading data into Power BI Desktop
- What is Query Editor
  - Cleaning Data with Query Editor
- Transforming Data with Query Editor
  - Unpivoting Columns
  - Eliminating Rows / Columns
  - Changing / Modifying Data Types
  - Adding Custom Columns
  - Replacing Values / NULL
  - Promoting / Demoting Row as Header
  - Modifying and managing existing ‘Steps’
- Extracting Date Components from Date-Time
- Introduction to “M Query”
- Combining Data
  - Append Merge / Joins, Transpose & Formatting Data Operations
- Hands-On
  - Cleaning Data using Power Query Editor
  - Shaping the data
  - Transforming and cleaning the data
  - Merging Rows / Columns from multiple tables
  - Joins / Append activities
- Skills Gained
  - Data Transformation using Query Editor
  - Loading the data
  - Understanding of “M Query”

Module 4:- Design a Data Model

Introduction to Data Modeling
- Understanding of Relationship
  - What is Relationship?
  - One to Many Vs One to One Relationship
- Auto-Detect Relationship during Load
- Dimension Table Vs Fact Table
- Cardinality in Data Modeling
- Creating Relationship Manually
- Managing Data Relationship
- Editing Relationship
- Creating Calculated Columns
- Creating Measures
- Optimizing Data Models for Better Visuals
- Cross Filter Direction
- Defining Hierarchies

Hands-On
- Creating Model Relationships
- Managing Relationships
- Creating Measures
- Creating hierarchies

Skills Gained
- Understanding the basics of data modeling
- Defining relationships and their cardinality
- Understand star schema and its’ importance
- Managing relationships

Module 5:- DAX Formulas & Calculations

Introduction to Data Analysis Expression (DAX)
- Importance of DAX
- Data Types in DAX
- Defining Calculation Type
  - Calculated Column Vs Calculated Measures
  - Adding New Measures to Report
  - Creating Calculated / DAX Tables
- DAX Syntax & Operators
- Most Important & Common Basics & Advanced DAX Functions
  - Aggregate Functions
  - Logical Functions
  - Time-Intelligence Functions
  - Information Functions
- DAX Variables
- Formatting DAX Code
- Handling Errors in DAX Expressions
Hands-On
- Creating Calculated Tables
- Creating Calculated Columns and Measures
- Writing DAX calculations to perform Data Analysis
- Beautifying DAX
- Creating Variables
Skills Gained
- Understanding DAX
- Create Calculated Columns, Measures & Tables
- Working with Advanced functions e.g. Time-Intelligence, Filter contexts etc.

Module 6:- Data Visualization & Creating Reports

Introduction to Visuals in Power BI
- Creating Visualization
- How to use Visual
- Exploring Visualizations’ List
- Exploring Most Common & Important Visualizations
  - Bar, Column, Line and Area Charts
  - Pie, Donut, and Gauge Charts
  - Single Number Cards and Multi Row Cards
  - Table & Matrix Visuals
  - Combo Chart, Funnel and Treemap Charts
  - Slicer, KPI and Custom Visuals
  - Map & Filled Map Visuals
- Modifying Color Properties of Charts and Visuals
- Shapes, Text Box, Buttons, and Images
- Types of Filters
- Slice and Dice Data in Power BI
- Drilling-Up/Down
- Understanding Custom Visuals & How to add them
- Customizing Canvas
  - Setting up Canvas & Must Know Global Fonts
  - Page Layout & Formatting
- Bookmarks in Power BI
- Reports in Power BI
- Conditionally formatting tables/matrixes
- Activity: Creating Sales Report
Hands-On
- Creating visual and charts
- Designing a report
- Managing visual fields and format properties
Skills Gained
- Creating and selecting effective visualizations
- Designing report page layout and Visual modification
- Adding report navigation & basic functionalities
- Creating visually stunning reports

Module 7:- Power BI Service and Managed Workspaces

Introduction to Power BI Service & Workspaces
What is Power BI Service
- Exploring Interface of Power BI Service
- Understanding the Admin Portal settings
What is Power BI Workspace
- Understanding of “Workspace”
- My Workspace Vs New Workspace
- Creating New Workspace
- Sharing and Managing Workspaces
Roles in workspaces in Power BI
Exploring Power BI Licensing
- Power BI Free Vs Power BI Pro Vs Premium
Hands-On
- Publishing reports on Power BI Service
- Creating workspaces
- Sharing and Managing Reports
- Moving important assets to App and Publishing app in Power BI
Skills Gained
- Knowledge of Power BI Service (Cloud)
- Workspaces in Power BI
- Creating and managing a workspace

Module 8:- Creating Dashboard in Power BI

Dashboard in Power BI
- Introduction to Dashboard
- Difference between Report Vs Dashboard
- Preparing and Creating Dashboard
  - Configuring a Dashboard
  - Pinning Visuals to Dashboard
- Dashboard Tiles
  - Pinning Tiles
- Dashboard Widgets
- Introduction to Power BI Q&A
  - Asking questions about data
  - Fetching results using Q&A
  - Using Q&A to create a dashboard tile
- Quick Insights in Power BI
  - Data Analysis using Quick Insights
- Sharing and Collaborating Dashboard with Business Users
Hands-On
- Creating a Dashboard
- Pinning visuals to Dashboard
- Adding text/video widgets to Dashboard
- Sharing and Moving Dashboard to distributed app
- Use of Power BI Q&A to question your data
Skills Gained
- Dashboard creation from report
- Enhancing dashboard usability
- Importance of Q&A and Quick Insights

Module 9:- Data Gateway, Security & Schedule Refresh

Report Security in Power BI
Introduction to Row-level Security (RLS)
- Setting up and Enforcing Row-level security
- Implementing Row-level security
Data Gateway & Report Scheduling
- What is Data Gateway
- Types of Gateway
  - On-premises data gateway (personal mode)
  - On-premises data gateway (standard mode)
- Installing Data Gateway
- Data Gateway System Requirement
- Benefits of Data Gateway
- Scheduled Refresh & Refreshing Data
- Managing Data Source
  - Adding and removing a Data Source
- Hands-On
  - Configuring & Implementing RLS
  - Managing datasets
  - Setting up On-Premise Data Gateway
  - Connecting Reports on Power BI Cloud with Local Data Files
  - Schedule dataset refresh
- Skills Gained
  - Dashboard creation from report
  - Enhancing dashboard usability
  - Importance of Q&A and Quick Insights

Bonus Module:- In-Class Project

In-Class Project: Building Sales Report & Dashboard from Scratch
- Extracting Data from the Local Source
- Transforming Data using Power Query
  - Cleaning, Shaping and Preparing the data if necessary
- Loading Data to Power BI Desktop
- Building Data Model
- Visual and Charts
- Row-level Security
- Publishing Reports
- Power BI Service
- Creating Dashboard
Hands-On
- Analyzing Sales data
- Derive conclusions from the patterns and trends shown in the visualization
Skills Gained
- Report and Dashboard creation
- Publishing, sharing, and collaborating with Business users

We would require 4 full days to cover all the above-mentioned content. We can connect over the call to understand the Power BI Workshop.

Gallery (49)

+42 more

About the Trainer

4.9 Avg Rating

67 Reviews

151 Students

7 Courses

Anil Dhawan

BA and MCA*

12 Years of Experience

A professional Excel Trainer and having 10+ years of experience as MIS/Data/Business Analyst and have been training since last 4-5 years. I have various applications knowledge i.e. Excel, SFDC, Business Object, Google Analytics, Webmaster, DFP, AdSense, VBA out of which I have strong grip over Excel/VBA/Google Analytics. I have trained over 50+ working professionals and given On Job Training during my stay at Google, Alcatel Lucent and couple of Real-Estate firms.

Courses that I have designed are especially for corporate people and freshers who want to appear for Excel/MIS/Data Analyst profiles. The examples, situations and material have been used from my past working experience that I tried collaborating it in one place for you to Make You Good in Excel and Informative. Post every session you get study material and session study material to practice and "Make Excel Your Power".