Previously we’ve done a tutorial on loading multiple text files within one query. This is nice, however we will also need to import multiple Excel files. First, to understand the procedure of querying multiple excel […]
As I have been exploring PowerBI and building dashboards I have noticed that often the visuals can obscure your data. As you click on different visuals there is a need to highlight different pieces of […]
Let me setup a scenario for you. You get a data file from an automated system, it has the same number of columns but the data changes for every new file. Being the data savvy […]
This tutorial walks through calculating a dynamic Compound Annual Growth Rate (CAGR). By dynamic we mean as you select different items on a bar chart for example the CAGR calculation will update to reveal the […]
Often there are times when you will want to display a totals. Using measures to calculate a total are extremely easy to use. The power of using a measure is when you are slicing and […]
In our last post we built our first measure to make calculated buckets for our data, found here. For this tutorial we will explore the power making measures using Data Analysis Expressions (DAX). When starting […]
There are often times when you need a small data set in order to make a visual behave exactly how you want it to. This may mean you need a small table to represent a […]
One of the most important concepts to learn within Power BI Desktop is how to build a Data Model. Note: In simple terms the Data Model is data that is collected from the get data […]
Ok, I’ve got to be honest the first two tutorials (Loading Excel Files, Loading CSV Files) were only there to get things kicked off. Now we are getting to some of the good stuff. When […]
This post is going to be similar to my previous post about Getting Data. I figure we better cover some of the basics before going crazy with deeper topics. Materials for this tutorial: CSV file […]
Copyright © 2024 | MH Magazine WordPress Theme by MH Themes