Virtual Advanced Data Modeling
- Start: Apr 15, 2024 9:00 AM EDT
- End: Apr 15, 2024 5:00 PM EDT
- Cost: $745.00
- Instructor: Greg Trzeciak
- Event Categories:
- Available Seats: Limited seats remaining!
- Missed your change to sign up, but still want to get in on the fun? Contact us!
- Need help convincing your boss? We can help.
Event description
Welcome to our Advanced Power BI Data Modeling Bootcamp, an intensive day class designed to elevate your data modeling skills to new heights. In this immersive full-day learning experience, you'll delve deeper than ever before into the world of Power BI and Data Modeling. Our expert instructors will guide you through advanced data modeling techniques, transforming raw data into a meaningful scheme. You'll master the intricacies of relationships, DAX (Data Analysis Expressions) functions for modeling which will enable you to create dynamic and interactive dashboards. Through hands-on exercises and a real-world case studies, you'll gain advanced knowledge in optimizing data models for performance and efficiency. Collaborative learning environments and peer interactions will enhance your problem-solving skills, ensuring you leave equipped with the expertise to tackle complex business challenges confidently. Join us on this transformative journey and unlock the full potential of your data modeling capabilities.
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- Conceptual Modeling
- Building a Conceptual Data Modeling
- Module Two – Fact and Dimensional Modeling on Raw Form-Data
- Advanced Column Transformations for proper Data Model Creation
- Module Three – Navigating Direct-Query Connections
- Direct-Query through SQL Data Source Connection
- Dual Connections and Import Connections
- Module Four – Building the Aggregate Table
- Enhancing Model Performance through Aggregate Tables
- Module Five – Understanding Relationships
- Directional Filtering and Cardinality Crackdown
Add an event to your calendar
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!