Have you ever needed to show percentage increases or variances between columns in Power BI? Well, here’s a method through DAX formulas to show it. At first, the idea of using tables in Power BI may not be considered the glamorous flashy way to show data visualization. I would argue that the clean interaction and …
Parameters in Power BI
Guy in a Cube had a great video on using Parameters to dynamically update information pulled in from the database to a Power BI report (view it here). At the time I discovered this video I was looking for something similar. The one difference was I wanted to select multiple items in one report. In other words, in Guy in a Cube’s example, he pulls one StudentID into his report. What if I wanted to pull three, four, or five StudentIDs at once?
Manipulating Strings in Excel
Changing parts of data within an Excel cell, AKA String Manipulation, consists of a few simple functions. Once we understand the basics, we can look at how to combine them to do perform complex maneuvers. When I use the term string, I am referring to a series of alphabetic, numeric, and other characters (e.g. comma, …
Importing Data into PowerPivot Part 1
Jumpstart your PowerPivot knowledge with this post. This Excel add-on can do some serious heavy lifting when it comes to crunching data. Here is an easy way to practice using PowerPivot with a free large dataset. Microsoft PowerPivot extends the capabilities within Excel to BI Analytics. The process is to pull data in from a …
Where Analytics Fits Best in Business
Understanding the business you are in is critical to producing quality work. The further an analytical resource is from this knowledge, the more likely the results are churned out without vetting the validity of the data. Then again, individuals immersed too heavily in the culture or business can produce biases when analyzing for honest answers. …
Months in an Excel Dropdown
When I find I am performing the same task repeatedly, I look for ways to make my life easier. I prefer spending my time doing new and exciting things, not monotonous and redundant activities. Often, these experiences give me the chance to try something that will save time, and keep me entertained. One example of …
First blog post
This is the excerpt for your very first post.
