Earlier this week I posted a challenge for creating a dynamic date filter using DAX. If you want to see the challenge first and see if you can solve it, check out that post first. If you just want to see how it’s done, read on… The Challenge Based on the Date field of […]
Power BI Report Challenge – Last Activity Date
This week I’m doing something a little bit different. I wanted to post a challenge that I think could apply to many business scenarios, and see the different approaches that people might take to get to the same solution. The challenge is the following: Based on Date field of when a Client last had an […]
Harris County Final Appraisal Values for 2018
This week the Harris County Appraisal District (HCAD) completed its final round of updates to property values in the county for 2018. With this data we are now able to see a more clear picture of the impact that Harvey had on property values in the Houston metroplex. Quick Rundown of the Numbers A total […]
2018 PGA Tour Player Analysis
This week we look at some golf numbers from the PGA Tour and try to find some patterns in the data worth sharing in a Power BI report. The inspiration for this post came from watching Tiger Woods make a run for the PGA Championship this past Sunday. Although he came up short, it made […]
Power BI Desktop July Update Review
With Power BI Desktop’s July update now out for a few weeks, I wanted to write a quick review of the new features, focusing on my Top 3 for this month’s update. 1. Visual Headers Having the ability to completely remove the hovering visual headers from each visual, in addition to moving it inside the […]
Is Serena Williams Being Singled Out by Tennis’ Drug Testing Agencies?
Earlier this week Serena Williams made news regarding her take on how often she is being required to go through drug testing. Williams took to Twitter to voice her opinion, and suggested that she is being singled out compared to the number of drug tests her peers are having to go through. I figured this […]
NBA Trades ’18-’19 Season
With the Lakers making headlines this season due to all their recent trades, I wanted to do some analysis on the overall number of trades that have occurred so far this season and see which teams are making the most moves. I pulled some data from Wikipedia for all the trades that have occurred so […]
FIFA World Cup 2018 – English Premier League Players
This week I’m starting a new series of posts aiming to leverage Power BI to visualize data about a current event for that week. With the World Cup coming to an end today, I wanted to share some insights around the number of players from the Premier League that participated in the World Cup. In […]
Using DATEADD() and other Date Tips for Filtering Data in Power BI
While working with Dates in DAX, you may have come across an interesting behavior when working with the DATEADD() function. If have used this function in SQL, you have a good idea of how the function works and the parameters you pass to it in order to shift a date forward or backwards. However, this […]
Analyzing Home Values in Houston After Hurricane Harvey Using Power BI
As the 1 year mark since Hurricane Harvey hit Houston approaches, I wanted to do some year over year analysis on home appraisal values. My goal was to get an idea of the financial impact to home values after all the flooding that occurred in the area. This post shows the result of that analysis, […]