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 […]
Continue reading Houston Home Appraisal Values with Power BI
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 […]
Continue reading Displaying a Power BI Dashboard in Your Office
Power BI and SQL Server Mobile Report Publisher (previously known as Datazen) are both Microsoft BI tools that offer mobile reporting capabilities. Mobile Report Publisher is part of the SQL Server 2016 release and provides on-premise mobile reporting functionality to SQL Server Reporting Services. Power BI is a standalone cloud-based service that provides similar mobile reporting […]
Continue reading Comparing Power BI and SSRS Mobile Report Publisher
SQL Server Mobile Report Publisher does not have an intuitive way for moving a mobile report across servers, and I wasn’t able to find any documentation about this online. So how do you go about doing this? I came across a couple of options while testing different approaches, which are described below. If you have found a […]
Continue reading Migrating SSRS Mobile Reports Across Servers
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
Below are some new (maybe old for some of you!) tips & hints that will come in handy when building new Power BI reports: Use the Shift + Arrow Keys to Move Items in Bigger Increments If you’re trying to get the location of a visual just right, and need to use the arrow keys instead […]
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) […]
Continue reading Analyzing Home Appraisal Values with Power BI
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 […]
Continue reading Weather Analysis Follow Up: Parsing through NOAA’s Data
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, […]
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. […]
