Skip main navigation

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. Organizations want to know how their business …

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. By doing this job well, you help …

Sharing and annotating in Power BI Mobile

One of the most common operations that you will do when working with queries is splitting columns. You will often find that data has been separated by delimiters such as …

Mobile Dashboard Layout

As you begin to work with very large sets of data, creating Query Groups in the Query Pane is a great way to stay organised. You’ll see a demonstration of …

Sharing a Dashboard

For users to be able to take advantage of the beautiful dashboards and reports in Power BI and the metrics that matter to you, you’ll need to share those dashboards …

Featured Questions

A simple way of helping people start to understand the sort of questions that they can ask to get meaningful results about the data that you expose through Q&A is …

Analyzing Data in Excel

You can take any report or dataset in Power BI and using the Analyze in Excel function, send that data to Excel to apply any of the tools in Excel …

Excel Workbook with Excel Data Model

Power Pivot is used to pull in data from different data sources or to manage multiple tables in an Excel workbook, and Power BI will understand that and translate that …

Importing Excel Data using Simple Table

The simplest way of using Excel with the Power BI service is to upload a standard Excel spreadsheet into Power BI and start using the data to create reports straight …

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 …

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 …

Working With Dates

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

What is Power BI?

Overview Of Power BI Welcome! In the previous activity, you were introduced to the course, had an opportunity to introduce yourself and had a chance to test launch your lab …

Apply Slicing, Filtering And Sorting

Introduction Power BI Desktop provides three tools that you can use to edit and configure interactions between the visualizations that you add to your report: slicers, filters, and sorting. The …