This week the Harris County Appraisal District (HCAD) completed its final round of updates to property values in the county for 2018. With this data we are now able to see a more clear picture of the impact that Harvey had on property values in the Houston metroplex. Quick Rundown of the Numbers A total […]
With Power BI Desktop’s July update now out for a few weeks, I wanted to write a quick review of the new features, focusing on my Top 3 for this month’s update. 1. Visual Headers Having the ability to completely remove the hovering visual headers from each visual, in addition to moving it inside the […]
Earlier this week Serena Williams made news regarding her take on how often she is being required to go through drug testing. Williams took to Twitter to voice her opinion, and suggested that she is being singled out compared to the number of drug tests her peers are having to go through. I figured this […]
While working with Dates in DAX, you may have come across an interesting behavior when working with the DATEADD() function. If have used this function in SQL, you have a good idea of how the function works and the parameters you pass to it in order to shift a date forward or backwards. However, this […]
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. […]
Thanks for sharing nice information about Hadoop and azure (...)
Hello, is there an option to have different folder color (...)
Thank you very much for such informations. but I want to (...)
Hi, I am exactly in the same problem. Even after 3 years of (...)
Hi this was really helpful. I'm using a digital solution (...)
Another option to add to this list for options to display (...)
There is a product called VuePilot that can help you with (...)
Good stuff! Go Reds
I am looking for a way to access the dashboard you (...)
Amazing post! Thank You for sharing such helpful (...)
Serena Williams is great player, but mostly wins from her (...)
Nice post. Is it possible to get a download of this .pbix (...)
When I use this method it does work, so thanks so much for (...)
Hi Craig - thanks. I've updated
Hello, it's great article. Is it possible somehow set (...)
Hey Victor, looks like the link to my site no longer works. (...)
Is there an option for full screen mode when using PowerBI (...)
Great post. no words to explain how thank you we
Hello, Thanks for this article! Any idea how to remove (...)
Lovely! Saved me a days work
What are the minimum rights necessary to be able to (...)
Good job ! Thank
OMG...Did not expect such a workaround could be available.I (...)
Hi AR - your calculated column only returns 8 clients for (...)
Activity = switch(true(), datediff(Clients[Last Activity (...)
Hi Venkat - I included link to download the file
Please share the PBIX
Hello, I am using Azure stream analytics to get telemetry (...)
This is awesome work, in one report you have handled many (...)
Thank
Hello Victor, it's fine now with lowercase thank you (...)
Hey Marin - make sure that "chromeless" is all lowercase. (...)
Hello, thanks for this tutorial it looks great (...)
Hello, thanks for this tutorial it looks great (...)
Hey Bob - check out this plug in for Chrome: (...)
Is there a way to rotate through multiple dashboards? We (...)
This is pretty neat. There's a new year out. I'm working (...)
Glad to hear that you found it
Very cool Victor! I'm getting ready to argue my property (...)
Thanks Adilson - I think both of them would
One quick note: The parameter, at the end of the URL must (...)
Hi Rashid - in that case you will need to map the server (...)
Hey thanks for the great post I am getting the same (...)
I am having a live screen running. One problem i faced is (...)
Hi , I have an issue with SSRS 2016 mobile reports. I tried (...)
Hi Judy - You will need the Enterprise version to use the (...)
Power BI reports in SQL Server Reporting Services can you (...)
Do you know if you need to have SQL 2016 Enterprise version (...)
Brutal!!!
Did you update the Twitter API keys with the ones from your (...)
Looks like I've got pass that but getting a " token has an (...)
Hi DS - can you try re-building the solution and seeing if (...)
Great blog post! I seem to get an error when running the (...)
[…] my last post I pointed out the different (...)