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

Power Master Course – Zero to Dashboard

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 9 lectures (3h 19m) | Size: 1.82 GB

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

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

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

Who this course is for
Excel Users and Power BI beginners who want to learn how to create professional reports and Dashboards in Power BI