Home > Vendors > microsoft > grc-104ft

Share

GRC-104FT - Intensive Data Modeling for Microsoft Power BI Creators - Fast Track

This workshop is a complete course about building the most optimal data models for your Power BI reports. It introduces the audience to the basic techniques of shaping data models in Power BI. It offers many real-world examples that will help you look at your reports in a different way – pretty much like experienced data modelers do.

Duration: 2.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

After completing this course, students will be able to:
  • Learn the vast techniques of shaping and building a correct data model to be used in Power BI. 
  • Understand the common challenges and mistakes that people have in creating a data model. 
  • Learn the most optimum way of building a sustainable data model for Power BI reports.

Content

Module 1:Introduction to Data Modeling
  • What is Data Modeling? 
  • Analytical limits 
  • Increasing the analytical power 
  • Introducing the facets of data modeling 
  • Leveraging the data model 
  • Normalization and denormalization 
  • Facts and dimensions 
  • Introducing star schemas 
  • Chains of relationships 
  • How many dimensions? 
  • Why data modeling is useful? 
  • Lab 01 – Basic data modeling

Module 2:Header / Detail Tables
  • Introduction to header / detail schemas 
  • Bidirectional filtering is not the way! 
  • Denormalizing the discount 
  • Back to star schema 
  • Lab 02 – Header / detail

Module 3:Working with Date and Time
  • Date attributes in the fact table 
  • Building a date dimension 
  • CALENDARAUTO function 
  • The model with a date dimension 
  • Automatic date grouping in Power BI 
  • Quick calculations in Power BI Desktop 
  • Disable automatic date columns 
  • Handling multiple dates 
  • Multiple date tables 
  • Multiple date tables with multiple fact tables 
  • Multiple relationships with date 
  • Handling date and time 
  • Computing with working days 
  • Create a holidays table (one country) 
  • Create a holidays table (multiple countries) 
  • Weekends are not always the same! 
  • Handling special periods of the year 
  • Non-overlapping periods in the model 
  • Non-overlapping special periods 
  • Overlapping period measure 
  • Lab 03 – Working with date and time

Module 4:Using Snapshot Tables
  • What is a snapshot table? 
  • Sales versus inventory in the same model 
  • Non-additive measures 
  • LASTDATE function does not work here! 
  • Optimizing performance 
  • Snapshots and granularity 
  • Transition matrix 
  • Parameter tables 
  • Lab 04 – Snapshots

Module 5:Analyzing Date and Time Intervals
  • What are intervals? 
  • Solving with DAX… too complex! 
  • Changing granularity 
  • Split hours AND amount! 
  • Analyzing active events 
  • Open orders: the starting model 
  • Open orders with DAX 
  • Open orders in a snapshot table 
  • Events with different durations 
  • Daily salary in DAX 
  • Precompute the values 
  • Lab 05 – Date and time interval

Module 6:Many-to-Many Relationships
  • What are many-to-many relationships? 
  • Possible solutions to this complex scenario 
  • Bidirectional filtering 
  • Using CROSSFILTER function 
  • Using expanded table filtering 
  • CROSSFILTER versus expanded tables 
  • Understanding non-additivity 
  • Cascading many-to-many 
  • Lab 06 – Many-to-many relationships

Module 7:Working with Different Granularities
  • Dimensions define granularity 
  • Analyzing budget data 
  • Reduce granularity on all the tables 
  • Using DAX to move the filters 
  • Filtering through relationships 
  • Using the correct column to slice 
  • Leveraging relationships 
  • Checking granularity in the report 
  • Hiding or reallocating? 
  • Lab 07 – Granularity

Audience

N/A

Prerequisites

Attendees preferably have a basic knowledge of data modeling in Power Pivot for Excel, or Power BI Desktop, or Analysis Services Tabular modeling. If such knowledge is absent, it is also a great eye-opener for these attendees to gain an insight to the world of data modeling.

Certification

product-certification

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Microsoft Popular Courses

ms-700t00

The Managing Microsoft Teams course is designed for those aspiring to be Microsoft 365 Teams Administrators to deploy, configure and manage Office 365 workloads

sc-900t00

This course provides foundational level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.

az-204

Learn to create end-to-end solutions in Microsoft Azure in this 5-days official Microsoft course.

az-104

This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, co
Enquire Now
 
 
 
 
n3C2qr
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy
➤