Advanced techniques for cleaning & transforming your data
place preheader text here
|
 | | 100-Minutes | Live & On-Demand Power BI Intermediate: Beyond the Basics Wednesday, October 6, 2021 at 1 PM (ET)
All registrants also receive the recording If you've mastered the basics of Power BI, join us for a 90-minute workshop and take your skills to the next level, in order to extract business intelligence for enhanced decision making.
You'll learn how to clean up your raw data to make it "report ready", create calculations using the Power BI formula language, and much more!
Here's a bit of what we'll cover:
Advanced Techniques for Cleaning & Transforming Your Data - Simple solutions for quickly cleaning up and restructuring less-than ideal data
- Best practices for creating executive level dashboards suitable for publication
- Expert methods for merging and appending data from multiple datasets
Power BI Formula Language - Understand the difference between M and DAX
- Ways to use DAX functions such as LOOKUPVALUE and IF
- Create additional columns in your datasets using M and DAX
Summarize Data & Display the Right Level of Granularity - Learn when to use Calculated Column vs. when to use Measures
- Techniques for implementing functions such as SUMX and AVERAGEX
- Why learning how to use the CALCULATE function is a must!
| |
No comments:
Post a Comment