IBM
BI Foundations with SQL, ETL and Data Warehousing Specialization
IBM

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.

IBM Skills Network Team
Shubhra Das
Rav Ahuja

Instructors: IBM Skills Network Team

Access provided by New York State Department of Labor

10,554 already enrolled

Get in-depth knowledge of a subject
4.6

(368 reviews)

Beginner level
No prior experience required
2 months
at 10 hours a week
Flexible schedule
Learn at your own pace
Get in-depth knowledge of a subject
4.6

(368 reviews)

Beginner level
No prior experience required
2 months
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

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English

Advance your subject-matter expertise

  • Learn in-demand skills from university and industry experts
  • Master a subject or tool with hands-on projects
  • Develop a deep understanding of key concepts
  • Earn a career certificate from IBM
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

Specialization - 5 course series

Hands-on Introduction to Linux Commands and Shell Scripting

Course 114 hours4.6 (1,505 ratings)

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: File Management
Category: Shell Script
Category: Linux
Category: Unix Commands
Category: Bash (Scripting Language)
Category: Unix
Category: Automation
Category: OS Process Management
Category: Linux Servers
Category: Network Protocols
Category: Operating Systems
Category: Unix Shell
Category: Scripting Languages
Category: Command-Line Interface
Category: Linux Administration

Databases and SQL for Data Science with Python

Course 220 hours4.7 (21,283 ratings)

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: Transaction Processing
Category: Pandas (Python Package)
Category: Query Languages
Category: Stored Procedure
Category: Databases
Category: Data Analysis
Category: Data Manipulation
Category: Relational Databases
Category: Jupyter
Category: Database Management
Category: Database Design

ETL and Data Pipelines with Shell, Airflow and Kafka

Course 317 hours4.5 (392 ratings)

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: Data Pipelines
Category: Extract, Transform, Load
Category: Apache Airflow
Category: Apache Kafka
Category: Scalability
Category: Performance Tuning
Category: Databases
Category: Data Migration
Category: Data Transformation
Category: Data Integration
Category: Data Mart
Category: Shell Script
Category: Big Data
Category: Real Time Data
Category: Data Warehousing
Category: Web Scraping

Data Warehouse Fundamentals

Course 415 hours4.4 (217 ratings)

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: Data Mart
Category: Snowflake Schema
Category: Star Schema
Category: Data Lakes
Category: Data Architecture
Category: Data Integration
Category: IBM DB2
Category: Data Cleansing
Category: Query Languages
Category: Database Design
Category: Extract, Transform, Load
Category: PostgreSQL
Category: Data Validation
Category: SQL
Category: Data Quality
Category: Data Modeling

BI Dashboards with IBM Cognos Analytics and Google Looker

Course 511 hours4.8 (25 ratings)

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: IBM Cognos Analytics
Category: Data Visualization
Category: Interactive Data Visualization
Category: Dashboard
Category: Business Intelligence
Category: Analytics
Category: Data Presentation
Category: Data Visualization Software
Category: Business Intelligence Software
Category: Data Analysis

Instructors

IBM Skills Network Team
IBM
64 Courses1,178,410 learners
Shubhra Das
6 Courses17,902 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."
Placeholder

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

Advance your career with an online degree

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

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

Upskill your employees to excel in the digital economy