Dec 14

Part-2: Data Warehouse, Business Intelligence Learning Resources

Topics Include

- Financial & process dashboards
- ETL solutions using SSIS
- Develop reports using SSRS
- OLAP solutions using SSAS
-Cube design
- Programming Languages: T-SQL, MDX
-Modeling Tools: Embarcadero ER Studio, CA Erwin, Visio
-Development Tools: Visual Studio, SSDT, PerformancePoint Dashboard Designer.

Related to Financial & process dashboards 

Building Real-World Microsoft BI Dashboards Today

http://sqlmag.com/blog/building-real-world-microsoft-bi-dashboards-today

 

Bi Dashboard Reporting For Microsoft Sql Server Analysis Services

https://www.inetsoft.com/solutions/bi_dashboard_reporting_for_microsoft_sql_server_analysis_services/

 

Dashboard - Templates - Office - Microsoft

http://office.microsoft.com/en-ca/templates/dashboard-TC101915534.aspx

 

50+ Best Free Excel Templates & Dashboards To Help You Get Ahead at the Office

http://www.skilledup.com/articles/best-free-excel-templates-dashboards/

 

Dundas Dashboard Tools

http://www.dundas.com/dashboard/features/microsoft-bi-technology/

 

Related to: ETL solutions using SSIS

Designing an ETL process with SSIS: two approaches to extracting and transforming data: http://blogs.msdn.com/b/andreasderuiter/archive/2012/12/05/designing-an-etl-process-with-ssis-two-approaches-to-extracting-and-transforming-data.aspx

 

Considerations for High Volume ETL Using SQL Server Integration Services

http://msdn.microsoft.com/en-us/library/cc671624.aspx

 

Build a Simple ETL System with SSIS

http://sqlmag.com/database-administration/build-simple-etl-system-ssis

 

Planning the SQL Server ETL implementation strategy using SSIS for Extracts

http://www.mssqltips.com/sqlservertip/1923/planning-the-sql-server-etl-implementation-strategy-using-ssis-for-extracts/

 

Related to: Develop reports using SSRS

 

Building Your First SSRS Report

http://www.codeproject.com/Articles/621332/Building-Your-First-SSRS-Report

 

SQL Server Reporting Services (SSRS)

http://www.mssqltips.com/sqlservertutorial/222/sql-server-reporting-services-ssrs/

 

Related to:  OLAP solutions using SSAS

Create First OLAP Cube in SQL Server Analysis Services

http://www.codeproject.com/Articles/658912/Create-First-OLAP-Cube-in-SQL-Server-Analysis-Serv

 

Microsoft SQL Server OLAP Solution

http://www.diva-portal.org/smash/get/diva2:350060/FULLTEXT01.pdf

 

Understanding OLAP Cubes

http://technet.microsoft.com/en-us/library/hh916543.aspx

 

Cube Design:

 

Cube Designer (Analysis Services - Multidimensional Data)

http://msdn.microsoft.com/en-ca/library/ms188152.aspx

 

The Art of Cube Design

http://sqlmag.com/database-performance-tuning/art-cube-design

 

Build a Cube From an Existing Data Source Using SQL Server Analysis Services

http://www.mssqltips.com/sqlservertip/1532/build-a-cube-from-an-existing-data-source-using-sql-server-analysis-services/

 

Transact-SQL Reference (Database Engine)

http://msdn.microsoft.com/en-us/library/bb510741.aspx

 

Related to MDX:

MDX Query Fundamentals (Analysis Services):

http://msdn.microsoft.com/en-us/library/ms145514.aspx

 

The Basic MDX Query (MDX)

http://msdn.microsoft.com/en-us/library/ms144785.aspx

 

PerformancePoint Dashboard Designer

https://support.office.com/en-sg/article/Getting-Started-PerformancePoint-Dashboard-Designer-88a12097-833c-40ee-86b4-beddd65506e6

 

Getting acquainted with PerformancePoint Dashboard Designer

https://support.office.com/en-in/article/Getting-acquainted-with-PerformancePoint-Dashboard-Designer-9e014283-afec-4819-87b9-78be6f6ef0d0

 

Up to Speed with PerformancePoint Dashboard Designer

https://support.office.com/en-ie/article/Up-to-Speed-with-PerformancePoint-Dashboard-Designer-b58539ee-314c-4b2a-ad37-ce988d0a8d53

 

Related To:

Embarcadero ER Studio : Data Architect - Quick Start Guide: http://docs.embarcadero.com/products/er_studio/erstudio9.0/ERStudioDAQuickStart.pdf

 

ER-Studio Tutorials

http://www.youblisher.com/p/20510-manual/

 

 

 

 

 

 

Skip to toolbar