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.

06 May
2014
Author: Anil
Anil

Using Power Query to tell your story form your Facebook Data.

Using Power Query to tell your story form your Facebook Data.

Most of the time of this weekend, I spent my time to extract the story behind my Facebook data by using Power Quer

16 April
2014
Author: Anil
Anil

How to transpose rows to columns in oracle.

In some case we need to transpose the table data that means we need to change the rows value into columns, and then this blog post will be surely helpful.

Let’s say we have to find ou

20 February
2014
Author: CraigLove

SQL Server Firewall Settings - Part 3

This is the 3rd part of my series of blog posts I am writing regarding configuring firewalls to permit connections to SQL Ser

27 January
2014
Author: CraigLove

(Repost) Dimension Attribute Relationships – Rigid vs. Flexible

As a consultant for PragmaticWorks, I work with a lot of different people.  I have noticed that there is a lot of confusion about dimension attribute relationships with SQL Server Analysis Ser

19 January
2014
Author: CraigLove

Windows 8.1 Upgrade And SQL Server Configuration Manager

After some hesitation I installed Windows 8.1 on my main laptop.  I am familiar with the new interface and so there were no surprises in that regard.  However, I was quite fond of Windows

18 January
2014
Author: Pradeep Dahiya

Tabbed SSRS Report

Creating a tabbed report in SSRS will be same as creating good UI report using HTML, JQuery etc.

Even with countless properties of SSRS there is no direct way to create a tabbed report arch

16 January
2014
Author: CraigLove

Deep Dive Into SSRS and Data Connection Permissions

A couple weeks ago I ran across a problem when setting up a shared data connection for a SQL Server Reporting Services in a test environment.  After beating my head against the desk for a few

25 November
2013
Author: Besim Ismaili

Another approach to Time Intelligence

Best Parctices for Time Scale solution 
This is an original method that I use when I build SSAS Cubes and it is time to share it with you 

22 November
2013
Author: AlexNykolaiszn

How to Give your Boss a Headache - an Introduction to Dashboard & Report Design

Hello. Please enjoy my presentation from SQL Saturday #248 Tampa BI

If you have any questions please feel free to reach out ot me.

Thanks!

 

12 November
2013
Author: RCharCox

Query Plans and what OPTION(RECOMPILE) does.

The other day I was tasked with creating a pretty intensive query (hey, I’m not an expert on T-SQL yet), and I came across a stored procedure that read something to the effect of:

&nb