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 […]
While going through some of the tutorials for HDInsight I decided to test adding my own data set to Azure and running some Hive queries against it. There are 2 ways that I was able to do this. The first way was using Azure Storage Explorer. This has a nice UI that lets you click […]
Here’s a really helpful video that shows you how to leverage Hadoop through Azure HDInsight: Below are my notes I took throughout the video: Can do analytics with Hadoop to get petabytes worth of data down into a manageable size that can be consumed by Excel Hive is very similar to SQL Good for data that […]
Here’s a quick presentation walking you through HDInsight and the different components: Hd insight overview from vhrocca
I know I’m a bit late on finding out about this, but I thought I’d post about it anyway since not everyone may be aware. The good news: Power View now can now connect to Multidimensional data models (aka Cubes) The bad news: The functionality is only available on stand alone SharePoint (2010 or 2013), and […]
A cool feature of Power View is that it allows you add pictures from the web into your dataset to make your reports more visually appealing. The way to do this is pretty straightforward: 1. In Excel create a new sheet 2. Create a column with the ID or unique name of the field/attribute for […]
With Microsoft pushing its new features of BI front-end tools, I thought I’d spend some time breaking down the different component of Power BI and what you need for each one. Power BI comes in 2 flavors: On-Premise (via Excel 2013), and On-the Cloud (via SharePoint 365) Power BI – On Premise The on-premise tools consist […]
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 (...)