ANUSHA C

Project Name: Sales Data Analysis and Dashboard Creation.

Technology: Python, Power BI, SQL, and Excel.

Description:

Developed a comprehensive analytics solution to track and visualize sales performance across various regions. The project involved automating data extraction, cleaning, transformation, and the creation of interactive dashboards, providing stakeholders with actionable insights into sales trends and performance metrics.

Responsibilities:

• Automated the extraction and cleaning of sales data from multiple sources using Python, ensuring data accuracy and reducing manual effort by 50%.
• Performed data transformation using Python (Pandas and NumPy) to prepare the data for analysis and visualisation.
• Designed and developed interactive dashboards in Power BI to visualize key metrics, such as revenue growth, customer segmentation, and product performance.
• Generated real-time reports and insights to support data-driven decision-making across sales and marketing teams.
• Collaborated with stakeholders to customize dashboards according to business requirements, enhancing the usability and relevance of the data presented.

Project Name: Customer Segmentation and Predictive Analytics
Technology: Python, Power BI, SQL, Excel
Description:
Executed a customer segmentation and predictive analytics project to identify distinct customer groups and forecast customer churn. The project leveraged machine learning techniques and data visualisation tools to provide actionable insights that enhanced customer retention strategies and targeted marketing campaigns.
Responsibilities:

• Collected and preprocessed customer data from various sources using Python, ensuring data integrity and quality.
• Applied clustering algorithms in Python to segment customers based on purchasing behavior, demographics, and other key metrics.
• Developed predictive models using Python's scikit-learn library to forecast customer churn, enabling proactive retention efforts.
• Visualised customer segments and predictive insights using Power BI, providing stakeholders with clear, actionable insights.
• Collaborated with the marketing team to align segmentation and predictive analysis with strategic objectives, enhancing targeted marketing efforts.