Microsoft Certified Solutions Expert: Business Intelligence 2012 Training

Microsoft Certified Solutions Expert: Business Intelligence 2012 training explains how to create managed enterprise BI solution and implement Big Data analysis solutions using the Microsoft data platform.

The MCSE:BI training provides insight on the implementation of the self-service Business Intelligence (BI) solutions by creating models and reports. The participants will be exposed to the use of Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI.

This training is a complete database solution offering studies on two different courses mentioned as following:

• Implementing Data Models and Reports with Microsoft® SQL Server®
• Designing Self-Service Business Intelligence and Big Data Solutions
• By the end of MCSE: BI 2012 certification training course, the participants will be able to:
  • Describe the components and architecture of BI solutions
  • Define the features and benefits of Self-Service Business Intelligence and Big Data Solutions
  • Use Analysis Services and create a multidimensional database
  • Use Reporting Services to create reports and enhance them to provide geographic and interactive data visualizations
  • Use PowerPivot and Power Query in Microsoft Excel to create analytical data models and import data into a data model
  • Use PerformancePoint Services in SharePoint Server to implement a dashboard
  • Use Data Mining for Predictive Analysis
  • Use Microsoft SharePoint Server to design and implement Big Data processes  to support collaborative self-service BI solutions
  • Use Pig and Hive to analyze big data in Windows Azure HDInsight.