Diploma in Business Intelligence and Data Analyst Batch-4

Responsible	Chaw Hsu Htet
Last Update	01/23/2025
Completion Time	1 day 8 hours 50 minutes
Members	84

Introduction
- Instructions and Disclaimer
- Timetable
Teaching Materials
- Teaching Materials : Instructor Min Han Tun, CFA
- Teaching Materials : Instructor Min Han Tun, Day 1
- Teaching Materials : Instructor Cho Cho Wai
- Teaching Materials : Instructor Wai Lin Tun
Assignment Session
- Assignment for Min Han Tun, CFA
- Assignment For Instructor Wai Lin Tun
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
- Data Visualization
- Data Visualization
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: 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
Functions - vlookup, index, match, sumif, sumifs
- Left & Right
- Index Match
- Vlookup
- Index+Vlookup+Format
- Sumif+Sumifs+Condition
- Large + small + index + condition
Zoom Video Record
- 20241103 Professional Diploma In Data Analyst Batch- 4 , Instructor U Wai Lin Htun
- 20241106 Professional Diploma In Data Analyst Batch- 4, Instructor Dr. Cho Cho Wai
- 20241110 Professional Diploma In Data Analyst Batch- 4 , Instructor U Min Han Tun,CFA
- 20241113 Professional Diploma In Data Analyst Batch- 4, Instructor Dr. Cho Cho Wai
- 20241117 Professional Diploma In Data Analyst Batch- 4 , Instructor U Min Han Tun, CFA
- 20241120 Professional Diploma In Data Analyst Batch- 4, Instructor Dr. Cho Cho Wai
- 20241127 Professional Diploma In Data Analyst Batch- 4, Instructor Dr. Cho Cho Wai
- 20241201 Professional Diploma In Data Analyst Batch- 4 , Instructor U Min Han Tun, CFA
- 20241208 Professional Diploma In Data Analyst Batch- 4 , Instructor U Min Han Tun, CFA
- 20241211 Professional Diploma In Data Analyst Batch- 4, Instructor U Wai Lin Htun
- 20241215 Professional Diploma In Data Analyst Batch- 4 , Instructor U Wai Lin Htun
- 20241218 Professional Diploma In Data Analyst Batch- 4, Instructor U Wai Lin Htun
- 20241222 Professional Diploma In Data Analyst Batch- 4 , Instructor U Wai Lin Htun
- 20241229 Professional Diploma In Data Analyst Batch- 4 , Instructor U Wai Lin Htun
- 20250105 Professional Diploma In Data Analyst Batch- 4 , Instructor U Wai Lin Htun
- 20250108 Professional Diploma In Data Analyst Batch- 4, Instructor U Wai Lin Htun
- 20250112 Professional Diploma In Data Analyst Batch- 4 , Instructor U Wai Lin Htun
- 20250115 Professional Diploma In Data Analyst Batch- 4, Instructor U Wai Lin Htun
- 20250119 Professional Diploma In Data Analyst Batch- 4 , Instructor U Wai Lin Htun
  
  New
- 20250122 Professional Diploma In Data Analyst Batch- 4, Instructor U Wai Lin Htun
  
  New