Powered by
Codebasics DA Bootcamp

Samuel Penugula

Data Aspirant

[email protected]

Resume

Hello, I am

Samuel Penugula.

3

PowerBI Projects

1

SQL Project

About Me

👋 Hello! I'm Samuel, an aspiring Data Analyst and MCA graduate with a strong foundation passion for turning raw data into meaningful, actionable insights.

I specialize in Power BI, SQL (MySQL), Advanced Excel, and Python, using these tools to build interactive dashboards, write efficient queries, clean and model data, and uncover trends that support business decisions. With a detail-oriented approach and a drive for continuous learning, I enjoy solving real-world problems through data and am excited to contribute to data-driven projects and grow in the analytics field.

Key Skills

PowerBI

SQL

Advanced Excel

Python

My Projects

My Experience

Data Analyst Intern – AtliQ Technologies
Feb 2026

Performed data cleaning, validation, and quality checks using Power Bi and Power Query to ensure accurate and reliable reporting.
Analyzed sales channel performance, improving reporting accuracy by 15% and supporting data-driven strategies to enhance client engagement across multiple cities.
Conducted detailed analysis using Power BI to evaluate revenue, customer behavior, city-wise trends, sales modes, and age demographics.

Software Engineer Intern – Kristu Jayanti Software Developement Centre(KJSDC), Bengaluru
Feb 2025 – Jun 2025

Developed an in-house Gym Management System for ~13,000 university members, handling subscriptions, renewals, add-ons, and payments via a centralized admin dashboard.
Implemented RFID-based attendance tracking with ID cards, allowing one daily check-in and improving efficiency by 70%.
Built core application using Java, MongoDB, and Redis; conducted thorough API and workflow testing with Postman to ensure data integrity and reliability.

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

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Microsoft Azure Fundamentals

Microsoft Azure Fundamentals

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/samuel-penugula/

https://github.com/sam3403

PowerBI Project

Buiness Insights 360

Domain/Function: Consumer Goods & Retail Analytics

Business Insights 360 is a powerful, interactive dashboard built for Atliq Hardware to enable effiecient data acess and eliminate limitations of scattered excel files. It delivers deep, actionable insights into Finance, Sales, Marketing, and Supply Chain operations on a global scale.

View Project
on GitHUB

Buiness Insights 360

Home Page

Buiness Insights 360

Executive View

Project Details

The core goal was to replace scattered Excel files with a single source of truth by integrating Excel/CSV and MySQL data into a robust star-schema model. This delivers real-time visibility and drillable insights across departments, letting users move from high-level KPIs to detailed views without switching tools. Focus areas were strong data modeling for accuracy/scalability, user-friendly design with intuitive navigation and clear visuals, and drillable insights for easy exploration.
Through this project, I gained hands-on experience in Power Query (basic to advanced transformations), simple and complex DAX formulas for custom metrics, building scalable models with 10+ tables and proper relationships, choosing effective visuals with professional formatting, dashboard design principles (layout, hierarchy, readability), using bookmarks for navigation and scenarios, publishing to Power BI Service, iteratively applying stakeholder feedback, and understanding key metrics.

Live Interactive Dashboard

PowerBI Project

Hospitality Revenue Insights

Domain/Function: Hospitality / Revenue Management

Hospitality Revenue Insights is a Power BI dashboard that consolidates booking, revenue, and guest data to provide real-time KPIs and drillable views by property, city, platform, and trends — helping revenue teams identify performance issues and optimize pricing strategies to regain market share.

View Project
on GitHUB

Other Tools

Excel

Hospitality Revenue Insights

Data Model

Hospitality Revenue Insights

Main Dashboard

Project Details

This project replaces inefficient, fragmented Excel-based reporting with one unified, interactive report that serves revenue managers, operations, and executive teams simultaneously. Data is seamlessly integrated into a robust star-schema model, ensuring clean relationships, fast performance, and accurate calculations.
The dashboard delivers real-time visibility into essential hospitality metrics: Total Revenue, RevPAR, Occupancy %, ADR, Realisation %, DBRN/DSRN, cancellation rates, and platform/channel performance. Interactive elements — trend charts for monthly patterns, property-level tables for detailed comparisons, and slicers (city, month, booking mode, age group) — allow users to quickly identify underperforming properties or channels, analyze guest preferences by age, compare sales modes, and drill down from high-level KPIs to granular insights. This empowers stakeholders to make targeted decisions on pricing adjustments, promotional strategies, and operational improvements.

Live Interactive Dashboard

SQL Project

Ad-Hoc Analysis – Consumer Goods

Domain/Function: Consumer Goods & Retail Analytics

Ad-Hoc Insights is SQL-based analysis and it answers 10 business requests using MySQL queries on customers, products, discounts, market share, and trends to deliver quick actionable answers and better insights.

View Project
on GitHUB

Ad-Hoc Analysis – Consumer Goods

SQL query to find the products with highest and lowest manufacturing costs.

Ad-Hoc Analysis – Consumer Goods

SQL query to find all the unique product counts for each segment and sort them in descending order of product counts.

Project Details

The goal of this project was to provide quick, accurate insights directly from the MySQL database without heavy ETL or full reporting cycles. Using optimized queries I solved questions like identifying top 10 customers by net sales contribution, ranking products with highest discount impact, comparing year-over-year market share, analyzing new product launches, evaluating channel performance, and highlighting regional sales trends. Each request returned precise results rapidly, enabling sales, marketing, and leadership to act on urgent needs in minutes.
Through this work, I strengthened advanced MySQL skills — complex multi-table joins, time-intelligence for fiscal comparisons, ranking for top-N analysis, and deriving key metrics like percentage contribution, discount rates, and growth trends. The project emphasized business value over pure tech: translating raw data into clear and actionable recommendations.

PowerBI Project

Insurance Performance Analysis

Domain/Function: Finance

Insurance Performance Analysis is a Power BI dashboard created during my AtliQ Technologies virtual internship (Data Analyst role). It analyzes Shield Insurance data to deliver insights on premiums, claims, policies, risk profiles, customer segments, and key metrics.

View Project
on GitHUB

Insurance Performance Analysis

Data Model

Insurance Performance Analysis

Sales Mode Analysis

Project Details

This project provides a unified, interactive view of insurance data, enabling stakeholders to monitor premiums, customer acquisition, and growth trends in real time. The dashboard features an overall KPI snapshot with total revenue, customer counts, daily revenue growth (DRG), and daily customer growth (DCG) alongside last-month comparisons. Monthly trends are visualized through toggleable area charts for revenue and customer growth, while customer segmentation breaks down contributions by age group. Revenue and customer splits by city include age-group sub-details, and sales mode performance is analyzed via pie/bar charts and trend lines. Age-group preferences for policies and sales modes are shown through tables, heatmaps, and stacked bars.
This demonstrates seamless data integration, advanced DAX for custom KPIs, and user-focused design. Key highlights include delivering actionable insights on high-performing segments and empowering better sales strategies, and profitability.

Live Interactive Dashboard