Advanced SharePoint 2013 Business Intelligence training is a five-day course that teaches how to use SharePoint as your platform for Business Intelligence. This course will explore the SharePoint Business Intelligence Center, Reporting Services, Excel Services, Analysis Service, Performance Point and PowerPivot to implement your BI Strategies. This course will also give you an overview of Big Data topics such as Hadoop, HDInsight, and StreamInsight. This course also includes the Power features like:
Module 1: Overview
A simple introduction module. After completing this module, candidates will be able to:
Understand your course, classroom, classmates, facility, and instructor.
Module 2: Business Intelligence
This module gives an overview of Business Intelligence (BI) is and the typical goals of BI. We also explore how Microsoft BI tools are enabling more advanced Business Intelligence features to filter down/up to the decision makers and Information Workers in general.
Why Business Intelligence?
Module 3: Business Intelligence Center
This module explores the Business Intelligence Center site definition that comes with SharePoint.
Business Intelligence Center
Module 4: Data Mart & Data Warehouses and Master Data Services
This module explains what data is and some of the many forms that it takes. We then explore and define the terms Data Warehouse and Data Mart.
Module 5: Business Connectivity Services and Secure Store
This module explains the SharePoint Business Connectivity Services and the SharePoint Secure Store service and how they can help surface external data into SharePoint sites.
Module 6: Analysis Services, HDInsight and StreamInsight
This module explains the feature of SQL Server called Analysis Services (SSAS). When regular SQL queries can't handle your data, MDX queries in SSAS can.
Module 7: Filter Web Parts
This module explains Filter Web Parts and the important role they play in building Business Intelligence portals.
Filter Web Parts
Module 8: Excel, Excel Services and Excel Web App
This module describes and works with the various features of SharePoint's Excel Services.
Module 9: PowerPivot, Tabular Data Sources
This module explains the PowerPivot tools of SQL Server and Excel and how they integrate with SharePoint.
Module 10: Reporting Services
In this module, we will explore Reporting Services, its integration with SharePoint and how to build Reporting Services reports.
Module 11: Power View, Power Query and Power BI
This module explains the new Microsoft BI Stack components including PowerView, PowerQuery and PowerBI.
Module 12: Performance Point
This module explains Performance Point and how it supercharges your BI Dashboards and Key Performance Indicators.
Module 13: Visio & Access Services
This module explains Visio and Access Services.
Module 14: GeoSpatial Data, GeoLocation and Power Map
This module explains how to store GeoSpatial data in SQL Server, how to use the new GeoLocation column, the new Power Map add-in for Excel and use the .NET Charts feature from 2010.
This course is intended for:
Before attending this course, candidates must have:
Understanding of SharePoint 2013 User Interface, database reporting concepts and familiarity with Data Marts and Data Warehouses.
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.