Power BI Course

About the Course

This Power BI training course lets you master the Microsoft Power BI tool. We provide the best training classes to help you learn Power BI architecture, Desktop, Service, and Visualize the Reports and deriving business insights. As part of this program, you will work on real world projects. Today all business enterprises and departments need extensive business insights, and Power BI puts the power in your hands You can easily work with multiple sources of data, convert it into a report, graph or data visualization of your choice By deploying Power BI, you get real time insights and deploy it faster than any other BI tool available in the market.

Introduction to Power BI

An Overview of the Workflow in Power BI Desktop Power BI Free Vs. Pro Vs. Premium

Power BI Key Components

Introducing the Different Views of the Data Model Taking a Closer Look at the Query Editor Interface

Power BI overview Concept

  • Dataset

  • Reports

  • Dashboard

  • Workspace

  • Tiles

  • Q&A Question box

    Good Data vs. Bad Data

  • Classification of Bad Data

    Connecting Power BI Desktop to our Data Sources

  • Excel , CSV, Web, PDF, MS Access, SQL Developer, Google Analytics, XML, Connecting to a folder, SharePoint Folder, JSON and many more.

    Power Query

  • When to Use Power Query

  • Import and analysis millions of Rows

  • Best things to happened in power BI

    • Type of Connection

    • Automate your data Processing

    • Query Editor Tool

    • Pivoting and Unpivoting Columns

    • Duplicating Vs. Referencing Queries

    • Transformations

    • Editing Rows

      • First Header Row

      • Remove Top Rows

      • Filtering- Remove-Replace Techniques

    • Editing Columns

      • Remove or Keep Columns

      • Navigation to the Columns

  • Formatting Data

    • Change data Type

    • Detect Data type for multiple columns

    • Remove error while loading

    • Remove null values

    • Splitting Columns

    • Delimiters

    • Delimiters positions

    • Creating a New Group for our Queries

  • Others

    • Sorting

    • Performing Basic Mathematical Operations in Query Editor

    • Improving Performance and Loading Data into the Data Model

    • Columns Distribution, Quality, Profile

Understanding Append Queries

Append Queries as existing (With two or Multiple tables) Append Queries as New

Introducing the Star Schema

Joins

Fact Table Vs. Dim Table Star Schema

Dim Vs. Fact Table

Star Schema Vs. Snow Flex Schema

Outer Join Left

Right Full Anti Left Right Inner

Data Table vs. Lookup Table Primary key Vs. Foreign Key Relationship Vs. Merged Table Connecting lookup to Lookups Relationship Cardinality

Introducing and Understanding Relationships One to One Relationship

One to Many or Many to One Many to Many Relationship

Bad Cardinality Many to Many Bad Cardinality One to One Importance for Filter Direction Editing Relationships

Data Model Best Practice

Working on our Data Model Data Relationship View

Query Editor vs. Data Model

Feature of Query Editor (Structure + Prepare Data)

Data Model – Add Relationship, Add Measures (Analysis Data) Active Properties

Understanding the differences between the M-Language and DAX DAX - Basic information

Calculated Columns vs. Measures


TIME INTELLIGENCE

FILTER

STATISTICAL

TEXT

MATH AND TRIG

DATE TIME

INFORMATION

LOGICAL

DATEADD

ALL

ADDCOLUMNS

BLANK

ABS

CALENDAR

ISBLANK

AND


DATESBETWEEN


ALLEXCEPT


AVERAGE


CONCATENATE


DIVIDE


DATE


ISERROR


IF


DATESINPERIOD


ALLSELECTED


AVERAGEX


CONCATENATEX


MOD


DATEDIFF


ISEVEN


IFERROR


ENDOFMONTH


CALCULATE


COUNT


EXACT


POWER


DAY


ISLOGICAL


NOT


ENDOFQUARTER


CALCULATETABLE


COUNTA


FIND


PRODUCT


EDATE


ISNONTEXT


OR


ENDOFYEAR


CROSSFILTER


COUNTBLANK


FORMAT


QUOTIENT


EOMONTH


ISNUMBER


SWITCH


FIRSTDATE


DISTINCT


COUNTROWS


LEFT


RANDBETWEEN


HOUR


ISODD


TRUE


LASTDATE


FILTER


COUNTX


LEN


ROUND


MINUTE


ISTEXT



NEXTDAY


FILTERS


CROSSJOIN


LOWER


ROUNDDOWN


MONTH




NEXTMONTH


RELATED


DATATABLE


MID


ROUNDUP


NOW




NEXTQUARTER


RELATEDTABLE


DISTINCTCOUNT


REPLACE


SIGN


SECOND




NEXTYEAR


SELECTEDVALUE


MAX


REPT


SQRT


TIME




PREVIOUSDAY


USERELATIONSHIP


MAXX


RIGHT


SUM


TODAY




PREVIOUSMONTH


VALUES


MIN


SEARCH


SUMX


WEEKDAY




PREVIOUSQUARTER



MINX


SUBSTITUTE



WEEKNUM




PREVIOUSYEAR



RANKX


TRIM



YEAR




SAMEPERIODLASTYEAR



SUMMARIZE


UNICHAR



YEARFRAC




STARTOFMONTH




UPPER






STARTOFQUARTER




VALUE






STARTOFYEAR


TOTALMTD


TOTALQTD


TOTALYTD

Working in the Report View to Visualize our Results Understanding the Interface of the Report View Creating our First Visualizations

Understanding which chart to use when Editing Interactions and Adding Tooltips Adding Color Saturation

Understanding Hierarchies and Adding Drill-Down Formatting Charts and Sorting

Essential Formatting settings: Color, Data Labels, Axis, Placement, Legends, Value Table View vs. Matrix View

Conditional Formatting in Table View

Basic Charts: Line, Bar Chart, Column Chart, Tree map, Pie, Doughnut, Area

Tooltips – On hover Text

Color Saturation in Column Chart Slicers: Vertical list vs. Horizontal tiles Text Cards

Ask a Question (Natural Language) – just type what you want with specific key terms Smart Narrative

Custom Visuals

Adding Tree maps and Tables Applying different Filter Types Creating Multi-Row Cards

Understanding Combined Visualizations and Waterfalls

Conditional columns and Data Segmentation:

Conditional Columns: Writing multi-layered IF conditions

Segmentation: Use “Group By” to calculate aggregated calculation based on clusters Segmentation: Use “Binning” to categorize values into equally sized groups

Advance Visualization:

KPI & Gauge Chart Forecast, Trend-line Scatter plot – Bubble Chart Map Visuals

Key Influencer Decomposition Tree Performance Analyser Bookmarks

Advance conditional formatting on visuals Small Multiples

Custom Visuals – Downloadable Charts

Use Drill down/up feature to specify chart behavior – granular view Show/Expand next level

Filter level: Report level vs Page level vs. Visual level

Power BI Service

Introducing Power BI Service Gateway Refresh and Data Flow Understanding Gateways

Personal Gateway

Enterprise Gateway Sharing & Collaboration Tool Power BI Mobile

My Workspace Vs. App Workspace Report Reading tool in Power BI Service Pining Tiles to Dashboard

Dashboard Interface

Report Vs Dashboard Vs Application Assign Roles & Manage Permissions Analysis in Excel

Usage Metrics

Row Level Security (Static Vs Dynamic) Manage Alerts

Exploring Data with Q & A

Generate Quick Insight and lot more….

query button