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