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

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

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()

Power Master Course - Zero to Dashboard

Url: View Details

What you will 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

Rating: 4.33333

Level: Intermediate Level

Duration: 3.5 hours

Instructor: Praveen Gampa