Project information

  • Project Name: Real-Time sales Insights Dashboard
  • Tools: Python, Excel, SQl, Power Bi
  • Techniques Used: Python Pandas, XLOOKUP, Conditional Formatting, Visualization
  • Project URL: : GitHub Link

Project Details

• Leveraged Python Pandas for data cleaning and preparation and create an interactive Power BI Dashboard.
• Implemented advanced Excel formulas (XLOOKUP, Conditional Formatting) to check data quality and empower insightful Power BI visualizations.
• Enhanced sales team decision-making by providing clear visualizations of revenue trends and sales quantity.