The course gives you knowledge of what the data warehouse concept is and how it connects to data analysis for decision-making and automated processes. You learn how and why data is collected, stored and processed into a basis for analyses and decisions. Through theory and practical exercises you develop skills in selecting, downloading, processing, validating and cleaning data so that it becomes suitable for analysis. After the course you can build data warehouses that make it possible to ask complex questions quickly.
The purpose of the course is to give the student knowledge of what the data warehouse concept is and what it consists of, and how it connects to data analysis for strategic purposes such as decision-making and automated processes. The student will also learn how and why data is collected, stored and processed into a basis for analyses, decisions and automation processes. The goal is for the student, through theory and practical exercises, to develop specialised knowledge of how to store large amounts of historical data and make it possible to ask fast, complex questions of the data warehouse, so that analysts and decision-makers can easily retrieve and compile relevant data from it for comparisons, analyses and processes. The student will develop skills in selecting and downloading data from relevant sources; processing, validating and cleaning the data so that it becomes uniform and suitable for analysis; and writing it into the correct storage formats.
The purpose of the course is to give the student knowledge of what the data warehouse concept is and what it consists of, and how it connects to data analysis for strategic purposes such as decision-making and automated processes. The student will also learn how and why data is collected, stored and processed into a basis for analyses, decisions and automation processes. The goal is for the student, through theory and practical exercises, to develop specialised knowledge of how to store large amounts of historical data and make it possible to ask fast, complex questions of the data warehouse, so that analysts and decision-makers can easily retrieve and compile relevant data from it for comparisons, analyses and processes. The student will develop skills in selecting and downloading data from relevant sources; processing, validating and cleaning the data so that it becomes uniform and suitable for analysis; and writing it into the correct storage formats.
What a data warehouse is and how it differs from other storage solutions.
How data is collected, validated and cleaned for analysis purposes.
Storing large amounts of historical data in correct formats.
How data warehouses are used by analysts and decision-makers for fast, complex questions.
The course is aimed at you who are studying TUC's YH programme in data/data analysis and want to understand how data warehouses are built and used.
When you complete the course, TUC Yrkeshögskola issues your certificate. Your name, the course content and the issue date are encrypted and secured on blockchain, so it cannot be changed, and anyone can check that it is genuine.
Sample Credential with placeholder data. Each credential is issued with the recipient’s details and is verifiable with the provider.