L6: Probability distributions | fitting data with theory & simulation

Welcome to Lecture 6 of the course "Business Analytics" by Prof. Rahul R Marathe Full Course: https://study.iitm.ac.in/ds/course_pages/BSMS2002.html Video Overview Learn how to build a simple yet effective dashboard in Excel using call center data. This tutorial walks you through the end-to-end process—from data cleaning and preprocessing to visualizing call volumes, agent allocation, and service level analysis. You will explore monthly and hourly trends, calculate service level metrics, and perform sensitivity analysis to optimize staffing strategies. Whether you're a beginner in data analysis or looking to build functional dashboards for operations, this session will help you turn raw data into actionable insights. About IIT Madras' online Bachelor of Science programme IIT Madras offers four-year BS programmes that aim to provide quality education to all, irrespective of age, educational background, or location. The BS programme has multiple levels, which provide flexibility to students to exit at any of these levels. Depending on the courses completed and credits earned, the learner can receive a Foundation Certificate from IITM CODE (Centre for Outreach and Digital Education), Diploma(s) from IIT Madras, or BSc/BS Degrees from IIT Madras. For more details, Visit: https://www.iitm.ac.in/academics/study-at-iitm/non-campus-bs-programmes #Excel #ExcelDashboard #DataAnalysis #DashboardDesign #CallCenter #DataVisualization #AgentAllocation #ServiceLevel #ExcelTutorial #SensitivityAnalysis #DataPreprocessing #ExcelForBeginners #OperationsAnalytics #StaffingOptimization #ExcelCharts #CustomerSupportAnalytics #ShiftPlanning #ContactCenter #DashboardDevelopment #BusinessIntelligence #ExcelTraining #ServiceMetrics #KPIVisualization #CallVolumeAnalysis #DataDrivenDecisions #ProcessImprovement