About The Course

Microsoft Business Intelligence training courses is designed to help IT professionals to enhance their career to advance levels. It systematically covers the use of the latest forms of Microsoft BI tools.. In this course you will get practical knowledge of T-SQL and designing of ETL Solution architecture using SQL Server Integration Services (SSIS), Understand the concept and need for ad-hoc reports, Integrate various BI tools to build a complete BI solution, Know the concepts of OLAP database and tables in SSAS and Understand the different mechanisms of the Microsoft Business Intelligence Stack.

ELearningLine’s self-paced learning,  online and classroom MS Business Intelligence training programs are present which widely cover techniques of Data Modeling, Data Representation and Data Transformation for Business Intelligence, Install and configure end-end MSBI system. You will expand your knowledge on MDX Queries and learn in-depth understanding of the architecture of SSRS and its components, Build and create charts, reports and dashboards using SQL Server Reporting Services.          

Course Objectives

1. After the completion of Microsoft BI course with ELearningLine, you will be able to:
2.  Install and configure end-end MSBI system
3. Data-Warehousing concepts along with ETL and Multidimensional modelling
4. ETL system using SQL Server Integration Services  (SSIS)
5. techniques of Data Modeling, Data Representation and Data Transformation for Business Intelligence
6. understanding of the architecture of SSRS and its components
7. Build and create charts, reports and dashboards with SSRS
8. concepts of OLAP database and tables in SSAS
9. Various relationship types in SSAS                                                                 
10. Write solid MDX queries against your SSAS cubes
11. Create KPI and scorecards in PerformancePoint Services 2010
12. Generate and development if new data sources and new Cubes
13. need for data warehouses and concepts of OLAP database and tables in SSAS.

 Key Features

1. 30 hours of High-Quality E-Learning material
2. 30 hours of Lab Exercises
3. 20 hour of Real Time Project work
4. Prepare you for MSBI  Professional Certification Exam
5. Long time Access to knowledge base including Videos, Tutorials and Course Material
6. Guidance to Resume Preparation and Job Assistance
7. Course Completion Certificate from ELearningLine 

Who should go for this course?

1. All Professionals looking for Business Intelligence Jobs
2. This course is designed for IT aspirant to make a career in Business Intelligence.
3. Software or Analytics experts having knowledge of any RDBMS, ETL, OLAP or reporting tools
4. Architects, ETL Developers and Data Analysts 

Pre-requisites

1. The pre-requisite for this course is basic understanding of any RDBMS.
2. Knowledge on SQL Server T-SQL Queries 

Why take MSBI Developer Training Course?

1. MSBI enable storing and retrieving data for smooth processing and speedy resolutions in business.
2. This Business Intelligence consists of various tools providing extensive solutions for BI.
3. The demand for SSAS, SSIS and SSRS Professionals is growing and many Organizations are looking for BI skilled candidates.
4. ELearningLine’s course is a complete package to learn various Microsoft BI tools and techniques.

Curriculum

Microsoft Business Intelligence 

1. SQL Server Installation
2. What is Business Intelligence?
3. What is Need for Business Intelligence
4. Architecture of Microsoft Business Intelligence (MSBI)
5. Import Wizard and Export Wizard
6. What is SSIS Package Designer?
7. SSDT-BI Installation

Control Flows in SSIS

1. Introduction of SSIS Architecture
2. What is Need for Control Flow in SSIS
3. Different tools of SSIS Control Flow

Data Flow in SSIS

1. Introduction to Data Flow?
2. What are different components in SSIS Data Flow?
3. Integrating with Control Flow Components
4. System variables & Custom Variables

Different SSIS Transactions

1. Workflow of SSIS
2. rameters of Transactions
3. What are the Different Transaction Options
4. Event Handling

Error Handling in SSIS

1. What is Error Handling in SSIS?
2. How to Handle Errors?
3. How to do Error logging?
4. Configuring OnError events?
5. Various levels of protection?

SSIS Configuration

1. What is Scripting Task?
2. Package Configurations
3. SSIS debugging?
4. Troubleshooting in SSIS?
5. SSIS Deployment and Scheduling

SSIS Advance Topics

1. SSIS Package tuning (Performance)?
2. Best Techniques and Practices in SSIS
3. What is OLTP and OLAP?
4. Introduction to Data Warehouse
5. Architecture of Data Warehouse
6. What are Schemas

SSAS

1. Introduction to SSAS Cube Design & SQL Server
2. SSAS MDX
3. SSAS DAX
4. Deploying SSAS?

SSRS

1. Introduction to SSRS?
2. How to do Reporting with SSRS
3. How to use report manager in SSRS?

MSBI Ecosystems

1. How MSBI Ecosystem components work together?
2. Unified effort to Business Solutions
3. Solutions to Data Problems in an Organization

Exam 70-448 Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Who should take this exam?

Candidates for this exam are accountable for creating business intelligence (BI) solutions by using SQL Server 2008 for their organizations. Candidates normally work with the full collection of BI skills in SQL Server 2008, including Reporting Services (SSRS), Analysis Services (SSAS), and Integration Services (SSIS).

This exam is planned for professionals who develop solutions by using the SQL Server 2008 BI tool suite. The candidate for this exam normally has:

1. 1 – 2 years of experience working with the MS .NET Framework
2. 2 – 3 years of experience using SQL Server 2005 BI components
3. 1 year of experience using SQL Server 2008
4. Prior experience in SQL Server 2008 Business Intelligence Development Studio
5. Prior experience in Microsoft SQL Server Management Studio
6. Basic knowledge of RDBMS and schemas
7. Prior experience creating and deploying cubes in SSAS.
8. Prior experience creating and deploying a data mining model in SSAS
9. Prior experience T-SQL
10. Prior experience in SSRS
11. Prior experience authoring and deploying SSIS packages
12. Prior experience in debugging, monitoring, and troubleshooting BI solutions

The percentages specify the relative load of each major topic area on the exam. The more the %, the more questions you are expected to see on that content area on the exam.

1. Implementing an SSIS solution (15-20%)
2. Configuring, deploying, and maintaining SSIS (15-20%)
3. Implementing an SSAS solution (20-25%)
4. Configuring, deploying, and maintaining SSAS (15-20%)
5. Implementing an SSRS solution (10-15%)
6. Configuring, deploying, and maintaining SSRS (13%)