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

Included with Coursera Plus

Get in-depth knowledge of a subject

(408 reviews)

Beginner level
No prior experience required
2 months at 10 hours a week
Flexible schedule
Earn a career credential
Share your expertise with employers
Get in-depth knowledge of a subject

(408 reviews)

Beginner level
No prior experience required
2 months at 10 hours a week
Flexible schedule
Earn a career credential
Share your expertise with employers

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

Overview

What’s included

Shareable certificate

Add to your LinkedIn profile

Taught in English
43 practice exercises

Specialization - 5 course series

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, Scripting, Unix Commands, Linux Servers, Scripting Languages, Automation, Operating Systems, Bash (Scripting Language), Command-Line Interface, Network Protocols, Software Installation, and Ubuntu

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), Databases, Data Analysis, Jupyter, Relational Databases, Data Manipulation, Query Languages, Transaction Processing, Python Programming, and Stored Procedure

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

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

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

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

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

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
83 Courses1,558,754 learners
Shubhra Das
7 Courses49,949 learners
Rav Ahuja
IBM
56 Courses4,347,424 learners
Hima Vasudevan
IBM
4 Courses631,736 learners

Offered by

IBM

Compare with similar products

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

You might also like

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."
Coursera Plus

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

Frequently asked questions

¹ Median salary and job opening data are sourced from Lightcast™ Job Postings Report. Content Creator, Machine Learning Engineer and Salesforce Development Representative (1/1/2024 - 12/31/2024) All other job roles (10/1/2024 - 10/1/2025)