Book Free Demo !

Microsoft Power BI

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights

Book Free Demo

Course Content

  • Introduction to Visualization
  • Why Business Intelligence
  • Introduction to Power BI
  • Power BI Architecture
  • Components of Power BI
  • Power BI Flow
  • Introduction of Power BI Desktop
  • Power BI Licensing (Free vs Pro vs Premium)
  • Power BI Desktop Installation
  • Power BI Desktop User Interface and Views
  • Types of Data Sources in Power BI
  • Data Loading Modes and Advantages
  • First Row Header
  • Duplicate Columns
  • Split Columns
  • Remove Duplicate/Columns
  • Replace Value
  • Change Data Type
  • Group BY
  • Pivot and Unpivot
  • Formatting data
  • Add Custom Columns
  • Invoke Function
  • Append Queries
  • Join Merge Queries
  • Combine Files (Folder)
  • Parameters
  • Other Query Features
  • Components of Data Modeling
  • Introduction to Data Models
  • Data Model Engine
  • Types of Data Model (Flat, Star & Snowflake)
  • Granularity of Data & multiple fact tables
  • Data Modeling Relationships
  • One to One
  • One to Many
  • Many to Many
  • Roll Playing Tables
  • Sorting/Renaming/Hiding Tables
  • Hierarchy Creation
  • Formatting & Data Category
  • Grouping / Binning
  • Drill Through Reports
  • What IF Parameter
  • Designer Options
  • Power BI Visualization Types
  • Custom Visualization
  • Best Practices
  • Choosing Colors
  • Types of Charts and Usage
  • Slicers / Filters
  • Creating Complete Visualization Report (Practical)
  • Continue Creating Complete Visualization Report (Practical)
  • Story Telling with the created Report
  • Bookmarks / Selection Pane
  • Spotlight
  • Drill Through
  • Additional Feature
  • Introduction DAX
  • DAX Data Types
  • Calculated Columns
  • Calculated Tables
  • Calculated Measures
  • Calculated Columns vs Measures
  • Aggregated Functions (SUM, MIN, MAX, AVG, COUNT)
  • Relate Functions (RELATED & RELATED TABLE)
  • Iterative Functions (SUMX, AVGX, COUNTX)
  • Variables (VAR)
  • Logical functions (AND, OR, IF, SWITCH)
  • Table Functions (VALUES, FILTER, CALCUILATETABLE)
  • FORMAT FUNCTION, FIND, SEARCH, SUBSTITUE, VALUE, UNION, ROW, ADDCOLUMNS, SUMMARIZE
  • Handling Blanks (ISBLANK, NOTISBLANK)
  • Rank Functions (RANKX)
  • CALCULATE (ALL, ALLEXCEPT, ALLSELECTED)
  • Understand Row & Table level Filter Context
  • Date Functions (DATEADD, DATEDIFF, TODAY Required Date Formats)
  • Calendar Functions (CALENDAR, CALENDAT AUTO)
  • Time Intelligence functions (TOTALMTD, TOTALQTD, TOTALYTD, PARALLELPERIOD, SAMEPERIODLASTYEAR, PARALLELPERIOD, RUNING TOTAL)
  • SEMI ADDITIVE (OPENING BALANCE, CLOSING BALANCE, LAST DATE, FIRST DATE, LASTNONBLANK, FIRSTNONBLANK)
  • Project 1
  • Project 2

Explore More

See Whole Course

Flexibility in Planning and Teaching

Theoretical Knowledge

Practical Skills

Individual Work with a Mentor

Final Individual Project

The premier destination for individuals seeking to elevate their professional skills and excel in their careers.

Facebook-f Instagram Twitter Whatsapp

Book Your Live Demo Now !

Book Now !

Copyright © 2023 WebridgeTech Pvt Ltd All rights reserved.

+91-8130121986

info@idacareer.com

Skip to content