MSBI

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

Ecorp Trainings has designed The Business Intelligence Track to help bring professionals to the next level in their career by learning to design and develop business intelligence systems that help reduce the complexity of organizing and distributing information for mid- to large-size organizations through the use of Microsoft Business Intelligence tools.

At the end of the training, participants will be able to:

Pre-requisite

  1. Conceptual understanding of OLAP solutions
  2. Experience navigating the Microsoft Windows Server environment
  3. Experience with Windows services (starting and stopping)
  4. Experience creating service accounts and permissions
  5. Some experience with Microsoft SQL Server, including:
  6. QL Server Agent
  7. SQL Server query language (SELECT, UPDATE, INSERT, and DELETE)
  8. SQL Server System tables

Duarion

5  days

Course Outline

  1. Core concept BI is the cube or UDM
  2. Example cube as seen using Excel pivot table
  3. MS BI is comprehensive more than Analysis Services on SQL Server
  4. Demonstration of SQL Reporting Services with cube as data source
  1. Modeling source schemasstars and snowflakes
  2. Understanding dimensional modeling Dimensions (Type 1, 2, or 3) or rapidly changing
  3. Understanding fact (measures) and cube modeling
  4. Other types of modelingdata mining etc
  1. Understanding the development environment
  2. Creating Data Sources and Data Source Views
  3. Creating cubes using the UDM and the Cube Build Wizard
  4. Refining Dimensions and Measures in BIDS
  1. KPIs
  2. Perspectives
  3. Translations cube metadata and currency localization
  4. Actions regular, drill-through and reporting
  1. Using multiple fact tables
  2. Modeling intermediate fact tables
  3. Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions
  4. Modeling changing dimensions Dimension Intelligence w/ Wizard
  5. Using the Add Business Intelligence Wizards write-back, semi-additive measures, time intelligence, account intelligence
  1. Storage topics basic aggregations, MOLAP
  2. Advanced Storage Design MOLAP, ROLAP, HOLAP
  3. Partitions relational and Analysis Services partitions
  4. Customizing Aggregation Design Processing Design
  5. Rapidly changing dimensions / ROLAP dimensions
  6. Welcome to the Real Time Proactive Caching
  7. Cube processing options
  1. Basic syntax
  2. Using the MDX query editor in SQL Server Management Studio
  3. Most-used Functions & Common tasks
  4. New MDX functions
  1. Adding calculated members
  2. Adding scripts
  3. Adding named sets
  4. .NET Assemblies
  1. Best practices health monitoring
  2. XMLA scripting (SQL Mgmt Studio)
  3. Other Documentation methods
  4. Security roles and permissions
  5. Disaster Recovery backup / restore
  6. Clustering high availability
  1. What and why?
  2. Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Nave Bayes, MS Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)
  3. Data Mining dimensions
  4. Data Mining clients
  5. Processing mining models
  1. Excel 2003 Pivot Tables
  2. SQL RS & Report Builder
  3. SPS RS web parts & .NET 2.0 report viewer controls
  4. Business Scorecards 2005 & ProClarity
  1. SharePoint 12 and AS
  2. Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter
  3. Excel Services 12 and AS (Web Services)
  1. Overview of Control Flow in SSIS
  2. Control Flow Tasks
  3. Workflow Tasks
  4. Other SQL Operations Tasks
  5. Precedence Constraints
  6. Data Processing Task
  1. Data Flow Overview
  2. Data Flow Pipeline
  3. Data Flow Sources
  4. Data Flow Destinations
  5. Data Viewers
  6. Data Flow Transformations
  1. Understanding Variables
  2. Using Variables in Control Flow
  3. Using Variables in Data Flow
  4. Understanding Property Expressions
  5. Understanding Configurations
  6. User Configurations
  7. Using Variables and Configurations between Packages
  1. Advanced Control Flow Overview
  2. Using Containers
  3. Transactions Support in SSIS
  4. Additional Control Flow Tasks
  1. Overview of Deploying Packages
  2. Deployment Challenges
  3. Create a Package Deployment Utility
  4. The Package Installation Wizard
  5. Deploy a Package to the File System
  6. Deploy a Package to SQL Server
  7. Redeploying Updated Packages
  1. Overview of Package Management
  2. Managing packages with DTUtil
  3. Managing packages with SQL Server Management Studio
  4. Executing Packages
  5. Scheduling packages with SQL Server Agent
  6. SSIS Security
  1. Extending SSIS Capabilities Through Code
  2. The SSIS scripting
  3. Scripting in Control Flows
  4. Scripting in Data Flows
  5. Custom SSIS Components
  1. Best Practices for Using SSIS
  2. Best Practices for Package Design
  3. Data Flow Best Practices
  1. Using SSIS Beyond ETL
  2. Migrating SQL Servers with SSIS
  3. SQL Server Maintenance Plans
  4. Working with Analysis Services
  5. Folder and File Management
  6. Working with Windows Event Log

Reviews