Project Details

I led the AtliQ Finance and Sales Analysis project, crafting vital financial insights and in-depth sales reports. This endeavor allowed us to gauge our financial health, optimize strategies, and explore new customer segments. Using Excel and Power Query, I transformed data, built a robust data model, and generated reports. Key insights revealed diverse customer profiles, regions, and direct sales channels. The project's outcomes are poised to guide strategic decisions and bolster business strategies.
Skills Gained:- ETL skills (Extract, Transform, Load).
Creating date tables with Power Query.
Handling fiscal months and quarters.
Building data model relationships with Power Pivot.
Adding extra data to existing models.
Using DAX for calculated columns.
Unlocked knowledge about finance and sales reports.
User-centric report design.

Project Details

AtliQ Hardware leads the industry transformation with its dynamic data analytics dashboard, empowering informed decisions. Explore key aspects:

Financial Insights:
GM and net sales robust, but net profit needs improvement.
Focus on cost reduction and sales enhancement for higher profitability.
Granular breakdown for pinpointing financial performance areas.

Sales Insights:
Dive into customer performance, net sales, and GM trends.
Identify customers, customize marketing campaigns, and enhance service.

Marketing Insights:
Explore product metrics like sales, gross margin, and net profit.
Target product segments for improvement, revamp struggling segments

Supply Chain Insights:
Optimize stock management and cost efficiency.
Analyze forecast accuracy, net error, and absolute error.
Identify inefficiencies, implement strategic changes for cost savings.

Executive Insights:
Dashboard benefits top-level officials.
Compare market shares performance against competitor

Live Interactive Dashboard