Portfolio - Aryan Pattnaik

Aryan Pattnaik

Aspiring Data Analyst | Power BI Developer | SQL | Excel

Resume

2

PowerBI Projects

About Me

I am an aspiring Data Analyst with hands-on experience in Power BI, SQL, and Excel. I enjoy transforming raw data into meaningful insights through interactive dashboards and data storytelling. I have worked on business-focused projects including economic impact analysis and performance dashboards. Currently preparing for entry-level Data Analyst roles where I can apply analytical thinking, problem-solving skills, and business understanding to drive data-backed decisions.

Key Skills

Power BI

SQL

Microsoft Excel

Power Query

DAX

Data Modeling

KPI Development

Data Cleaning & Transformation

Dashboard Design

Business Reporting

My Projects

IPL Data Analytics Magazine

Domain/Function: Sports & Entertainment

360° Business Insights

Domain/Function: Business Intelligence (BI)

My Experience

Data Analyst | Business Intelligence Projects

• Developed interactive Power BI dashboards analyzing business performance and trend metrics.
• Cleaned, transformed, and structured raw datasets using Power Query and SQL for analysis readiness.
• Designed optimized data models with proper table relationships and calculated measures using DAX.
• Created meaningful KPIs and business metrics to evaluate operational and financial performance.
• Delivered clear, insight-driven reports using structured data visualization techniques.

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

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/aryan-pattnaik-81362926a/

Call Me

+91 8328844053

GitHub

https://github.com/AryanPattnaik-30

PowerBI Project

IPL Data Analytics Magazine

Domain/Function: Sports & Entertainment

Designed a strategic IPL analytics dashboard transforming match data into business-level insights through KPI engineering, pressure analysis, season comparisons, and predictive Best XI modeling.

View Project
Engagement

View Project
on GitHUB

Other Tools

DAX

Power Query

Excel

Batting & Performance Analysis Interactive IPL batting dashboard showcasing Top 10 players by runs, average, and strike rate, along with boundary percentage analysis. Includes dynamic year and team filters for comparative performance insights.

Predictions & Best XI IPL 2024 prediction module featuring Orange Cap and Purple Cap projections, Best Playing XI selection, and all-rounder rankings based on 3-year weighted performance analysis and advanced scoring logic.

Project Details

Designed and developed an end-to-end IPL Data Analytics dashboard in Power BI to transform match-level statistics into strategic cricket intelligence. The solution analyzes batting, bowling, and team performance using qualification-based metrics, pressure scenario classification, and multi-season trend comparison.

Implemented advanced business logic including minimum balls qualification, chasing vs defending impact analysis, 3-year weighted performance scoring, and a role-balanced Best Playing XI model. Built a structured star schema data model with fact and dimension tables, and developed dynamic KPIs using advanced DAX functions such as CALCULATE, FILTER, and time intelligence measures.

The dashboard delivers interactive storytelling with drill-through capabilities, ranking logic, and performance benchmarking to provide management-level insights beyond traditional cricket statistics.

Live Interactive Dashboard

PowerBI Project

360° Business Insights

Domain/Function: Business Intelligence (BI)

End-to-end 360° Business Insights dashboard built in Power BI integrating Finance, Sales, Marketing, and Supply Chain analytics. Designed executive KPIs, profitability analysis, forecast accuracy tracking, and performance benchmarking using advanced DAX and data modeling.

View Project
Engagement

View Project
on GitHUB

Other Tools

Data Modeling

Advanced DAX

Data Cleaning

Data Transformation

Power Query

ETL Layer

Microsoft Excel

Executive View Executive KPI dashboard summarizing revenue, gross margin, net profit, and performance trends. Provides high-level cross-functional insights for leadership decision-making with dynamic filters and benchmark indicators.

Supply Chain View Supply chain dashboard analyzing forecast accuracy, inventory risk (excess vs out-of-stock), and operational performance. Supports data-driven planning and demand-supply optimization decisions.

Project Details

Developed a comprehensive 360° Business Insights solution in Power BI to provide unified visibility across Finance, Sales, Marketing, and Supply Chain functions.

Designed a star schema data model integrating multi-domain datasets and built advanced DAX measures for revenue analysis, gross margin tracking, net profit evaluation, forecast accuracy monitoring, and risk classification (Excess Inventory vs Out-of-Stock).

Implemented executive KPI dashboards, profit & loss statements, customer and product performance analysis, regional benchmarking, and performance matrix visualizations. Integrated drill-through navigation, dynamic filtering, and conditional formatting to enable decision-focused analytics.

The solution delivers management-level insights into revenue growth, profitability trends, market share shifts, customer segmentation, and operational efficiency.