Specialization BI Fundamentals with SQL, ETL and Data Warehousing

The job market for business intelligence (BI) analysts is expected to grow 23 percent from 2021 to 2031 (U.S. Bureau of Labor Statistics). This IBM specialization gives you the in-demand skills employers are looking for when hiring a BI analyst. BI analysts collect, clean, and analyze key business data to find patterns and insights that help make business decisions. In this specialization, you'll learn the fundamentals of SQL, focusing on querying relational databases with this popular and powerful language. You'll use core Linux commands to create basic shell scripts . You'll also learn how to create and automate ETL, ELT, and data pipelines using Bash scripts, Apache Airflow, and Apache Kafka . You'll learn why companies use data lakes and data maps, and how to work with a data warehouse . You'll also dive into the useful side of BI by creating interactive reports and dashboards so you can extract value from the data stored in your warehouse. Plus, you'll gain valuable hands-on practice using real tools used by data professionals. Each course is packed with hands-on assignments and includes a project that will give you something to talk about in an interview. Once you complete the full course, you will have a portfolio of projects and a certificate of specialization for your resume and LinkedIn profile . Get started in the in-demand field of business analytics. Enroll today. **Applied learning project** **Using the course's hands-on labs and projects, hosted in cloud environments, you'll gain work-ready experience with the following real-world tools and tasks:** - Writing SQL queries and creating joins using PostgreSQL, MySQL and DB2 databases - Executing Commands and Pipes in Linux, Creating Shell Scripts - Scheduling jobs with cron, building ETL and data pipelines, creating and monitoring Airflow DAGs, working with streaming data using Kafka - Designing Data Warehouses Using Star and Snowflake Schemas - Data quality check, loading of staging and production storages - Developing cubes, rollups and materialized views/tables - Create interactive reports and dashboards - Analyze warehouse data using BI tools such as Cognos Analytics