Usage of Excel & Business Requirement in Atliq

Atliq Hardware is a company moving towards advanced analytics, but Excel still has a stronghold in data-informed decision making

Task :

• Sales Analytics : Create customer performance report
• Salws Analytics : Create market performance report
• Finance Analytics : P & L by year report
• Finance Analytics : P & L by month report

Data Modeling : Daigram View

Customer performance report

Market performance vs Target

P & L Year

P & L Month

Skills Learnt :

• Cleaning data in Power Query
• ETL (Extract, Transform, & Load)
• Data modeling in Power Pivot
• Advanced data analysis techniques using pivot tables and functions like VLOOKUP, INDEXMATCH, XLOOKUP, SUMIF, and COUNTIF
• Statistic concepts (Variance, Standard Deviation, Correlation)
• User empathetic report design
• Creating reports using Pivot tables