Avishek Choudhary

Data Analyst

I have skills in Excel, SQL and Power BI. You can view my personal portfolio here or download my resume from here.

About Avishek

I'm an aspiring Data Analyst. Unearthing patterns and establishing connections within data is a source of genuine fascination for me. Proficient in SQL querying, and Python scripting and adept at crafting insightful Power BI Reports with advanced Excel skills, I eagerly seek career opportunities to bring detail and precision into data analysis.

SKILLS

    SQL (MySQL, PostgreSQL)
    Python (Numpy, Pandas, Matplotlib, Seaborn)
    Power BI
    Microsoft Office Suite: Excel, Word, PowerPoint

EXPERIENCE

    KPMG  
    Data Analytics Virtual Internship - July, 2023
  • Assessed data quality and completeness for 3 datasets in Excel provided by the client.
  • Developed an approach for targeting high-value customers based on demographics and attributes.
  • Created an interactive dashboard in Power BI to visualize and present data insights in PowerPoint.
  • Proposed marketing and growth strategies for Sprocket Central Pty Ltd based on the analysis.
  • Gained practical skills in data analysis and communication within KPMG's Lighthouse & Innovation Team.
    PWC  
    Power BI Virtual Case Experience - June, 2023
  • Developed expertise in Power BI and data analytics.
  • Created comprehensive dashboards for a telecom client, reflecting KPIs and metrics.
  • Designed a dashboard focused on proactive customer retention strategies.
  • Contributed to diversity and inclusion initiatives through interactive dashboards.
  • Enhanced digital awareness and problem-solving skills.
    TATA Group  
    Data Visualization Virtual Internship - May, 2023
  • Gained hands-on experience with data visualization tools and techniques in Power BI.
  • Worked on real-world datasets to create visualizations that communicated insights to senior management.
  • Developed a strong understanding of the principles of data visualization and how to use them to communicate effectively using PowerPoint.

EDUCATION

    B.Sc in Computer Science Honours from University of Calcutta, Kolkata

ACHIEVEMENT

    5 in SQL at HackerRank

CERTIFICATION

PROJECTS

Zoom Electric: Sales Analysis
Validated the sales drop of Sprint scooters and figured out the reasons for this decline by conducting in depth analysis for the sales team, and evaluated the effectiveness of email campaign.

IBM HR Analytics
Created a dynamic Power Bi dashboard of the IBM HR dataset to answer some questions about employee attrition and performance data. The goal of this project was to generate actionable insights and recommendations for developing employee retention strategies.

SQL Case Study: Music Store
Analyzed the dataset of an Online Music Store to answer a set of questions using complex SQL queries which can be used to make decisions about its marketing and product offering.