Overview
Work History
Education
Skills
Summary
Work Preference
Certification
Interests
Timeline
Generic

DIVYA NAITHANI

Data Analyst
New Delhi

Overview

1
1
year of professional experience
2
2
Languages

Work History

Personal Project

10.2023
  • DNA Challenge Project November 2023
  • Analyzed 1000 YouTube channels for strategic growth insights using Power BI
  • Utilized Excel for initial data cleaning and transformation, creating calculated columns for key metrics
  • Imported the refined data into Power BI for comprehensive modeling, establishing relationships, and designing interactive visualizations
  • Employed DAX for advanced calculations, offering insights into subscriber count, views, and engagement rates
  • PIZZA SALES ANALYSIS
  • Sliced through data to boost pizza sales with strategic insights using SQL, Excel, and Power BI
  • Identified key trends and customer preferences, optimizing pricing strategies
  • Contributed to increased operational efficiency and revenue growth
  • Presented actionable insights to cross-functional teams
  • SENTIMENT ANALYSIS ON TWEETS – Personal Project October 2023
  • Conducted sentiment analysis on 14,000 tweets regarding six major airlines using Power BI and SQL/Excel
  • Employed Power BI for data visualization and SQL/Excel for data cleaning, text analysis, and identifying major complaints
  • E COMMERCE SALES ANALYSIS – Virtual Project September 2023
  • Utilized SQL to extract data from 10 different related tables from customer sales databases using JOIN and VIEW
  • Designed a comprehensive Power BI dashboard to interpret and visualize sales trends, providing actionable insights
  • Utilized MS Excel for data manipulation and calculation of DAX measures, contributing to a strategic increase in potential revenue.

DATA ANALYST INTERN

10.2023 - 11.2023
  • Collaborated on 2 Power BI projects for Sales Data Analysis
  • Applied SQL to predict diabetes based on diagnostic measurements.

INTERN

POWER BI
09.2023 - 10.2023
  • Collaborated on 3 Power BI projects related to Call Centre Trends, Customer Retention and Diversity Inclusion
  • Gained practical experience in these areas.

DATA ANALYST INTERN

AI Variant
05.2023 - 08.2023
  • Collaborated with cross-functional teams to identify 5 key business metrics
  • Developed actionable insights for informed decision-making using Power BI and Tableau
  • Maintained databases for streamlined data analysis using MS Excel and SQL.

Education

BACHELOR OF TECHNOLOGY - Civil Engineering

Graphic Era University
August 2016

Skills

  • SQL (SQL Server, MySQL)
  • Tableau
  • MS Excel
  • Microsoft Power BI
  • Python
  • Project

Summary

To seek and maintain full-time position as a Data Analyst that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Work Preference

Work Type

Full Time

Location Preference

On-SiteHybrid

Important To Me

Career advancementWork-life balanceCompany CultureTeam Building / Company Retreats

Certification

  • Certified Data Analyst, ExcelR Soln- Feb 2023 to June 2023
  • Power BI- Data Analytics Essentials with Power BI
  • Introduction to MS Excel- Simplilearn -Issued Feb 2023

Interests

Data Analyst

Business Analyst

Power BI Intern

Timeline

Personal Project

10.2023

DATA ANALYST INTERN

10.2023 - 11.2023

INTERN

POWER BI
09.2023 - 10.2023

DATA ANALYST INTERN

AI Variant
05.2023 - 08.2023

BACHELOR OF TECHNOLOGY - Civil Engineering

Graphic Era University
DIVYA NAITHANIData Analyst