Implementing a Data Warehouse with Microsoft SQL Server (MS-20463)

Rating:
91% of 100

This course helps professionals learn the art of implementing a data warehouse and helps professionals proficiently work with Business Intelligence Solutions.

Virtual

Learning Style

Microsoft

Provider

Intermediate

Difficulty

5 Days

Course Duration

5

SATV Value

Course Info

Download PDF

Certificate

See Sample

Timezone
empty table
tab

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

Outline

More Information

More Information
Brand Microsoft
Subjects IT Ops & Management
Lab Access Yes
Technology Microsoft
Learning Style Virtual Classroom
Learning Type Course
Difficulty Intermediate
Course Duration 5 Days
Language English
SATV Value 5
VPA Discount VPA Discount

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Course Expert:

Author

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
  1. 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 by

    Posted on

  2. 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 by

    Posted on

  3. Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    Paula Woodall is a first­rate 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 by

    Posted on

  4. 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 by

    Posted on

  5. 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 by

    Posted on

  6. Real World Knowledge
    Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  7. Great Instructor!
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  8. Excellent
    Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  9. 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 by

    Posted on

  10. Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  11. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  12. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  13. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  14. 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 by

    Posted on

  15. 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 by

    Posted on

  16. 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 by

    Posted on

  17. 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 by

    Posted on

  18. 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 by

    Posted on

  19. Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  20. 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 by

    Posted on

  21. 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 by

    Posted on

  22. 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 by

    Posted on

  23. Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  24. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  25. 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 by

    Posted on

  26. 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 by

    Posted on

  27. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%

    Review by

    Posted on

  28. Quality of Instructor
    80%

    Review by

    Posted on

  29. Course Quality
    80%
    Quality of Instructor
    60%
    Overall Satisfaction
    80%

    Review by

    Posted on

  30. Quality of Instructor
    100%

    Review by

    Posted on

  31. Quality of Instructor
    100%
    Hardware was good..configuration has already been told to the client.the machine was setup accordingly. NA

    Review by

    Posted on

  32. Quality of Instructor
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  33. Quality of Instructor
    100%

    Review by

    Posted on

  34. Overall Satisfaction
    80%

    Review by

    Posted on

  35. Course Quality
    80%
    Overall Satisfaction
    100%
    More real world examples could be used

    Review by

    Posted on

  36. 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 by

    Posted on

  37. 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 by

    Posted on

  38. Overall Satisfaction
    100%

    Review by

    Posted on

  39. Overall Satisfaction
    80%
    I learn visually so I would like to see more demos and examples.

    Review by

    Posted on

  40. Overall Satisfaction
    100%

    Review by

    Posted on

  41. Quality of Instructor
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  42. Overall Satisfaction
    100%

    Review by

    Posted on

  43. Course Quality
    80%
    Overall Satisfaction
    100%

    Review by

    Posted on

  44. Overall Satisfaction
    100%

    Review by

    Posted on

  45. Course Quality
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%

    Review by

    Posted on

  46. Overall Satisfaction
    100%
    I hope the class can provide physical book and online book

    Review by

    Posted on

  47. 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 by

    Posted on

  48. Course Quality
    60%
    Overall Satisfaction
    100%
    Jeff is an excellent instructor, can explain things so a 7 year old could understand

    Review by

    Posted on

  49. Course Quality
    80%
    Overall Satisfaction
    100%
    The instructor was great. He kept the class engaged, was knowledgeable and easy to follow.

    Review by

    Posted on

  50. Overall Satisfaction
    100%

    Review by

    Posted on

  51. Overall Satisfaction
    100%

    Review by

    Posted on

  52. Overall Satisfaction
    100%
    I thought the examples made the material easier to understand.

    Review by

    Posted on

  53. Course Quality
    80%
    Overall Satisfaction
    100%
    Jeff was very knowledgable and patient with awnsering any and all questions.

    Review by

    Posted on

  54. 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.

    Review by

    Posted on

  55. Overall Satisfaction
    100%

    Review by

    Posted on

  56. Course Value
    60%
    Quality of Instructor
    60%
    Overall Satisfaction
    80%

    Review by

    Posted on

  57. Overall Satisfaction
    100%

    Review by

    Posted on

click here