Column Comparisons in Power BI Using DAX

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 …

Continue reading Column Comparisons in Power BI Using DAX

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?

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

Continue reading Where Analytics Fits Best in Business