Let eMexo Technologies Best MSBI Training in Electronic City Bangalore take you from the fundamentals of MSBI to Advance MSBI and make you an expert in developing real time MSBI applications. Here are the major topics we cover under this MSBI course Syllabus SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services. Each topic will be covered in practical way with examples.
All the topics will be covered with Practical and hands on training. Our trainers have industry experience with live project experience in cutting edge technologies which they teach. We hire only Best MSBI industry specialists as trainer for our MSBI trainings.
Come over to our training institute for a free demo class. Let our trainer give you a demo on MSBI and only then you take the decision to enroll into the training program.
Training Features
Expert Instructors
30 hours of Instructor led Classes. Weekend class:10 sessions of 3 hours each and Weekday class: 15 sessions of 2 hours each.
Real life Case Studies
Do a real life case study to understand the usage on real world scenarios.
Assignments
Each class will be followed by practical assignments which can be completed before the next class.
Demo Class
Register today for a demo class to experience our teaching methodologies first hand and it’s completely free
FAQs
We at eMexo believe nothing beats a hands-on practice when it comes to learning a concept. Our teaching methodology is 100% practical hands-on oriented. You learn a concept, you practice it then and there with the trainer. We also give you assignments for each topic which you can practice at home and any doubts regarding the topic can be cleared with the trainer next day.
We generally cover our courses in 30 hours, however, we are aware that we can’t put a hard-stop to learning with a number. Our trainer will make sure that you have learned everything that is part of the curriculum. This could mean 28 hours or 35 hours, doesn’t matter.
We have industry standard course material which is used by our trainers to train you. At the end of the training apart from the notes which you have taken during the course, we will also provide you with the training material which was used. This training material includes the training content, interview questions etc.
Our trainers are working professionals who work in MNC’s. They are the expert in their domain and they know exactly what an interviewer looks into a candidate. Our expert trainers apart from sharing the interview questions they will also conduct mock interviews to help you prepare for the real interview.
Our trainers are industry experts who work in their respective technologies day in day out. They work in MNC’s and are technology experts within their organisation.
We maintain a strict batch size of maximum 5 students. We also provide exclusive one to one training as well. Talk to our training partner to get more details.
Yes, at the end of training we provide a certification of completion.
You will be added to a new batch.
Yes, we provide fast-track training as well for those who want to complete the course faster. The curriculum and the total hours required to complete the course will remain same. However, the trainer will be spending more hours with you to complete the course.
Our trainers are expert professionals in their organisations and they often act as the interviewer to hire new candidates. Our trainers will help you prepare your resume with industry standards. After all, they know exactly what to look in a resume.
We provide both regular and weekend training. Talk to our training partner to learn more about the timings.
Yes, apart from doing the hands-on practice our trainer will also be taking a real-world project and work with you for the implementation.
If you miss a class the content of that class will be taught to you again. With us you might miss a class but not the content.
Yes, absolutely! Talk to our training counsellor on phone at 9513216462 or email us at info@emexotechnologies.com to arrange for a free demo. You can also fill in the contact us form below and we will call you to discuss your training requirements.
Have Questions? Call our Course Advisor for discussing Curriculum Details – +91 9513216462
Book your free demo class today
-
SQL Server Integration Services (SSIS)
- Introduction to SSIS Packages and Legacy DTS Packages
- Introduction of (BIDS) and Explanation of All tool boxes, Solution Explorer, Package variables a
- Import and Export Wizard, Control Flow and Dataflow tasks
- Control Flow tasks like Execute SQL Task, BULK insert tasks, File System tasks , The FTP Task and Send mail task
- Dataflow tasks and transformations introduction
- Data sources, Data transformations, Copy column Transformation, Derived Column transformation, Conditional Split and Aggregate Transformation, Sort Transformation and Data Viewers.
- Slowly Changing Dimension (SCD) Concepts and its Transformations.
- Debugging, Error Handling and Logging
- How to implement Checkpoints.
- SSIS Package Deployment and Package Management like how to schedule package , DTUtil and DTExec command.
-
SQL Server Analysis Services (SSAS)
- Introduction to Data Warehousing, OLTP, OLAP, Star Schema and Snowflake schema.. etc
- Understanding Dimension Modeling
- Creating Data source and Data source views
- Creating the Cube through Wizard and through UDM.
- Creating Dimensions and Measures in SSAS and how to add those in Cube.
- Partitions and Aggregations Design in cube and Processing Options in cube
- Key Performance Indicators(KPI) , Perspectives and Translations .
- What is Build , Deploy and process in cube.
- How to do Slice and Dice in the Cube .
- How to retrieve the data in Cube i.e Through MDX .
- Full Coverage of MDX and its functions from Basics to Advanced.
- What is Role and How to give Cube access to a Login.
- Different Options for Deploying a Cube.
- How to take Cube backup and how to synchronize the cube from one server to another server and how to do that with XMLA query
- How to take the report from Cube in Excel and Power Pivot .
-
SQL Server Reporting Services (SSRS)
- What is the Terminology involved in SSRS, SSRS Architecture and how to configure SSRS.
- What is Shared Data source and How to Create an Ad-hoc Report from Wizard.
- Creating Expressions and Conditional Formatting.
- How to Calculate Total and Percentage and how to create Drill-Down reports.
- Creating Report Parameter and Debugging Parameter issues.
- How to create a Basic Matrix Report , Tablix Report and Charts.
- How to Create a Standard and Data-driven Subscription and managing subscriptions.
- Managing Reports, Security and how to use Web-based Report Manager.
Instructor
