Category: SSIS/SSAS/SSRS/MDX

Tip & Tricks – SSAS Performance Tuning Flow Chart

In the Analysis Services Performance Guide white paper, Microsoft has introduces a very handy flow chat for tuning SSAS performance. The first and key step of the flow chat is to investigate whether the performance problem is caused by query processor or storage engine. If the problem lies in query processor, SSAS developers need to … Continue reading Tip & Tricks – SSAS Performance Tuning Flow Chart →

Creating Custom SSRS Spatial Map Reports for Dynamics CRM 2011

Creating Custom SSRS Spatial Map Reports for Dynamics CRM 2011

A CRM system in an organisation is often the central place to store business data related to customers, sales, and markets, which are highly valuable for any business. The BI feature in Dynamics CRM 2011 is very powerful which allows developers or even end-users to create report tables or charts very easily. However,  it is … Continue reading Creating Custom SSRS Spatial Map Reports for Dynamics CRM 2011 →

Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 4)

Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 4)

Part 1 – Introduction & Building the Back-End Reporting Database Part 2 – Developing SSIS Package to Import Data from Sharepoint List to Reporting Database Part 3 – Setup SQL Server Agent Job to periodically execute the SSIS Package Part 4 – Building Reports and Publish on Sharepoint using Excel Services This part of the … Continue reading Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 4) →

Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 3)

Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 3)

Part 1 – Introduction & Building the Back-End Reporting Database Part 2 – Developing SSIS Package to Import Data from Sharepoint List to Reporting Database Part 3 – Setup SQL Server Agent Job to periodically execute the SSIS Package Part 4 – Building Reports and Publish on Sharepoint using Excel Services This part of the … Continue reading Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 3) →

Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 2)

Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 2)

Part 1 – Introduction & Building the Back-End Reporting Database Part 2 – Developing SSIS Package to Import Data from Sharepoint Lists to Reporting Database Part 3 – Setup SQL Server Agent Job to periodically execute the SSIS Package Part 4 – Building and Publish Excel Reports on Sharepoint This is the second part of the … Continue reading Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 2) →

Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 1)

Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 1)

Part 1 – Introduction & Building the Back-End Reporting Database Part 2 – Developing SSIS Package to Import Data from SharePoint Lists to Reporting Database Part 3 – Setup SQL Server Agent Job to periodically execute the SSIS Package Part 4 – Building and Publishing Excel Reports on SharePoint Sharepoint is a rapid application development platform … Continue reading Using SSIS and Excel Services to Build a Lightweight Reporting Solution for SharePoint-Based Applications (Part 1) →

Chinook BI

Update: I built the original version of this solution in 2010, but I am updating the solution  with SSDT 2012. This is an entire  BI solution on Chinook sample database using SSIS, SSAS, and SSRS. Credits: Enterprise SSIS Framework has been used to implement the ETL componments in this soluiton. Please find Source Code here.