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) […]
Author: Victor Rocca
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:
Microsoft’s BI Reporting Roadmap
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. […]
Report Server 2016 Custom Branding
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.
Configuring SQL Server 2016 Components
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 […]