NAKSHATRA JOSHI
Bengaluru, IN • Joined Jul 2023
About
Results-driven professional specializing in Data Analytics and Sales. Skilled in Excel, Power BI, SQL, Python, R, and Tableau, I analyze complex datasets to uncover trends and transform data into actionable insights. With a background in B2B sales, I excel in driving revenue and improving operational efficiency through data-driven strategies. Certified in Data Analytics and Data Visualization (IBM).
Work experience
2 years 7 months
Ai Variant
3 month
Data Analyst
April 2023 - June 2023
Internship
- Honed skills in data analysis, visualization, and database management - Created dynamic dashboards in Excel and Power BI - Loaded and connected data in SQL - Crafted engaging dashboards in Tableau - Acquired hands-on experience in leveraging data-driven insights for informed business decisions - Uncovered key trends and identified growth opportunities - Developed a deep understanding of the power of data in driving meaningful outcomes - Passionate about transforming complex data into actionable intelligence - Proficient in Microsoft Excel, Microsoft Power BI, MySQL, and Tableau
Skill-Lync
9 month
Senior Sales Executive
April 2022 - December 2022
Full-time
- Optimized customer onboarding for seamless experience - Personalized learning program recommendations - Generated and qualified leads, driving sales growth - Efficiently managed payment and finance processing - Proactive post-sales support and issue resolution
Simplilearn
6 month
Senior Sales Executive
September 2021 - February 2022
Streamlined customer onboarding for seamless experience Personalized program recommendations, boosting enrollment Generated and qualified leads, driving revenue growth Managed end-to-end payment and finance processing Proactive post-sales support, ensuring customer satisfaction
NoBroker.com
7 month
Sales Executive
December 2020 - June 2021
Full-time
- Proven Commercial Property Consultant - Expert in matching products to customer needs - Skilled in lead qualification and sales optimization - Strong focus on post-sales for customer retention
JW Marriott
6 month
Internship Trainee
May 2018 - October 2018
Underwent a 6-month internship program. Gained practical experience in all core departments of hotel management
Education
Excel R Solutions
2023 - 2023
Certification course in Data Analyst / Business Analyst
January 2023 - July 2023
decision-making and optimize business performance. Proficient in utilizing data visualization techniques to effectively communicate complex findings to stakeholders. Skilled in conducting advanced statistical analysis and employing business analytics strategies to identify trends and patterns, ultimately improving operational efficiency and revenue generation.
Projects
Excel Dashboard
Jun 2023 - Jul 2023
Excel R Solutions
- Analyzed income sources and their percentages using a comprehensive Excel dashboard - Identified the top-performing source with the highest value - Examined monthly income trends through a line chart - Broke down income sources with a pie chart - Determined total counts and percentages of income sources - Calculated the average monthly income - Visualized monthly operating profits with a bar chart - Evaluated marketing strategies for two types - Provided deep insights and maximized financial performance
olist E-commerce Data Analyst Project
Apr 2023 - Jun 2023
Ai Variant
- Led a comprehensive data analysis project involving nine Excel files, ensuring data accuracy and consistency - Cleaned and preprocessed data to maintain data quality - Developed and implemented key performance indicators (KPIs) to derive actionable insights - Created visually appealing dashboards using Excel, Power BI, and Tableau - Integrated data from multiple sources efficiently using VLOOKUP in Excel - Utilized DAX functions in Power BI for real-time KPI calculation and analysis - Loaded and managed data in SQL, establishing seamless updates with Power BI - Derived valuable insights such as payment trends, customer satisfaction correlations, and order fulfillment efficiency - Presented actionable recommendations to improve business processes and customer experience
POWER BI DASHBOARD: Service Requests Analysis
Jun 2023 - Jun 2023
Excel R Solutions
- Developed a Power BI dashboard for analyzing service requests - Analyzed total received requests and identified key observations or trends in monthly requests - Calculated the average daily requests - Tracked the status of each request (completed, pending, cancelled) - Monitored payments received and identified key observations or trends in monthly payments - Compared paid amounts with quotations to gain insights on pricing accuracy - Conducted analysis on service types to determine top types by counts and revenue - Examined regional payments breakdown to identify leading regions and payments
Awards & achievements
Excel R Solutions
Data Analyst Certification
Jun 2023
Excel R Solutions
IBM Certification
Jun 2023