ONCE1193 - Advanced Power BI
Course Description
Expand your knowledge of Power BI Desktop to the highest level. This course focuses on the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results.
Course Outline
Agenda
Unit 1
Power Query
- Utilize Column profile, distribution, and quality
- Perform fuzzy match
- Duplicate versus Reference queries
- Debug errors
Unit 2
Data Modeling
- What a Star Schema is
- Understand relationship types
- Manage relationships
Unit 3
DAX
- Understand contexts
- CALCULATE function
- COALESCE function
- Compute visual totals accurately
Unit 4
Reports
- Insert Objects
- Create Bookmarks
Learner Outcomes
Course outcomes
1.Check for data inconsistencies
2.Use data profiling to create efficient queries
3.Write efficient DAX code
4.Add trendlines to charts
5.Add Objects and Bookmarks to reports
Course objectives
1.Provide an understanding of Data Profiling in Power Query.
2.Have students learn how to create a Fuzzy Match
3.Give an understanding the difference between Duplicate and Reference Queries
4.Have students know the differences between relationship types
5.Explore advanced DAX functions
6.Create a Key Influencer visual
Notes
This is a self-paced, online course in partnership with UGotClass.
This course is part of the Power BI Certificate Program.
Cancellation, Withdrawal and Refund Policy: A participant who withdraws from a non-credit course, in writing, up to one-week prior to the starting date of the course, will receive a refund, minus a $25 withdrawal fee; for all certificate programs the withdrawal fee is $50. For courses costing $75 or less, the withdrawal fee is $10 per course. No refunds will be given after that time. E-mail your withdrawal request to: ncce@temple.edu. Please note that if you do not officially withdrawal from a course and you do not attend the course, you are still responsible for payment. Temple University reserves the right to cancel a course for any reason. If the course is cancelled, you will be notified, and your entire tuition will be refunded. For more information contact us at ncce@temple.edu or 267-468-8500.
Applies Towards the Following Certificates
- Power BI Certificate Program : Power BI Certificate Program