Home └Diploma in Business Intelligence and Data Analyst Batch-7
Diploma in Business Intelligence and Data Analyst Batch-7

Diploma in Business Intelligence and Data Analyst Batch-7

Login to Enroll
Responsible Chaw Hsu Htet
Last Update 01/13/2026
Completion Time 2 days 10 hours 37 minutes
Members 79
  • Introduction
    • Instruction and Disclaimer
  • Instructor Wai Lin Tun
    • Raw Data
    • Sales Data
    • Image File
    • Assignment Data
    • U Wai Lin Tun Viber Materials
    • 21 September 2025
    • 23 September 2025
    • 28 September 2025
  • Instructor Dr. Cho Cho Wai
    • PowerPoint Materials
    • Excel Data
  • Instructor Min Han Tun
    • U Min Han Tun, CFA Excel Materials
  • Power Pivot Teaching Materials
    • Power Pivot Workbooks
  • Excel Intro
    • Excel Essential Intro+ Excel interface, sheet, options setup
    • Excel Shortcut Part-1
  • Excel Shortcuts
    • 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 Beat Practices
    • Data Visualization
  • Chart Types
    • Chart Types Part 1
    • Dos and Don't of Charts
    • Excel Formatting Ribbons
    • Chart Types Part 3
    • Chart Types Part 2
  • Case Study 1: Stacked Columns Targets
    • Target Vs Actual Part 1
    • Target Vs Actual Part 2
    • Pareto Part 1
    • Pareto Part 2
    • Dropdown Part 1
    • Dropdown Part 2
  • Case Study 3: Dropdown Boxes and Charts
    • Waterfall
    • Funnel Chart
    • Heat Map
    • Certificatein Accounting Practice
  • Case Study 4: Guge Charts
    • Gauge Chart Part 1
    • Gauge Chart Part 2
    • Gauge Chart Part 3
    • Gauge Chart Part 4
    • Gauge Chart Part 5
  • Case Study 5: Bullent Charts
    • Bullet Chart
  • Formatting
    • Introduction + Formatting Part-1
    • Formatting Part-2
    • Remove Duplicate Function
    • Data Validation
  • Pivot Tables
    • Pivot Table Part-1
    • Pivot Table Part-2
    • Pivot Ribbon
    • Pivot Chart
    • Slicer Timeline
  • Conditional Formatting
    • Conditional Formatting
    • Spark-line
  • 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 Record
    • 20250907 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20250909 Professional Diploma In Data Analyst Batch- 7 , Instructor Tr Cho Cho Wai
    • 20250914 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20250921 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20250923 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 28092025 Professional Diploma In Data Analyst Batch-7, Instructor U Wai Lin Htun
    • 20250930 Professional Diploma In Data Analyst Batch- 7 , Instructor Tr Cho Cho Wai
    • 20251012 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20251014 Professional Diploma In Data Analyst Batch- 7 , Instructor Tr Cho Cho Wai
    • 20251019 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20251021 Professional Diploma In Data Analyst Batch- 7 , Instructor Tr Cho Cho Wai
    • 20251026 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20251028 Professional Diploma In Data Analyst Batch- 7 , Instructor U Min Han Tun
    • 20251109 Professional Diploma In Data Analyst Batch 7 , Instructor: U Wai Lin Htun
    • 20251116 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20251118 Professional Diploma In Data Analyst Batch- 7 , InstructorU Min Han Tun
    • 20251123 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20251125 Professional Diploma In Data Analyst Batch- 7 , InstructorU Min Han Tun
    • 20251130 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20251202 Professional Diploma In Data Analyst Batch- 7 , Instructor U Min Han Tun, CFA
    • 20251207 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20251209 Professional Diploma In Data Analyst Batch- 7 , Instructor U Min Han Tun, CFA
    • 20251214 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20251214 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20251216 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20251221 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20251230 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20260106 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun
    • 20260111 Professional Diploma In Data Analyst Batch- 7 , Instructor U Wai Lin Htun