Microsoft Certified Solutions Expert: Business Intelligence 2012 Training

9612 Learners

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.
Target audience
  • Database Professionals
  • Business Intelligence Developers/Professionals
  • Data Analysts
  • Reporting Engineers
Prerequisites

The candidates have to meet the following prerequisites:

  • Atleast two years of work experience using relational databases
  • Knowledge of data modeling  and data warehousing principles
  • Familiarity with Microsoft SharePoint Server 2013 and Microsoft Excel
  • Basic understanding of key business priorities such as financial accounting, revenue, and profitability
Exams

After being trained on above skills, you can attempt following exams to get MCSE: Business Intelligence 2012 certification from Microsoft:

Course Name Course No. Exam No. Certification Achieved
Implementing Data Models and Reports with Microsoft SQL Server 466 70-466 MCSE: BI 2012
Designing Business Intelligence Solutions with Microsoft SQL Server 467 70-467

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.
Target audience
  • Database Professionals
  • Business Intelligence Developers/Professionals
  • Data Analysts
  • Reporting Engineers
Prerequisites

The candidates have to meet the following prerequisites:

  • Atleast two years of work experience using relational databases
  • Knowledge of data modeling  and data warehousing principles
  • Familiarity with Microsoft SharePoint Server 2013 and Microsoft Excel
  • Basic understanding of key business priorities such as financial accounting, revenue, and profitability
Exams

After being trained on above skills, you can attempt following exams to get MCSE: Business Intelligence 2012 certification from Microsoft:

Course Name Course No. Exam No. Certification Achieved
Implementing Data Models and Reports with Microsoft SQL Server 466 70-466 MCSE: BI 2012
Designing Business Intelligence Solutions with Microsoft SQL Server 467 70-467

Microsoft Certified Solutions Expert: Business Intelligence 2012 Training Course Content

Course 20466: Implementing Data Models and Reports with Microsoft® SQL Server®

1. Introduction to Business Intelligence and Data Modeling

  • Elements of an Enterprise BI Solution
  • The Microsoft Enterprise BI Platform
  • Planning an Enterprise BI Project

2: Creating Multidimensional Databases

  • Introduction to Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Overview of Cube Security

3: Working with Cubes and Dimensions

  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Hierarchies

4: Working with Measures and Measure Groups

  • Working with Measures
  • Working with Measure Groups

5: Introduction to MDX

  • MDX Fundamentals
  • Adding Calculations to a Cube
  • Using MDX to Query a Cube

6: Enhancing a Cube

  • Working with Key Performance Indicators
  • Working with Actions
  • Working with Perspectives
  • Working with Translations

7: Implementing an Analysis Services Tabular Data Model

  • Introduction to Analysis Services Tabular Data Models
  • Creating a Tabular Data Model
  • Using an Analysis Services Tabular Data Model in the Enterprise

8: Introduction to DAX

  • DAX Fundamentals
  • Enhancing a Tabular Data Model with DAX

9: Implementing Reports with SQL Server Reporting Services

  • Introduction to Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Publishing and Viewing a Report

10: Enhancing Reports with SQL Server Reporting Services

  • Showing Data Graphically
  • Filtering Reports by Using Parameters

11: Managing Report Execution and Delivery

  • Managing Report Security
  • Managing Report Execution
  • Subscriptions and Data Alerts
  • Troubleshooting Reporting Services

12: Delivering BI with SharePoint PerformancePoint Services

  • Introduction to SharePoint Server as a BI Platform
  • Introduction to PerformancePoint Services
  • PerformancePoint Data Sources and Time Intelligence
  • Reports, Scorecards, and Dashboards

13: Performing Predictive Analysis with Data Mining

  • Overview of Data Mining
  • Creating a Data Mining Solution
  • Validating a Data Mining Model
  • Consuming Data Mining Data

Drop Us a Query

+91 95550 06479

Available 24x7 for your queries

Microsoft Certified Solutions Expert: Business Intelligence 2012 Corporate Training & Certificat

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.

Learn from the experts

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements of your workforce. You can even choose a trainer from our team of certified industry experts.

Learn from the experts

Expert Mentors

Get trained from our team of highly skilled and certified trainers, who are officially accredited professionals with relevant industry experience and adept in providing the knowledge and skills required to be successful.

Learn from the experts

360º Learning Solution

Engage your employees with our all-inclusive learning platform. Avail benefits of 24/7 access to the learning management system, industry-certified mentors, assessments & mock tests, real-time learning and more.

Learn from the experts

Learning Assessment

Check test score and performance with our skills analysis tools. Our detail scoreboard displays scores, areas of strength, detailed answer of questions and more for each employee.

Download Corporate Brochure

+91 9555006479

Available 24x7