Ankur Ghogale

Intro

Hello,

Hello, and welcome to my data analyst portfolio! I'm Ankur Ghogale, a passionate data enthusiast with a keen eye for uncovering insights and driving data-driven decisions. With a background in Data & Analytics, I've spent 5 years honing my skills in data analysis, engineering, and visualization.

Throughout my journey, I've had the privilege of working on diverse projects that have allowed me to dive deep into data from various domains. From BizOps Analytics to Operation Analytics, each endeavor has been a unique opportunity to transform raw data into meaningful narratives that inform and empower.

My approach to data analysis combines technical proficiency with a strong curiosity. I am well-versed in programming languages such as Python and R, and I'm skilled in utilizing tools like AWS Airflow, Glue and Tableau Prep to wrangle and model data effectively. Whether it's cleaning messy datasets, conducting exploratory data analysis, or building predictive models, I thrive on the challenges that data presents.

Beyond just crunching numbers, I believe in the power of storytelling through data visualization. With a creative eye and a commitment to clarity, I create compelling visualizations that transform complex datasets into intuitive visuals that resonate with both technical and non-technical audiences.

As you explore my portfolio, you'll find a collection of projects that showcase my data analysis journey. Each project has a story to tell, a problem to solve, and insights to share. From tackling real-world business challenges to delving into personal data curiosities, these projects reflect my dedication to continuous learning and growth in the world of data.

Thank you for visiting my portfolio. Feel free to explore my projects and reach out to discuss potential collaborations or opportunities. Let's connect and harness the power of data to drive impactful decisions together!

Work

I played a pivotal role in transforming raw data into actionable insights that drove strategic decisions for clients in various domains like BizOps, Marketting, and Operations. My responsibilities encompassed data exploration, analysis, visualization, and reporting, contributing to the success of numerous projects. Below is the summary of my Accomplishments:

Accomplishments :

• Created compelling data visualizations using tools such as Matplotlib and Tableau, effectively communicating insights to technical and non-technical stakeholders.

• Conducted in-depth exploratory data analysis on large datasets, identifying trends, outliers, and patterns that informed business strategies.

• Collaborated closely with cross-functional teams to understand data requirements and translate business questions into analytical tasks.

• Build data pipelines using AWS Airflow, Glue, Python to migrate data to AWS database (Athena). Cleaning and validating data for uniformity and accuracy using SQL.

• Developed complex SQL queries to extract, clean, and manipulate data from disparate sources, ensuring data accuracy and consistency.

• Built predictive models to forecast key metrics, contributing to more informed decision-making and resource allocation.

• Communicate analytic solutions to stakeholders and implement improvements as needed to operational systems.

• Participated in regular data review meetings, offering data-driven recommendations and insights that guided project strategies.

Projects

Click Through Rate Prediction

Analysed and evaluated Click Through Rate (CTR) values to decide which unique member of the column has the highest influence. CTR is a method used to find out how frequently people clicked on the ad.

911 calls Data Analysis

I developed my interest in data analytics with this project and was surprised to see how data can be used to find valuable informations and insights.

Loan Repayment Prediction

Loan default prediction using deep learning considering features like current unpaid balance, loan tenure, unemployment rates, national interest rates and many other economical factors. The model performance was evaluated under various feature selection and architecture, where all comparisons were done using 5-fold cross validation.

Covid Data Exploration using SQL

Explored covid19 deaths and vaccination data using SQL. Answered various questions like likelihood of dying if you contract covid in your country.

Data Analysis for an Ecommerce company

Analyzed customer and user data to find out whether the company should focus on their mobile app or on their website. Moreover, we also built linear regression model with the accuracy of above 90% to predict yearly amount spent by the customers.

Projects

Building Audiobook using Python

An Audiobook is a recording or voiceover of a book or other work read aloud. You can listen to audiobooks on any smartphone, tablet, computer, home speaker system, or in-car entertainment system. In this mini project, I have created an audiobook with Python.

Live Weather Updates

This mini project takes name of a location as input from user and gives their live weather updates as output. There are many ways to get live weather updates using the Python programming language. You can either use a paid API or use web scraping skills by searching for the location on Google and collecting data about its weather. Here we have scraped data from google.

Vehicle detection uisng opencv

The objective of the program given is to detect object of interest(Car) in video frames and to keep tracking the same object. This is an example of how to detect vehicles in Python using Opencv.

Instagram Scraper

Scraping any social media website can help you to gain insights on new business trends or can even get you new leads which can be your potential customers. Here we have scraped Instagram using Instaloader library which is an API used for scraping Instagram. Here are scraping the profile information like profile id, followers names, followees name, bio, and images and their captions from other's profiles.

Get In Touch

• Facebook
• Linkedin
• Github
• Instagram

Elements

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';