Microsoft Excel
Data analytics Training, Nikhil Analytics, Bangalore, India, Predictive Analytics using Python. Advance Excel Techniques & Data Management. SQL For Analyst. Tableau For Analyst. Data analytics using Python from University of Pennsylvania IBM
Windows
SQL Server
Excel,MS Word and Tableau
Project 1 - Diwali Sales Analysis . python
Objective: Enhance customer experience and boost revenue through insightful sales data analysis.
Process:
1. Utilized Python with Pandas to extract and analyze sales data.
2. Checked for data integrity by inspecting empty rows and assessed data distribution with the described function.
3. Dealt with NULL values, dropping columns exceeding 40% missing data, and filling the rest with column medians.
4. Conducted exploratory data analysis on various columns, employing Seaborn and Matplotlib for visual representation.
5. Summarized key findings for clear insights
Project 2 - Virinda Store Annual Sales Report (Excel):
Objective: Create a comprehensive 2022 annual sales report for Virinda Store to inform strategies for increased sales in 2023.
Process:
1. Cleaned, filtered, and sorted data for clarity.
2. Utilized Excel functions including VLOOKUP and IF to enhance data insights.
3. Added necessary columns for a more comprehensive report.
4. Crafted visually appealing dashboards with charts, slicers, and timelines.
5. Ensured data accuracy and eliminated duplicates for a reliable report.
Ongoing Work:
Nikhil Data analytics
IBM excel course
Upgrad excel certificate
Nikhil Data analytics