Introduction To Data Warehouse

What you'll learn
We really hope this course will help you with your career immensely and take you to the next level
Assessment questionnaires are included at appropriate points to test your knowledge
Important sessions of this course are Transactional vs Analytical Processing, ETL
Data Warehouse Architecture, Data Mart, Data Warehouse Schema and SCDs
Requirements
You need to have Basic knowledge on RDBMS Concepts and SQL
Description
A Data warehouse is a database that is used for data analysis and reporting. It is a central repository for all the data that is needed for reporting and analysis. In this course you will learn everything about the Data warehouse. Data and analytics have become indispensable to businesses to stay competitive. Business users rely on reports, dashboards, and analytics tools to extract insights from their data, monitor business performance, and support decision making. Data warehouses power these reports, dashboards, and analytics tools by storing data efficiently to minimize the input and output (I/O) of data and deliver query results quickly to hundreds and thousands of users concurrently. A data warehouse architecture is made up of tiers. The top tier is the front-end client that presents results through reporting, analysis, and data mining tools. The middle tier consists of the analytics engine that is used to access and analyze the data. The bottom tier of the architecture is the database server, where data is loaded and stored. Data is stored in two different types of ways: 1) data that is accessed frequently is stored in very fast storage (like SSD drives) and 2) data that is infrequently accessed is stored in a cheap object store, like Amazon S3. The data warehouse...

Read more

Continue reading...