Microsoft 70-463: Implementing A Data Warehouse - ITU Online

Microsoft 70-463: Implementing a Data Warehouse

In this course you will learn how to create Business Intelligence (BI) solutions. This course will teach you how to implement a data warehouse platform to support a BI solution. You will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Included In This Course

Included In This Course

Total Hours
6 Training Hours
Microsoft 70-463: Implementing a Data Warehouse
69 On-demand Videos
Closed Caption

Closed Captions

Course Topics
14  Topics
Prep Questions
101 Prep Questions
Microsoft 70-463: Implementing a Data Warehouse

Certificate of Completion

Course Description

Note: Although the associated examination for this course has been retired, it is a good resource for training.

About the current exam objectives

This Microsoft 70-463: Implementing a Data Warehouse with SQL Server exam is designed to assess the knowledge and skills of ETL and data warehouse developers who are responsible for developing Business Intelligence (BI) solutions, such as performing data cleansing tasks and implementing Extract Transform Load processes in a data warehouse.

This course is preparation for the 70-463 Implementing a Data Warehouse with SQL Server exam. The course covers topics that are featured on the exam, such as how to implement a data warehouse platform to support a BI solution, how to create a data warehouse with Microsoft SQL Server, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Skills measured in exam questions

  • 10–15% – Create and execute a data warehouse that exemplifies efficiency, performance, and scalability.
  • 20–25% – Streamline your data by leveraging Extract and Transform capabilities. Quickly extract the most relevant information from multiple sources for advanced analytics, enabling you to make informed decisions about how best to utilize your resources.
  • 25–30% – Upload data for processing and analysis.
  • 20–25% Quickly and efficiently deploy SSIS solutions in order to get the most out of your business. 
  • 15–20% – Construct robust data integrity solutions that ensure accuracy, reduce errors and maximize efficiency.

Frequently Asked Questions About Microsoft 70-463: Implementing a Data Warehouse

What will I learn from the Microsoft 70-463: Implementing a Data Warehouse course?

You’ll learn how to create Business Intelligence (BI) solutions. The course teaches you how to implement a data warehouse platform to support a BI solution. You’ll also get the chance to learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

How long is the course and what are the components?

The course is six training hours long. It consists of 69 videos and 14 topics, and it provides you with 101 practice questions​.

How can I access the course?

The course is available through an All Access Monthly Subscription. This gives you access to over 2,500 hours of on-demand content. You can start a 7-day free trial with no obligation and you can cancel anytime.

I heard the associated exam has been retired. Is the course still relevant?

Yes, while the exam associated with this course has been retired, the course itself remains a valuable resource for training. It’s especially beneficial for ETL and data warehouse developers who are developing Business Intelligence (BI) solutions​.

What skills are measured in the exam questions?

The exam measures your ability to create and execute a data warehouse that exemplifies efficiency, performance, and scalability.

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 Course Content

Lesson 1: Introduction to Data Warehouse

  •    Introduction

  •    Introduction To Data Warehouse-Part1

  •    Introduction To Data Warehouse-Part2

  •    Introduction To Data Warehouse-Part3

  •    Introduction To Data Warehouse-Part4

  •    Introduction To Data Warehouse-Part5

  •    Introduction To Data Warehouse-Part6

Lesson 2: Creating Dimensions and Changing Granularity of Dimensions

  •    Creating Dimensions And Changing Granularity Of Dimensions-Part1

  •    Creating Dimensions And Changing Granularity Of Dimensions-Part2

  •    Creating Dimensions And Changing Granularity Of Dimensions-Part3

  •    Creating Dimensions And Changing Granularity Of Dimensions-Part4

  •    Creating Dimensions And Changing Granularity Of Dimensions-Part5

  •    Creating Dimensions And Changing Granularity Of Dimensions-Part6

Lesson 3: Creating Fact Tables and ColumnStore Indexes

  •    Creating Fact Tables And Column Store Indexes-Part1

  •    Creating Fact Tables And Column Store Indexes-Part2

  •    Creating Fact Tables And Column Store Indexes-Part3

  •    Creating Fact Tables And Column Store Indexes-Part4

  •    Creating Fact Tables And Column Store Indexes-Part5

Lesson 4: Implementing Data Warehouse in SQL Server 2012

  •    Implementing Data Warehouse-Part1

  •    Implementing Data Warehouse-Part2

  •    Implementing Data Warehouse-Part3

  •    Implementing Data Warehouse-Part4

Lesson 5: Working with Integration Services

  •    Working With Integration Services-Part1

  •    Working With Integration Services-Part2

  •    Working With Integration Services-Part3

  •    Working With Integration Services-Part4

  •    Working With Integration Services-Part5

  •    Working With Integration Services-Part6

Lesson 6: Managing Control Flow

  •    Managing Control Flow-Part1

  •    Managing Control Flow-Part2

  •    Managing Control Flow-Part3

  •    Managing Control Flow-Part4

  •    Managing Control Flow-Part5

Lesson 7: Working with Dynamic Variables

  •    Working With Dynamic Variables-Part1

  •    Working With Dynamic Variables-Part2

  •    Working With Dynamic Variables-Part3

  •    Working With Dynamic Variables-Part4

  •    Working With Dynamic Variables-Part5

  •    Working With Dynamic Variables-Part6

  •    Working With Dynamic Variables-Part7

  •    Working With Dynamic Variables-Part8

Lesson 8: Implementing Data Flow

  •    Implementing DataFlow-Part1

  •    Implementing DataFlow-Part2

  •    Implementing DataFlow-Part3

  •    Implementing DataFlow-Part4

  •    Implementing DataFlow-Part5

  •    Implementing DataFlow-Part6

  •    Implementing DataFlow-Part7

  •    Implementing DataFlow-Part8

Lesson 9: Managing Data Flow

  •    Managing DataFlow-Part1

  •    Managing DataFlow-Part2

  •    Managing DataFlow-Part3

  •    Managing DataFlow-Part4

Lesson 10: Managing SSIS Package Execution

  •    Managing SSIS Package Execution-Part1

  •    Managing SSIS Package Execution-Part2

  •    Managing SSIS Package Execution-Part3

  •    Managing SSIS Package Execution-Part4

  •    Managing SSIS Package Execution-Part5

  •    Managing SSIS Package Execution-Part6

Lesson 11: Debugging and Troubleshooting

  •    Debugging And Troubleshooting-Part1

  •    Debugging And Troubleshooting-Part2

  •    Debugging And Troubleshooting-Part3

  •    Debugging And Troubleshooting-Part4

Lesson 12: Deploying Packages

  •    Deploying Packages-Part1

  •    Deploying Packages-Part2

  •    Deploying Packages-Part3

Lesson 13: Securing Packages and Databases

  •    Securing Packages And Databases-Part1

  •    Securing Packages And Databases-Part2

Lesson 14: Working with MDS and Windows

  •    Working With MDS And Windows Azure

Add a review
Currently, we are not accepting new reviews
4.8
Based on 78 reviews
1-5 of 78 reviews
  1. Smooth delivery and easy access to LMS. Good to see that the LMS offers progress tracking. Would be great if badges were offered on completion of courses to share via Credly to future employers.

Your Training Instructor

Rafiq Wayani

Rafiq Wayani

Project Management Instructor

Rafiq has extensive experience including more than 20 years in IT as a Systems Architect, Software Engineer, DBA, and Project Manager. He has instructed in a variety of technical areas and has designed and implemented network and information systems. Bringing nearly 30 years of advanced IT experience to each course and adding his unique perspective and “real world” tips, Rafiq has a knack for making complex topics easy to understand.

Microsoft 70-463: Implementing a Data Warehouse
 

$49.00

OR

Subscribe To All-Access
Lock In $14.99 / Month Forever

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Microsoft 70-463: Implementing a Data Warehouse

Microsoft 70-463: Implementing a Data Warehouse with SQL Server
Microsoft 70-463: Implementing a Data Warehouse
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

Become a Certified Kubernetes Application Developer (CKAD). Enroll now and learn how to build, deploy, and manage Kubernetes applications.

If you’re looking to ace the Certified Kubernetes Application Developer (CKAD) exam, this is the  video IT  course for you! Through its comprehensive instruction materials, and lectures, it will teach you all that there is to know about Kubernetes – an open-source system designed by Google but now maintained by The Cloud Native Computing Foundation and pass the certification program. 

Add To Cart

$49.00

Take the Microsoft 70-480: Programming in HTML5, JavaScript and CSS3 course and become a skilled web developer. Enroll now!

In this Microsoft 70-480 course you will learn how to implement and manipulate document structures and objects, implement program flow, access and secure data, and use CSS3 in applications. This course will teach you HTML5, CSS3, Javascript and jQuery.

Add To Cart

$49.00

Master HTML5 with our comprehensive online course! Get hands-on training and learn the latest web development techniques.

This Learn HTML course is designed for beginner level individuals who are interested in learning how to build a page for a website. Our comprehensive training course dives into all areas of HTML writing & editing so that by the end, you will be an expert in coding with HTML!

Add To Cart