Virtual Advanced Data Modeling
- Start: Nov 18, 2024 9:00 AM EST
- End: Nov 18, 2024 5:00 PM EST
- Cost: $745.00
- Instructor: Allison Gonzalez
- 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 01- Conceptual Modeling
- Building a Conceptual Data Modeling
- Module 02 – Fact and Dimensional Modeling on Raw Form-Data
- Advanced Column Transformations for proper Data Model Creation
- Module 03 – Navigating Direct-Query Connections
- Direct-Query through SQL Data Source Connection
- Dual Connections and Import Connections
- Module 04 – Building the Aggregate Table
- Enhancing Model Performance through Aggregate Tables
- Module 05 – Understanding Relationships
- Directional Filtering and Cardinality Crackdown
Add an event to your calendar
Instructor – Allison Gonzalez
Allison graduated from Flagler College in 2011. She has worked in management and training for tech companies for the past decade. As a Microsoft Certified Trainer, her primary focus is helping our customers learn the ins and outs of Power BI, along with Excel and Teams.