Looking for Global training? Go to https://firebrand.training/en or stay on the current site (United Arab Emirates)
Learn how to implement a Business Intelligence platform for Microsoft SQL Server on this accelerated MCSE Business Intelligence course 50% faster than traditional training.
Your MCSE Business Intelligence course has updated official courseware, to include training for SQL Server 2014. This complements the SQL Server 2012 content that is already within the curriculum. What you learn on this course will be applicable to both SQL Server 2012 and 2014.
In just six days you'll learn how to implement and design data models, create reports and visualisations - using SQL Server Reporting Services, SharePoint and Excel. You'll also learn key skills to work with Windows Azure HDInsight and manage unstructured data.
Learn how to create a data warehouse with SQL Server 2014, and also find out more about:
As a SQL Server database professional, you may be required to participate in, or perhaps even lead, a project with the aim of implementing an effective enterprise BI solution. Therefore, it is important that you have a good understanding of the various elements that comprise a BI solution, the business and IT personnel typically involved in a BI project, and the Microsoft products that you can use to implement the solution.
Lessons Lab : Exploring a BI Solution After completing this module, you will be able to: This module provides an introduction to multidimensional databases and introduces the core components of an Online Analytical Processing (OLAP) cube. Lessons Lab : Creating a Multidimensional Database After completing this module, you will be able to: Module 3: Working with Cubes and Dimensions This module describes how to create and configure dimensions and dimension hierarchies in an Analysis Services multidimensional data model. Lessons
Lab : Working with Cubes and Dimensions
After completing this module, you will be able to: This module describes measures and measure groups. It also explains how you can use them to define fact tables and associate dimensions with measures. Lessons Lab : Configuring Measures and Measure Groups After completing this module, you will be able to: This module describes the fundamentals of MDX and explains how to build calculations, such as calculated members and named sets. Lessons Lab : Using MDX After completing this module, you will be able to: This module describes how to enhance a cube with Key Performance Indicators (KPIs), actions, perspectives, and translations. Lessons Lab : Customising a Cube After completing this module, you will be able to: This module describes Analysis Services tabular data models and explains how to develop a tabular data model using the SQL Server Data Tools for Business Intelligence (BI) add-in for Visual Studio. Lessons Lab : Implementing an Analysis Services Tabular Data Model After completing this module, you will be able to:
This module explains the fundamentals of the DAX language. It also explains how you can use DAX to create calculated columns and measures, and how you can use them in your tabular data models. Lessons After completing this module, you will be able to: This module introduces Microsoft SQL Server Reporting Services and discusses the tools and techniques that a professional BI developer can use to create and publish reports. Lessons Lab : Creating a Report with Report Designer After completing this module, you will be able to: This module describes how to apply security and report execution settings, and how to create subscriptions to deliver reports. Lessons Lab : Implementing Report Subscriptions After completing this module, you will be able to: This module introduces Microsoft SharePoint Server as a platform for BI, and then focuses on building BI dashboards and scorecards with PerformancePoint Services. Lessons Lab : Implementing PerformancePoint Services After completing this module, you will be able to: This module introduces data mining, describes how to create a data mining solution, how to validate data mining models, how to use the Data Mining Add-ins for Microsoft Excel, and how to incorporate data mining results into Reporting Services reports. Lessons Lab : Using Data Mining to Support a Marketing Campaign After completing this module, you will be able to: This module enables students to plan the components of a BI Solution. Lessons Lab : Planning BI Solutions After completing this module, you will be able to: This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters. Lessons Lab : Planning BI Infrastructure After completing this module, you will be able to: This module describes how to design a data warehouse given a set of user requirements. Lessons Lab : Designing a Data Warehouse Logical Schema After completing this module, you will be able to: This lesson describes how to design an extract, transform and load (ETL) solution. Lessons Lab : Designing an ETL Solution After completing this module, you will be able to: This module describes how to design analytical data models for specific BI scenarios. Lab : Designing Analytical Data Model Lab : Designing Dimensions and Hierarchies After completing this module, you will be able to: This module describes how to choose an appropriate delivery solution for a given scenario. Lessons Lab : Planning a BI Delivery Solution After completing this module, you will be able to: This module describes how to design a reporting services solution. Lessons Lab : Designing a Reporting Services Solution After completing this module, you will be able to: In this module students will learn how to design a reporting solution using Excel. Lessons Lab : Designing and Excel Reporting Solution After completing this module, you will be able to: This module introduces the use of SharePoint Server as a BI solution. Lessons Lab : Implementing a SharePoint Server BI Solution Lab : Implementing PerformancePoint Services After completing this module, you will be able to: At the conclusion of this module you will be able to optimise and monitor a BI solution. Lessons Lab : Monitoring and Optimising a BI Solution After completing this module, you will be able to: At the conclusion of this module you will be able to plan management and maintenance operations of a BI solution. Lessons Lab : Operating a BI Solution After completing this module, you will be able to:
Module 2: Creating Multidimensional Databases
Module 4: Working with Measures and Measure Groups
Module 5: Introduction to MDX
Module 6: Customising Cube Functionality
Module 7: Implementing an Analysis Services Tabular Data Model
Module 8: Introduction to Data Analysis Expression (DAX)
Module 9: Implementing Reports with SQL Server Reporting Services
Module 10: Automating Report Execution and Delivery
Module 11: Delivering BI with SharePoint PerformancePoint Services
Module 12: Performing Predictive Analysis with Data Mining
Course 20467D: Designing Business Intelligence Solutions with Microsoft SQL Server 2014
Module 1: Planning a BI Solution
Module 2: Planning BI Infrastructure
Module 3: Designing a Data Warehouse
Module 4: Designing an ETL solution
Module 5: Designing Analytical Data Models
Module 6: Planning a BI Delivery Solution
Module 7: Designing a Reporting Services Solution
Module 8: Designing an Excel Based reporting Solution
Module 9: Planning a SharePoint Server BI Solution
Module 10: Monitoring and Optimising a BI Solution
Module 11: Operating a BI Solution
You'll sit the following exams:
Do you already have a SQL Server 2008 certification? If so, you may be able to take fewer exams on this course before you get your certification. Call us on
+442032862989 to find out more.
Your accelerated course includes:
In addition to your professional experience, you must have the following Microsoft certifications (MCSA: SQL Server):
You must have:
Awareness of key business priorities such as revenue, profitability, and financial accounting is also recommended.
Unsure whether you meet the prerequisites? Don’t worry. Your training consultant will discuss your background with you to understand if this course is right for you.
Here's the Firebrand Training review section. Since 2001 we've trained exactly 134,561 students and asked them all to review our Accelerated Learning. Currently, 96.41% have said Firebrand exceeded their expectations.
Read reviews from recent accelerated courses below or visit Firebrand Stories for written and video interviews from our alumni.
"Firebrand gave me the opportunity to focus on my training by providing a good environment for studying, lectures which focused on relevant content and a clear and attainable goal in the form of a certification at the end."
Jonas Olsson, Dedicatum Consulting AB. (6/6/2016 (Monday) to 11/6/2016 (Saturday))
"I achieved my MCSE, over the moon. Thank you."
Wayne Chandler. (6/6/2016 (Monday) to 11/6/2016 (Saturday))
"Very focused and intensive: great if you know the content/have experience and need to prepare for the exam(s) in the shortest possible time. Very good learning environment and brilliant for shutting out distractions"
A.S., Contractor. (17/8/2015 (Monday) to 22/8/2015 (Saturday))
"I bought a Fast Pass and have never looked back. It is a shame that I have to come to the UK all the time as I live in Dubai. The site at Wyboston is very suitable to enable the studying required. "
A.R.. (17/8/2015 (Monday) to 22/8/2015 (Saturday))
"A good way to learn, wouldn't have gain half this knowledge from self study as I did with the instructor."
Jason Linham. (17/8/2015 (Monday) to 22/8/2015 (Saturday))
Start |
Finish |
Status |
Location |
Book now |
---|---|---|---|---|
19/2/2024 (Monday) |
24/2/2024 (Saturday) |
Finished - Leave feedback |
- |
|
24/6/2024 (Monday) |
29/6/2024 (Saturday) |
Wait list |
Nationwide |
|
5/8/2024 (Monday) |
10/8/2024 (Saturday) |
Limited availability |
Nationwide |
|
16/9/2024 (Monday) |
21/9/2024 (Saturday) |
Open |
Nationwide |
|
28/10/2024 (Monday) |
2/11/2024 (Saturday) |
Open |
Nationwide |
|
9/12/2024 (Monday) |
14/12/2024 (Saturday) |
Open |
Nationwide |
|