This course helps professionals learn the art of implementing a data warehouse and helps professionals proficiently work with Business Intelligence Solutions.
Individual course plan gives you access to this course
$2,995.00
/ Seat
Contact Us
You have already taken demo for this course.
If you want to get access to demo again, feel free to contact our support at (855) 800-8240
This course helps professionals learn the art of implementing a data warehouse and helps professionals proficiently work with Business Intelligence Solutions.
Course Information
Candidates enrolling directly in this course without the Master Subscription Plan will receive a free official exam voucher for the 70-463 Exam (Except Purchases included in Training Vouchers/SATV). There is no free official exam voucher for candidates enrolling using the Master Subscription Plan. However, the official exam voucher can be purchased separately on request.
About this Course:
This intermediate-level 5-days course provides professionals with the conceptual insight of Data Warehousing. This course helps professionals learn the art of implementing a data warehouse and helps professionals proficiently work with Business Intelligence Solutions. The primary objective of this course is to train & prepare students for success in the Microsoft 70-463 Certification Exam. Through this course, professionals will learn the art of handling Microsoft SQL Servers proficiently and will help them become proficient BI Leaders
Course Objectives:
The core objective of this course is to help professional gain a better understanding and sound knowledge of the following key concepts:
Data Warehouse Architecture Considerations & Concepts
Hardware Platform Selection for Data Warehousing
Data Warehouse Implementation and Design
SSIS Package Control Flow & Data Flow Implementation
Troubleshooting and Debugging SSIS Packages
ETL Solution Implementation for Incremental Data Loading & Data Extraction
Microsoft Data Quality Services Data Cleansing Implementation
Enforcing Data Integrity by Master Data Services Implementation
SSIS Extension with Custom Components and Scripts
SSIS Packages Deployment and Configuration
BI Solution Data Consumption from Data Warehouse
Audience:
Business Intelligence Developers
Database Professionals
Professionals liable for Implementing Data Warehouse & Data Cleansing
Developers Creating & Developing BI Solutions
Professionals liable for Developing SSIS Packages & Enforcing Data Integrity
Prerequisites:
Professionals planning to enroll in this course must comply with the following prerequisites:
2-Years’ Practical Experience of Relational Databases
Familiarity with Transact SQL Querying, Tables Creation, & Normalized Databases
Fundamental Knowledge of Branching, Looping, other Programming Concepts
Understanding of Major Business Priorities is highly Recommended
Our experts featured on QuickStart are driven by our ExpertConnect platform, a community of professionals focused on IT topics and discussions. Interact with these experts, create project opportunities, gain help and insights on questions you may have, and more.
Course Expert:
Tom Robertson (Data Science Enthusiast)
Tom is an innovator first, and then a Data Scientist & Software Architect. He has integrated expertise in business, product, technology and management. Tom has been involved in creating category defining new products in AI and big data for different industries, which generated more than hundred million revenue cumulatively, and served more than 10 million users. As a Data Scientist and Software Architect Tom has extensive experience in data science, engineering, architecture and software development. To date Tom has accumulated over a decade of experience in R, Python & Linux Shell programming.
Tom has expertise on Python, SQL, and Spark. He has worked on several libraries including but not limited to Scikit-learn, Pandas, NumPy, Matplotlib, Seaborn, SciPy, NLTK, Keras, and Tensorflow.
Customer Reviews
Implementing a Data Warehouse with Microsoft SQL Server (MS20463)
Overall Satisfaction
60%
Quality of Instructor
80%
Course Quality
60%
Course material should have focused little bit more on planning and designing data warehousing. Instructor was pretty flexible and was able to help me out understand the subject and labs.
Review bySushma
Posted on
Course Quality
80%
Course Value
80%
Quality of Instructor
100%
Overall Satisfaction
80%
I wish my exchange class was not cancelled and when it was cancelled, it would have been good to have had a notification.
Review byDeanna Cross
Posted on
Course Quality
80%
Course Value
80%
Quality of Instructor
80%
Overall Satisfaction
80%
Paula Woodall is a firstrate instructor, knowledgeable and organized. The class material was comprehensive, although a bit dated (SS2014). I have had a mix of experiences with QuickStart, but use more instructors like Paula, and update curriculum, and I will be back.
Review byJack Colon
Posted on
Course Quality
100%
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Overall experience was great. I wasn't able to access the course through quickstart and received immediate support.
Review byJeannie White
Posted on
Confident Instructor
Course Quality
100%
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
I found Jeff personable,approachable and very knowledgeable on the subject matter. I feel like the labs cover a lot and I definitely need to go over them again to fully understand everything - however all the necessary components are there.
Review byClyde Jackson
Posted on
Real World Knowledge
Course Quality
100%
Course Value
80%
Quality of Instructor
100%
Overall Satisfaction
100%
Review byRobert Anthony
Posted on
Great Instructor!
Course Quality
100%
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Review byLaura Swenson
Posted on
Excellent
Course Quality
100%
Course Value
80%
Quality of Instructor
100%
Overall Satisfaction
100%
Review byJennifer Findley
Posted on
Course Value
100%
Quality of Instructor
60%
Overall Satisfaction
60%
9 isn't high enough in terms of a top rating! Instructors are great. I have worked less than 1 year in the IT industry when taking this training.
Review byMartha Abbott
Posted on
Course Value
80%
Quality of Instructor
100%
Overall Satisfaction
100%
Review bySydney Marquez
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Review byTimothy Schreier
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
80%
Review byLucille Phipps
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Review byAmanda Coleman
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Very enthusiastic and knowledgeable I have worked over 10 years in the IT industry when taking this training.
Review byJustin Dennett
Posted on
Course Value
80%
Quality of Instructor
100%
Overall Satisfaction
100%
Great job I enjoyed class thoroughly and learned a lot. I have worked less than 1 year in the IT industry when taking this training.
Review byJamie Justice
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
40%
Jeff has great stories on history of SQL Server and practical real world examples on how the tech is used. I have worked over 10 years in the IT industry when taking this training.
Review byJohn Lyons
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Jeff is a fantastic trainer. Very knowledgeable on the subject matter. Great teaching skills. Quickly develops a great rapport with the students. I have worked over 10 years in the IT industry when taking this training.
Review byRichard Blanding
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Overall the instructor was very good I have worked over 10 years in the IT industry when taking this training.
Review byTodd Leyba
Posted on
Course Value
80%
Quality of Instructor
100%
Overall Satisfaction
80%
Review byMichael Fehr
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
I don't have much experience in SQL server the instructor provided the information needed for me at work. I have worked over 10 years in the IT industry when taking this training.
Review byRichard Bower
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Jeff has been outstanding answering all our questions queries and provided relevant examples and references. He is a subject matter expert. Love to take his classes. ~Sushant I have worked over 10 years in the IT industry when taking this training.
Review byCassie Alejandro
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Like Jeff's approach on presenting the course material through real life situations.It is effective in understanding and applying the knowledge. I don't like when instructor read from the manual; I can do that on my own. Jeff is a great instructor and communicator. I have worked over 10 years in the IT industry when taking this training.
Review byJohn Peters
Posted on
Course Value
80%
Quality of Instructor
100%
Overall Satisfaction
80%
Review byBarbara Cullen
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Review byStacey Demaio
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
100%
Excellent Instructor I have worked 3-5 years in the IT industry when taking this training.
Review byMichael Fisher
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
80%
Jeff clearly has a grasp of the course material and was more than willing and able to answer any questions I have worked over 10 years in the IT industry when taking this training.
Review byRandall Stoddard
Posted on
Course Value
100%
Quality of Instructor
100%
Overall Satisfaction
80%
Review byCheryl Cover
Posted on
Quality of Instructor
80%
Review byViola Larsen
Posted on
Course Quality
80%
Quality of Instructor
60%
Overall Satisfaction
80%
Review byAimee Odom
Posted on
Quality of Instructor
100%
Review byLoreen Miller
Posted on
Quality of Instructor
100%
Hardware was good..configuration has already been told to the client.the machine was setup accordingly. NA
Review byGlenda Sullivan
Posted on
Quality of Instructor
80%
Overall Satisfaction
80%
Review byDouglas Branan
Posted on
Quality of Instructor
100%
Review byDonald Kim
Posted on
Overall Satisfaction
80%
Review byNancy Dortch
Posted on
Course Quality
80%
Overall Satisfaction
100%
More real world examples could be used
Review byRobert Canter
Posted on
Overall Satisfaction
100%
Very well put together class. Jeff is very practical and knowledgeable. Willing to share. I would not change much. Just make sure the students know they must have some SQL experience. Otherwise, this is very hard class with no SQL exp.
Review byIrene Garrett
Posted on
Quality of Instructor
80%
Overall Satisfaction
100%
With not having any experience what so ever with DW, I would have like so spend more time learning about dimensions and fact tables. Also, which tables do users query on for reports for the most of the time
Review byLuke Shepard
Posted on
Overall Satisfaction
100%
Review byZoraida Smith
Posted on
Overall Satisfaction
80%
I learn visually so I would like to see more demos and examples.
Review byTommy Leeper
Posted on
Overall Satisfaction
100%
Review byChristine Vue
Posted on
Quality of Instructor
80%
Overall Satisfaction
80%
Review byCarlos Werner
Posted on
Overall Satisfaction
100%
Review byDaniel Bell
Posted on
Course Quality
80%
Overall Satisfaction
100%
Review byMark Tatum
Posted on
Overall Satisfaction
100%
Review byRobert Najera
Posted on
Course Quality
80%
Quality of Instructor
80%
Overall Satisfaction
80%
Review byKathryn Chisolm
Posted on
Overall Satisfaction
100%
I hope the class can provide physical book and online book
Review byRaul Parker
Posted on
Overall Satisfaction
100%
It was made clear that another course is focused more on reporting, but it would be nice to have the full package/overview from inception to user delivery Jeff's knowledge and ability to pass it on in a clear and concise manner is great.
Review byJames Chung
Posted on
Course Quality
60%
Overall Satisfaction
100%
Jeff is an excellent instructor, can explain things so a 7 year old could understand
Review byErica Coughlin
Posted on
Course Quality
80%
Overall Satisfaction
100%
The instructor was great. He kept the class engaged, was knowledgeable and easy to follow.
Review byKenneth Sykes
Posted on
Overall Satisfaction
100%
Review byScott Herring
Posted on
Overall Satisfaction
100%
Review byJose Puga
Posted on
Overall Satisfaction
100%
I thought the examples made the material easier to understand.
Review byEdith Kopec
Posted on
Course Quality
80%
Overall Satisfaction
100%
Jeff was very knowledgable and patient with awnsering any and all questions.
Review byDeborah Terry
Posted on
Course Quality
60%
Course Value
60%
Overall Satisfaction
100%
The instructor showed great knowledge in the subject area and was also very good in explaining the various modules.