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 […]
Continue reading Working with the new features of SQL Server 2016
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!
Continue reading PowerMap – Houston Single-Family Home Appraisals 2014-15
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 […]
Continue reading Upload your own data to Azure Blob storage using Azure PowerShell
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 […]
Continue reading Power View Now Connects to Multidimensional SSAS Cubes
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 […]
Continue reading Adding Pictures from the Internet into a Power View Report
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 […]
