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
Power Master Course – Zero to Dashboard
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
Password/解压密码www.tbtos.com
转载请注明：0daytown » Data 2 Dashboard – Power BI – 2021 – Key Metrics Performance