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.

02 May
2016
Author: AlanFaulkner

SQL Saturday Jacksonville 2016 – Long Travel for the Community

        Hello all!  Fueling up for the long haul!  I am contemplating fueling up the SQL Bug and doing a cross country run!  If I had the time, I probably would do it!  That would be quite the cross-country jaunt, over the hills, through the woods, and over the dunes, to the Atlantic coast of...
02 May
2016
Author: JasonStrate

Monday Morning SQL Break – May 2, 2016

Gotta love Mondays.  At least the weather here in Minnesota is clearing up, the last two weeks have been cold and overcast.  To get things started for the week, I’ll start again with a recap of the links I’ve shared and activity on my blog.  Also, for this this week, Michael Fal will be...
29 April
2016
Author: Robert Cain

Arcane Training and Consulting, LLC

Well this has been an exciting last few months. I’m finally able to share what’s been happening with me. As some of you know, I’ve left Pragmatic Works. They went through a reorganization of sorts, and several of us either had our positions eliminated, or as people departed were not replaced. Let...
28 April
2016
Author: SteveHughes

Power BI Is Finally in the Azure Trust Center

With the most recent announcement of Power BI’s inclusion in the Azure Trust Center, it is a good time to review where we are today with Power BI security and compliance as it relates to various customer needs. I do a lot of work with financial, energy, and medical customers. These groups...
26 April
2016
Author: DustinRyan
DustinRyan

Power BI and the Bing Maps API

This week I was working on a project for a school up North. This customer wanted to use Power BI and map visualizations to view the locations of the various school buildings in the district. The problem for this very large school district was that they were missing the street address information...
25 April
2016
Author: JasonStrate

Monday Morning SQL Break – April 25, 2016

It’s Monday and if getting a start on the week is as exciting for you as it is for me, it’s time to take a quick break.  For the break, here’s a summary of the most popular links and content that I shared out in the past week through this blog and twitter.  If you haven’t already, follow me on...
24 April
2016
Author: MitchellPearson

MDX CALCULATION WIZARD – 12 Awesome MDX Calculations

12 MDX Calculations for your SSAS Cube: If you have suddenly found yourself in a situation of having to improve the functionality of your cube with MDX Calculations but you don’t know MDX then you have come to right place!  Learning MDX can be a difficult task and one that can take some time, and...
20 April
2016
Author: SteveHughes

JSON in SQL Server 2016 – The Good, The Bad, and The Ugly

Microsoft introduced support for JSON data in SQL Server 2016 and in Azure SQL Database. I was excited to see this functionality coming. As an early user of XML when it was introduced, my expectations were high. Microsoft has done some really good work with JSON support, but I find that is not...
19 April
2016
Author: AlanFaulkner

Introduction to Azure Data Factory

Advanced Data Integration in a Modern Day Data Warehouse In recent surveys by TDWI Research, roughly half of respondents report that they will replace their primary data warehouse (DW) platform and/or analytic tools within three years. Ripping out and replacing a DW or analytics platform is...
16 April
2016
Author: SteveHughes

SQL Saturday #492 Follow Up – A Window into Your Data

Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any questions about the session post them in comments and I will try to...