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.

31 May
2016
Author: DustinRyan
DustinRyan

Power BI Desktop May 2016 Update Info: Conditional Formatting and Quick Calc

So it appears that the May 2016 update to Power BI Desktop has dropped without any notification from the Power BI team on their blog. So I figured I’d take a moment to point out a couple new enhancements to Power BI Desktop. New to Power BI Desktop? Get started here. 1. Conditional Formatting...
23 May
2016
Author: Joshua Luedeman

The Cloud: The Real Deal or the Next Big Fad

I am an unapologetic cloud enthusiast. When Amazon Web Services became publicly available, I signed up for the first roll out of developer credits to try the service out. I remember signing up for Azure credit when the free month Read More ...
23 May
2016
Author: JasonStrate

Monday Morning SQL Break – May 23, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog. You may have...
23 May
2016
Author: JasonStrate

Monday Morning SQL Break – May 23, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog. You may have...
23 May
2016
Author: JasonStrate

Monday Morning SQL Break – May 16, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog. Most Popular...
23 May
2016
Author: JasonStrate

Monday Morning SQL Break – May 16, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog. Most Popular...
20 May
2016
Author: BradleyBall

SQL Server Random Workload Generator

Hello Dear Reader!  Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog).  He’s an Microsoft Data Platform MVP, MCM,  part of the amazing crew over at SQLSkills, and a really nice guy.  About 4 years ago Jonathan created The AdventureWorks2008R2 BOL...
20 May
2016
Author: MitchellPearson

How to get Line Item Detail information with Totals in T-SQL (Percent of Parent).

Hi All, This blog post is a follow up to a question I received when I gave my Advanced TSQL Webinar for Pragmatic Works. If you haven’t seen that yet and would like to see it you can view the webinar here:  Question: How can we get SubTotals in TSQL using the CTE method you mentioned? In my...
16 May
2016
Author: DustinRyan
DustinRyan

10 SQL Server Data Warehouse Design Best Practices to Follow (Part 1 )

This past Saturday I had the pleasure of speaking at SQL Saturday #552 here in beautiful Jacksonville, Florida. My good friend, Mitch Pearson ( blog | twitter ), and I presented our session, Designing a Data Warehouse from the Ground Up. We had a great crowd and lots of great questions from the...
11 May
2016
Author: MitchellPearson

Advanced T-SQL Webinar / Free Training

Thank You! First of all thank you to everyone who attended my T-SQL presentation on 5/10/2016. We had over 1400 people registered for the training and 871 people joined and listened in, that’s a lot of people! I also received a lot of good and encouraging feedback so thank you for that as...