Отличная пошаговая инструкция стратегу!
Материалы для разработчиков BI решений на платформе Microsoft
Путешествуя по раличным разделам необъятного сайта Microsoft, иногда наталкиваешься на залежи сверхполезной информации. Вот, оказывается, в феврале у нас прошел семинар для разработчиков BI решений с теорией и лабораторными работами (практикой). Вот материалы (к сожалению на английском, но все очень хорошо структурировано и понятно J):
Презентации
Microsoft Business Intelligence Voyage
Module 01 — Microsoft BI Strategy Overview
Module 02 — Introduction to Dimensional Modeling Techniques
Module 03 — Introduction to ETL Techniques Using SSIS
Module 04 — Advanced SSIS
Module 05 — Introduction to SSRS
Module 06 — Advanced SSRS
Module 07 — Designing a Report Model for Ad Hoc Reporting
Module 08 — Publishing and Accessing Reports with Reporting Services and Office
Module 09 — Introduction to the UDM
Module 10 — Accessing the UDM from SSRS and Excel Services
Module 11 — Advanced Data Analysis Using Excel 2007 and ProClarity 6.2
Module 12 — Introduction to SSAS Data Mining Models
Module 13 — Building Dashboards in Office SharePoint Server 2007
Module 14 — Monitoring KPIs with PerformancePoint Server 2007 Scorecards
Лабораторные работы
Lab 02A: Database Modeling. Creating the Reseller Sales Database Diagram
Lab 03A: Control Flow. Loading the Sales Quota Fact Table, Part 1
Lab 03B: Data Flow. Loading the Sales Quota Fact Table, Part 2
Lab 04A: Slowly Changing Dimensions. Loading the Employee Dimension
Lab 05A: Creating Managed Reports. Developing a Report for Publication
Lab 06A: Advanced Managed Reports. Enhancing the Report Design
Lab 07A: Report Builder. Self-Service Reporting
Lab 08A: Deploying and Accessing Reports. Deployment to SSRS
Lab 08B: Using the ReportViewer Control. Smart Client Integrated Reporting
Lab 09A: Building a Basic Cube. The Cube Wizard
Lab 09B: Working with Dimensions. Building and Enriching the Cube
Lab 09C: Calculations and KPIs. Building the Calculations Layer
Lab 09D: Cube Deployment. Developing an Installer Package
Lab 10A: UDM Reporting. Developing Reports for Reuse
Lab 10B: UDM Reporting. Developing Excel Reports Based on the UDM
Lab 11A: Advanced Data Analysis. Analyzing with Excel 2007
Lab 11B: Advanced Data Analysis. Analyzing with ProClarity 6.2
Lab 12A: Data Mining. Applied Mining for Meaning
Lab 13A: Building Dashboards. Creating a Dashboard Site
Lab 14A: Building and Deploying a Scorecard. Creating the Reseller Sales Scorecard