Rating 4.33 out of 5 (6 ratings in Udemy)
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, …
Rating 4.33 out of 5 (6 ratings in Udemy)
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
DescriptionDetails 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()
