Portfolio - Infant | Codebasics

Powered by
Codebasics Bootcamp

Hello, I am

Infant

Data Analyst

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About

Me

🚀 Meet Infant Arockia Mary, Your Data Detective! 🚀

🔍 Unearthing Insights from Numbers 🔍

Hey there, I'm Infant Arockia Mary, on a data adventure. I started with a master's degree in communication systems, but my heart found its true calling in data analysis.

📊 I'm your data wizard, skilled in Excel, Power BI, SQL, and Python. I turn numbers into stories, revealing hidden gems in the data.

💡 Even though I'm new to the working world, I've tackled real-world projects you can check out in my portfolio. These projects have given me a taste of solving practical business puzzles using data.

🌟 Explore my portfolio to see how I've cracked data's code. I might be at the beginning of my journey, but I'm eager to bring data's magic to your team and help your organization thrive.

📞 Ready to make data work for you? Let's connect and start this data-driven journey together!

Technical

Skills

Excel

PowerBI

SQL

Python

My

Projects

Sales and Finance Reports

Sales and Finance Reports

Objective: Analyze AtliQ Hardware's finances and market presence. Create vital reports ("Customer Net Sales," "Market vs. Target") using Excel. Empower users with key sales and finance insights amidst analytics advancements.

Business Insights 360

Business Insights 360

"Introducing '360° Data Illumination' with Power BI: Transforming AtliQ Hardware's analytics landscape for informed decisions. Dive into finance, sales, marketing, and supply chain insights!"

Consumer Adhoc Insights

Consumer Adhoc Insights

AtliQ Hardware analyzed data closely, discovering insights through SQL across 10 tasks. We learned about consumer trends, helping us make smarter decisions.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

CB Cert

SQL Beginner to Advanced For Data Professionals

CB Cert

Python For Beginner and Intermediate Learners

Contact Me

Email

[email protected]

Github

https://github.com/InfantMary

Linkedin

https://www.linkedin.com/in/i-infant-arockia-mary-8b1a7626b

Call

+91 6379239449

Infant

Data Analyst

Download Resume

Resume

Excel Project

Sales and Finance Reports

Objective: Analyze AtliQ Hardware's finances and market presence. Create vital reports ("Customer Net Sales," "Market vs. Target") using Excel. Empower users with key sales and finance insights amidst analytics advancements.

View Project
Engagement

View Project
on GitHUB

Sales and Finance Reports

Customer net sales performance: Analyzes revenue generated per customer after deductions. Key for strategic decision-making.

Sales and Finance Reports

Market performance vs target: Compares actual market results with predefined targets. Crucial for evaluating goal attainment and strategizing.

Project Details

In this project, I've meticulously crafted a sales report using Excel's pivot tables, transforming raw data into actionable insights. It guides businesses towards optimal discounts, smoother negotiations, and lucrative market expansion. I've mastered Pivot Tables, Power Query, and DAX to distill complex data. Through conditional formatting and visual enhancements, I've created compelling narratives. Delving into sales metrics, I've uncovered growth opportunities. This project isn't just about reports; it's about empowering businesses to thrive in dynamic markets, charting a course towards sustained growth and profitability.

Project video

PowerBI Project

Business Insights 360

"Introducing '360° Data Illumination' with Power BI: Transforming AtliQ Hardware's analytics landscape for informed decisions. Dive into finance, sales, marketing, and supply chain insights!"

View Project
Engagement

View Project
on GitHUB

Business Insights 360

Create a welcoming landing page that grabs users' attention, becoming a vital part of our dashboard.

Business Insights 360

Check Model View to see how columns in different tables connect, giving you a clear picture of your data relationships.

Project Details

"Embark on a transformative journey with 'Insights360,' our Power BI project that transcends data analytics. Uncover the intricacies of data modeling, master Power Query's alchemy, and sculpt DAX Measures into narrative threads. Immerse in the art of visuals, bookmarks, and tooltips, creating an intuitive dashboard.
1. Finance reveals its heartbeat through metrics like Net Sales and Gross Margin %.
2. Sales becomes a navigable terrain, offering deep insights into customer-product dynamics.
3. Marketing gains clarity with regional performance insights, turning strategies into precision.
4. Supply Chain complexities unfold, from customer trends to error analysis, igniting optimization.
Beyond technique, 'Insights360' is a strategic asset:
• Empower decision-makers with seamlessly deployed reports.
• Embrace iterative improvement fueled by stakeholder feedback.
• Elevate data from mere numbers to a dynamic force guiding strategic decisions.

Project video

Live Interactive Dashboard

SQL Project

Consumer Adhoc Insights

AtliQ Hardware analyzed data closely, discovering insights through SQL across 10 tasks. We learned about consumer trends, helping us make smarter decisions.

View Project
Engagement

View Project
on GitHUB

Consumer Adhoc Insights

One of the queries is for calculating the percentage difference between 2020 and 2021

Consumer Adhoc Insights

This analysis helps to get an idea of low and high-performing months and take strategic decisions.

Project Details

Project Description:
AtliQ Hardware, the electronics company, dived into data analysis using SQL for 10 tasks. Here's a quick peek:

- **Insights Extraction:** We carefully processed queries to find useful insights.
- **Tools We Used:**
- SQL for queries
- OBS for videos
- PowerPoint for slides
- Clipchamp for editing
- **Discovering Customer Trends:** Unraveling customer behaviors and trends was a key focus.
- **Decision Power:** Armed with these insights, we made smarter decisions for growth and innovation.

Project video