<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Virtual Advanced Data Shaping

  • Start: Feb 06, 2024 8:00 AM EST
  • End: Feb 06, 2024 4:00 PM EST
  • Cost: $745.00
  • Instructor: Greg Trzeciak
  • Event Categories:
  • Missed your change to sign up, but still want to get in on the fun? Contact us!
Image of the event

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 One- Advanced Column Transformations
    • Merging, Appending, Fill-Down and many more complex data cleansing operations
  • Module Two – Integrating Python as a Data Source Connection
    • Get Data with the help of Python
  • Module Three – Advanced M Transformations
    • Leveraging the Advanced Editor for M-Query Data Shaping
  • Module Four – Query Folding
    • Utilizing Query Folding to produce faster report results
  • Module Five – Data Profiling Tools and Techniques
    • Tackling Errors for advanced troubleshooting
    • Advanced Diagnostics and Performance Analytics

Add an event to your calendar

Add to Calendar
Event Instructor Image
Instructor – Greg Trzeciak

Gregory Trzeciak has his master’s degree in Education from the University of Florida. He has 9 years of teaching experience in high school, college level, and summer programs where he was recognized as a top educator and leader in interactive education. As a trainer at Pragmatic Works, his primary goal is to help individuals gain confidence in using Power BI and the Power Platform. While not in the office, he enjoys fantasy football, walking his dog, and running half-marathons!