Edureka’s Microsoft BI Certification Training helps you master MSBI concepts such as ETL, SSIS, SSAS and SSRS using SQL Server 2014 and SQL Server Data tools 2013. This MSBI course will also help you earn an MSBI Certification
|1. MSBI and SSIS Architecture Overview|
|Learning Objectives – In this module, you will understand the need for an Integration tool and its significance in real world.You will learn the importance of SSIS as an integration tool and get a birds-eye-view of the overall architecture.||00:00:00|
|Topics – Understand the Need of Business Intelligence Understand the MSBI Architecture, Import and Export wizard, Overview of SSIS Package Designer & Environment Installation of SQL Server and SSDT- BI||00:00:00|
|2. SSIS Control Flow and Data Flow|
|Learning Objectives – In this module, you will understand the SSIS designing environment and gain in-depth knowledge of the SSIS Control flow & Data flow.||00:00:00|
|Topics – Understand SSIS Architecture, Control Flow & its Components (Tasks, Containers, Precedence Constraints), Data Flow & its Components (Source and Destination Connections, different types of Transformations), Scenarios by combining Control Flow and Data Flow components, System Variables and User defined variables||00:00:00|
|3. SSIS (Transactions, Error Handling)|
|Learning Objectives – In this module, you will understand how the objects of the core SSIS workflow work and interact with each other to help in security, restartablity and other key functions.||00:00:00|
|Topics – Parameters, Expressions, Event Handling, Transaction Options, CheckPoints, Logging options (5 types), Configure Error Output and OnError event, Package Security: Package Protection Levels||00:00:00|
|4. SSIS (Configuration, Deployment and Scheduling)|
|Learning Objectives – In this module, you will learn advanced SSIS programming features which will help in handling custom requirements using .Net code. Also you will learn the way to configure and deploy SSIS projects.||00:00:00|
|Topics – Custom code using Script Task, Script Component, Package Configurations (5 types), Debugging & Troubleshooting, Executing packages – DTExec and DTExecUI, Package Deployment, Package Scheduling using SQL Agent||00:00:00|
|5. SSIS Advance Topics & DWH Basics|
|Learning Objectives – In this module you will learn SSIS advanced concepts such as SSIS Performance Tuning & its Best Practices. You will also learn Introduction to Datawarehouse and its Architecture, Loading Data into DW using SSIS as well as Introduction to Dimensional Modeling. This will be base for understanding SSAS features.||00:00:00|
|Topics – Package Performance Tuning, SSIS Best Practices, Need for DW & Business Intelligence, OLTP vs. OLAP, DW Architecture, Dimensional Modeling, Schemas: Star, Snowflake||00:00:00|
|6. SSAS Cube Design|
|Learning Objectives – This module will help you in understanding SQL Server Analysis Services Overview and its Architecture. It also covers various types of SSAS models along with designing dimensions and measure groups. You will also learn about SSAS Administration with prime focus on deployment and processing.||00:00:00|
|Topics – Tabular Model and Multidimensional Model, Data Sources, Data Source Views, Identify the Fact and Dimensions, Named Calculation and Named Queries, Designing Dimensions, Dimension Hierarchies, Designing Measure Groups, Dimension Usage with Measure Group,Attribute Relationships, Storage Modes: MOLAP, ROLAP, HOLAP, Partitions, Aggregations,KPIs, Actions, Translations and Perspectives||00:00:00|
|7. SSAS Deployment and MDX, DAX|
|Learning Objectives – In this module you will learn basics of MDX & DAX and get step by step approach of basic SSAS Performance Tuning and Troubleshooting. You will also learn the concepts of Adhoc-Reporting and creation of a report against SSAS as a data source.||00:00:00|
|Topics – SSAS Deployment and Cube Processing, Different Processing Options, Loading Data into DW using SSIS, MDX queries, DAX Queries, Performance Optimization of cube and Dimension, Best Practices,||00:00:00|
|8. SSRS Reporting|
|Learning Objectives – In this module you will understand Reporting Services, its Architecture and how to configure it. You will also learn about the environment where reports are created and also about server where the reports are deployed.||00:00:00|
|Topics – Reporting Services Architecture & Lifecycle, Report Parameters and MultiValued, Cascading Drop down Parameters, Types of Reports: Table, Matrix, Sub Report, Chart Report (Bar, Pie, Line), Drill-Down Report, Drill Through Report, Creating Groups, Filters, Expressions Sort and Interactive Sort, Alternate Row Colors, Repeating Row Headers and Column Headers, Exporting Reports to different formats||00:00:00|
|9. SSRS: Report Manager|
|Learning Objectives – In this module you will learn about different kinds of reports and their functionalities along with best practices to be followed. You will also learn about various SSRS Administrative activities.||00:00:00|
|Topics – Report Manager, Deploying Reports and Data Sources, Securing Access to Reports (Role based Security), Data Source Security, Caching Report and Snapshot Report, Report Subscriptions: Standard, Data-Driven Managing Subscriptions,Ad-Hoc Reporting with Report Builder,Develop SSRS Report using MDX||00:00:00|
|10. Putting the Pieces Together|
|Learning Objectives – In this module you will understand how MSBI ecosystem components work together in a Business Intelligence environment to solve the Organizations data problems. This module covers end to end implementation from Data Retrieval –> Data Transformation –> Data Loading into DWH –> Data Modeling –> Report Delivery||00:00:00|
|Topics – End to End Business Intelligence case study involving SSIS, SSAS, SSRS and MDX.||00:00:00|
Yes, One can always use Windows to work on assignments. The initial 5 modules require R set-up which can be easily installed on your windows system. To work on Hadoop on your Windows, the simplest way is to install VMware Player on your Windows Machine. VMPlayer is a software using which you can run another operating system on your Windows. So, by using a VMPlayer and run an Ubuntu/Cloudera OS you can work on the R+Hadoop or Mahout environment and run the assignments. System Requirements to run VMplayer: RAM: 3 to 4 GB. Processor: i3 or above. A 64-bit system is recommended to run the Mahout libraries. To set-up the same, detailed step-wise installation guides are provided in the LMS. Our 24*7 team support will guide you to get the set-up ready.
We will help you to setup the required environment for practicals. The set-up will comprise: – R programming IDE set-up – Setting up Hadoop – Performing R+Hadoop Integration – Installing Mahout The detailed step-wise installation guides are provided in the LMS for you. In case you come across any doubt, the 24*7 support team will promptly assist you.
You will never lose any lecture. You can choose either of the two options: 1. View the class presentation and recordings that are available for online viewing through the LMS. 2. You can attend the missed session, in any other live batch. Please note, access to the course material will be available for lifetime once you have enrolled into the course.
All our instructors are working professionals from the Industry and have at least 10-12 yrs of relevant experience in various domains. They are subject matter experts and are trained by Edureka for providing online training so that participants get a great learning experience.
Edureka is the largest online education company and lots of recruitment firms contacts us for our students profiles from time to time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don’t guarantee any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.
Yes, this can be done. Moreover, this ensures that when you will start with your batch, the concepts explained during the classes will not be totally new to you.
Requesting for a support session is a very simple process. As soon as you join the course, the contact number and email-id of the support team will be available in your LMS. Just a phone call or email will solve the purpose.
You can go through the sample class recording and it would give you a clear insight about how the classes are conducted, quality of instructors and interactiveness in a class.
You can pay by Credit Card, Debit Card or NetBanking from all the leading banks. We use a CCAvenue Payment Gateway. For USD payment, you can pay by Paypal. We also have EMI options available.
You can give us a CALL at +91 9599586895 OR email at email@example.com
I think the course is doing an excellent job of giving a comprehensive understanding of each topic and putting emphasis on the most important question such as when do we choose a particular technique with Hadoop to solve a problem etc.
Splunk course was absolutely great. Instructor taught all the concepts thoroughly and he is very knowledgeable, clarified and answered all the questions. The support team at Edureka is really good. Enjoyed the course, good hands on as well which was very helpful.
Pretty good module and the instructor. The mock tests were useful for the final exam. Though the tips on the LMS would have been more nicer, but well worth the time. Thanks. #PMPExamPass
I would definitely like to give more than 5 stars to Edureka, i have been associated with more than two years from now, and i have never had any issue or any complains. Support staff is excellent and very professional, the amount of time they spend with each customer is really appreciated. Today I registered for the PMP training, and Mr Shyam from sales was extremely good to do the registration process. Keep up the good work , a very well organized and structured company I would say.
The MSBI course curriculum is really good and the training was awesome.Interactive learning classes, knowledgeable instructors and great support staff is the added advantage for people.
No Reviews found for this course.