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


Bi Dashboard Reporting For Microsoft Sql Server Analysis Services


Dashboard - Templates - Office - Microsoft


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


Dundas Dashboard Tools


Related to: ETL solutions using SSIS

Designing an ETL process with SSIS: two approaches to extracting and transforming data:


Considerations for High Volume ETL Using SQL Server Integration Services


Build a Simple ETL System with SSIS


Planning the SQL Server ETL implementation strategy using SSIS for Extracts


Related to: Develop reports using SSRS


Building Your First SSRS Report


SQL Server Reporting Services (SSRS)


Related to:  OLAP solutions using SSAS

Create First OLAP Cube in SQL Server Analysis Services


Microsoft SQL Server OLAP Solution


Understanding OLAP Cubes


Cube Design:


Cube Designer (Analysis Services - Multidimensional Data)


The Art of Cube Design


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


Transact-SQL Reference (Database Engine)


Related to MDX:

MDX Query Fundamentals (Analysis Services):


The Basic MDX Query (MDX)


PerformancePoint Dashboard Designer


Getting acquainted with PerformancePoint Dashboard Designer


Up to Speed with PerformancePoint Dashboard Designer


Related To:

Embarcadero ER Studio : Data Architect - Quick Start Guide:


ER-Studio Tutorials







Skip to toolbar