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