Virtual Advanced Data Shaping
- Start: Jan 28, 2025 9:00 AM EST
- End: Jan 28, 2025 5:00 PM EST
- Cost: $745.00
- Instructor: Angelica Choo Quan
- Event Categories: ,
- Available Seats: Limited seats remaining!
- Tickets: Get your ticket HERE
- Need help convincing your boss? We can help.
Event description
Welcome to our Advanced Power BI Data Shaping Bootcamp, a comprehensive day class tailored for data enthusiasts seeking to refine their skills in data transformation and shaping. Throughout this immersive class, you will embark on a deep dive into the powerful world of the Power Query Editor, Power BI’s cutting-edge data shaping tool. Led by seasoned instructors, this course will empower you to manipulate and mold raw data into insightful, actionable information. You'll explore advanced techniques in data cleansing, merging, and transformation, as well as mastering the art of data preparation for analysis and visualization. Through hands-on exercises and real-world case studies, you'll learn to handle diverse data sources and complex data structures, ensuring you can confidently navigate and reshape any dataset. Collaborative learning environments and interactive discussions will enhance your problem-solving abilities, enabling you to transform messy data into clear, meaningful insights. Join us for this transformative journey and equip yourself with the expertise to shape data with finesse, making a significant impact on your organization's decision-making processes."
Prerequisites
This class is targeted for advanced power users or end-users looking to enhance their skills in Power BI and in general Data Modeling. Because this class is focused on self-service end-user solutions, previous SQL Server knowledge is not required. While it’s not mandatory, ideally students should have an intermediate understanding of database terminology such as tables, views, columns, rows, etc.
System Requirements
- Windows 10, Windows 7, Windows 8
- Microsoft Power BI Desktop requires Internet Explorer 10 or greater
- Microsoft Power BI Desktop is available for 32-bit (x86) and 64-bit (x64) platforms
- Power BI Desktop [https://aka.ms/pbiSingleInstaller](https://aka.ms/pbiSingleInstaller)
Course Outline:
- Module 01- Advanced Column Transformations
- Merging, Appending, Fill-Down and many more complex data cleansing operations
- Module 02 – Integrating Python as a Data Source Connection
- Get Data with the help of Python
- Module 03 – Advanced M Transformations
- Leveraging the Advanced Editor for M-Query Data Shaping
- Module 04 – Query Folding
- Utilizing Query Folding to produce faster report results
- Module 05 – Data Profiling Tools and Techniques
- Tackling Errors for advanced troubleshooting
- Advanced Diagnostics and Performance Analytics
Get tickets:
| Ticket type | Price | Quantity |
|---|---|---|
| Virtual Advanced Data Shaping (Jan 28, 2025 – 1/28/25) | $745.00 | |
Add an event to your calendar
Instructor – Angelica Choo Quan
Shortly after graduating from the University of Florida in 2012, Angelica moved to Jacksonville and began her career as a high school Biology teacher. As a trainer at Pragmatic Works, her primary goal is to help individuals feel more comfortable and confident using Power BI. While not in the office, she enjoys traveling around the city of Jax to check out local eateries, live music events, and performing arts.