Data 2 Dashboard – Power BI – 2021 – Key Metrics Performance
Learn how to create interactive reports and dashboards in Power BI with this comprehensive course. Discover how to use filters and slicers to analyze your data, implement business logic using DAX functions, and optimize your use of DAX formulas. Gain lifetime access to course materials and practice activities, and receive a 100% money back guarantee. Perfect for Excel users and Power BI beginners looking to create professional reports and dashboards. Sign up now and unlock the power of Power BI!
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
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
User Reviews
Be the first to review “Data 2 Dashboard – Power BI – 2021 – Key Metrics Performance”
You must be logged in to post a review.
There are no reviews yet.