Portfolio - Devang Patel | Codebasics

Powered by
Codebasics Bootcamp

Devang Patel

Aspiring Data Analyst

EMAIL

[email protected]

PHONE

+91 9662331035

Download CV

About Me

Hi, I'm Devang Patel — a final-year B.Tech student in Computer Science with a focus on Artificial Intelligence, and an aspiring Data Analyst passionate about solving real-world problems through data.

Over the past year, I’ve worked on practical data analytics projects involving financial reporting, business intelligence dashboards, and predictive modeling. My tools of choice include Power BI, Excel, SQL, and Python. I’ve built automated P&L reports that saved hours of manual work, created sales dashboards that supported revenue growth, and used machine learning to predict customer behavior.

I believe data should drive every business decision. That’s why I focus not just on crunching numbers—but also on uncovering clear, actionable insights that create business impact.

3

PowerBI Projects

1

Python Project

Key Skills

Power BI (Dashboards, KPIs, DAX, Slicers, Drill-throughs)

Microsoft Excel (Pivot Tables, Power Query, VLOOKUP, IF, Data Cleaning)

Python (Pandas, NumPy, Matplotlib, Seaborn)

Data Storytelling & Insight Generation

SQL (Joins, CTEs, Subqueries, Aggregations, Window Functions)

Data Modeling & Relational Database Design

Git & GitHub (Version Control)

Jupyter Notebook

DAX Studio

OneDrive & Google Sheets (Cloud Collaboration)

Figma

Power Point

My Projects

Awards & Certificate

Python: Beginner to Advanced For Data Professionals

SQL for Data Science

Math and Statistics For AI, Data Science

Master Machine Learning for Data Science & AI: Beginner to Advanced

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Let's Work Together!

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

[email protected]

Call Me

+91 9662331035

LinkedIn

https://www.linkedin.com/in/devang-ai/

GitHub

https://github.com/devang1005

PowerBI Project

BI 360

Domain/Function: Brick & mortar and ecommerce

Customized a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market by gathering data from 2 different sources (Excel/CSV files and a SQL database)

View Project
Engagement

View Project
on GitHUB

Other Tools

SQL

EXCEL

DAX STUDIO

Visualize P&L statements, Net Sales, and product/customer performance

Analyze revenue, Gross Margin %, COGS & deductions

Project Details

Built data model and visualizations in Power BI, and optimized the report with DAX studio which improved the performance of the
report by 5%.
Developed a dashboard that enabled Atliq Hardware to analyze department sales trends, driving a projected 10% revenue
acceleration and a 20% reduction in data-related expenses.

Live Interactive Dashboard

Python Project

Expense Tracking System

Domain/Function: Personal Finance Management

An Expense Tracking System is a web application that allows users to manage their personal or business expenses effectively. This project is built using Python and utilizes several powerful packages to ensure a robust and efficient solution.

View Project
Engagement

View Project
on GitHUB

Other Tools

MYSQL

FastAPI

Pydantic

requests

Pandas

Streamlit

Expense Tracking System

User-friendly interface for tracking expenses. Integration with a MySQL database for storing expense data.

Expense Tracking System

Streamlit-powered interactive dashboards. RESTful API using FastAPI for backend operations.

Project Details

an Expense Tracking System using Python, Pandas, Pytest, SQL, and Streamlit to simplify financial management. The project allows users to log, categorize, and analyze expenses with an intuitive interface.

PowerBI Project

Weather Report

Domain/Function: Weather Analytics

a Live - Weather Dashboard that shows live weather data , forecasts, and air quality metrics for multiple cities using real-time API's from WeatherAPI.com .

View Project
Engagement

View Project
on GitHUB

Other Tools

Figma

weatherapi

Blue Theme

Purple Theme

Project Details

🔧 What I Built:

🌡️ Current Weather: Temperature, Humidity, Wind Speed, UV Index, and Precipitation
📅 7-Day Forecast: Day-wise temperature and rain chances
🌅 Sunrise & Sunset Timings
🌧️ Chance of Rain for each day
🌫️ Air Quality Index: PM2.5, PM10, CO, NO2, O3, SO2 with indicators
🌍 Cities covered: Ahmedabad, Bengaluru, and Hyderabad
✅ Clean UI and a simple, informative dashboard experience

Live Interactive Dashboard

PowerBI Project

EV Sales Insights Dashboard

Domain/Function: Sales Analysis

Designed and developed an interactive Power BI dashboard to analyze EV sales trends across India (FY 2022–2024), tailored for Tesla's strategic market planning

View Project
Engagement

View Project
on GitHUB

Other Tools

PostgreSQL

Figma

EV Sales Insights Dashboard

Maker's Analytics

EV Sales Insights Dashboard

State Analytics

Project Details

The dashboard helps Tesla identify:

High-penetration markets for 4-wheeler EVs
Seasonality in EV demand
States with growing vs declining EV adoption
Growth rate projections up to 2030
Impact of policy incentives and infrastructure

Live Interactive Dashboard