Comprehensive Course on Power BI

Languages
English + Hindi
Duration
40 hours
Request Training Proposal

Course Contents

​Learn Microsoft Power BI end-to-end.

  1. INTRODUCTION TO POWER BI
    • Download Data files first
    • Import data from CSV files
    • Import data from Excel files
    • Import data from Web 1
    • Import data from Web 2
    • Import Data from Folder
    • Dataflows - Introduction
    • Dataflows - Create Gateway from Scratch
    • Dataflows - Create Entities from CSV file
  2. Power Query: Prep, Clean & Shape Data
    • Download resources for this section.
    • Remove Rows
    • Remove Columns
    • Make first row as headers
    • How to create calculate columns
    • How to remove duplicates
    • Unpivot columns and split columns
    • Change Data type, Replace Values and Rearrange 1
    • Append Queries
    • Merge Queries
  3. POWER BI VISUALS
    • Visuals Intro
    • Visuals-Bar Charts
    • Visuals-Line Charts
    • Visuals-Pie Chart
    • Stacked bar Chart
    • Clustered Column Chart
    • Visuals-Area Chart and Analytics Tab Explained-0
    • Visuals-Area Chart and Analytics Tab Explained-1
    • Visuals-Combo Chart
    • Visuals-Scatter Chart
    • Visuals-Treemap Chart
    • Visuals-funnel Chart
    • Visuals-Card and Multi-Row Card
    • Visuals-Gauge Card
    • Visuals-KPIs
    • Visuals-Matrix
    • Visuals-Table
    • Visuals-Text boxes - Shapes - Images
    • Visuals-Slicers
    • Visuals-Maps
    • Custom Visuals - Word Cloud
    • Visualization interactions
  4. DATA MODELING IN POWER BI
    • Our First Report-0
    • Our First Report-1
    • Our First Report-2
    • Our First Report-3
  5. Publishing and Sharing your first report
    • Theme Download file
    • Modeling Basics-0
    • Modeling Basics-1
    • Modeling Basics-2
    • Modeling and Relationships-0
    • Modeling and Relationships-1
    • Other ways to create Relationship
    • Normalization - Denormalization-0
    • Normalization - Denormalization-1
    • OLTP vs OLAP
    • Star Schema vs Snowflake Schema-0
  6. INTRODUCTION TO DAX USING POWER BI
    • DAX101 - Importing Data for Dax Learning
    • DAX101 - Resources for Dax Learning
    • DAX101 - What is Dax
    • DAX101 - Dax Data Types
    • DAX101 - Dax Operators and Syntax
    • DAX101 - M vs Dax
    • DAX101 - Create a Column
    • DAX101 - Rules to Create Measures
    • DAX101 - Calculated Columns vs Calculated Measures-0
    • DAX101 - Calculated Columns vs Calculated Measures-1
    • DAX101 - Sum()
    • DAX101 - AVERAGE()-MIN()-MAX()
    • DAX101 - SUMX()
    • DAX101 - DIVIDE()
    • DAX101 - COUNT()-COUNTROWS()
    • DAX101 - CALCULATE()-O0
    • DAX101 - CALCULATE()-1
    • DAX101 - FILTER()
    • DAX101 - ALL()
    • DAX101 - Time Intelligence - Create Date Table in M (important)
    • DAX101 - Time Intelligence - Create Date Table in DAX-0
    • DAX101 - Time Intelligence - Create Date Table in DAX-1
    • DAX101 - Time Intelligence - SAMEPERIODLASTYEAR()
    • DAX101 - Time Intelligence - TOTALYTD()
    • DAX101 - Display Last Refresh Date
    • DAX101 - Time Intelligence - PREVIOUSMONTH()
    • DAX101 - Time Intelligence - DATEADD()
    • DAX101 - Quick Measures
  7. POWER BI SERVICES & DASHBOARD
    • PowerBl Reports
    • PowerBI Workspaces
    • PowerBl Datasets
    • What are Dashboards
    • How to create Workspace and Publish Report
    • Create dashboards 6 different ways-0
    • Create dashboards 6 different ways-1
    • Favorite dashboards, reports, and apps in Power BI
    • Subscribe to a Report or Dashboard
    • Rename Workspace or Report or Dashboard
    • Display Reports or Dashboards in Full screen mode
    • Delete Reports or Dashboards
    • Dashboard Menus
    • Quick Insights
    • Setting up Alerts on Cards
    • Report page tooltip
  8. ROW LEVEL SECURITY in POWER BI
    • PATH Function
    • PATHCONTAINS Function
    • PATHITEM Function
    • PATHITEMREVERSE Function
    • PATHLENGTH Function
    • RLS - Static Row Level Security
    • RLS - Dynamic Row Level Security
    • RLS - Organizational Hierarchy 1
    • RLS - Organizational Hierarchy 2
    • RLS - Organizational Hierarchy 3
  9. SHARING & COLLABORATION
    • Sharing and Collaboration
    • Sharing Dashboard
    • Sharing Workspaces
    • Sharing App
    • Publish To Web
  10. HANDS ON Project

​N/A

Instructor Profile

instructor_image

Advanced Excel knowledge with success in maintaining and organizing data, including dictionaries, power pivot, power query and cross-reference indexes across a broad range of industries.

This course includes:

  • 100% Online Sessions
  • Instructor led
  • Customizable Syllabus
  • Customizable Schedule
  • Certificate of Completion
  • Training Recordings
  • Training Resources
  • Learner Assessment
Request Training Proposal

Related courses