Key points about this course
Duration: 5 Days *
Language: EnglishDates & Prices Enquire
We have your course. Please kindly fill below your contact details to receive full course information and pricing.
At The Knowledge Academy, our classroom-based training courses allow delegates to study and learn in a friendly, engaging,
and interactive environment. We ensure the very best level of teaching, with first-rate instructors, resources,
and state-of-the-art facilities. We provide courses of varying durations and can arrange weekend and residential
courses in order to suit your requirements.
Furthermore, our classroom courses are carried out in thousands of locations worldwide, making training easily accessible wherever you are. Our courses typically begin at 9.00 am and continue until 5.00 pm each day, with breaks and refreshments provided. , As our most popular form of training available, we pride ourselves in continuously delivering an outstanding learning experience for our delegates in the classroom.
Our online-based training courses aim to provide you with a complete training experience. Due to their
flexibility, these courses are greatly suited to busy working professionals, or any individual who would prefer the
convenience of an online training course.
Our Computer-Based Training (CBT) courses remove the time and cost associated with travelling to course locations. You can complete your chosen course in any location, and work at your own pace, as the learning portal can be accessed 24/7. All of our online training courses have technical and administrative support and mobile access. Furthermore, each course has been carefully designed to incorporate informative, instructive, and engaging content. In this way, online learning can guarantee a valuable and enjoyable training solution.
Our Onsite training option allows you to select any of our courses and receive training at a venue of your choice,
by any method of your choice.
Onsite courses deliver training to multiple employees at once, thus reducing travel expenses and providing you with the ultimate convenience and value for money. In addition, this option allows you to receive a training course that has been specifically tailored to meet your business needs, ensuring first-class quality, applicability, and value.
By choosing to bring bespoke training to the office, you can improve business performance, and make your organisation more streamlined, resourceful, and profitable. With over 25 years’ of experience, we are the market-leaders of Onsite training.
Our Virtual training courses provide you with the option to learn using a specialised simulated virtual environment.
In this environment, our expert training instructors will be able to convey information and provide you with the
all the knowledge you require to earn your qualification with The Knowledge Academy. As the largest global
training provider, this method of training allows us to extend our training scope to those who may not
be able to attend a classroom course itself, but would like to receive direct training and support from an instructor.
Using this training delivery method, you would benefit from the convenience of remote access and the elimination of the time and cost associated with travelling to a training venue.
Duration: 5 Days *
Language: EnglishDates & Prices Enquire
Available delivery methods for this course
Select your preferred delivery method
Choose a region
Choose a location
Choose a month
This 5 day Implementing a Data Warehouse with Microsoft SQL Server training course provides delegates with the ability to implement data warehouse structures in order to support Business Intelligence solutions. Individuals will become familiar with the Microsoft SQL Server 2014 for the purposing of data warehouse construction, and will learn how to apply ETL with the SQL Server. As well as this, delegates will use SQL Server Data Quality Services and SQL Server Master Data Services to cleanse and verify information.
This training course is suitable for those who wish to learn about SQL Server 2012 or SQL Server 2014. The new features of the 2014 SQL Server are explored, as are the fundamental proficiencies of the overall SQL Server system.
Module 1: Introduction to Data Warehousing
Overview of Data Warehousing
Considerations for a Data Warehouse Solution
Lab: Exploring a Data Warehousing Solution
Module 2: Data Warehouse Hardware Considerations
Considerations for building a Data Warehouse
Data Warehouse Reference Architectures and Appliances
Lab: Planning Data Warehouse Infrastructure
Module 3: Designing and Implementing a Data Warehouse
Logical Design for a Data Warehouse
Physical design for a Data Warehouse
Lab: Implementing a Data Warehouse Schema
Module 4: Creating an ETL Solution with SSIS
Introduction to ETL with SSIS
Exploring Data Sources
Implementing Data Flow
Lab: Implementing Data Flow in an SSIS Package
Module 5: Implementing Control Flow in an SSIS Package
Introduction to Control Flow
Creating Dynamic Packages
Lab: Implementing Control Flow in an SSIS Package
Lab: Using Transactions and Checkpoints
Module 6: Debugging and Troubleshooting SSIS Packages
Debugging an SSIS Package
Logging SSIS Package Events
Handling Errors in an SSIS Package
Lab: Debugging and Troubleshooting an SSIS Package
Module 7: Implementing an Incremental ETL Process
Introduction to Incremental ETL
Extracting Modified Data
Loading Modified Data
Lab: Extracting Modified Data
Lab: Loading Incremental Changes
Module 8: Enforcing Data Quality
Introduction to Microsoft SQL Server Data Quality Services (DQS)
Using Data Quality Services to Cleanse Data
Using Data Quality Services to Match Data
Lab: Cleansing Data
Lab: De-duplicating data
Module 9: Using Master Data Services
Master Data Services Concepts
Implementing a Master Data Services Model
Managing Master Data
Creating a Master Data Hub
Lab: Implementing Master Data Services
Module 10: Extending SQL Server Integration Services
Using Scripts in SSIS
Using Custom Components in SSIS
Lab: Using Custom Components and Scripts
Module 11: Deploying and Configuring SSIS Packages
Overview of SSIS Deployment
Deploying SSIS Projects
Planning and Monitoring SSIS Package Execution
Lab: Deploying and Configuring SSIS Packages
Module 12: Consuming Data in a Data Warehouse
Introduction to Business Intelligence
Introduction to Reporting
An Introduction to Data Analysis
Lab: Using Business Intelligence Tools
This training course is designed for database professionals who are looking to accomplish the role of a Business Intelligence Developer. Attendees should be familiar with generating Business Intelligence solutions such as Data Warehouse implementation and data cleansing. They should be accustomed with the advancement of SSIS packages for information extraction, conversion, and loading, and the administering of data integrity through the use of Master Data Services.
Delegates must possess at least 2 years of relational database experience, specifically in:
Designing normalized databases
Constructing tables and relationships
Querying with Transact-SQL
Fundamental programming constructs
Understanding of business elements like profitability, revenue, and accounting would be useful, although this is not compulsory.
The Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 70-463 exam is not included with this training course. Delegates will be able to sit this examination, which will cover the following topics:
Designing and Implementing a Data Warehouse
Extracting and Transforming Data
Configuring and Deploying SSIS Solutions
Building Data Quality Solutions
Delegates will need to sign a non-disclosure exam agreement, which confirms that they agree not to share information regarding the exam format with any other person.
Best price in the industry
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