Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

01 September
2015
Author: BradGall

Intro To Datazen: Dashboard Development

Last week I presented a Intro to Datazen Dashboard Design webinar with Pragmatic Works.  The goal of the webinar is to get you started with the basics of creating Datazen Dashboards with Datazen Publisher and your Datazen Enterprise Server.  If you weren’t able to attend a recording was just...
01 September
2015
Author: DustinRyan
DustinRyan

10 DAX Calculations for your Tabular or Power Pivot Model (Part 1)

If you’ve read my blog for a while you may have seen the following posts: Ten MDX Calculations For Your Cube (part 1) Ten MDX Calculations For Your Cube (part 2) Well the time has come for me to put together a compilation of ten useful DAX calculations for your Tabular or Power Pivot model (in...
01 September
2015
Author: DustinRyan
DustinRyan

Join Me for Free #PowerPivot Training w/ @ExcelBIPASS Sept 10 – 12p CDT

I’m excited to be able to say that coming up next week on Thursday September 10, I’ll be presenting my session Power Pivot 101: An Introduction to the PASS Excel BI Virtual Chapter! For a lot of users, Power Pivot is like the Ferrari you had in your garage but weren’t aware and that’s one of the...
28 August
2015
Author: DustinRyan
DustinRyan

5 Tips for #PowerBI

After a couple months of fun with Power BI, I’ve picked up a few little tricks along the way that have helped me to be able to create some pretty cool data visualizations and dashboard reports. Here are five Power BI tips and tricks that you may find useful as you begin creating dashboards for...
28 August
2015
Author: SteveHughes

Using Power BI with HDInsight Part 2: Power BI Desktop and Hive

With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help you take advantage of those big data investments. If you need to set up a cluster to work with, check out my previous posts on Setting Up an HDInsight Cluster and Loading Data Into Your New...
27 August
2015
Author: SteveHughes

Using Power BI with HDInsight Part 1: Power Query and Files

With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help you take advantage of those big data investments. If you need to set up a cluster to work with, check out my previous posts on Setting Up an HDInsight Cluster and Loading Data Into Your New...
26 August
2015
Author: SteveHughes

Uploading Files to an HDInsight Cluster (No Scripting Required)

As I noted in my first post, I am not a fan of scripting. In that post we set up a cluster without using scripts to do so. Now we are going to look at how to upload files without scripts. While this will work for our demo and learning purposes, I would encourage you to use scripting to handle...
25 August
2015
Author: DustinRyan
DustinRyan

Taking #PowerPivot to the Next Level

Power Pivot is an amazing, flexible and powerful business intelligence and there is no doubt about that fact. As a feature included with Excel 2013 and 2016 (and an add-on for Excel 2010), Power Pivot allows user with a little technical expertise to integrate disparate data source together within...
25 August
2015
Author: SteveHughes

Exploring the Microsoft Azure HDInsight Query Console (No Scripting Required)

As I noted in my previous post, I am not a fan of scripting. In that post we set up a cluster without using scripts to do so. Before we get to the steps to load our own data, I wanted to take a moment and explore the HDInsight Query Console or Dashboard (according to the link on the Azure...
24 August
2015
Author: SteveHughes

Setting Up an HDInsight Cluster (No Scripts Required)

Let me start by saying, I am not a fan of scripting. It definitely has its place and a lot of my peers really like it. It is the easiest way to get functionality out from software vendors such as Microsoft. PowerShell is an incredibly powerful tool which can do just about anything. However,...