Description
BI Foundations with SQL, ETL and Data Warehousing Specialization is published by Coursera Academy. The job market for business intelligence (BI) analysts is projected to grow by 23% from 2021 to 2031 (US Bureau of Labor Statistics). This IBM specialization will provide you with the skills employers are looking for when hiring a BI analyst. BI analysts collect, cleanse, and analyze key business data to find patterns and insights that help inform business decisions. During this specialization, you will learn the basics of SQL and focus on how to query relational databases using this popular and powerful language.
You will use essential Linux commands to create basic shell scripts. In addition, you will learn how to build and automate ETL, ELT, and data pipeline jobs using BASH, Apache Airflow, and Apache Kafka scripts. You will discover why companies use data lakes and marts, and you will work with a data warehouse. In addition, you will delve into the rewarding side of BI, creating interactive reports and dashboards so you can gain insights from your data in the data warehouse. In addition, you will gain valuable hands-on practice using real tools used by data professionals. Each course has plenty of hands-on labs and includes a project that will give you plenty to talk about in interviews. When you finish the full program, you will have a collection of shareable projects and a certificate of expertise for your resume and LinkedIn profile.
What you will learn
- In-demand business intelligence skills that will help you land your first job in BI
- How to routinely use SQL to work with RDBMS and automate ETL tasks and data pipelines using BASH scripts, Apache Airflow, and Kafka
- How to design data warehouses using STAR and snowflake schemas, load/validate data into staging areas, build cubes, rollups, and materialized views/tables
Who is this course suitable for?
BI Foundations with SQL, ETL and Data Warehousing Specialization Course Details
- Publisher: Coursera
- Instructor: IBM Skills Network Team
- Language: English
- Education level: Elementary
- Number of lessons: 5
- Training duration: 2 months, including 10 hours of work per week
BI Foundations with SQL, ETL and Data Warehousing Specialization Course Topics
Course prerequisites
- No prior experience required
Pictures
Sample video
Video display
Installation Guide
After Extract, view with your favorite player.
Subtitles: English
Quality: 720p
Download link
Course 1 – Hands-on Introduction to Linux Commands and Shell Scripting
Course 2 – Databases and SQL for Data Science with Python
Course 3 – ETL and Data Pipelines with Shell, Airflow and Kafka
Course 4 – Data Warehouse Fundamentals
Course 5 – BI Dashboards with IBM Cognos Analytics and Google Looker
File size
852 MB
