Coursera

Business intelligence and data warehousing (Coursera)

Offered by Universidad Nacional Autónoma de México,
Business intelligence and data warehousing (Coursera)

Welcome to the specialization course Business Intelligence and Data Warehousing. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how to identify, design and develop analytical information systems, such as Business Intelligence with a descriptive analysis on data warehouses. You will be able to understand the problem of integration and predictive analysis of high volume of unstructured data (big data) with data mining and the Hadoop framework.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

After completing this course, a learner will be able to
● Create a Star o Snowflake data model Diagram through the Multidimensional Design from analytical business requirements and OLTP system
● Create a physical database system
● Extract, Transform and load data to a data-warehouse.
● Program analytical queries with SQL using MySQL
● Predictive analysis with RapidMiner
● Load relational or unstructured data to Hortonworks HDFS
● Execute Map-Reduce jobs to query data on HDFS for analytical purposes
Programming languages:
For course 2 you will use the MYSQL language.
Software to download:
Rapidminer
MYSQL
Excel
Hortonworks Hadoop framework
In case you have a Mac / IOS operating system you will need to use a virtual Machine (VirtualBox, Vmware).
Course 2 of 4 in the Database systems Specialization.

Syllabus

WEEK 1
Introduction to Business Intelligence as Analytical System
In the first module named Introduction to Business Intelligence as Analytical System, we will learn how the steps of the process of datawarehousing to automate analytical processes that companies need for their business strategies. Let's start!

WEEK 2
Designing a Data Warehouse
After completing this module, a learner will be able to identify the entire process of datawarehousing, which consist on OLAP design concepts and multidimensional modelling. The learner will be able to design and create a data warehouse from OLAP requirements.

WEEK 3
The ETL process and Analytical queries with SQL
After completing this module, a learner will differentiate from structured and unstructured data and will be able to extract, transform and load data into a datawarehouse. The student will also be able to program and execute OLAP queries with SQL.

WEEK 4
Predictive Analytics with Data mining
After completing this module, a learner will identify the main data mining tasks and some algorithms for classification, regression and clustering for predictive and descriptive analysis on business intelligence.

WEEK 5
The problem of integration and analysis of unstructured data
After completing this module, a learner will learn the types of data according to structure and how to integrate, store and analyze unstructured data.

WEEK 6
Big Data and Hadoop Framework
After completing this module, a learner will understand the problem of big data, a possible solution to the analysis of big data with the Hadoop ecosystem and under which conditions should be apply each element of this ecosystem.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Association Rules Analysis (Coursera) Coursera
University of Colorado Boulder

Association Rules Analysis (Coursera)

Statistics & Data Analysis Data Science

The "Association Rules and Outliers Analysis" course introduces students to fundamental concepts of unsupervised learning methods, focusing on association rules and outlier detection. Participants will delve into frequent patterns and association rules, gaining insights into Apriori algorithms and constraint-based association rule mining. Additionally, students will explore outlier detection methods, with a deep understanding of contextual outliers. Through interactive tutorials and practical case studies, students will gain hands-on experience in applying association rules and outlier detection techniques to diverse datasets.

Jun 22nd 2026
5-12 Weeks
Data Mining Unsupervised Learning Coursera Plus
Details
Data Warehouse Concepts, Design, and Data Integration (Coursera) Coursera
University of Colorado System

Data Warehouse Concepts, Design, and Data Integration (Coursera)

CS: Design & Product

This is the second course in the Data Warehousing for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will learn exciting concepts and skills for designing data warehouses and creating data integration workflows. These are fundamental skills for data warehouse developers and administrators. You will have hands-on experience for data warehouse design and use open source products for manipulating pivot tables and creating data integration workflows.

Jun 22nd 2026
5-12 Weeks
Business Intelligence Data Warehousing Data Warehouse
Details
Data Mining Pipeline (Coursera) Coursera
University of Colorado Boulder

Data Mining Pipeline (Coursera)

Statistics & Data Analysis Data Science

This course introduces the key steps involved in the data mining pipeline, including data understanding, data preprocessing, data warehousing, data modeling, interpretation and evaluation, and real-world applications. Data Mining Pipeline can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform.

Jun 22nd 2026
4 Weeks
Data Modeling Data Mining Data Warehousing
Details
Data Wrangling with Python Project (Coursera) Coursera
University of Colorado Boulder

Data Wrangling with Python Project (Coursera)

Statistics & Data Analysis Data Science

The "Data Wrangling Project" course provides students with an opportunity to apply the knowledge gained throughout the specialization in a real-life data wrangling project of their interest. Participants will follow the data wrangling pipeline step by step, from identifying data sources to processing and integrating data, to achieve a fine dataset ready for analysis. This course enables students to gain hands-on experience in the data wrangling process and prepares them to handle complex data challenges in real-world scenarios.

Jun 22nd 2026
5-12 Weeks
Python Data Mining Data Wrangling
Details
Design Thinking and Predictive Analytics for Data Products (Coursera) Coursera
University of California, San Diego

Design Thinking and Predictive Analytics for Data Products (Coursera)

Statistics & Data Analysis Data Science

This is the second course in the four-course specialization Python Data Products for Predictive Analytics, building on the data processing covered in Course 1 and introducing the basics of designing predictive models in Python. In this course, you will understand the fundamental concepts of statistical learning and learn various methods of building predictive models.

Jun 22nd 2026
5-12 Weeks
Data Analysis Design Thinking Data Products
Details
Text Retrieval and Search Engines (Coursera) Coursera
University of Illinois at Urbana-Champaign

Text Retrieval and Search Engines (Coursera)

Statistics & Data Analysis Data Science

Recent years have seen a dramatic growth of natural language text data, including web pages, news articles, scientific literature, emails, enterprise documents, and social media such as blog articles, forum posts, product reviews, and tweets. Text data are unique in that they are usually generated directly by humans rather than a computer system or sensors, and are thus especially valuable for discovering knowledge about people’s opinions and preferences, in addition to many other kinds of knowledge that we encode in text.

Jun 22nd 2026
5-12 Weeks
Machine Learning Search Data Mining
Details
Introduction to Clinical Data (Coursera) Coursera
Stanford University

Introduction to Clinical Data (Coursera)

Statistics & Data Analysis Data Science

This course introduces you to a framework for successful and ethical medical data mining. We will explore the variety of clinical data collected during the delivery of healthcare. You will learn to construct analysis-ready datasets and apply computational procedures to answer clinical questions. We will also explore issues of fairness and bias that may arise when we leverage healthcare data to make decisions about patient care.

Jun 22nd 2026
5-12 Weeks
Health Ethics Data Mining
Details
Pattern Discovery in Data Mining (Coursera) Coursera
University of Illinois at Urbana-Champaign

Pattern Discovery in Data Mining (Coursera)

Statistics & Data Analysis Data Science

Learn the general concepts of data mining along with basic methodologies and applications. Then dive into one subfield in data mining: pattern discovery. Learn in-depth concepts, methods, and applications of pattern discovery in data mining. We will also introduce methods for data-driven phrase mining and some interesting applications of pattern discovery. This course provides you the opportunity to learn skills and content to practice and engage in scalable pattern discovery methods on massive transactional data, discuss pattern evaluation measures, and study methods for mining diverse kinds of patterns, sequential patterns, and sub-graph patterns.

Jun 22nd 2026
4 Weeks
Algorithms Data Mining Data Analysis
Details
Practical Predictive Analytics: Models and Methods (Coursera) Coursera
University of Washington

Practical Predictive Analytics: Models and Methods (Coursera)

Statistics & Data Analysis Data Science

Statistical experiment design and analytics are at the heart of data science. In this course you will design statistical experiments and analyze the results using modern methods. You will also explore the common pitfalls in interpreting statistical arguments, especially those associated with big data. Collectively, this course will help you internalize a core set of practical and effective machine learning methods and concepts, and apply them to solve some real world problems.

Jun 22nd 2026
4 Weeks
Machine Learning Models Methods
Details
Data Ecosystem (Coursera) Coursera
Tableau Learning Partner

Data Ecosystem (Coursera)

Statistics & Data Analysis Data Science

The Data Ecosystem course will give you a foundational understanding of the entire data ecosystem, including data management. Specifically, this course shows how a business intelligence analyst would organize, access, and use data. You will learn about a variety of data sources along with the use and purpose of each type. Additionally, you’ll learn about the importance of data quality and data governance in relation to effective data management.

Jun 22nd 2026
3 Weeks
Databases Data Management Data Warehousing
Details