Excel for Data Career: Analyze Faster, Decide Smarter

Lihat Detail

Deskripsi

Our Mentor

Industry practitioners from leading companies:

  • Huawei — Data Analytics
  • Telkom Indonesia — Business Intelligence
  • BAPPENAS — Data Analytics
  • LinkAja — Senior Product Data Analytics
  • Bukalapak — Data Analytics

Kurikulum

Modul 1 Overview of Data Analysis, Career, and Salary

  • Overview of Data Analyst Career and Salary Part 1
  • Overview of Data Analyst Career and Salary Part 2
  • Overview of Data Analyst Career and Salary Part 3
  • QnA

Modul 2 Boost Your Skills with Advanced Excel

  • Overview
  • Finding Insight: Sort & Filter (Part 1–2)
  • Join Functions: VLOOKUP, XLOOKUP, INDEX MATCH, Pivot Table (Part 1–2)
  • Statistics for Data Analyst & Conditional Formatting

Modul 3 Advanced Excel Skills for Data Analysts

  • Overview
  • Data Cleaning in Excel
  • Data Validation
  • Dashboard with Excel

Modul 4 Exploring the World of Statistics & Insight Analysis

  • Overview
  • Introduction to Statistics (Part 1–2)
  • Descriptive vs Inferential Statistics
  • Hypothesis Testing
  • Statistical Tests
  • Latihan Soal
  • QnA

Modul 5 Ultimate Data-Driven Decisions

  • Overview
  • Understanding A/B Testing (Part 1–2)
  • Mastering Correlation
  • Regression Analysis for Predictive Modeling (Part 1–2)

Modul 6 Understanding Business Challenges (Part 1)

  • OverviewIntroduction to Business Problems
  • Business Frameworks
  • Prioritizing Action to Improve Productivity
  • Developing Hypotheses and Proving Them
  • Identifying Root Causes
  • QnA

Modul 7 Understanding Business Challenges (Part 2)

  • Overview
  • How Business Problems Relate to Analytics
  • Business Goals & Metrics
  • Determining a Good Metric (Part 1–2)
  • Dashboard & Performance Monitoring
  • Funnel Analysis 

Lihat Detail

Loading...