Against a backdrop characterised by the digitisation and data analysis, our course provides an essential foundation for understanding and managing enterprise information architecture. We will delve into ETL processes – which are vital for data transformation and transfer – and into the effective organisation of data, whilst exploring the various types of databases, both relational and NoSQL. We will explore data organisation models and techniques for database optimisation, preparing participants to tackle current challenges in any sector. Furthermore, the section on data warehouses and data marts will provide an understanding of how they work and how to make the most of the stored data, including an examination of leading platforms such as Amazon RedShift. This course Data transformation and organisation: Data warehouses, data marts and end-to-end ETL It is a crucial step for those seeking to keep up to date with the demands of managing large volumes of information and turning them into strategic decisions, without the pressure of having to become a specialist overnight.
Data transformation and organisation: Data warehouses, data marts and ETL
Databases
40 hours
Introduction
Objectives
-
Understanding the logic ETL and its key use.
-
Drive data using current ETL tools.
-
Discover Data warehouse and data marts.
-
Explore Database relational and NoSQL.
-
Learn about columnar databases and optimisation.
-
Designing and utilising data in Data Marts.
-
Assess Inmon and Kimball in DWH.
Table of Contents
TEACHING UNIT 1. ETL PROCESSES
Introduction to ETL
ETL tools
ETL process elements
Microsoft SSIS ETL
Comparison of tools
TEACHING UNIT 2. ORGANISATION OF DATA (I)
Introduction and trends in the data
Relational databases (I)
Relational databases (II)
NoSQL databases
SQL vs NoSQL Comparison
TEACHING UNIT 3. ORGANISATION OF DATA (II)
Data organisation models
Columnar Databases
Optimising Databases (I)
Optimising Databases (II)
Relational database design
TEACHING UNIT 4. DATA WAREHOUSES AND DATA MARTS
Data Warehouse
Inmon v Kimbal
Analysing DWH data
Data Mart
Amazon RedShift
Your questions answered
Why choose Educa.Pro?
Educa.Pro enables organisations to centralise training management, personalise learning and gain clear insights into the impact of training programmes. Thanks to its AI-powered technology, organisations can optimise their learning strategies, enhance talent development and make data-driven decisions.
Can the courses be taken at your own pace?
Yes. Most of the courses on Educa.Pro are self-paced and on-demand, allowing users to progress at their own pace without missing out on progress tracking or assessments, which makes it easier to fit them around work or study commitments.
What levels of security and compliance does the platform offer?
Educa.Pro complies with security standards designed to protect user and organisational data. Furthermore, it supports the traceability of certifications, digital signatures and the management of assessments, thereby ensuring regulatory and legal compliance in both educational and corporate environments.
What support and guidance does Educa.Pro offer?
The Educa.Pro team offers comprehensive support throughout implementation, roll-out and adoption, ensuring that organisations get the most out of the platform and achieve measurable results from day one.