Course: Microsoft Power BI: Advanced Data Analysis and Visualisation

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 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 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 …

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. …

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 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 …

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 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 …

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.

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 …

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 …

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 …

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 …

The Date option in the Transformation ribbon gives you a range of options for transforming your data columns, and extracting data like: day of the week, week of the year, …

Introduction To Power BI and Data Transformation Previously, you saw an overview of Power BI and how you can use it to connect to data and create a report. In …