ONCE1193 - Advanced Power BI
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.
- Utilize Column profile, distribution, and quality
- Perform fuzzy match
- Duplicate versus Reference queries
- Debug errors
- What a Star Schema is
- Understand relationship types
- Manage relationships
- Understand contexts
- CALCULATE function
- COALESCE function
- Compute visual totals accurately
- Insert Objects
- Create Bookmarks
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
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
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: email@example.com. 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 firstname.lastname@example.org or 267-468-8500.
Applies Towards the Following Certificates
- Power BI Certificate Program : Power BI Certificate Program