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 […]
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, […]
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 […]
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. […]
This post shows how to edit the different attributes in the Colors.json file, and what parts of the SQL Server Mobile Report Publisher each attribute relates to.
In my last post I pointed out the different components in SQL Server 2016 that are available for reporting. In this post, I will walk you through the configurations of each component, and highlight some of the things that you need to look for in order to make everything work. The steps below walk you through what needs […]
So after taking a hiatus from my blog, I’ve decided to start posting again and keep you up to date on the latest technology I’m working with. In this post, I’m highlighting the new reporting features available with SQL Server 2016, which is set to be released June 1st of this year. As you may […]
Here’s another video I created using PowerMap. This one shows high growth areas in Houston real estate based on year over year prices as recorded by Houston County Appraisal District (HCAD). Enjoy!
Here’s a video built using Power Map for Excel showing Houston crime statistics for 2014. Power Map lets you build a story and highlight points that you can share during a presentation, or post online for other users to view.