It is pleasure to announce that we have another great offering in our premier catalogue.  BI Academy is targeting any technical contributor to Business Intelligence solution, who wants to skill up on Microsoft Business Intelligence components. BI Academy is not only set of classroom trainings. We regularly catch up with attendees to give opportunity to ask their questions. BI Academy is mentoring program which involves classroom, virtual trainings as well as mentoring sessions.If you are interested in following mentoring program, please contact premier services or your Technical Account Manager.

 

BI Academy Training
BI Academy is divided in seven modules, which provides different levels of expertise and knowledge. Each module is a two days class with hands-on training. It follows a roadmap from the fundamentals to deeper areas inside the BI stack, like performance and tuning techniques. Learn how to integrate SQL Server™ BI technologies with SharePoint® Server so that you can use them to provide one central location for placing all your enterprise-wide BI content and tools. Technologies covered:

 

  • SQL Server Engine
  • Analysis Services (SSAS) Tabular and Multi-Dimensional
  • Reporting Services (SSRS)
  • Integration Services (SSIS)
  • Data Quality Services
  • Master Data Services
  • Excel tools and PowerPivot
  • SharePoint Server 2010
  • PerformancePoint and Excel Services

 

Module 1
BI Fundamentals

Overview of the fundamental concepts in a BI solution by introducing the different multi-dimensional models.
Module 2
Tabular Modelling with SQL Server 2012

Learn how to install, develop and configure SSAS Tabular Solutions with SQL Server 2012 and take advantage of xVelocity technology.
Module 3
SSAS Performance, Tuning & Optimization

Review and improve the performance of a SSAS solution and learn how to troubleshoot the most common scenarios.
Module 4
Building and loading data warehouses with SSIS & T-SQL

Review how to improve the performance of a BI solution and review of how to troubleshoot the most common scenarios, including DW Design, SSIS Development and how to Load data into a Data Warehouse.
Module 5
Enterprise Information Management

Take advantage of Data Quality Services (DQS) and Master Data Services (MDS) to build a Knowledge Driven solution. Learn how to operate with data quality issues and how you can achieve this using real case scenarios.
Module 6
Data Consumption & Visualization with SharePoint Integration

After session 3 where we saw how to create different ways to explore data or to aggregate that data on a custom view, this session has the main pur-pose of showing how to turn those visualizations available in SharePoint. In resume, this session show how a BI Solution could be integrated with a SharePoint infrastructure.
Module 7
Data Consumption & Visualization with SSRS, PowerPivot and Power View

Presentation of the capabilities of the Data Visualization & Data Consumption Layers, Reporting Services Features & Development, Self-Service BI with Report Builder and Self-Service BI with PowerPivot for Excel.