Python
Abhijay Singh Chauhan
Good judgment comes from experience. Experience comes from bad judgment.
Jim Horning
Summary
Detail-oriented Junior Data Analyst with 2+ years of experience in transforming complex datasets into actionable insights. Proficient in advanced Excel techniques, Power BI, SQL, and Python, with a proven track record of streamlining data processes and enhancing decision-making efficiency. Currently pursuing an MBA in Information Technology and System Management. Adept at data visualization and cross-functional collaboration to deliver tailored analytical solutions.
Overview
2
2
years of professional experience
3
3
Certification
Work History
Junior Data Analyst
Precise Calibrations
07.2022 - Current
- Data Analysis and Reporting : Collected, cleaned, and analyzed large datasets using advanced Excel techniques. Developed and maintained data reports and dashboards to support business decision-making.
- Data Visualization : Created insightful data visualizations to illustrate trends and patterns, enabling better understanding and communication of complex data to stakeholders.
- Cross-Functional Collaboration : Worked closely with various departments to gather data requirements and deliver tailored analytical solutions. Improved data accuracy and consistency across the organization.
- Continuous Learning : Actively pursued professional development by upgrading skills and knowledge, including completing an MBA in Information Technology and System Management.
Key Achievements :
- Successfully streamlined data collection and reporting processes, reducing report preparation time by 30%.
- Identified key performance indicators (KPIs) that improved decision-making efficiency across departments.
Education
MBA - Information Technology and System Management
06.2022
B.Com - Banking and Insurance
01.2022
Skills
- SQL
- Python
- Oracle Cloud Infrastructure
- Scikit-learn
- Storytelling and presentation
- Data Analysis
- Power Bi
- Data Visualization
- Excel proficiency
- MS Excel
- Management
Certification
- Oracle Project Management Foundation Associate
- EY Business Intelligence Using Power BI
- CISCO Data Analytics Essentials
- Google Advanced Data Analytics Specialization
- Microsoft Deploy and Maintain Power Bi Assets and Project
Accomplishments
- EY Business Intelligence Using Power BI - 2024
- Google Advanced Data Analytics Specialization - 2024
- Microsoft Deploy and Maintain Power BI Assets and Project - 2023
- Accenture Data Analytics and Visualization Job Simulation on Forage - 2023
- NISM's CSR Program of Kotak Securities Limited by SEBI- 2021
- TCS iON Career Edge - Young Professional - 2021
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Software
MS Office 365
Power Bi
Alteryx
MySQL
Tableau
Projects
Maximizing Revenue: The Sales Performance
Overview: In this project, I analyzed the relationship between advertising expenditure and sales performance for a major e-commerce company specializing in fashion apparel. The goal was to determine how effectively ad spend drives sales and to identify the optimal allocation of marketing resources.
Objectives:
- Measure the correlation between ad spend and sales revenue.
- Identify the top-performing products and categories across different marketplaces.
- Provide actionable insights to optimize marketing strategies and boost sales performance.
Key Findings:
- A strong positive correlation of 0.79 was identified between ad spend and sales, indicating that increased advertising expenditure significantly boosts sales revenue.
- A detailed analysis of year-wise sales growth, top-performing products, and average delivery times provided valuable insights for strategic decision-making.
- Scatter Plot with Trend Line: Shows the correlation between ad spend and sales.
- Top Products Analysis: Visuals showing top 10 products by sales for each marketplace.
- Sales Growth Charts: Year-wise growth percentage for different marketplaces.
- Distribution of Sales: Sales distribution across different product categories and marketplaces.
Data Collection: Collected data from various e-commerce marketplaces, including Myntra, Amazon, Ajio, Flipkart, and Snapdeal, covering sales revenue, ad spend, and delivery times.
Data Analysis: Used Power BI to perform data cleaning, transformation, and visualization. Calculated correlation coefficients and conducted detailed analysis of sales trends, top products, and category performance.
Tools Used:
- Power BI for data visualization and analysis.
- DAX for advanced calculations and measures.
Conclusion: This project demonstrates the significant impact of strategic advertising on sales performance. By leveraging data-driven insights, businesses can optimize their marketing spend to maximize sales and improve overall revenue. The strong positive correlation between ad spend and sales highlights the importance of investing in effective advertising campaigns.
View Full Report: https://drive.google.com/drive/folders/1EA7R2PVSdGhOnlKkx2CTzIobOKNy20XR?usp=sharing
Interests
Photography
FPS Gaming
Reading Books
MMA
Work Preference
Work Type
Full TimeWork Location
On-SiteRemoteHybridImportant To Me
Work-life balanceCareer advancementWork from home optionCompany CultureTimeline
Junior Data Analyst - Precise Calibrations
07.2022 - Current
SVKM's NMIMS - MBA, Information Technology and System Management
IPER UG - B.Com, Banking and Insurance
- Oracle Project Management Foundation Associate
- EY Business Intelligence Using Power BI
- CISCO Data Analytics Essentials
- Google Advanced Data Analytics Specialization
- Microsoft Deploy and Maintain Power Bi Assets and Project
Similar Profiles
Travis HolmanTravis Holman
Scale Technician at GC Weighing & CalibrationsScale Technician at GC Weighing & Calibrations
Touqeer DarTouqeer Dar
Electrical Instrumentation Engineer at HK Calibrations PTY LTDElectrical Instrumentation Engineer at HK Calibrations PTY LTD
Tyler AndryTyler Andry
Calibration and Repair Technician at Coastal Calibrations & RepairsCalibration and Repair Technician at Coastal Calibrations & Repairs