Avishek Choudhary | Data Analytics | Business Intelligence | SQL Developer

Avishek Choudhary

Data Analytics | Business Intelligence | SQL Developer

Based in Kolkata WB, India

About

As an aspiring Data Science professional, I am currently immersed in the realm of Data Analytics, driven by my passion for leveraging data to tackle intricate challenges and fuel organizational triumph. 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 apply my meticulous approach to data analysis.

Skills

Projects

SQL Case Study: Online 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.

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.

Consumer Credit Card Spend Analysis

Analyzed Consumer Credit Card Spending data with SQL queries to answer questions about the data. The goal of the project was to answer a set of questions about Consumer Credit Card usage data that can be used by banks to make decisions about their consumer base and product offering.

Spotify EDA

Performed Exploratory Data Analysis on the Spotify dataset to analyze the data.

Zoom EV Sales Analysis

Validated the sales drop for an EV scooter model named "Sprint" and figured out the reason for its decline.

Netflix EDA

Performed Exploratory Data Analysis on the Netflix dataset to analyze the data and presented some key insights into the data.

Experience

May, 2023

Data Visualization - Virtual Internship by TATA Group

Gained hands-on experience with data visualization tools and techniques. Worked on real-world data sets 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. Received a certificate of completion from TATA.

June, 2023

Power BI - Virtual Case Experience by PwC, Switzerland

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. Received a certificate of completion from PwC.

July, 2023

Data Analytics - Virtual Internship by KPMG, Australia

Assessed data quality and completeness for 3 datasets provided by the client. Developed an approach for targeting high-value customers based on demographics and attributes. Created an interactive dashboard to visualize and present data insights. 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. Received a certificate of completion from KPMG.

Education

2017 - 2020

B.Sc in Computer Science Honours from University of Calcutta

Grade A

2014 - 2016

Senior Secondary in Science from I.S.C

Grade A

2013 - 2014

Secondary Education from I.C.S.E

Grade A