The Analyst's Playbook

မြန်မာဘာသာ – အခန်း (၁): Excel ကျွမ်းကျင်မှု – အရောင်းဒေတာပြင်ဆင်ခြင်း

🎯 Purpose: To teach how to prepare and summarize sales data using Excel formulas.

🎯 Purpose: Advanced lookups (XLOOKUP) and region-based analysis using SUMPRODUCT.

🎯 Purpose: Importing from Excel, CSV, and Folders.

🎯 Purpose: Joining datasets and segmentation.

🎯 Purpose: Building the Fact Table for analysis.

🎯 Purpose: Grouping, Pivoting, and Unpivoting.

🎯 Purpose: Building the Data Model and Basic Measures.

🎯 Purpose: SWITCH, SUMX, and Connecting Dimensions.

🎯 Purpose: Multiple Fact Tables (Sales, Budget, Expense).

🎯 Purpose: CALCULATE, YoY, YTD Growth.