Key points about this course
Duration: 5 Days*
Support: 24/7Dates & Prices Enquire
Send us your message.X
We have your course. Please kindly fill below your contact details to receive full course information and pricing.
Available delivery methods for this course
This 5-day course focuses on teaching delegates such as database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies.
This Designing Business Intelligence Solutions with Microsoft SQL Server 2014 course is fully accredited by Microsoft through the Microsoft Silver Partnership held by The Knowledge Academy.
After completing this course, delegates will be able to:
This course includes the following modules:
Module 1: Planning a BI Solution
This module enables delegates to plan the components of a BI Solution.
Lab: Planning BI Solutions
Module 2: Planning SQL Server Business Intelligence Infrastructure
This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.
Lab: Planning BI Infrastructure
Module 3: Designing a Data Warehouse
This module describes how to design a data warehouse given a set of user requirements.
Lab: Designing a Data Warehouse Logical Schema
Module 4: Designing an ETL solution
This lesson describes how to design an extract, transform, and load (ETL) solution.
Lab: Designing an ETL Solution
Module 5: Designing Analytical Data Models
This module describes how to design analytical data models for specific BI scenarios.
Lab: Designing Analytical Data Models
Lab: Designing Dimensions and Hierarchies
Module 6: Planning a BI Delivery Solution
This module describes how to choose an appropriate delivery solution for a given scenario.
Lab: Planning a BI Delivery Solution
Module 7: Designing a Reporting Services Solution
This module describes how to design a reporting services solution.
Lab: Designing a Reporting Services Solution
Module 8: Designing an Excel-based Reporting Solution
In this module, delegates will learn how to design a reporting solution using Excel.
Lab: Designing and Excel Reporting Solution
Module 9: Planning a SharePoint Server BI Solution
This module introduces the use of SharePoint Server as a BI solution.
Lab: Implementing a SharePoint Server BI Solution
Lab: Implementing PerformancePoint Services
Module 10: Monitoring and Optimising a BI Solution
At the conclusion of this module, delegates will be able to optimise and monitor a BI solution.
Lab: Monitoring and Optimising a BI Solution
Module 11: Operating a BI Solution
By the end of this module, delegates will be able to plan management and maintenance operations of a BI solution.
Lab: Operating a BI Solution
This course is intended for delegates who need to fulfil a Business Intelligence Developer role to create analysis and reporting solutions. Their responsibilities may include:
Before attending this course, delegates should possess or be able to demonstrate:
Duration: 5 Days*
Support: 24/7View dates & prices
Select your preferred delivery method
Choose a Region
Choose a Location
Choose a Month
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Trusted & Approved
Microsoft Silver Learning Partner
Various delivery methods
Flexible delivery methods are available depending on your learning style.
Resources are included for a comprehensive learning experience.
"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"
Joshua Davies, Thames Water
"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."
Diane Gray, Shell