Business intelligence and data warehousing

  • 3.9
Approx. 10 hours to complete

Course Summary

This course covers the fundamentals of business intelligence and data warehousing. Students will learn how to design, build, and maintain data warehouses and use business intelligence tools to analyze and report on data.

Key Learning Points

  • Learn how to design and build data warehouses
  • Understand business intelligence tools and their application
  • Analyze and report on data using business intelligence

Related Topics for further study


Learning Outcomes

  • Design and build a data warehouse
  • Use business intelligence tools to analyze and report on data
  • Implement ETL processes for data integration

Prerequisites or good to have knowledge before taking this course

  • Basic understanding of databases and SQL
  • Familiarity with data modeling concepts

Course Difficulty Level

Intermediate

Course Format

  • Online
  • Self-paced

Similar Courses

  • Data Warehousing for Business Intelligence
  • Business Intelligence and Data Mining

Related Education Paths


Notable People in This Field

  • Kimball Group
  • Ralph Kimball

Related Books

Description

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.

Outline

  • Introduction to Business Intelligence as Analytical System
  • Introduction to BI
  • How data is analyzed?
  • Welcome to the course
  • Business intelligence
  • Designing a Data Warehouse
  • Design and implement an analytical databases
  • Steps to Multidimensional model OLTP
  • Designing a Data Warehouse
  • The ETL process and Analytical queries with SQL
  • Extract, transform and load data
  • Typical OLAP operations
  • The ETL process and Analytical queries with SQL
  • Predictive Analytics with Data mining
  • The process of data mining
  • ID3 Algorithms
  • Data mining
  • The problem of integration and analysis of unstructured data
  • Data types according to structure of data
  • Integrate, store and analyze unstructured data
  • Types of data
  • Big Data and Hadoop Framework
  • What Big Data is?
  • Analysis of unstructured data
  • Concepts of Big Data and Hadoop Framework
  • Assesment

Summary of User Reviews

Learn Business Intelligence and Data Warehousing with Coursera. This course has received positive reviews from users who found it helpful in understanding data analytics. One key aspect that many users thought was good is the comprehensive coverage of the course material.

Pros from User Reviews

  • Comprehensive coverage of course material
  • Engaging and interactive course content
  • Great for beginners in data analytics
  • Flexible learning options
  • Helpful and responsive instructors

Cons from User Reviews

  • Some users found the course material too basic
  • Lack of real-world case studies
  • Limited interaction with other students
  • No certification offered for completing the course
  • Some technical issues reported with the platform
English
Available now
Approx. 10 hours to complete
María del Pilar Ángeles
Universidad Nacional Autónoma de México
Coursera

Instructor

Share
Saved Course list
Cancel
Get Course Update
Computer Courses