Will I earn university credit for completing the Specialization?

No university credit is associated with this Specialization at this time.

Is this course really 100% online? Do I need to attend any classes in person?

This course is completely online, so there’s no need to show up to a classroom in person. You can access your lectures, readings and assignments anytime and anywhere via the web or your mobile device.

Can I just enroll in a single course?

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. 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.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Can I take the course for free?

No, you cannot take this course for free. When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. If you cannot afford the fee, you can apply for financial aid.

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

Included with Coursera Plus

Learn more

5 course series

Get in-depth knowledge of a subject

4.6

(408 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

(408 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

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English

43 practice exercises

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

Linux Commands, Shell Script, Linux, File Management, Unix, Unix Commands, Scripting, Automation, Linux Servers, Ubuntu, Bash (Scripting Language), Network Protocols, Operating Systems, Command-Line Interface, Scripting Languages, and Software Installation

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

SQL, Pandas (Python Package), Data Manipulation, Data Analysis, Jupyter, Databases, Relational Databases, Python Programming, Query Languages, Transaction Processing, and Stored Procedure

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

Extract, Transform, Load, Data Pipelines, Apache Airflow, Apache Kafka, Shell Script, Command-Line Interface, Scalability, Unix Shell, Data Warehousing, Data Migration, Data Mart, Data Integration, Web Scraping, Data Processing, Big Data, Performance Tuning, and Data Transformation

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

Data Warehousing, Data Mart, Data Lakes, Snowflake Schema, Star Schema, IBM DB2, Query Languages, Data Integration, Database Systems, Data Quality, SQL, Extract, Transform, Load, Data Architecture, Database Design, PostgreSQL, Data Modeling, Data Validation, and Data Cleansing

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

Data Visualization Software, Looker (Software), IBM Cognos Analytics, Interactive Data Visualization, Dashboard, Data Presentation, Analytics, Business Intelligence Software, Data Visualization, and Business Intelligence

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

84 Courses1,567,886 learners

Shubhra Das

7 Courses50,419 learners

Offered by

IBM

Compare with similar products

	Category: This Certificate

Rating
Level
Skills
Tools
Last updated
Number of practice exercises
Degree eligibility
Part of Coursera Plus

Related skills

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

BI Foundations with SQL, ETL and Data Warehousing Specialization

What you'll learn

Skills you'll gain

Tools you'll learn

Details to know

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

Specialization - 5 course series

Hands-on Introduction to Linux Commands and Shell Scripting

What you'll learn

Skills you'll gain

Databases and SQL for Data Science with Python

What you'll learn

Skills you'll gain

ETL and Data Pipelines with Shell, Airflow and Kafka

What you'll learn

Skills you'll gain

Data Warehouse Fundamentals

What you'll learn

Skills you'll gain

BI Dashboards with IBM Cognos Analytics and Google Looker

What you'll learn

Skills you'll gain

Earn a career certificate

Instructors

Offered by

Compare with similar products

You might also like

Related skills

Why people choose Coursera for their career

Open new doors with Coursera Plus

Advance your career with an online degree

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

Frequently asked questions

More questions

BI Foundations with SQL, ETL and Data Warehousing Specialization

What you'll learn

Skills you'll gain

Tools you'll learn

Details to know

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

Specialization - 5 course series

Hands-on Introduction to Linux Commands and Shell Scripting

What you'll learn

Skills you'll gain

Databases and SQL for Data Science with Python

What you'll learn

Skills you'll gain

ETL and Data Pipelines with Shell, Airflow and Kafka

What you'll learn

Skills you'll gain

Data Warehouse Fundamentals

What you'll learn

Skills you'll gain

BI Dashboards with IBM Cognos Analytics and Google Looker

What you'll learn

Skills you'll gain

Earn a career certificate

Instructors

Offered by

Compare with similar products

You might also like

Related skills

Why people choose Coursera for their career

Open new doors with Coursera Plus

Advance your career with an online degree

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

Frequently asked questions

How long does it take to complete the Specialization?

What background knowledge is necessary?

Do I need to take the courses in a specific order?

More questions