Skip to content

AsthaMishra818/Excel-project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 

Repository files navigation

Excel-project

**Key Insights

Women represent the majority of buyers, contributing approximately 65% of total sales.

The top three states—Maharashtra, Karnataka, and Uttar Pradesh—account for nearly 35% of overall sales.

The adult age group (30–49 years) is the largest contributor, representing around 50% of sales.

Amazon, Flipkart, and Myntra are the leading sales channels, collectively driving about 80% of total sales.

**Role of Reports

Align financial planning with the organization’s strategic objectives.

Strengthen decision-making processes by providing actionable insights.

Build transparency and instill confidence in the organization’s financial outlook among stakeholders.

**Technical & Analytical Skills

Proficiency in ETL methodology (Extract, Transform, Load).

Skilled in Power Query to generate custom Date tables.

Expertise in building and managing data model relationships using Power Pivot.

Ability to integrate supplementary datasets into existing models for enhanced insights.

Proficient in creating calculated columns and measures using DAX.

**Final Conclusion to Improve Astha Store Sales

Astha Store should prioritize women customers aged 30–49 years residing in Maharashtra, Karnataka, and Uttar Pradesh. To maximize sales potential, the business should deploy targeted marketing campaigns, personalized advertisements, exclusive offers, and discount coupons through leading e-commerce platforms—Amazon, Flipkart, and Myntra—as these channels drive the highest contribution to sales.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published