Here’s an updated version of the 2016 Houston home appraisal values Power BI report. I included a Trends tab that makes use of Power BI’s forecast feature to project the Average Appraisal Value and YOY Appraisal Change for the years 2017-2020. It’s interesting to note that while homes continue to appreciate in value, the amount […]
Power BI
Using Color Gradients to Improve Your Visuals
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+ […]
Displaying a Power BI Dashboard in Your Office
cLast week I did some research on how to render a Power BI report on a TV for the purposes of displaying it in an office. A good case scenario for this is if you have a help desk or service desk team and you want to show how each person on the team is performing and how they […]
Analyzing Home Appraisal Values with Power BI
Have you ever been curious to know what the market value of your home is? Or how it compares to that of your neighbors? I had some of the same questions too, so I set out to look for a good dataset to build a dashboard on, and came across the Harris County Appraisal District’s (HCAD) […]
Troubleshooting Power BI On-Premises Gateway Errors
While troubleshooting some Power BI Data Gateway errors for one of my solutions, I came across a good post from Adam Saxton that walks you through how to troubleshoot common errors when working with On-Premises Data Gateways. You can check out his post here: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-tshoot/ In my case, my issue was dealing with authenticating users with an […]
Using Stream Analytics and Power BI to Analyze Data in Real-Time
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 […]
Weather Analysis Follow Up: Parsing through NOAA’s Data
Since my last Power BI dashboard on weather analysis in the U.S., I’ve had a few requests and questions around the data I used to build the dashboard and how I transformed it into a CSV file. In this post I’ll provide a step by step walkthrough of the process I used, along with a copy […]
Does weather affect your business?
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, […]
Power BI Tips and Best Practices
In this post I’ll be focusing on some best practices and tips to keep in mind when developing dashboards using Power BI. These tips have been gathered from personal experience and from other Power BI developers that have shared their experiences as well. Copy and Paste your visualizations to easily recreate the formatting used – Once […]
Analyzing Wimbledon 2016 with Power BI
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: