Microsoft MCSE: Business Intelligence (SQL Server) - Only 6 Days

Seven reasons why you should sit your MCSE Business Intelligence course with Firebrand Training

Find Out How We Help You To Learn New Skills Quickly

  1. You'll be MCSE Business Intelligence certified in just 6 days. With us, you’ll be MCSE Business Intelligence trained in record time
  2. Our MCSE Business Intelligence course is all-inclusive. A one-off fee covers all course materials, exams, accommodation and meals. No hidden extras
  3. Pass MCSE Business Intelligence first time or train again for free. This is our guarantee. We’re confident you’ll pass your course first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
  4. You’ll learn more MCSE Business Intelligence. A day with a traditional training provider generally runs from 9am – 5pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day quality learning time, with your instructor
  5. You’ll learn MCSE Business Intelligence 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
  6. You’ll be studying MCSE Business Intelligence with the best. We’ve been named in 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 65,138 professionals, and we’re partners with all of the big names in the business
  7. You'll do more than study MCSE Business Intelligence courseware. We use practical exercises to make sure you can apply your new knowledge to the work environment. Our instructors use demonstrations and real-world experience to keep the day interesting and engaging

Think you are ready for the course? Take a FREE practice test to assess your knowledge!

When do you want to sit your accelerated course?

Start

Finish

Status

Location

Book now

21/8/2017 (Monday)

26/8/2017 (Saturday)

Finished

-

 

5/2/2018 (Monday)

10/2/2018 (Saturday)

Limited availability

Nationwide

 

19/3/2018 (Monday)

24/3/2018 (Saturday)

Open

Nationwide

 

30/4/2018 (Monday)

5/5/2018 (Saturday)

Open

Nationwide

 

11/6/2018 (Monday)

16/6/2018 (Saturday)

Open

Nationwide

 

Here's the Firebrand Training review section. Since 2001 we've trained exactly 65,138 students and asked them all to review our Accelerated Learning. Currently, 96.55% have said Firebrand exceeded their expectations:



"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. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (6/6/2016 to 11/6/2016)

"I achieved my MCSE, over the moon. Thank you."
Wayne Chandler. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (6/6/2016 to 11/6/2016)

"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. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (17/8/2015 to 22/8/2015)

"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.. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (17/8/2015 to 22/8/2015)

"A good way to learn, wouldn't have gain half this knowledge from self study as I did with the instructor."
Jason Linham. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (17/8/2015 to 22/8/2015)

"Simply a great way to learn."
Niall Kynoch, N/A. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (2/3/2015 to 7/3/2015)

"A brand for a very good training provider."
HariKrishnaRao Bhatlapenumarthy. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (24/11/2014 to 29/11/2014)

"Great 6 days and look forward to use in real world."
David Wheeler, Amazing IT LTD. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (24/11/2014 to 29/11/2014)

"A very enjoyable and informative course which provided good real world examples of software use, as well as being great preparation for the certification exam."
Mary Hughes, Altius. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (24/11/2014 to 29/11/2014)

"Great place to get the job done!!!"
Trevor Thackwell, Advent International. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (9/9/2013 to 14/9/2013)

"Good introduction to the broad range of technologies available in 2012"
glen wilkinson, Aspen Re. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (9/9/2013 to 14/9/2013)

"I have tried many other training venues around the world in my years as an IT professional and i have been back to Firebrand twice. Why, because they are the best,no comparison."
Ejay Aninye, Unemployed. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (9/9/2013 to 14/9/2013)

"It's a fast way of learning and a fast way to get certified You do not have a lot of spare time, you are just studying."
James Kemp, SDRS UK Ltd. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (15/7/2013 to 20/7/2013)

"Brilliant training again! It's a tough week, but well worth it "
Gary Evans, CUBIQ Solutions Limited. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (15/7/2013 to 20/7/2013)

"Hard work that pays off, you will not regret choosing Firebrand for your certification."
Ryan Gillett. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (18/3/2013 to 23/3/2013)

"Firebrand is a excellent environment to attend an accelerated learning course and the entire staff does their utmost to facilitate achieving your goals. Together with the forthcoming renovation in accommodation, I'm sure it will be an unbeatable combination. A very knowledgeable trainer and has put an excellent effort into the training presentation and supplemental material. I can highly recommend her for an accelerated approach to training for the SQL 2012 MSCE BI exams."
Anonymous - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (1/10/2012 to 6/10/2012)

"Excellent tutor with a lot of knowledge, hard work but well worth it!"
J.N. - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (1/10/2012 to 6/10/2012)

"Kompakt, innholdsrikt og god instruktoer"
Anonymous - Microsoft MCSE: Business Intelligence (SQL Server) (6 days) (14/10/2013 to 19/10/2013)

"Firebrand taught me 2 months ago for a networking course and was just as good this time, highly recommend Firebrand. Until next time!"
Jordan Duncan, LSI Architects. - Microsoft MTA Security Fundamentals (2 days) (6/10/2017 to 7/10/2017)

"This is now the 3rd time I have attended a Firebrand course and still cannot fault them. Each instructor I've had has been extremely knowledge and helpful. I have recommended FB to many colleagues."
Laura OConnor, Utilita Energy Limited. - Microsoft MTA Security Fundamentals (2 days) (6/10/2017 to 7/10/2017)

"The course was intensive with a lot to take in during a short period but you have every resource you need. Great Staff, great atmosphere and you get well looked after too. I'll be back!"
D.W.. - Microsoft MCSE: Messaging (Exchange 2016) (6 days) (2/10/2017 to 7/10/2017)

"Excellent tutor, all explained clearly and in detail."
Arkadiusz Rycyk, Environ Audio Ltd. - Microsoft Specialist: Programming in C# (4 days) (2/10/2017 to 5/10/2017)

"The teaching was dynamic, engaging, immersive and knowledgeable. The instructor made complex concepts simple. I enjoyed the course very much. "
Richard Barnes, Whale Tankers. - Microsoft Specialist: Programming in C# (4 days) (2/10/2017 to 5/10/2017)

"Intense but very rewarding course, learned a lot in a few days."
S.S.. - Microsoft Specialist: Programming in C# (4 days) (2/10/2017 to 5/10/2017)

"The course was very intense and very informative, real examples were given to concepts hard to understand."
Anonymous - Microsoft Specialist: Programming in C# (4 days) (2/10/2017 to 5/10/2017)

"Training with Firebrand has been a great way to kick-start my IT certifications and to help me aim to progress in my careers. Instructors are knowledgeable and insightful and the learning experience was top notch!"
L.M.. - Microsoft MTA: Windows Server Administration Fundamentals (2 days) (2/10/2017 to 3/10/2017)

"Great facilities, good teacher and an enjoyable course."
Adam Batten. - Microsoft MTA Software Development Fundamentals (2 days) (28/9/2017 to 29/9/2017)

"This course was condensed but covered most of the topics. Will recommend to my colleagues and friends. One has to understand OOP, SDLC, VS, .net +Core. The Dev course was tough for me but the trainer made it understandable for me. "
P.A., kpdsolutions Ltd and contract client - TfL. - Microsoft MCSE: Cloud Platform and Infrastructure (Azure) (9 days) (9/9/2017 to 17/9/2017)

"As expected, I had an excellent experience here and the instructor knew the subject matter very well. I will definitely recommend Firebrand anytime and any day."
Ekhorutomwen Asemota, Capgemini. - Microsoft Specialist: Architecting Microsoft Azure Solutions (2 days) (16/9/2017 to 17/9/2017)

"Excellent and to the point, cannot not praise enough the instructor whose delivery was impeccable. "
P.V.. - Microsoft MCSD: Azure Solutions Architect (9 days) (9/9/2017 to 17/9/2017)

"The training was well structured and comprehensive. I filled in my Azure knowledge gaps and the instructor prepared me for the exams excellently, and was extremely knowledgeable, patient, and friendly throughout. All hail Lord Chinzilla!"
Chris Smallman. - Microsoft MCSE: Cloud Platform and Infrastructure (Azure) (9 days) (9/9/2017 to 17/9/2017)

"Lots of long days paid off - the course was tough but greatly rewarding. The instructor was a brilliant coach and we wouldn't have made it through the 9 days without him. The food wasn't bad either!"
Joseph Ellis, PA Consulting. - Microsoft MCSE: Cloud Platform and Infrastructure (Azure) (9 days) (9/9/2017 to 17/9/2017)

"The instructor has been great. Extremely enthusiastic and engaging. Would definitely recommend him to my colleagues. The structure and coverage of the material will definitely help me succeed with Azure, thanks Victor!"
Tarun Julka, Diligent Corporation. - Microsoft MCSE: Cloud Platform and Infrastructure (Azure) (9 days) (9/9/2017 to 17/9/2017)

"I always enjoy my courses at Firebrand and would recommend people take their courses here."
Ridhan Romjon, Retail 247. - Microsoft MCSE: Cloud Platform and Infrastructure (Azure) (9 days) (9/9/2017 to 17/9/2017)

"Intensive means just that. Long and exhausting training days but the quality of instruction makes the time fly by. Looking forward to part 2!"
C.P.. - Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions (3 days) (9/9/2017 to 11/9/2017)

"The instructor was very engaging and knew his stuff! "
Anonymous - Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions (3 days) (9/9/2017 to 11/9/2017)

"The quality of the training at Firebrand is perfect for preparing your for the exams!"
Rachel Hillier, Computer-eye2. - Microsoft MCSA: Windows 10 (6 days) (21/8/2017 to 26/8/2017)

"If you need massive amounts of knowledge in a short time, these are the guys to train with. Excellent facility and instructors. "
Darrall Jarman, Dazzle Computer Solutions (Self Employed). - Microsoft MCSA: Windows 10 (6 days) (21/8/2017 to 26/8/2017)

"Great place to come if like me you cant sit at home and read through a book, as it just does not go in. I came here having read books and have learnt a lot in the 6 days I was here. The classrooms are quite a nice environment and if you get a good trainer then it makes the whole thing better. The days are long and a bit of a slog at times getting in at 8/8.30 and then leaving at 9. Obviously there are breaks in between but still long days and don't sleep much. Overall a great experience and will definitely be using Firebrand for training again. "
Ben Farnath-Jones, OC&C Strategy Consultants. - Microsoft MCSA: Windows 10 (6 days) (21/8/2017 to 26/8/2017)

"Although the course consisted of very long days, the instructor was brilliant, it was a good laugh in the classroom and covered the subject areas very well! "
Anonymous - Microsoft MCSA: Windows 10 (6 days) (21/8/2017 to 26/8/2017)

"The trainer was great and very engaging. I thoroughly enjoyed the course and felt that all of the modules were covered clearly and concisely."
Ethan ODonnell. - Microsoft Windows Server 2016 - Identity (4 days) (17/8/2017 to 20/8/2017)

"After finishing the training for the MCSA course, I now feel confident in taking the examination!"
Callum Nocton-Gribben, Onefile ltd. - Microsoft MCSA: SQL Server 2016 - Database Development (6 days) (14/8/2017 to 19/8/2017)

"Had a great time at Firebrand. Thank you for all your support."
Jacob Johnson, St Johns School. - Microsoft Windows Server 2016 - Networking (3 days) (14/8/2017 to 16/8/2017)

"MCSD - App Builder course experience was great, got to know lot of new stuff like Azure & MVC and information about how to develop/plan enterprise level web application. The instructor was great through out the course explaining lot of modern stuff which goes on and also balancing the course with exam perspective. "
Amit Rathod. - Microsoft MCSD: App Builder (9 days) (5/8/2017 to 13/8/2017)

"The instructor was great and answered all questions in detail as well as making sure everyone understood. I found the course challenging but learning at Firebrand helps beginners get better knowledge of all the courseware covered."
Hannah McEwan. - Microsoft MCSD: App Builder (9 days) (5/8/2017 to 13/8/2017)

"The course was of very high quality and has provided me with the relevant information to allow me to put it into practice. I attended the course with little knowledge of administering SharePoint and I am leaving knowing that I have the relevant knowledge to build and administer a SharePoint farm. This is all thanks to the instructor - he has been fantastic!"
Benjamin Riley, Halton Borough Council. - Microsoft MCSE: SharePoint 2016 (6 days) (7/8/2017 to 12/8/2017)

"Very experienced tutor also allowed flexible learning environment to discuss wider scope of applied knowledge. All In one location (accommodation and self contained classroom building that is 24 hours accessible)."
A.A.. - Microsoft MCSA: SQL Server 2016 - Database Administration (6 days) (7/8/2017 to 12/8/2017)

"The quality of the training experience was excellent! Good facilities, helpful staff and brilliant instructors. This was my first experience of official Microsoft training and Firebrand have definitely made me want more... and with them! I will be Back!"
D.W., Declaro Support Limited. - Microsoft MCSA: Office 365 (5 days) (7/8/2017 to 11/8/2017)

"Excellent facility with excellent trainers."
Owen Heaume . - Microsoft MCSA: Office 365 (5 days) (7/8/2017 to 11/8/2017)

"It has been a great course, the instructor takes a fast-paced & information dense course, yet somehow makes it feel relaxed. Its been a great 3 days."
Anonymous - Microsoft Developing ASP.NET MVC Web 4 Applications (3 days) (8/8/2017 to 10/8/2017)

MCSE Business Intelligence

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

Read more ...

Interested? See prices or call 080 80 800 888

Use your free Microsoft training vouchers

You may be entitled to heavily-discounted training via Microsoft's Software Assurance Training Voucher (SATV) scheme. If your business has bought Microsoft software, check to see if it came bundled with free training vouchers! Vouchers can be exchanged against training for all Microsoft technologies. If you’re unsure, get in touch with us

Other accelerated training providers rely heavily on lecture and independent self-testing and study.

Effective technical instruction must be highly varied and interactive to keep attention levels high, promote camaraderie and teamwork between the students and instructor, and solidify knowledge through hands-on learning.

Firebrand Training provides instruction to meet every learning need:

  • Intensive group instruction
  • One-on-one instruction attention
  • Hands-on labs
  • Lab partner and group exercises
  • Question and answer drills
  • Independent study

This information has been provided as a helpful tool for candidates considering training. Courses that include certification come with a Certification Guarantee. Pass first time or train again for free (just pay for accommodation, exams and incidental costs). We do not make any guarantees about personal successes or benefits of obtaining certification. Benefits of certification determined through studies do not guarantee any particular personal successes.

Read more ...

Interested? See prices or call 080 80 800 888

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

  • Introduction to Business Intelligence
  • The Microsoft Enterprise BI Platform

Lab : Exploring a BI Solution

After completing this module, you will be able to:

  • Describe the elements of a typical BI solution.
  • Select appropriate Microsoft technologies for a BI solution.
  • Describe key considerations for planning a BI project.

Module 2: Creating Multidimensional Databases

This module provides an introduction to multidimensional databases and introduces the core components of an Online Analytical Processing (OLAP) cube.

Lessons

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

Lab : Creating a Multidimensional Database

After completing this module, you will be able to:

  • Describe the considerations for a multidimensional database.
  • Create data sources and data source views.
  • Create a cube.
  • Implement security in a multidimensional database.

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

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

Lab : Working with Cubes and Dimensions

After completing this module, you will be able to:

  • Configure dimensions.
  • Define attribute hierarchies.
  • Sort and group attributes.

Module 4: Working with Measures and Measure Groups

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

  • Working with Measures
  • Working with Measure Groups

Lab : Configuring Measures and Measure Groups

After completing this module, you will be able to:

  • Configure measures.
  • Configure measure groups.

Module 5: Introduction to MDX

This module describes the fundamentals of MDX and explains how to build calculations, such as calculated members and named sets.

Lessons

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

Lab : Using MDX

After completing this module, you will be able to:

  • Describe MDX.
  • Add calculations to a cube.
  • Describe how to use MDX in client applications.

Module 6: Customising Cube Functionality

This module describes how to enhance a cube with Key Performance Indicators (KPIs), actions, perspectives, and translations.

Lessons

  • Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations

Lab : Customising a Cube

After completing this module, you will be able to:

  • Implement Key Performance Indicators.
  • Implement Actions.
  • Implement Perspectives.
  • Implement Translations.

Module 7: Implementing an Analysis Services Tabular Data Model

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

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

Lab : Implementing an Analysis Services Tabular Data Model

After completing this module, you will be able to:

  • Describe Analysis Services tabular data model projects.
  • Implement an Analysis Services tabular data model.
  • Use an Analysis Services tabular data model.

Module 8: Introduction to Data Analysis Expression (DAX)

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

  • DAX Fundamentals
  • Using DAX to Create calculated Columns and Measures in a Tabular Data Model
  • Lab : Creating Calculated Columns and Measures by using DAX

After completing this module, you will be able to:

  • Describe the fundamentals of DAX.
  • Use DAX to create calculated columns and measures.

Module 9: Implementing Reports with SQL Server Reporting Services

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

  • Introduction to Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Showing Data Graphically
  • Filtering Reports Using Parameters

Lab : Creating a Report with Report Designer

After completing this module, you will be able to:

  • Describe the key features of Reporting Services.
  • Use Report Designer to create a report.
  • Group and aggregate data in a report.
  • Publish and view a report.

Module 10: Automating Report Execution and Delivery

This module describes how to apply security and report execution settings, and how to create subscriptions to deliver reports.

Lessons

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

Lab : Implementing Report Subscriptions

After completing this module, you will be able to:

  • Configure security settings for a report server.
  • Configure report execution settings to optimise performance.
  • Use subscriptions and alerts to automate report and data delivery.
  • Troubleshoot reporting issues.

Module 11: Delivering BI with SharePoint PerformancePoint Services

This module introduces Microsoft SharePoint Server as a platform for BI, and then focuses on building BI dashboards and scorecards with PerformancePoint Services.

Lessons

  • Introduction to SharePoint Server as a BI Platform
  • Planning Security for a SharePoint Server BI Solution
  • Planning for PerformancePoint Services

Lab : Implementing PerformancePoint Services

After completing this module, you will be able to:

  • Describe SharePoint Server as a BI platform.
  • Use PerformancePoint Services to deliver BI functionality.
  • Configure PerformancePoint Data Sources.
  • Create Reports, Scorecards, and Dashboards.

Module 12: Performing Predictive Analysis with Data Mining

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

  • Overview of Data Mining
  • Using the Data Mining Add-in for Excel
  • Creating a Custom Data Mining Solution
  • Validating a Data Mining Model
  • Connecting to and Consuming Data Mining Data

Lab : Using Data Mining to Support a Marketing Campaign

After completing this module, you will be able to:

  • Describe the key data mining concepts and use the Data Mining Add-ins for Excel.
  • Create a data mining solution.
  • Validate data mining models.
  • Use data mining data in a report.

Course 20467D: Designing Business Intelligence Solutions with Microsoft SQL Server 2014


Module 1: Planning a BI Solution

This module enables students to plan the components of a BI Solution.

Lessons

  • Elements of a BI Solution
  • Planning a BI Project
  • The Microsoft BI Platform

Lab : Planning BI Solutions

After completing this module, you will be able to:

  • Describe the components of a BI Solution.
  • Identify the components of a BI Solution.
  • Plan a BI Project.

Module 2: Planning BI Infrastructure

This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.

Lessons

  • Considerations of BI Infrastructure
  • Planning Data Warehouse Hardware

Lab : Planning BI Infrastructure

After completing this module, you will be able to:

  • Describe the components of a BI Infrastructure and where you would use them.
  • Plan for the hardware requirements of a data warehouse implementation.

Module 3: Designing a Data Warehouse

This module describes how to design a data warehouse given a set of user requirements.

Lessons

  • Data Warehouse Design Overview
  • Designing Dimension Tables
  • Design FACT tables

Lab : Designing a Data Warehouse Logical Schema

After completing this module, you will be able to:

  • Design a data warehouse.
  • Design dimension tables.
  • Design Fact tables.
  • Design a logical schema for a data warehouse.

Module 4: Designing an ETL solution

This lesson describes how to design an extract, transform and load (ETL) solution.

Lessons

  • ETL Overview
  • Planning for Data Extraction
  • Planning for Data Transformations
  • Planning for Data Loading

Lab : Designing an ETL Solution

After completing this module, you will be able to:

  • Describe the components of an ETL solution.
  • Design an ETL solution.

Module 5: Designing Analytical Data Models

This module describes how to design analytical data models for specific BI scenarios.

Lessons
  • Introduction to Analytical data Models
  • Designing Analytical Data Models

Lab : Designing Analytical Data Model

Lab : Designing Dimensions and Hierarchies

After completing this module, you will be able to:

  • Describe the features of an analytical data model.
  • Design an analytical data model.

Module 6: Planning a BI Delivery Solution

This module describes how to choose an appropriate delivery solution for a given scenario.

Lessons

  • Considerations for BI delivery
  • Common Reporting Scenarios
  • Choosing a Reporting Tool

Lab : Planning a BI Delivery Solution

After completing this module, you will be able to:

  • Describe the components of a BI delivery solution.
  • Describe some common reporting scenarios.
  • Choose an appropriate delivery solution for a given scenario.

Module 7: Designing a Reporting Services Solution

This module describes how to design a reporting services solution.

Lessons

  • Planning a Reporting Solution
  • Designing Reports
  • Planning Report Consistency

Lab : Designing a Reporting Services Solution

After completing this module, you will be able to:

  • Plan for a reporting Services solution.
  • Design reports for a reporting services solutions.
  • Plan for consistency of reporting

Module 8: Designing an Excel Based reporting Solution

In this module students will learn how to design a reporting solution using Excel.

Lessons

  • Using Excel for Data Reporting and Analysis
  • PowerPivot in Excel
  • Power View in Excel

Lab : Designing and Excel Reporting Solution

After completing this module, you will be able to:

  • Describe key features of excel reporting solutions.
  • Use PowerPivot in Excel to create reports.
  • Use Power View in excel to create reports.

Module 9: Planning a SharePoint Server BI Solution

This module introduces the use of SharePoint Server as a BI solution.

Lessons

  • Introduction to SharePoint Server as a BI Platform
  • Planning Security for a SharePoint Server BI Solution
  • Planning Reporting Services Configuration
  • Planning PowerPivot Configuration
  • Planning for PerformancePoint Services

Lab : Implementing a SharePoint Server BI Solution

Lab : Implementing PerformancePoint Services

After completing this module, you will be able to:

  • Describe the components of a SharePoint Server BI solution.
  • Plan security for a SharePoint Server BI solution.
  • Plan reporting solutions for a SharePoint Server BI solution.
  • Describe the components of a PerformancePoint Solution.
  • Implement PerformancePoint services.

Module 10: Monitoring and Optimising a BI Solution

At the conclusion of this module you will be able to optimise and monitor a BI solution.

Lessons

  • Overview of BI Monitoring
  • Monitoring and Optimising the Data Warehouse
  • Monitoring and Analysing Analysis Services
  • Monitoring and Optimising Reporting Services

Lab : Monitoring and Optimising a BI Solution

After completing this module, you will be able to:

  • Describe the options for monitoring and optimising a BI solution.
  • Be able to monitor and optimise a BI solution.

Module 11: Operating a BI Solution

At the conclusion of this module you will be able to plan management and maintenance operations of a BI solution.

Lessons

  • Overview of BI Operations
  • ETL Operations
  • Data Warehouse Operations
  • Analysis Services Operations
  • Reporting Services Operations

Lab : Operating a BI Solution

After completing this module, you will be able to:

  • Describe the components to be managed in a BI Solution.
  • Be able to manage the components of a BI solution.

Read more ...

Interested? See prices or call 080 80 800 888

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
080 80 800 888 to find out more.

Read more ...

Interested? See prices or call 080 80 800 888

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

Firebrand Training offers top-quality technical education and certification training in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so our students can focus solely on their studies and certification goals.

Our Accelerated Learning Programmes include:

  • Intensive Hands-on Training Utilising our (Lecture | Lab | Review)TM Delivery
  • Comprehensive Study Materials, Program Courseware and Self-Testing Software including MeasureUp *
  • Fully instructor-led program with 24 hour lab access
  • Examination vouchers **
  • On site testing ***
  • Accommodation, all meals, unlimited beverages, snacks and tea / coffee****
  • Transportation to/from designated local railway stations
  • Examination Passing Policy

Our instructors teach to accommodate every student's learning needs through individualised instruction, hands-on labs, lab partner and group exercises, independent study, self-testing, and question/answer drills.

Firebrand Training has dedicated, well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and lounging rooms. Our students consistently say our facilities are second-to-none.

Firebrand goes digital

We’re currently migrating from printed to digital courseware. Some courseware is already available in digital, while other books remain in printed form. To find out if this course is digital, call us on 080 80 800 888.

There are several benefits of easy-to-use digital courseware: downloads are immediate, and you’ll always have your courseware available wherever you are. You won’t need to wait for a printed book to be delivered before you start learning – and it’s better for the environment. You can choose to download the courseware to your own device, or borrow one of ours.

Considering a Microsoft course? Always have the most up-to-date Microsoft digital courseware with ‘Fresh Editions’. This gives you access to all versions of digital courseware – you’ll receive updates and revisions of your textbook, at no charge, for the life of that course.

Examination Passing Policy

Should a student complete a Firebrand Training Program without having successfully passed all vendor examinations, the student may re-attend that program for a period of one year.  Students will only be responsible for accommodations and vendor exam fees.

Please note

  • * Not on all courses
  • ** Examination vouchers are not included for the following courses: PMI, GIAC, CISA, CISM, CGEIT, CRISC, CISSP CBK Review and CSX Practitioner Level 1,2 and 3
  • *** On site testing is not included for our PMI, GIAC, CSX Practitioner or ITIL Managers and Revision Certification Courses.
  • **** Accommodation not included on the CISSP CBK Review Seminar

Read more ...

Interested? See prices or call 080 80 800 888

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.

Unsure whether you meet the prerequisites?

Don’t worry - we’ll discuss your technical background, experience and qualifications to determine whether this accelerated course suits you.

Just call us on 080 80 800 888 and speak to one of our enrolment consultants.

Firebrand is an immersive environment and requires commitment. Some prerequisites are simply guidelines; you may find your unique experience, attitude and determination enables you to succeed on your accelerated course.

Interested? See prices or call 080 80 800 888