This five-day instructor-led course is a complete high-level tour of the Microsoft Business Intelligence stack. It introduces students to the SQL 2012 Business Intelligence and SharePoint 2013 Business Intelligence services including PerformancePoint Service, Excel Services, Business Connectivity Services, Visio Services and the Business Intelligence Center focusing on their interdependency. Each of the modules is stand-alone allowing for customization of the course for those audiences that may not have an interest in a certain service. Each concept is demonstrated with a video before the exercise on that concept, so first you will have the short lecture then see the concept demonstrated then do it yourself. Remember if you can’t do it you didn’t learn it. Each of the videos, and there are approximately 13 hours of them, is intended as a take-away from the class for each student.
Course OutlineModule 1: Course Overview
Module 2: The Business Intelligence Stack
Lab : The Business Intelligence Stack
Module 3: SQL Server Integration Services (SSIS) 2012In this module we will give an overview of ETL and discuss two approaches that should be considered prior to implementation. We will also go over the SQL Server Data Tools application and explain the concept of Packages, Tasks, and Containers with further instruction on how to use these tools and others. In the following list of topics you will see two topics that are part of SQL Server Integration Services ETL although not covered in this module. They are SQL Server Integration Services Data Profiler and Data cleansing which are covered later in the course.Lessons
Lab : SQL Server Integration Services (SSIS) 2012
Module 4: SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode)
Lab : SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode)
Module 5: Microsoft Multidimensional Expressions
Lab : Microsoft Multidimensional Expressions
Module 6: SQL 2012 Business Intelligence Semantic Model (Tabular Mode)
Lab : SQL 2012 Business Intelligence Semantic Model (Tabular Mode)
Module 7: SQL Server 2012 Reporting Services
Lab : SQL Server 2012 Reporting Services
Module 8: Master Data Services
Lab : Master Data Services
Module 9: Data Mining/Predictive Analytics
Lab : Data Mining/Predictive Analytics
Module 10: SharePoint 2013 Business Intelligence Center
Lab : SharePoint 2013 Business Intelligence Center
Module 11: SharePoint 2013 Excel Services
Lab : SharePoint 2013 Excel Services
Module 12: SharePoint 2013 PerformancePoint 2013
Lab : SharePoint 2013 PerformancePoint 2013
Module 13: SharePoint 2013 Visio Services
Lab : SharePoint 2013 Visio Services
Module 14: PowerPivot
Lab : PowerPivot
Module 15: SharePoint 2013 Business Connectivity Services
Lab : SharePoint 2013 Business Connectivity Services
Module 16: Dashboards
Lab : Dashboards
This course is intended for Project Managers, Business Intelligence Developers, SQL Server Developers and IT Professionals that will be involved with the design, development and maintenance of SharePoint 2013 Business Intelligence solutions. The course introduces each of the services and minimizes or eliminates any coding.
College Credit, CEUs, PDUs and CDUs
When you take courses with the Babbage Simmel, be sure you get the credit you deserve. Curriculum offered by Babbage Simmel can earn you college credit, CEUs, PDUs or CDUs.
Select curriculum offered by Babbage Simmel can be utilized for College Credit. For questions please E-Mail: firstname.lastname@example.org or call 614-481-4345.
Continuing Education Units (CEUs)
Continuing Education Units (CEUs) are nationally recognized standard units of measurement earned for satisfactory completion of qualified programs of continuing education. If you need more information about CEUs, please E-Mail: email@example.com or call 614-481-4345.
Professional Development Units (PDUs)
Professional Development Units (PDUs) can be issued by PMI® for formal learning activities related to project management. Project Management Professionals (PMPs®) are required to earn a minimum of 60 PDUs every 3 years to maintain certification. For more information about this program go to the PMI® web site or call 1-855 746 4849.
Continuing Development Units (CDUs)
CDUs may be earned by attending professional development (e.g. courses, seminars) offered by organizations endorsed by IIBA® and designated as an EEP vendor. As an IIBA Endorsed Education Provider (EEP) Babbage Simmel's IIBA® endorsed courses qualify for CDU credit. For more information about CDUs go the IIBA® web site or call 1-647-426-3735.
Our babsimLIVE distance learning brings the classroom learning experience to you by seating you virtually into a real-life instructor-led classroom taught by award winning world-class instructors with other IT professionals like yourself. From the comfort of your home, workplace, or at the Babbage Simmel Columbus Campus, you acquire the training you need, when you want it, in the environment that is most comfortable for you to be successful.