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
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 […]
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?
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 […]
Continue reading Using DATEADD() and other Date Tips for Filtering Data in Power BI
I recently came across a requirement to report the number of devices owned by customers, along with the age of each of the devices (how long it had been in service). The idea behind it was to be able to quickly see customers that had the majority of their devices within the replacement window (10+ […]
Continue reading Using Color Gradients to Improve Your Visuals
I recently ran into a scenario where I developed a Power BI report against a SQL database using a live connection, and later developed a Tabular cube that I wanted to use to replace the SQL data source. As it turns out, replacing one live data source with another is not as straightforward as it […]
Continue reading How to Replace a Data Source Connection With a Live Connection in Power BI
This weekend I spent some time researching how to leverage Azure’s Stream Analytics engine and testing out the connection to Power BI in order to create a dashboard with a near real-time data feed. There are many different business scenarios where real-time data provides valuable insight and can help a company adjust to changes more […]
Continue reading Using Stream Analytics and Power BI to Analyze Data in Real-Time
A few years back I got to work on a project for a client that was interested in relating weather data (rain precipitation, temperature, cloudiness, etc.) to their sales metrics in order to validate an assumption that the weather had an impact on how their sales performed in different parts of the country. During management meetings, […]
With another amazing year of Wimbledon wrapping up this weekend, I wanted to share some interesting stats about the tournament, and what better way to show these than through Power BI? Click on the image below to access an interactive Power BI dashboard and views stats from the matches played so far in the tournament:
As Microsoft continues to release new product updates, and most recently with the launch of new reporting features in SQL Server 2016, I thought it would be a good idea to take a broader look at where Microsoft is planning to go in the future, and review how all of these reporting components fit together. On-Premises vs. […]
