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+ […]
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 […]
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 […]
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. […]
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.
On January 27th, 2015 James Phillips – Microsoft’s General Manager for Data Experiences announced the latest developments in Power BI. The latest news include the availability of Power BI FREE for everyone, as well as subscription based version called Power BI Pro. In addition, there is a new tool available, called Power BI Designer, which […]