𝗣𝗿𝗼𝗯𝗹𝗲𝗺: To Uncover crucial insights and develop key performance metrics, peak seasons, top-performing segments, markets, and categories.
𝗧𝗼𝗼𝗹𝘀 𝗮𝗻𝗱 𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵:
🔍 Data Transformation and Visualization with Power BI:
1️⃣ ETL (Extract, Transform, Load): Connecting to data sources, performing data cleansing, and transformation using Power Query.
2️⃣ Data Modeling: Creating a robust data model.
3️⃣ Key Metric Generation: Utilizing DAX to generate essential metrics.
4️⃣ Compelling Visualizations: Developing insightful visual representations.
𝗞𝗲𝘆 𝗙𝗶𝗻𝗱𝗶𝗻𝗴𝘀: 📈 I successfully developed and presented a range of significant metrics, including total orders, sales, profit, average delivery days, and monthly sales and profit year-over-year (YOY).
📊 By harnessing data from the past two years, I created a 15-day forecast, offering valuable insights to steer future decisions and strategies.