Online Course – Certified Professional Internship in Business Intelligence from the University of Colorado System

Build a custom business data management system with five courses that teach you how to build an optimal business data warehouse.

Suggested by: Coursera (What is Coursera?)

Professional Certificate

Advanced

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Business needs assessment
  • Data warehouse planning
  • Data integration and presentation
  • Working with large data systems
  • Creating dashboards
  • Visual analyses
  • Using MicroStrategy
  • OLAP capabilities
  • In-depth understanding of data warehouse design
  • Data manipulation
  • SQL encoding
  • Building a data warehouse
  • Data communication for a wide audience

What you will learn in the course

Courses for which the course is suitable

  • Data Analyst
  • Data warehouse developer
  • Data Architect
  • BI expert
  • SQL key
  • Information Systems Analyst
  • Data Project Manager
  • Visual analysis specialist
  • Dashboard developer
  • OLAP expert

Internship – Series of 5 courses

Assess business needs, design a data warehouse, and integrate and present data using dashboards and visual analytics.

This specialization covers data architecture skills that are increasingly being applied across various technology domains. You will learn the basics of the structured data model, gain hands-on experience in SQL coding, and develop a deep understanding of data warehouse design and data manipulation.

What you’ll learn:

  • Working with large data systems in a data warehouse environment.
  • Create dashboards and visual analyses.
  • Using MicroStrategy, a leading BI tool.
  • OLAP (Online Analytical Processing) and Visual Insights capabilities.

In the final project, you will apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a wide audience.

Details of the courses that make up the specialization

Database Management Fundamentals

Course 1
122 hours
4.6 (3,294 ratings)

What you’ll learn

Database Administration Fundamentals provides the foundation needed for a career in database development, data warehousing, or business intelligence. In this course, you will create relational databases, write SQL commands, create entity-relationship diagrams (ERDs), and analyze table designs.

Skills you will acquire

  • Data storage
  • SQL
  • Realized view
  • Data warehouse

Data warehouse, data planning, and data integration terms

Course 2
62 hours
4.4 (1,038 ratings)

What you’ll learn

In this course, you will learn concepts and skills for designing data warehouses and creating data integration flows. You will have hands-on experience designing data warehouses.

Skills you will acquire

  • Extraction, Transformation, and Loading (ETL)
  • Penthouse
  • Data integration
  • Data warehouse

Relational database support for data warehouses

Course 3
71 hours
4.6 (590 ratings)

What you’ll learn

You will learn about the features of relational database management systems for managing aggregate data. We will delve into storage architectures, parallel processing, data management, and the impacts of big data.

Skills you will acquire

  • Database (DB) Design
  • Entity-Relationship (ER) Model
  • Database (DBMS)
  • SQL

Business Intelligence Terms, Tools, and Applications

Course 4
21 hours
4.5 (630 ratings)

What you’ll learn

A data warehouse is a key component of data mining. The ability to quickly observe early trends is essential for making good decisions.

Skills you will acquire

  • Business intelligence
  • Data Analytics
  • Microstrategy
  • Data display

Design and build a data warehouse for business intelligence implementation

Course 5
31 hours
4.6 (287 ratings)

What you’ll learn

The final course includes a practical case study that integrates your learning from all courses in the specialization. You will design and build a small data warehouse, create data integration flows, and write SQL commands.