Powered by
Codebasics DA Bootcamp

ANTHONY MARTIN

Data Aspirant

+91 8970285820 [email protected]

Resume

Hello, I am

ANTHONY MARTIN.

1

Excel Project

1

PowerBI Project

1

SQL Project

1

Python Project

About Me

Welcome to my portfolio!
I'm an aspiring data analyst with a strong background in leveraging data to drive impactful business decisions. I specialize in Power BI, Excel, and SQL, turning complex datasets into clear, actionable insights. My passion lies in creating interactive dashboards, automating data processes, and conducting in-depth analyses that enhance operational efficiency. I am constantly learning and evolving in the field of data analytics and visualization, and I thrive in collaborative environments where I can make a difference through data-driven projects.
Take a look around, and feel free to reach out with any questions or collaboration opportunities!

Key Skills

excel

power bi

python

sql

tableau

AWS

EC2

S3

boxplot

oracle sql

matplotlib

ETL

VLOOKUP

apache airflow

CTE

windows functions

pivot

NUMPY

My Projects

My Experience

FOXCONN HON HAI TECHNOLOGY - Product data analyst (Nov 2023 - Present)

• Product Data Analyst with 1.6 years of experience leveraging Excel, Tableau, and Oracle SQL to drive product insights.

•Skilled in data visualization, trend analysis using box plots, ETL processes and translating complex data into compelling stories for stakeholders to support strategic decisions.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

[email protected]

https://www.linkedin.com/in/antoprofile/

+ 91 8970285820

https://github.com/AnthonyMartin444

Excel Project

EXCEL---SALES-ANALYTICS

Domain/Function: Sales and Finance

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

EXCEL---SALES-ANALYTICS

Customer Performance Report: Provides net sales performance of each customer across years

EXCEL---SALES-ANALYTICS

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Finance, Sales, Marketing and Supply Chain

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
Engagement

View Project
on GitHUB

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

User-empathetic landing page as a part of dashboard design

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Project video

Live Interactive Dashboard

SQL Project

SQL-Consumer-Goods-Ad-hoc-Insights

Domain/Function: Consumer Goods | Function: Executive Management

In this project, I used MySQL to query a relational database, solving real-world business problems by applying advanced SQL techniques. I worked with subqueries, multiple joins, CTEs, and window functions to extract and analyze data, improving both my technical and problem-solving skills.

View Project
Engagement

View Project
on GitHUB

SQL-Consumer-Goods-Ad-hoc-Insights

Ad-hoc SQL Query Analysis for Consumer Goods Insights– This project showcases SQL queries designed to extract actionable insights from a consumer

SQL-Consumer-Goods-Ad-hoc-Insights

Sharing a screenshot of my LinkedIn post highlighting a SQL project where I applied my skills to analyze and extract insights from complex datasets

Project Details

"Ad-hoc SQL Query Analysis for Consumer Goods Insights" – This project showcases SQL queries designed to extract actionable insights from a consumer goods dataset. Tasks include analyzing product trends, calculating unique product counts and percentage changes, identifying top-performing product segments, and segment-wise product tracking using advanced SQL techniques like CTEs, cross joins, and aggregations.

Python Project

EDA Hospitality Industry

Domain/Function: Hospitality

Conducted exploratory data analysis to uncover insights, including a 65% contribution from top booking platforms and a 20% revenue surge during peak seasons. Created visualizations for occupancy rates and guest ratings (85% average satisfaction) to support data-driven decision-making.

View Project
Engagement

View Project
on GitHUB

EDA Hospitality Industry

Analyzed AtliQ Hotels' data by importing five datasets, including booking details, room categories, and guest ratings, using Python.

EDA Hospitality Industry

AtliQ Hotels Data Analysis Project involved calculating average guest ratings per city and visualizing revenue distribution across booking platform

Project Details

This project involved analyzing hospitality industry data using Python to extract actionable insights. The analysis focused on uncovering key patterns and trends, such as identifying that 65% of bookings came from top platforms and revenue surged by 20% during peak seasons. Visualizations were created to highlight occupancy rates and guest satisfaction levels, revealing an impressive 85% average satisfaction. These insights help businesses in the hospitality sector optimize their marketing strategies, improve operational efficiency, and enhance guest experiences through data-driven decision-making.