BI Foundations with SQL, ETL and Data Warehousing Specialization

BI Foundations with SQL, ETL and Data Warehousing Specialization

Get job-ready for your first role in BI. Build the in-demand skills you need to get started in business intelligence (BI) in just 2 months. No degree or prior experience required.

Instructors: IBM Skills Network Team

12,059 already enrolled

Included with Coursera Plus

Learn more

5 course series

Get in-depth knowledge of a subject

4.6

(397 reviews)

Beginner level

No prior experience required

2 months to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

5 course series

Get in-depth knowledge of a subject

4.6

(397 reviews)

Beginner level

No prior experience required

2 months to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Sought-after business intelligence skills that will help you get your first job in BI
How to run frequently used SQL queries to work with RDBMS and automate ETL jobs and data pipelines using BASH scripts, Apache Airflow & Kafka
How to design data warehouses using STAR and snowflake schemas, load/verify data in staging areas, build cubes, rollups, & materialized views/tables
How to analyze data in warehouses for interactive reports and create dashboards using BI tools such as Cognos Analytics and Google Looker

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Specialization - 5 course series

The job market for business intelligence (BI) analysts is expected to grow by23 percent from 2021 to 2031 (US Bureau of Labor Statistics). This IBM specialization gives you sought-after skills employers look for when recruiting for a BI analyst.

BI analysts gather, clean, and analyze key business data to find patterns and insights that aid business decision-making.

During this specialization, you’ll learn the basics of SQL, focusing on how to query relational databases using this popular and powerful language. You’ll use essential Linux commands to create basic shell scripts. Plus, you’ll learn how to build and automate ETL, ELT, and data pipelines using BASH scripts, Apache Airflow, and Apache Kafka.

You’ll discover why companies use data lakes and data marts, and work with adata warehouse. Plus, you’ll dive into the rewarding aspect of BI, creating interactive reports and dashboards so you can derive insights from data in your warehouse.

Additionally, you’ll gain valuable hands-on practice employing real-world tools used by data professionals. Each course has numerous hands-on labs and includes a project, which gives you plenty to talk about in interviews.

When you complete the full program, you’ll have a shareableportfolio of projects and a Specialization certificate for your resume and LinkedIn profile.

Get started on an in-demand business intelligence role. Enroll today.

Applied Learning Project

Using hands-on labs and course projects hosted in cloud-based environments, you’ll gain job-ready experience with the following real-world tools and tasks:

Writing SQL queries and creating joins using PostgreSQL, MySQL, and DB2 databases
Running Linux commands and pipes, creating shell scripts
Scheduling jobs using cron, building ETL and data pipelines, creating & monitoring Airflow DAGs, working with streaming data using Kafka
Designing data warehouses using star and snowflake schemas
Verifying data quality, loading staging, and production warehouses
Developing cubes, rollups, and materialized views/tables
Creating interactive reports and dashboards
Analyzing warehouse data using BI tools such as Cognos Analytics

Hands-on Introduction to Linux Commands and Shell Scripting

Course 114 hours

What you'll learn

Describe the Linux architecture and common Linux distributions and update and install software on a Linux system.
Perform common informational, file, content, navigational, compression, and networking commands in Bash shell.
Develop shell scripts using Linux commands, environment variables, pipes, and filters.
Schedule cron jobs in Linux with crontab and explain the cron syntax.

Skills you'll gain

Category: Linux Commands

Category: Shell Script

Category: File Management

Category: Linux

Category: File Systems

Category: Unix

Category: Automation

Category: Scripting

Category: Unix Commands

Category: OS Process Management

Category: Command-Line Interface

Category: Bash (Scripting Language)

Category: Network Protocols

Category: Linux Administration

Databases and SQL for Data Science with Python

Course 218 hours

What you'll learn

Analyze data within a database using SQL and Python.
Create a relational database and work with multiple tables using DDL commands.
Construct basic to intermediate level SQL queries using DML commands.
Compose more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins.

Skills you'll gain

Category: SQL

Category: Pandas (Python Package)

Category: Data Manipulation

Category: Relational Databases

Category: Data Analysis

Category: Databases

Category: Python Programming

Category: Stored Procedure

Category: Database Management

Category: Transaction Processing

Category: Database Design

ETL and Data Pipelines with Shell, Airflow and Kafka

Course 317 hours

What you'll learn

Describe and contrast Extract, Transform, Load (ETL) processes and Extract, Load, Transform (ELT) processes.
Explain batch vs concurrent modes of execution.
Implement ETL workflow through bash and Python functions.
Describe data pipeline components, processes, tools, and technologies.

Skills you'll gain

Category: Extract, Transform, Load

Category: Data Pipelines

Category: Apache Airflow

Category: Apache Kafka

Category: Shell Script

Category: Scalability

Category: Data Processing

Category: Data Integration

Category: Web Scraping

Category: Data Transformation

Category: Big Data

Category: Performance Tuning

Category: Real Time Data

Category: Data Manipulation

Data Warehouse Fundamentals

Course 415 hours

What you'll learn

Job-ready data warehousing skills in just 6 weeks, supported by practical experience and an IBM credential.
Design and populate a data warehouse, and model and query data using CUBE, ROLLUP, and materialized views.
Identify popular data analytics and business intelligence tools and vendors and create data visualizations using IBM Cognos Analytics.
How to design and load data into a data warehouse, write aggregation queries, create materialized query tables, and create an analytics dashboard.

Skills you'll gain

Category: Data Warehousing

Category: Star Schema

Category: Data Mart

Category: Data Lakes

Category: Snowflake Schema

Category: IBM DB2

Category: Database Architecture and Administration

Category: Data Quality

Category: Data Integration

Category: Data Storage

Category: Query Languages

Category: Data Modeling

Category: Data Storage Technologies

Category: SQL

Category: Database Design

Category: Data Architecture

BI Dashboards with IBM Cognos Analytics and Google Looker

Course 511 hours

What you'll learn

Explore the purpose of analytics and Business Intelligence (BI) tools
Discover the capabilities of IBM Cognos Analytics and Google Looker Studio
Showcase your proficiency in analyzing DB2 data with IBM Cognos Analytics
Create and share interactive dashboards using IBM Cognos Analytics and Google Looker Studio

Skills you'll gain

Category: Looker (Software)

Category: Interactive Data Visualization

Category: IBM Cognos Analytics

Category: Data Visualization Software

Category: Dashboard

Category: Data Visualization

Category: Data Presentation

Category: Business Analytics

Category: Business Intelligence

Category: Analytics

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructors

IBM Skills Network Team

IBM

82 Courses1,405,573 learners

Shubhra Das

7 Courses37,996 learners

Offered by

IBM

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

The specialization is self-paced and requires 36-48 hours of effort to complete. Learners taking the course part-time e.g. 3-4 hours per week can complete in 3-4 months. Learners taking the courses full-time can complete considerably faster.

Basic computer literacy, some data literacy, and a passion to self-learn online are the only pre-requisites. No prior database or data warehouse skills required although some learners may benefit from a little programming experience.

It is highly recommended the courses be taken in the order they are listed as later courses build on concepts taught in previous ones.

Upon completing this specialization you will be able to:

List and execute commonly used Linux/Unix commands
Create pipes, shell scripts and schedule cron jobs
Query relational databases using SQL and perform CRUD operations
Filter, ORDER, aggregate and JOIN data in tables
Automate ETL and ELT tasks using BASH scripts
Build batch and streaming data pipelines with Apache Airflow and Kafka
Differentiate between Data Lakes, Data Marts and Enterprise Data Warehouses (EDW)
Design Data Warehouses, load staging areas, verify data quality
Create cubes, rollups and summary/materialized views/MQTs
Analyze warehouse data using reports and interactive dashboards
Work hands-on with real tools including Linux, Db2, MySQL, PostgreSQL, Airflow, Kafka, Cognos Analytics

Yes! To get started, click the course card that interests you and enroll. You can enroll and complete the course to earn a shareable certificate, or you can audit it to view the course materials for free. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. Visit your learner dashboard to track your progress.