Big Sale:17Courses in 4000 Rs, 10courses in 3500 Rs, 7 in 3000 Rs

Power BI Desktop & Service with DAX- English

Power BI Desktop & Service with DAX- English

BI For Dashboards and DAX formula

Created by Ajay Parmar

Material Includes

  • All BI and data files are attached for you to download

Course Description

  • A very detailed discussion on Power BI introduction. A Free Microsoft tool works in real world to produce amazing , powerful and dynamic ,interactive dashboards/Reports.
  • Also, covered basic level information on PowerQuery for your better grip on fundamental.
  • Installation on Power BI – Real live example shown. No fast forward. Helpful for new students who never seen BI before.
  • Clustered Column and Stacked Column Chart visualizations covered . When and why they should be used and difference between them discussed too.
  • how to import data and things to be taken care of from different sources.
  • Drill down feature for deep analysis.
  • Stylish Drill-Through feature.
  • Line & Pie Visualizations.
  • Tool-tip and Tool Tips features – Why you need them and what is the difference.
  • How to make Tables and Matrix. Their role in reports .Difference between them. Advantages and disadvantages.
  • Learn how to create Slicers and rules to be followed.
  • What are Cards and Themes in BI – Simple awesome.
  • Learn not so much explored Analytical feature in Visualizations- A full detailed discussion on each feature. Why and where you need this.
  • Cross Filtering feature – No VBA ,  no complex formulas- Inbuilt feature which adds so much value to your reports and dashboards.
  • Area Chart Visualization -from scratch. with practical scenarios telling the difference between it and others .
  • Line and Column visualization – including stacked.
  • How to use custom visuals if you not happy with in-built ones though they are always extra-ordinary
  • Show amazing up and down falls in business using Waterfall visualization
  • Complete discussion on KPI ,Map , Tree Map , QnA feature, Decomposition tree visualization, Ribbon Chart.
  • How to use shapes ,bookmarks and selections in power-bi to take the reports to extreme level.
  • Use of Slicers in navigating pages.
  • How to Create a Dashboard in Powerbi Using above points.
  • What is DAX Measure and Calculated Column (This is Part1 series  of DAX)
  • What is the difference between Measure and Calculated Columns in terms of functioning and fundamentals.
  • Which one is better or which one to choose while writing DAX Formula in PowerBI
  • To begin with , Learn first how to write DAX in PowerBI window. How to write SUM,AVERAGE,COUNT,MAX,MIN,DIVIDE . Its different from excel in terms of fundamental.
  • Learn amazing DAX functions like SUMX, COUNTX,FILTER
  • How to use One DAX into another DAX ,If situation demands.
  • What is a DAX Studio and how it can help you in understanding DAX
  • Most versatile and used DAX in POWERBI – CALCULATE – From basic to advance
  • Utmost important DAX like – ALL , ALL SELECTED, ALL EXCEPT
  • Mixing of ALL with CALCUALTE to yield powerful results
  • How to write IF dax as a calculated column
  • How to write IF as a measure. Its fundamentals which is important.
  • Use of DISTINCT and DISTINCTCOUNT and what is the difference between them.
  • How to handle multiple conditions in a simpler manner using SWITCH Dax. Its alternate to your IF Dax.
  • What is IN and NOT dax. Check out their use.
  • Get ready for surprise Tests.
  • Ask anything on the forum related to DAX. You will have my support .
  • TEXT Functions like LEFT, RIGHT, MID , FIND, SUBSTITUE – Learn their importance in Data crunching.
  • How to find out top or bottom scores in a table. For eg, how to find top scorers or sales revenue values . Learn TOPN in full detail.
  • How to use RANKX – its fundamentals with challenges
  • Which one better – Calculated column DAX or Measure DAX – with scenarios
  • Learn about HASONEVALUE – From functioning to practical use
  • Get ready for Surprise Tests also – See how well you are doing.
  • Related DAX – Vlookup way
  • All great Time Intelligence DAX functions
  • Comparison of performance over the years, months,quarters
  • Cumulative SUMs – yearly, monthy , daily
  • Why we should know SUMMARIZE Dax
  • CALCULATETABLE Dax and its use with Summarize dax
  • Powerful Dax – Selected Value

Course Curriculum

Introduction to PowerBI – Understand in-depth its Components

  • Introduction to basic and important concepts
    52:11

How to Import Excel Data in BI and fundamentals

Clustered Column Visual – Let us finally begin the show

Stacked Column with Bar Visuals

SLICERS Visual – Life changing experience

Line Visual – How to see TRENDS

Area Chart Visual – Magnitude is the key

Column Line and Ribbon Visuals – Do the Deep analysis

Introduction PowerQuery for you – Overview

Power query came to rescue – BI Refresh issues on modifying the data source

Quiz Score – How did students performed

Quiz Score discussion continues

Quiz Score ends – What was your Score

Small multiples Feature in BI

My favorite Tables – Most used Visual

Multi Card Visual – Useful in displaying overall numbers

Gauge Visual – Track how far are we from Targets

A surprise Test conducted- check your score

MATRIX Visual – Its awesome – Everything you need to know

How to use Drill on feature in Matrix – game changing

Map Visual

Decomposition Visual

How to use Drill on feature – Deep dive

CrossFiltering feature – A unique way of doing the automations

Filter pane in BI

Shapes in BI

Buttons in BI

Let us create a Dashboard – Begin the story

Dashboards Continues

Final touch to your Dashboard – Great success

Scattered Visualization – How one parameter affect second

Funnel Visual

Import Data from Google Sheet and how to change it – Challenge solved

Data Modelling – Relationships

BI Service – Sharing of Reports

DAX Tutorials Starts now

999.00
999.00 6,400.00

Power BI Desktop & Service with DAX- English

999.00
999.00 6,400.00

Material Includes

  • All BI and data files are attached for you to download

Course Description

  • A very detailed discussion on Power BI introduction. A Free Microsoft tool works in real world to produce amazing , powerful and dynamic ,interactive dashboards/Reports.
  • Also, covered basic level information on PowerQuery for your better grip on fundamental.
  • Installation on Power BI – Real live example shown. No fast forward. Helpful for new students who never seen BI before.
  • Clustered Column and Stacked Column Chart visualizations covered . When and why they should be used and difference between them discussed too.
  • how to import data and things to be taken care of from different sources.
  • Drill down feature for deep analysis.
  • Stylish Drill-Through feature.
  • Line & Pie Visualizations.
  • Tool-tip and Tool Tips features – Why you need them and what is the difference.
  • How to make Tables and Matrix. Their role in reports .Difference between them. Advantages and disadvantages.
  • Learn how to create Slicers and rules to be followed.
  • What are Cards and Themes in BI – Simple awesome.
  • Learn not so much explored Analytical feature in Visualizations- A full detailed discussion on each feature. Why and where you need this.
  • Cross Filtering feature – No VBA ,  no complex formulas- Inbuilt feature which adds so much value to your reports and dashboards.
  • Area Chart Visualization -from scratch. with practical scenarios telling the difference between it and others .
  • Line and Column visualization – including stacked.
  • How to use custom visuals if you not happy with in-built ones though they are always extra-ordinary
  • Show amazing up and down falls in business using Waterfall visualization
  • Complete discussion on KPI ,Map , Tree Map , QnA feature, Decomposition tree visualization, Ribbon Chart.
  • How to use shapes ,bookmarks and selections in power-bi to take the reports to extreme level.
  • Use of Slicers in navigating pages.
  • How to Create a Dashboard in Powerbi Using above points.
  • What is DAX Measure and Calculated Column (This is Part1 series  of DAX)
  • What is the difference between Measure and Calculated Columns in terms of functioning and fundamentals.
  • Which one is better or which one to choose while writing DAX Formula in PowerBI
  • To begin with , Learn first how to write DAX in PowerBI window. How to write SUM,AVERAGE,COUNT,MAX,MIN,DIVIDE . Its different from excel in terms of fundamental.
  • Learn amazing DAX functions like SUMX, COUNTX,FILTER
  • How to use One DAX into another DAX ,If situation demands.
  • What is a DAX Studio and how it can help you in understanding DAX
  • Most versatile and used DAX in POWERBI – CALCULATE – From basic to advance
  • Utmost important DAX like – ALL , ALL SELECTED, ALL EXCEPT
  • Mixing of ALL with CALCUALTE to yield powerful results
  • How to write IF dax as a calculated column
  • How to write IF as a measure. Its fundamentals which is important.
  • Use of DISTINCT and DISTINCTCOUNT and what is the difference between them.
  • How to handle multiple conditions in a simpler manner using SWITCH Dax. Its alternate to your IF Dax.
  • What is IN and NOT dax. Check out their use.
  • Get ready for surprise Tests.
  • Ask anything on the forum related to DAX. You will have my support .
  • TEXT Functions like LEFT, RIGHT, MID , FIND, SUBSTITUE – Learn their importance in Data crunching.
  • How to find out top or bottom scores in a table. For eg, how to find top scorers or sales revenue values . Learn TOPN in full detail.
  • How to use RANKX – its fundamentals with challenges
  • Which one better – Calculated column DAX or Measure DAX – with scenarios
  • Learn about HASONEVALUE – From functioning to practical use
  • Get ready for Surprise Tests also – See how well you are doing.
  • Related DAX – Vlookup way
  • All great Time Intelligence DAX functions
  • Comparison of performance over the years, months,quarters
  • Cumulative SUMs – yearly, monthy , daily
  • Why we should know SUMMARIZE Dax
  • CALCULATETABLE Dax and its use with Summarize dax
  • Powerful Dax – Selected Value

Course Curriculum

Introduction to PowerBI – Understand in-depth its Components

  • Introduction to basic and important concepts
    52:11

How to Import Excel Data in BI and fundamentals

Clustered Column Visual – Let us finally begin the show

Stacked Column with Bar Visuals

SLICERS Visual – Life changing experience

Line Visual – How to see TRENDS

Area Chart Visual – Magnitude is the key

Column Line and Ribbon Visuals – Do the Deep analysis

Introduction PowerQuery for you – Overview

Power query came to rescue – BI Refresh issues on modifying the data source

Quiz Score – How did students performed

Quiz Score discussion continues

Quiz Score ends – What was your Score

Small multiples Feature in BI

My favorite Tables – Most used Visual

Multi Card Visual – Useful in displaying overall numbers

Gauge Visual – Track how far are we from Targets

A surprise Test conducted- check your score

MATRIX Visual – Its awesome – Everything you need to know

How to use Drill on feature in Matrix – game changing

Map Visual

Decomposition Visual

How to use Drill on feature – Deep dive

CrossFiltering feature – A unique way of doing the automations

Filter pane in BI

Shapes in BI

Buttons in BI

Let us create a Dashboard – Begin the story

Dashboards Continues

Final touch to your Dashboard – Great success

Scattered Visualization – How one parameter affect second

Funnel Visual

Import Data from Google Sheet and how to change it – Challenge solved

Data Modelling – Relationships

BI Service – Sharing of Reports

DAX Tutorials Starts now