Excel Data Analytics & Dashboard Reporting: Pivot Tables, Charts & Slicers Guide
Data Analytics-e Excel-er Bhumika
Data Analytics shobder orthoi holo bishal poriman obinnyosto data theke proyojoniyo insights ber kore ana. Ekta business-e kon product shobcheye beshi bikri hochhe, kon shohore (Ramnagar, Contai, Tamluk, Haldia) growth beshi, ebong kon mashe revenue barche — egulo sohojei Excel Dashboard diye bojha jay.
1. Pivot Table Toiri Korar Shohoj 4-Step Process
Pivot Table holo Excel-er shobcheye shoktishali tool jar sahajye hazaro row data-ke matro koyek sekende summary table-e rupantor kora jay:
- Data range select korun ebong Ribbon-er Insert -> PivotTable e click korun.
- PivotTable Fields pane-e 4-ti box paben:
- Rows: Je Category ba Name onujayi group korben (e.g. Salesperson, Course Name, City).
- Columns: Uporer header breakdown (e.g. Quarter, Year, Payment Mode).
- Values: Numeric calculation (e.g. Sum of Revenue, Count of Students).
- Filters: Overall page filtering.
- Right-Click -> Group: Date column-ke automaticaly Months, Quarters, ebong Years-e group korun.
- Value Field Settings: Sum charao Percentage of Total, Running Total, ba Average hisheb korun.
2. Interactive Slicers & Timelines
Static table-er poriborte interactive filter toiri korte Slicers bebohar hoy:
- PivotTable Tools theke Insert Slicer select korun (e.g. Course, Location, Batch).
- Insert Timeline diye date range (2024, 2025, Jan, Feb) slider akare filter korun.
- Slicer Report Connections: Ekta single slicer diye ekadhik Pivot Table ebong Chart-ke ek sathe control korun!
3. Dynamic KPI Cards & Visual Charts
Ekta modern executive dashboard-e shadharonoto 3-ti angsho thake:
- Top KPI Cards: Total Revenue, Active Students, Average Passing Rate, Monthly Growth % — boro bold font ebong indicator color diye show kora hoy.
- Visual Comparison Charts:
- Monthly trend dekhate Line with Markers chart.
- Category share dekhate Donut Chart with data labels.
- Branch performance compare korte Horizontal Bar Chart.
- Conditional Formatting: Data Bars, Color Scales (Green to Red heatmap), ebong Icon Sets (Up/Down arrows) diye instant trend visualize kora.
4. Career Scope in Data Analytics & MIS Reporting
Purba Medinipur ebong Kolkata-r IT & corporate firm-e MIS Executive, Data Analyst, ebong Reporting Specialist hishebe prachur chakrir sujog royeche. Starting salary ₹18,000 theke ₹35,000+ hoye thake.
🚀 Shikhun Data Analytics with Satyajit Giri at Pragati Skill Academy
Amader specialized Advanced Excel & Data Analytics module-e Real-world Sales Data, Hospital Patient Data, ebong Financial Statements niye live dashboard project kora hoy. Call korun 8016363962 e.
Official Course Study Notes & Practice Materials
Pragati Skill Academy provides complete chapter-by-chapter curriculum notes, 195+ solved MCQs, formula cheat sheets, and practical lab assignments with recognized government certifications.