Sqlbi – Data Modeling for Power BI Video Course

Data modeling is a required skill to get the most out of Power BI, Power Pivot for Excel, and Analysis Services. This video course is aimed at users of Power BI Desktop or Power Pivot for Excel, and at Analysis Services developers who want to learn how to build the optimal data model for their reporting needs.

The goal of the video course is to teach through examples of increasing complexity how to solve business scenarios by adapting the data model, so that the required DAX code becomes easier, faster and more robust. All the demos and the exercises are based on Power BI examples. However, the very same concepts can be applied to Power Pivot and Analysis Services Tabular.

What You’ll Learn In Data Modeling for Power BI Video Course

Presentation of Data Modeling for Power BI

• Presentation of Data Modeling for Power BI

Exercises, slides, and demos

• How to download and complete exercises
• Exercises download
• Demos download
• Slides of the video course
• SQL Server Contoso DW database

Introduction to data modeling

• Introduction to data modeling
• Introduction
• Analytical limits
• Increasing the analytical power
• Introducing the data model
• Leveraging the data model
• Normalization and denormalization
• Facts and dimensions
• Introducing star schemas
• If you don’t have a star schema
• Chains of relationships
• How many dimensions?
• Why data modeling is useful
• LAB number 1

Header / detail tables

• Header / detail tables
• Introducing header / detail schemas
• Bidirectional filtering is not the way to go
• Header / detail
• Denormalizing the discount
• Back to a star schema
• LAB number 2

Multiple fact tables

• Multiple fact tables
• Using multiple fact tables
• Moving filters with DAX
• Building a star schema
• How to properly use multiple fact tables, if present
• Trying bidirectional filtering
• Model ambiguity
• Solving ambiguity
• LAB number 3

Working with date and time

• Working with date and time
• Date attributes in the fact table
• Building a date dimension
• CALENDARAUTO
• The model with a date dimension
• Automatic date grouping in Excel and Power BI
• 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: the model
• Non-overlapping special periods
• Overlapping special periods
• Overlapping period measure
• LAB number 4

Tracking historical attributes

• Tracking historical attributes
• Attributes change over time
• Handling variations over time
• Slowly changing attributes or dimensions?
• Rapidly changing dimensions
• Attributes in the fact table

Using snapshots

• Using snapshots
• What is a snapshot?
• Sales versus inventory in the same model
• Non-additive measures
• LASTDATE does not work here
• Optimizing performance
• Snapshots and granularity
• Transition matrix
• Parameter table
• LAB number 5

Analyzing date and time intervals

• 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
• Changing the model
• Open orders is a snapshot table
• Events with different durations
• Daily Salary (DAX)
• Precompute the values
• LAB number 6

Many-to-many relationships

• Many-to-many relationships
• What are many-to-many relationships?
• Possible solutions to the scenario
• Bidirectional filtering
• Using CROSSFILTER
• Using expanded table filtering
• CROSSFILTER versus expanded tables
• Understanding non-additivity
• Cascading many-to-many
• Additional material
• LAB number 7

Working with different granularities

• 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
• Use the correct column to slice
• Leveraging relationships
• Checking granularity in the report
• Hiding or reallocating?
• LAB number 8

Segmentation data models

• Segmentation data models
• Segmentation models
• Static segmentation
• Static segmentation: the formula
• Dynamic segmentation
• Dynamic segmentation: the formula
• ABC and Pareto analysis

Working with multiple currencies

• Working with multiple currencies
• Using multiple currencies
• Beware of simple calculations
• Multiple sources, one reporting currency
• Conversion with a calculated column
• Single source, multiple reporting currencies
• What the formula should perform
• Multiple sources, multiple reporting currencies

Sale Page: Sqlbi – Data Modeling for Power BI Video Course

When will I receive my course?

You will receive a link to download your course immediately or within 1 to 21 days. It depends on the product you buy, so please read the short description of the product carefully before making a purchase.

How is my course delivered?

We share courses through Google Drive, so once your order is complete, you'll receive an invitation to view the course in your email.

To avoid any delay in delivery, please provide a Google mail and enter your email address correctly in the Checkout Page.

In case you submit a wrong email address, please contact us to resend the course to the correct email.

How do I check status of my order?

Please log in to MMOCourse account then go to Order Page. You will find all your orders includes number, date, status and total price.

If the status is Processing: Your course is being uploaded. Please be patient and wait for us to complete your order. If your order has multiple courses and one of them has not been updated with the download link, the status of the order is also Processing.

If the status is Completed: Your course is ready for immediate download. Click "VIEW" to view details and download the course.

Where can I find my course?

Once your order is complete, a link to download the course will automatically be sent to your email.

You can also get the download link by logging into your mmocourse.hk account then going to Downloads Page.