Microsoft End-to-End Business Intelligence Boot Camp is a seven-day course that provides core understanding of the Microsoft Business Intelligence environment. Through this course, participants get an understanding of SQL 2012 Business Intelligence and SharePoint 2013 Business Intelligence services along with PerformancePoint Service, Business Connectivity Services, Excel Services, Visio Services and the Business Intelligence Center focusing on their interdependency.
Module 1: Course Overview
This module describes how the class will be structured and introduces course materials and additional administrative information.
Module 2: The Business Intelligence Stack
This module explains the three different ways in which business intelligence can be viewed. We will take a brief look at PowerPivot, examining the new features and their significance.
Module 3: SQL Server Integration Services (SSIS) 2012
This module explains ETL and discusses two approaches that should be considered prior to implementation.
Module 4: SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode)
This module explains the basics of using multidimensional mode and the tools available.
Module 5: Microsoft Multidimensional Expressions
This module explains key concepts in multidimensional space and browses some basic MDX statements with specific coverage on navigating hierarchies and working with time.
Module 6: SQL 2012 Business Intelligence Semantic Model (Tabular Mode)
This module explains the basics of using tabular mode and the tools available.
Module 7: SQL Server 2012 Reporting Services
This module explains the new and exciting features available in SQL 2012 Reporting Services.
Module 8: Master Data Services
This module explains Master Data Management and explains what it is and why it is important.
Module 9: Data Mining/Predictive Analytics
This module explains the concept of data mining and how it can be a valuable tool in your business intelligence arsenal.
Module 10: SharePoint 2013 Business Intelligence Center
This module explains the new and improved 2013 SharePoint Central Administration site.
Module 11: SharePoint 2013 Excel Services
This module explains the new 2013 Excel Services features, and we will explore the core components of Excel Services.
Module 12: SharePoint 2013 PerformancePoint 2013
This module explains the new 2013 PerformancePoint Services features.
Module 13: SharePoint 2013 Visio Services
This module explains how Visio drawings can be extremely effective and in this module we cover the shared service that allows users to share and view them.
Module 14: PowerPivot
This module is intended as an overview of the PowerPivot and covers all the new features available in the 2013 release of the add-in.
Module 15: SharePoint 2013 Business Connectivity Services
This module explains the new features available within SharePoint 2013 Business Connectivity Services, how to configure the security and clarify the terminology.
Module 16: Dashboards
This module borrows content from the three-day Microsoft course on Dashboards number 50596A. We will discuss monitoring, analyzing, and managing dashboards along with details on how to use them most effectively.
This course is intended for:
Before attending this course, candidates must have:
An understanding of the benefits of business intelligence.
I want to express the extent of my admiration and appreciation for the organization and the effort you had made for the sake to success the training I did particularly and the success to the Institute generally. What I have seen during the past few days will be an opportunity to return again and recommend the Institute among colleagues. Interacting with many tools and share information with the students. Moreover, to that the instructor provides activities and demonstrates the process for running tools in live mode.
I like Mercury Solutions, they provided me with what they promised. All communication with the staff was good. All the tactics used to impart training was good. The trainer was an awesome person. He has a vast knowledge and knows how to train a student, he taught me with all the possibilities in the security field. He knows his subject very well. I highly recommend the trainer for all the security related trainings. The company guest house and the staff was very good. The overall transportation was also good and the drivers are helpful. They also sent me for city tours which were awesome.
I am really delighted about the SQL Training course: Querying Microsoft SQL Server with Mercury Solutions. Every session was great and very valuable. Practical application made the course significantly more valuable. The thing most impressive was the way the entire programme was structured. Instructor is having great experience and diverse knowledge in SQL Server. I am looking for learning Administering Microsoft SQL Server 2014 Databases with same trainer.
I came to make resolution to learn Cisco Security, so I chose Mercury Solutions. I learnt a lot and gained a lot. Presently, I became CCNA certified and EC-Council Penetration Tester. I learnt a lot from good lectures and from trainers, and also I enjoyed a lot and I would advise all to come down and learn."
Mercury Solutions Ltd. is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.