Diploma in Business Intelligence and Data Analyst Batch-7

Responsible	Chaw Hsu Htet
Last Update	10/29/2025
Completion Time	1 day 8 hours 28 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
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
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
  
  New
- 20251028 Professional Diploma In Data Analyst Batch- 7 , Instructor U Min Han Tun
  
  New