Microsoft MSBI Business Intelligence Video

First: Bi media installation, BI basics, BI methodology, and project presentations
1.BI basic knowledge, BI methodology implementation
2. Introduction to Microsoft BI (Data Warehouse Introduction, SSIS Introduction, SSAS Introduction, SSRS Introduction)
3.SQLSERVER database installation and goodness of Base library import, Visual Studio 2008 installation, PowerDesigner installation
4. Introduction of the content, process, case and precautions of the whole training

Second Lecture: Data Warehouse (SQL Server)
1. Concept and development of data Warehouse
2. Data Warehouse related technologies and concepts (dimension table, fact table, etc.)
3, Data Warehouse architecture and model (star model, snowflake model and other topics and modules design, etc.)
4, the Data Warehouse overall plan explanation and realization (constructs the Data Warehouse five steps)
5, the use of PowerDesigner for Data Warehouse modeling development, conceptual model, physical model design and development and application
6. Data Warehouse implementation method and establishment
7, the Data Warehouse classroom case explanation and realization

Third Lecture: ETL (SSIS)
1, ETL overview, ETL Design method,
2, ETL in enterprise-level applications, ETL tools Introduction
3, SSIS application, incremental extraction implementation, SSIS control explained,
4. Data flow, control flow, source control (from different databases), conversion control, target control and other applications
5, ETL cases, conversion between different databases, the use of advanced SSIS control
6. The explanation and realization of SSIS classroom case

IV: Multidimensional Database (OLAP) Analysis and Interpretation, SSAS application and interpretation
1. Cube Overview and Application
2. Analytical basis, cube analysis Method (roll up, drill down, slice, dice, rotate), 3, cube storage mode
4. SSAS tools explained, SSAS design multidimensional database, design dimension, dimension attribute, hierarchy,
5, Design cube, measure group, measure value, etc., build Star schema, snowflake schema.
6. The explanation and realization of SSAS classroom case

Lecture Five: Design and release of reports, application and explanation of SSRS
1, report definition, report composition and classification,
2, the data source of the report,
3. MDX definition, MDX app,
4, Matrix, rectangular block, list, sub-report, such as the use of controls, histogram, line chart, shape chart, the use of the scope chart
5. The explanation and realization of SSRS classroom case

Talk about SSRS reporting and Web integration, database Performance tuning, database performance optimization with

Explain, publish OLAP under IIS
1, SSRS Report and Web integration explained
2, SSRS Report How to achieve universality in Web integration
3. How to publish with Web integration
4, Database performance Optimization index, index fragmentation, statistical information, tuning content explained
5, Database performance optimization Tool data base object, index optimization, blocking, asynchronous data transmission, file group partition, partition function partition, SQL Mail and other functions explained
6. How remote client machines access OLAP, how to quickly publish OLAP under IIS

Seventh: Bi Summary and review tool explanation
1. Data Warehouse (PowerDesigner between different databases),
2, ETL (package configuration, log processing), SSIS, timestamp and other incremental update application
3, multidimensional database (timed processing multidimensional database), zoning, aggregation applications
4, Report (Analyzer demo), Qlikview and other reporting applications
5. The universality of report and portal integration
6. Deployment and release of data warehouses, SSIS Deployment and Release, SSAS deployment and release, SSRS deployment and development, and how to transform in production and development environments

Microsoft MSBI Business Intelligence Video