Data Warehousing

Use data warehousing to improve your decision making process.

Preview the first lesson free — get full access to all 43 lessons.

Course: On-Demand

Intermediate Provider : Katie Gatto 7 chapters · 43 Lessons · 1h 10m in Arabic, English, Spanish

Course Description

Data warehousing is the first in many data tasks that are necessary in order to identify and analyze the data needs of a business process or a project. Through this “Data Warehousing” course, you will learn how to implement data modeling and incorporate it in your management system. You will also gain business intelligence skills, becoming knowledgeable about the fundamentals of data warehousing by understanding the purpose of collecting data and how it will be relevant to your business.

The different topics included in this course will advance your decision-making processes. By following the basic steps of data modeling covered in this course, you will be able to apply the fundamentals of data warehousing to improve your project management skills. Learn powerful and flexible tools for interpreting information and get ahead of your competitors by knowing how to pick out the most valuable data that your business needs.

What You'll Learn

Decipher the basic steps of data modeling alongside data warehousing fundamentals
Collect data that is relevant for your business and understand its purpose
Improve project management techniques using business intelligence infrastructure
Identify the best strategies for working with data and metadata in project management
Employ powerful tools for data collection and modeling in data mining
Build a data warehouse and apply its fundamentals to improve decision-making

Key Takeaways

Data warehousing is the first step in identifying and analyzing the data needs of a business process or project.
The course explains how business intelligence, data modeling, and data warehousing are linked and how to incorporate data modeling into a management system.
Topics include transactional databases, data marts, data mining, applied analytics, and dimension and fact tables.
Understanding the purpose of collecting data and selecting the most valuable data helps a business get ahead of competitors and advance decision-making.
The course covers business intelligence roles, program management, change management, quality management, and metadata challenges and strategies.

Frequently Asked Questions

What will I learn in this Data Warehousing course?

You will learn how to implement data modeling and incorporate it into your management system, gain business intelligence skills, understand the fundamentals of data warehousing, and learn how to build a data warehouse to improve your project management and decision-making.

What topics does this course cover?

The course covers business intelligence, data modeling, data warehousing, transactional databases, data mining, data marts, dimension and fact tables, business intelligence processes and roles, program and change management, quality management with data, project management methodology, and metadata challenges and strategies.

Who is this course for?

This course is for people who want to learn the fundamentals of data warehousing and business intelligence, improve their project management skills, and learn how to collect, model, and interpret the data their business needs.

What skills will I gain from this course?

You will gain skills in Business Intelligence, Business Intelligence Data Modeling, BusinessObjects OLAP Intelligence, Data Warehousing, and Data Warehousing and Business Intelligence (DWBI), aligned with Data Warehousing Concepts Certification.