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.

23 January
Author: Anil

How to Schedule and Automate backups of all the SSAS catalogs within the Server Instance.

This is a research project that I had done; the main goal of this project is to schedule the backup of all the SSAS catalogs and SQL database from the server to the specific location automatically. With the course of time, you might need to backup all the SSAS databases within a server instance...
21 October
Author: Surendra

SSRS - Table Row Visibility onMultiple pages

This artical contains SSRS table row,column headers visibility on each page

02 August
Author: okeofs

Flexible Fiscal Data Sorting

Presenting data for a custom fiscal year

10 July
Author: Eric D

SSRS - Insert details section under existing group

When looking how to add a details section I searched for a while and found lots of examples of how to add groups to an already existing details section, or working from details going up each group. I didn't find anything for a pre-existing report where the details section was already deleted...
24 June
Author: Steve Simon

Dynamic calculations of running totals

Dynamic calculations of running totals

11 January
Author: MitchellPearson

SSRS Tutorials and SSRS Videos. A great starting place for beginners.

One of the great things about the SQL Community is that there are so many great resources out there for anyone who wants to learn. However, sometimes the amount of resources can be a bit overwelming so I have put together a list of links to tutorials and videos that I have found while searching...
26 July
Author: Surendra

Create a Sample Report in Power View

Power View is a server side Silverlight based application which runs in a web browser. The intention of this product is to be able to present the data in meaningful way using highly interactive visualizations, animations, smart querying and presentation capabilities.

16 July
Author: MikeDavis

Crystal Reports DataDate in SSRS

Crystal Reports has a special field name ?DataDate?. This date shows the last time the data on the report has been executed. A recent client asked for the similar functionality in SSRS when a snapshot is run. They wanted to see the actual date for to be used as a print date but they wanted to...
06 July
Author: ChrisAlbrektson

Check out my SSRS 2012 Webinar

Pragmatic Works and Wrox have teamed up for a series of webinars that focus on the new release of SQL 2012 and the new SQL 2012 books from Wrox. On Tuesday July the 10th at 11 EST I will be giving a presentation titled, Getting Started with SSRS 2012. This will be an introduction type session and...
24 May
Author: karthi.kamal

Trend line for Line chart in SSRS 2005

This article will help to draw the Trend Line for Line chart in SSRS 2005 .this was done through by calculating the data points for the specific data .the mathematical formula for find the trend line was Y=Mx+C.i was searched more links to solve this problem but i didnt get any solution. i tried...