Home └Professional Diploma in Business Intelligence and Data Analyst Batch-2
Professional Diploma in Business Intelligence and Data Analyst Batch-2

Professional Diploma in Business Intelligence and Data Analyst Batch-2

Login to Enroll
Responsible Administrator
Last Update 12/23/2025
Completion Time 1 day 18 hours 56 minutes
Members 48
  • Introduction
    • Instruction & Disclaimer
  • Teaching Materials
    • Teaching Materials : Dr. Cho Cho Wai
    • Teaching Materials : Instructor Wai Lin Tun
    • Teaching Materials : Instructor Min Han Tun, CFA
  • Power Pivot Teaching Materials
    • Power Pivot Work Books
  • Excel Intro
    • Excel Essential Intro+ Excel interface, sheet, options setup
  • Excel Shortcuts
    • Excel Shortcut Part-1
    • Excel Shortcut Part-2
    • Group and Shortcut Part-1
    • Group and Shortcut Part-2
    • Text to columns
  • What if Analysis
    • One Variable Data Table
    • Two Variable Data Table
    • Data Table Case with Conditional Formatting
    • Data Table Case
    • Goal Seek Function
  • Data Visualization and Charts Best Practices
    • Data Visualization
    • Dos and Don't of Charts
    • Excel Formatting Ribbons
  • Chart Types
    • Chart Types Part 1
    • Chart Types Part 2
    • Chart Types Part 3
  • Case Study 1: Stacked Columns Targets
    • Target Vs Actual Part 1
    • Target Vs Actual Part 2
  • Case Study 2: Pareto Analysis
    • Pareto Part 1
    • Pareto Part 2
  • Case Study 3: Dropdown Boxes and Charts
    • Dropdown Part 1
    • Dropdown Part 2
    • Waterfall
    • Funnel Chart
    • Heat Map
  • Case Study 4: Gauge Charts
    • Gauge Chart Part 1
    • Gauge Chart Part 2
    • Gauge Chart Part 3
    • Gauge Chart Part 4
    • Gauge Chart Part 5
  • Case Study 5: Bullet Charts
    • Bullet Chart
  • Power Pivot
    • Power Pivot Introduction
    • Power Pivot Setup
    • Building a Regular Pivot Table
    • Building a Basic Data Model Power Pivot
    • Calculating Basic Measures in Power Pivot
    • Power Pivot Analysis for Basic Data Model
    • Power Pivot Case Study Introduction
    • Adding Data to Data Model
    • Creating Relationships in Tables
    • Basic Measures Units, MarginAmt, SumX
    • Date Time Dimesion and Sorting
    • Pivot Slicer and Timeline Connections
    • Adding PDF File to Data Model
    • DAX Daily Sales Propotion of Selected Periods
    • DAX Sales Performance Same Period Last Year
    • DAX Margin Performance Same Period Last Year
    • DAX Contribution to Total Sales
    • DAX Promotion Value to Total Sales
    • DAX SalesDay, YTD Calculation
    • Creating and Editing KPIs in Power Pivot
    • Power Pivot Case Study Summary
  • Zoom Video Records
    • 20240317 Professional Diploma In Data Analyst Batch-2, Instructor U Wai Lin Tun
    • 20240320 Professional Diploma In Data Analyst Batch-2, Instructor U Wai Lin Tun
    • 20240324 Professional Diploma In Data Analyst Batch-2, Instructor U Min Han Tun
    • 20240327 Professional Diploma In Data Analyst Batch-2, Instructor Cho Cho Wai
    • 20240331 Professional Diploma In Data Analyst Batch 2, in Instructor: U Min Han Tun
    • 20240403 Professional Diploma In Data Analyst Batch-2, Instructor Cho Cho Wai
    • 20240407 Professional Diploma In Data Analyst Batch-2, Instructor U Min Han Tun
    • 20240410 Professional Diploma In Data Analyst Batch-2, Instructor U Wai Lin Tun
    • 20240428Professional Diploma In Data Analyst Batch-2, Instructor U Wai
    • 20240501 Professional Diploma In Data Analyst Batch-2, Instructor U Wai Lin Htun
    • 20240505 Professional Diploma In Data Analyst Batch-2, Instructor U Wai Lin Htun
    • 20240508 Professional Diploma In Data Analyst Batch-2, Instructor U Wai Lin Htun
    • 20240512 Professional Diploma In Data Analyst Batch-2, Instructor U Wai Lin Tun
    • 20240515 Professional Diploma In Data Analyst Batch-2, Instructor U Wai Lin Tun
    • 20240519 Professional Diploma In Data Analyst Batch-2, Instructor U Wai Lin Tun
    • 20240522 Professional Diploma In Data Analyst Batch-2, Instructor U Wai Lin Tun
    • 20240526 Professional Diploma In Data Analyst Batch-2, Instructor U Wai Lin Tun
    • 20240529 Professional Diploma In Data Analyst Batch- 2, Instructor U Wai Lin Tun
    • 20240602 Professional Diploma In Data Analyst Batch- 2, Instructor U Wai Lin Tun
    • 20240605 Professional Diploma In Data Analyst Batch- 2, Instructor U Wai Lin Tun
    • 20240609 Professional Diploma In Data Analyst Batch- 2, Instructor U Wai Lin Tun
    • 20240613 Professional Diploma In Data Analyst Batch- 2, Instructor U Wai Lin Tun
    • 20240616 Professional Diploma In Data Analyst Batch- 2, Instructor U Wai Lin Tun
    • 20240623 Professional Diploma In Data Analyst Batch- 2, Instructor U Wai Lin Tun