Data 2 Dashboard – Power BI – 2021 – Key Metrics Performance

Power Master Course – Zero to Dashboard

Details of what you will learn during this course

What you’ll learn

  • Creating Power BI Dashboard from Scratch to Publishing.
  • Learn to use the EASIEST Business Intelligence tool to create INTERACTIVE Reports and Dashboards in Power BI.
  • Learn Modeling, and how to use FILTERS and SLICERS to ask the MEANINGFUL questions of your data.
  • How to implement Business logic in the Power BI reports using DAX functions.
  • Measure Branching, Rolling Period (1 month Sales, Costs and Profits, Cumulative/Running (Sales, Costs and Profits), KPI’s, Top N and Dynamic Titles for Visuals.
  • Lifetime access to course materials and practice activities. 100% money back guarantee.
  • Learn how to use different graph VISUALIZATIONS and shapes such as column, line, pie, card, bar shape map and line shape, etc…
  • Learn how to connect to Share Point.
  • End to end formatting of a report.
  • Publishing and pin to dashboard.

Course Content

  • Introduction –> 9 lectures • 3hr 20min.

Data 2 Dashboard - Power BI - 2021 - Key Metrics Performance

Requirements

  • You will require Power BI desktop, access to the Power BI Service and SharePoint (optional) on the Internet.
  • You should be able to work with data in Excel and SharePoint do basic reporting.
  • You will require a work email address to sign up for the Power BI Service.
  • Download the Power BI Desktop app which is available free from Microsoft for Windows.
  • You should be familar with Power BI Desktop and Power BI Service.

Details of what you will learn during this course

  • Learn – best practices on how to optimize your use of DAX
  • Master – key DAX formulas and techniques
  • Create – a consistently defined extended date table efficiently
  • Simulate – a scenario easily using randomized data
  • Discover – the best practices in creating quality Power BI reports and dashboards
  • Implement – an efficient Power BI deployment of your organization

What is offered in this course?

In this course, you will learn to use the AMAZING Power BI tool to create a dashboard and how to use the power BI service to publish your work.

 

  • Introduction and Course Content
  • Signing up for Power BI and Loading Data
  • Tables and Cards,
  • Columns, Bar, Line, Pie and Shape Map
  • Filters and Slicers
  • Performance of trends and Key Measures
  • Creating Interactive Report and Dashboard
  • Publishing to Power BI Service and Pinning to Dashboard
  • Data Gateways and refreshing data sets
  • Using Custom visualizations and themes

 

  • Core functionality – Slice and dice the data with Measures and Time Frame
  • Getdata – From Sharepoint
  • Date Table – with M-Code
  • Modeling – Star scheme and relations ships
  • Logics – Measure Branching, Rolling Period (1 month Sales, Costs and Profits, Cumulative/Running (Sales, Costs and Profits), KPI’s, Top N, Dynamic Titles for Visuals, etc.. .
  • Dax Functions covered –

o SELECTEDVALUE()

o SWITCH()

o IF()

o DIVIDE()

o CALCULATE()

o FILTER()

o ALLSELECTED()

o VARIABLES

o RANKX()

o SUMX()

o AVERAGEX()

o LASTDATE()

o DATESINPERIOD()

o SAMEPERIODLASTYEAR()

o COUNTA()

o CONCATENATE()

Get Tutorial