SQL Server 2012商业智能解决方案高级培训.pptxVIP

SQL Server 2012BI Solution Deep Training ;Outline;What is Business Intelligence？;The Business Problem;What Is a Data Warehouse?;;;BI Projects;;CEO’s Idea;Data Warehouse Designer’s will see;And then…;;Scenario-Reporting;;Creating Reporting Services Reports;Power View;Scenario-Data Analysis;;;Using Excel As a Data Analysis Tool;Outline;Design and Implement Data Warehouse;Lesson 1: Logical Design for a Data Warehouse;Introduction to Dimensional Modeling;;Considerations for Dimension Tables;;;Transact-SQL scripts using Date/Time functions Microsoft Excel functions Autogeneration by BI tools;Lesson 2: Physical Design for a Data Warehouse;;;;;Outline;SQL Server Integration Service;Lesson 1: Introduction to ETL with SSIS;;What Is SSIS?;SSIS Projects and Packages;The SSIS Design Environment;Lesson 2: Exploring Source Data;;;Profiling Source Data;Lesson 3: Implementing Data Flow;Connection Managers;The Data Flow Task;;Data Destinations;;Optimizing Data Flow Performance;Lesson 4: Implementing Control Flow;Control Flow Tasks;;;;Creating a Package Template;;;;Introduction to Containers;Sequence Containers;For Loop Containers;;;;;Lesson 5: Implementing an Incremental ETL Process;;Considerations for Incremental ETL;Slowly Changing Dimensions;Options for Extracting Modified Data;;Change Data Capture;Extracting Data with Change Data Capture;The CDC Control Task and Data Flow Components;Options for Incrementally Loading Data;Using CDC Output Tables;The Lookup Transformation;The Slowly Changing Dimension Transformation;The MERGE Statement;Lesson 6: Troubleshooting ,Configuring and Deploying SSIS Packages;Overview of SSIS Debugging;Viewing Package Execution Events;Breakpoints;Data Viewers;;;Implementing SSIS Logging;Viewing Logged Events;;Implementing Event Handlers;Handling Data Flow Errors;SSIS Deployment Models;Package Deployment Model;Project Deployment Model;Deployment Model Comparison;Creating an SSIS Catalog;Environments and Variables;Deploying an SSIS Project;Viewing Project