►INTRODUCTION
- Introduction SQL Server 2012.
- SQL-Architecture.
- GAM, SGAM, Pages, Extents.
- Database engine,
- Multiple instances,
- Sql server2012 editions,
- SQL Server 2012 databases and Objects,
- Sql Server Physical Structure.
- MSBI studio.
- What is new for MSBI in SQL Server 2012?
►MS-BI (SSIS, SSAS, SSRS)
►SSIS Objectives
- Plan data transfer and staging solutions for an ETL operation
- Plan an SSIS Solution
- Design and implement data flows
- Incorporate logging, error handling and reliability into a package
- Optimize an SSIS Solution
- Deploy an SSIS Solution
►Contents: Planning for ETL
- Identifying Data Sources and Destinations
- Evaluating Source Data
- Identifying Staging Requirements
►Planning an SSIS Solution
- Planning Packages
- Planning Package Development
- Designing Package Control Flow
►Designing Data Flow
- Understanding Data Flow
- Designing Data Flow Operations
- Handling Data Changes
►Logging, Error Handling and Reliability
- Logging ETL Operations
- Handling Errors in SSIS
- Implementing Reliable ETL Processes with SSIS
►Optimizing an SSIS Solution
- Monitoring SSIS Performance
- Optimizing SSIS Packages
- Scaling Out SSIS Packages
►Deploying and Operating an SSIS Solution
- Deploying SSIS Packages
- Operating an SSIS Solution
►SSAS Objectives:
- Describe how SQL Server Analysis Services can be used to implement Analytical solutions
- Create multidimensional analysis solutions with SQL Server Analysis Services
- Implement dimensions in an Analysis Services solution
- Implement measures and measure groups in an Analysis Services solution
- Query a multidimensional Analysis Services solution
- Customize an Analysis Services cube
- Deploy and secure an Analysis Services database
- Maintain a multidimensional Analysis Services solution
- Implement Data Mining solution
►Contents: Introduction to Microsoft SQL Server 2012 Analysis
►Services
- Overview of Data Analysis Solutions
- Over of SQL Server 2012 Analysis Services
- Installing SQL Server 2012 Analysis Services
►Creating Multidimensional Analysis Solution
- Developing Analysis Services Solutions
- Data Sources and Data Source Views
- Creating a Cube
►Working with Dimensions
- Configuring Dimensions
- Defining Hierarchies
- Sorting and Grouping Attributes
►Working with Measures and Measure Groups
- Working with Measures
- Working with Measure Groups
►Querying Multidimensional Analysis Solutions
- MDX Fundamentals
- Adding Calculations to a Cube
►Customizing Cube Functionality
- Implementing Key Performance Indicators
- Implementing Actions
- Implementing Perspectives
- Implementing Translations
►Deploying and Securing an Analysis Services Database
- Deploying an Analysis Services Database
- Securing an Analysis Services Database
►Maintaining a Multidimensional Solution
- Configuring Processing Settings
- Logging, Monitoring and Optimizing an Analysis Services Solution
- Backing Up and Restoring an Analysis Services Database
►Introduction to Data Mining
- Overview of Data Mining
- Creating a Data Mining Solution
|