Skip to content

Siddarameshwaruh/Excel_Project-Sales_Analytics

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

17 Commits
 
 
 
 
 
 

Repository files navigation

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

2023-05-31T13_55_58

Customer performance report

2023-05-31T13_38_32

Market performance vs Target

2023-05-31T13_40_09

P & L Year

2023-05-31T13_41_21

P & L Month

2023-05-31T13_44_05

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

About

The project was a part of the Excel course offered by codebasics.io.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published