https://store-images.s-microsoft.com/image/apps.52202.a4dcf186-ec10-44af-a639-a85f4375b495.232c54d1-dbdc-4663-a57b-222bd91ba2b3.9543a8d3-c3fd-49ef-aa85-96c3805e682d

Advanced Data Modeling with Power BI: 3-Day Workshop

MAQ Software

Do you want to take the next step into becoming a Power BI expert? Advance your data modeling skills to gain more powerful insights.

Leverage your core base of Power BI knowledge to dive deep into the world of advanced visualization. As the 2021 Microsoft Power BI Partner of the Year, we are recognized for our expertise in implementing business intelligence and analytics solutions. Our workshop offers mid-level Power BI users the chance to dive deep into the more complex functionalities of Power BI. Our team of certified engineers will demonstrate the key aspects of creating a great data model that meets your organization’s unique business needs.

Target Audience

  1. Mid-level BI developers
  2. Power BI business users

Agenda

Day 1: Introduction to Data Modeling with Power BI

  1. Module 1: Introduction to Power BI Desktop
  2. Module 2: Power Query M Language
  3. Module 3: Introduction to DAX calculated columns and measures

Lab 1: Using Power BI Desktop

Day 2: Advanced Modeling Techniques

  1. Module 4: M Transformations
  2. Module 5: The Benefits of Parameterizing Queries
  3. Module 6: Introduction to Optimization Techniques

Day 3: Data Analysis Expressions (DAX) and Modeling Best Practices

  1. Module 7: Introduction to DAX

Lab 2: Queries, transformations, and DAX 8. Module 8: Calculating functions with DAX 9. Module 9: Understanding complex measures with data modeling techniques 10. Module 10: Time-intelligence functions 11. Module 11: Data modeling best practices

Deliverables/Takeaways

By the end of the workshop, you will be able to create advanced data models in Power BI, implement simple and advanced DAX calculations, and apply best practices to both data models and DAX.

Advantages

  1. Intermediate workshop for analysts who have some experience with Power BI
  2. Hands-on Workshop on data modelling with Power BI
  3. Learn about best practices in data modelling with Power BI

Prerequisites

Pre-Configured Set-Up for Your Computer/Laptop

  1. System Requirements: Computer with 2-cores and 4GB RAM running Windows 8/Windows Server 2008 R2, or later
  2. Display: Minimum resolution of 1440x900 or 1600x900, and aspect ratio of 16:9 (recommended). It is also recommended to have two screens
  3. Internet connectivity: You must have the ability to connect to the Internet outside your organization
  4. Downloads & Installs: Our content and software get updated every month. Download the software and materials 2-3 days prior to the event to ensure you are downloading the most recent updates. Links to download the content will be provided.
  5. Microsoft Power BI Desktop: You need to download and install Power BI Desktop from the Microsoft Store https://go.microsoft.com/fwlink/?linkid=2135345 or from the download center https://go.microsoft.com/fwlink/?linkid=2135519
  6. Sign up for Power BI: You need to sign up for Power BI. You can do that from http://aka.ms/pbidiadtraining using a business email address.

At a glance

https://store-images.s-microsoft.com/image/apps.1552.a4dcf186-ec10-44af-a639-a85f4375b495.cba8a632-bd30-47fd-b252-cefef5c679c0.b3c65076-d142-4a86-82d8-51b75494bc11