Skip main navigation

Understand Contex

Understand Context How context affects DAX measures is a difficult concept to comprehend. The ensuing visuals will demonstrate how context affects DAX measures so you can see how they interact …

Introduction to DAX

Introduction To DAX Data Analysis Expressions (DAX) is a programming language that is used throughout Microsoft Power BI for creating calculated columns, measures, and custom tables. It is a collection …

Resolve Modelling Challenges

Resolve Modelling Challenges Modeling data is about establishing and maintaining relationships so that you can effectively visualise the data in the form that your business requires. When you are creating …

Work With Relationship & Cardinality

Work With Relationship And Cardinality Unlike other database management systems, Power BI has the concept ofdirectionality to a relationship. This directionality, or cardinality, plays an important role in filtering data …

Define Data Granularity

Define Data Granularity Data granularity is the detail that is represented within your data, meaning that the more granularity your data has, the greater the level of detail within your …

Create A Date Table

Create A Date Table During report creation in Power BI, a common business requirement is to make calculations based on date and time. Organisations want to know how their business …

Work With Dimensions

Work With Dimensions When building a star schema, you will have dimension and fact tables. Fact tables contain information about events such as sales orders, shipping dates, resellers, and suppliers. …

Working With Tables

Work With Tables When users see fewer tables, they will enjoy using your data model considerably more. For example, suppose you’ve imported dozens of tables from many data sources and …

Data Modelling

Introduction Creating a great data model is one of the most important tasks that a data analyst can perform in Microsoft Power BI. The following image is an example data …

Query Parameters

Query Parameters are a way to limit or refine the data that users might pull from a database into Power BI Desktop so that they only access the data that …

Transforming Less Structured Data

When you load data that is strangely formatted or unstructured, you may find the following tools help to transform your data into something more useable.

Merge Queries

As you build up more and more Queries within your Power BI Desktop file, you might have Queries that are dependent on one another. We can explore these dependencies in …

Connecting to Files in a Folder

You may sometimes need to load related data from different sources. For example, sales data from different countries. If you have multiple data sets in a folder, Power BI Desktop …

More Column Transformations

As you transform your data you may end up with redundant data columns. You may also want to re-order your columns so they follow a logical or hierarchical flow. We’ll …

DataSet / Examples Terms of Usage and Disclaimer

Throughout the course, you will use examples and datasets provided through text files, Excel workbooks, SQL backup, and Access database. They are provided ‘as-is’. All the data you need for …