BI Foundations with SQL, ETL and Data Warehousing

18.732 students enrolled
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.
CERTIFICATEKatılım Sertifikası
FORMAT100% Online
DURATION2 ay

What you'll learn

  • Linux Commands
  • Shell Script
  • Linux
  • Scripting
  • Unix
  • File Systems
  • Package and Software Management
  • Bash (Scripting Language)
  • Unix Shell
  • Data Importu002FExport
  • File Iu002FO
  • Command-Line Interface

Course Content

5 topics
  1. Kurs 1 Hands-on Introduction to Linux Commands and Shell Scripting
  2. Kurs 2 Databases and SQL for Data Science with Python
  3. Kurs 3 ETL and Data Pipelines with Shell, Airflow and Kafka
  4. Kurs 4 Data Warehouse Fundamentals
  5. Kurs 5 BI Dashboards with IBM Cognos Analytics and Google Looker

Details

  • ProviderIBM
  • TypeCourse
  • CategoryIT & Cloud
  • LevelBeginner
  • Duration2 ay
  • LanguageEnglish

Öğrenenlerimiz ne diyor?

Türkiye'nin yüz akı üniversitelerince hazırlanan; akademik doyuruculuğa sahip eğitim içeriklerinin, etkileşimli videolarla bir araya getirildiği bir üniversiteden eğitim almak istiyorsanız doğru yerdesiniz.
Ramazan Bölükbaşı
Çok yoğun programı olan öğrenciler için büyük bir fırsat. Bir şeylerin gelişmesi değişmesi için çabalamalıyız.
Melis Gülsar
Hızlı desteği ve üst düzey hizmeti ile Campus Online ve Sosyal Medya Sertifika Programı hizmeti sağlayan Adnan Menderes Üniversitesine sonsuz teşekkürlerimi sunuyorum.
Nazif Bayram
$49
CampusOnline Assistant
courses saved

Course Comparison

Institution
Rating
Turkish Subtitles
Level
Duration
Price
Certificate