-
Project objective:
1. Create a Sales Dashboard
2. Conduct a comprehensive comparison between SteelCo and Global Steel Market
-
Purpose of sales analytics: To empower businesses to monitor and evaluate their sales activities and performance.
-
Importance of analyzing sales data: Identify sales patterns, track key performance indicators (KPIs), key contributor to revenue, etc.
-
Role of this report: Determine effective customer segments, and company position compared to the global trend, identify potential business expansion opportunities in promising countries, and plan steps according to the current and future trend.
- Proficiency in ETL methodology (Extract, Transform, Load).
- Create KPIs using the Pivot Table.
- Generate easy-to-understand Excel Dashboard.
- Incorporate Hyperlinks and Filters to make the dashboard interactive.
- Comparison of findings from my research of the Global Steel Market with the internal data analysis of SteelCo Ltd.
- Present the insights from both sources in a PowerPoint presentation along with key recommendations.
- Refined understanding of Sales & Revenue.
- Designing user-centric reports with empathy in mind.
- Optimization of report generation through meticulous fine-tuning.
- Developing a systematic approach to devising a report-building plan.