Only 6 days
Classroom
28/10/2024 (Monday)
Overview
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.
Learn advanced SQL Server functionality
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:
- Implementing multi-dimensional models
- Implementing tabular data models
- Querying with MDX and DAX
- Creating and managing reports
- Visualising data with Excel
- Delivering a self-service reporting environment
- Implement and Process BigData in Windows Azure HDInsight
Curriculum
Course 20466D: Implementing Data Models and Reports with SQL Server 2014
Module 1: Introduction to Business Intelligence and Data Modeling
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
Exam Track
You'll sit the following exams:
- Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server
- Exam 70-467: Designing Self-Service Business Intelligence and Big Data Solutions
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
{{{phoneNumber}}} to find out more.
What's Included
Microsoft Official Curriculum
- MOC 20466D – Implementing Data Models and Reports with Microsoft SQL Server
- MOC 20467D – Designing Business Intelligence Solutions with Microsoft SQL Server 2014
- Delivering Business Intelligence with Microsoft SQL Server 2012 3rd Edition ISBN: 9780071759380
Prerequisites
In addition to your professional experience, you must have the following Microsoft certifications (MCSA: SQL Server):
- 70-461: MCTS - Querying Microsoft SQL Server
- 70-462: MCTS - Administering Microsoft SQL Server Databases
- 70-463: MCTS - Implementing a Data Warehouse with Microsoft SQL Server
You must have:
- Minimum two years of experience of working with relational databases, including:
- Designing a normalised database
- Creating tables and relationships
- Querying with Transact-SQL
- Fundamental knowledge of data warehouse schema topology (including star and snowflake schemas)
- Exposure to basic programming constructs (such as looping and branching)
Awareness of key business priorities such as revenue, profitability, and financial accounting is also recommended.
Benefits
Seven reasons why you should sit your course with Firebrand Training
- Two options of training. Choose between residential classroom-based, or online courses
- You'll be certified fast. With us, you’ll be trained in record time
- Our course is all-inclusive. A one-off fee covers all course materials, exams**, accommodation* and meals*. No hidden extras.
- Pass the first time or train again for free. This is our guarantee. We’re confident you’ll pass your course the first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
- You’ll learn more. A day with a traditional training provider generally runs from 9 am – 5 pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day of quality learning time, with your instructor
- You’ll learn faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
- You’ll be studying with the best. We’ve been named in the Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified over 135,000 professionals
*For residential training only. Doesn't apply for online courses
**Some exceptions apply. Please refer to the Exam Track or speak with our experts
Think you are ready for the course? Take a FREE practice test to assess your knowledge! Free Practice Test