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 […]
Business Intelligence
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 […]
Continue reading Power BI Report Challenge – Last Activity Date
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 […]
Continue reading Harris County Final Appraisal Values for 2018
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 […]
Continue reading Is Serena Williams Being Singled Out by Tennis’ Drug Testing Agencies?
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 […]
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, […]
Continue reading Analyzing Home Values in Houston After Hurricane Harvey Using Power BI
PASS Summit Recap – Days 1-3
This post is a continuation of my last post, PASS Summit 2017 Recap – PreCon Sessions and focuses on days 1-3 of the conference. The next few days at PASS Summit were jam-packed with sessions, key-note speakers, vendors, and networking events. I tried picking the sessions that would give me the most benefit by attending in […]
PASS Summit 2017 Recap – PreCon Sessions
This last week I had the opportunity to attend my first PASS Summit in Seattle, and it was an awesome experience! I got to meet lots of great people, ran into some old colleagues, and learned about the latest tools and technologies. I’ll summarize my first 2 days at the conference in this post and […]