Loading Portfolio...

Gagan BP |

Delivering Insights with Clarity, Simplicity & Impact

I help businesses unlock the full value of their data by building clean, insightful dashboards and automating reporting processes. With expertise in Power BI, Excel, Python, and SQL, I turn raw data into accurate, meaningful visual stories that drive smart decisions.

I also integrate AI tools like GPT to streamline analysis and boost efficiency. I believe clear visualizations speak louder than words — so every project I build focuses on clarity, simplicity, and real business value.

Feel free to connect with me on LinkedIn to discuss collaborations or opportunities.

About Me

I’m an AI-driven aspiring data analyst with a passion for uncovering insights and telling stories through data. My journey began during my MCA when I worked on a project analyzing suicide trends in India — that experience opened my eyes to the power of data in creating real impact.

Since then, I’ve been honing my skills in Power BI, Excel, Python, SQL, and data visualization to clean, explore, and present data in meaningful ways. I enjoy building dashboards that don’t just look good but deliver clarity, simplify decisions, and communicate patterns that matter.

I actively use AI tools like ChatGPT to streamline workflows and boost productivity. Whether it’s data cleaning, reporting automation, or turning raw data into strategic insights — I focus on reducing noise and helping businesses and teams make informed, confident decisions.

Always learning, always improving — I’m committed to growing into a data analyst who brings not just technical skill, but real business value.

Skills & Technologies

Data Management

SQL MySQL Excel Functions Data Cleaning Pivot Tables Conditional Formatting

Programming & Tools

Python Pandas NumPy Jupyter / Google Colab VS Code Git & GitHub HTML & CSS

Data Visualization

Power BI DAX Power Query Excel Dashboards Matplotlib Seaborn

Machine Learning Basics

Scikit-learn Train-Test Split Accuracy / Confusion Matrix

Automation & AI Tools

Excel Automation (Python + GPT) AI-Driven Data Analysis

Featured Projects

HR Analytics Using Power BI

Created a comprehensive Power BI dashboard analyzing employee attrition and workforce trends. Delivered actionable insights that helped HR teams improve retention strategies and optimize compensation structures.

Power BI Data Visualization HR Analytics Dashboard Design

Amazon Sales Analytics Using Power BI

Developed an interactive Power BI dashboard analyzing Amazon sales trends, product performance, and state-wise profits. Enabled data-driven decision making through comprehensive sales analytics and regional performance insights.

Power BI E-commerce Sales Analysis Business Intelligence

Heart Disease Prediction Using Machine Learning

Compared multiple machine learning, deep learning, and ensemble models for heart disease prediction. Achieved 93% ROC-AUC with a stacked ensemble model, demonstrating strong evaluation and model optimization skills.

Machine Learning Python Healthcare Scikit-learn

Analysis of Suicide Trends in India

Analyzed suicide trends across Indian states using NCRB 2021 data. Created comprehensive visualizations to understand patterns and contributing factors, providing insights for public health policy decisions.

Data Analysis Python Public Health Matplotlib

Netflix Movie Analysis

Analyzed Netflix movie dataset to explore trends in popularity, genres, ratings, and release years. Performed data cleaning, visualization, and statistical analysis to uncover key insights about factors influencing movie success on the platform.

Data Analysis Python Entertainment Seaborn

Services I Offer

Excel Dashboards

I create professional Excel dashboards using advanced formulas, pivot tables, conditional formatting, charts, and slicers. Ideal for tracking KPIs, business metrics, or custom reports based on your data.

Power BI Reports

I design interactive and visually compelling reports in Power BI using DAX and Power Query. Whether you need dashboards for sales, operations, or data monitoring, I can help you present your data effectively.

Data Cleaning (Excel / Python / Power Query)

I clean messy or unstructured data using Excel functions, Power Query, or Python (Pandas). From handling missing values to formatting columns, I ensure your data is clean, consistent, and ready for analysis.

SQL Query Writing

I write optimized SQL queries in MySQL for selecting, filtering, joining, and summarizing data. Whether it's simple reports or complex conditions, I can help you extract the right insights from your database.

Python Data Visualization

I use Matplotlib and Seaborn to create clear and impactful charts like bar graphs, heatmaps, line plots, and more. These visuals help you explore and present your data effectively in reports or dashboards.

Machine Learning (Basic Models)

I build beginner-friendly machine learning models using scikit-learn. I can help you with data preparation, model training, accuracy evaluation, and visual insights — great for academic or prototype-level use.

Excel Automation (Python + AI)

I automate Excel tasks like updating files, formatting data, or generating reports using Python scripts and AI (GPT). Save time by letting me handle repetitive Excel work with smart automation.

Portfolio / Resume Website (HTML & CSS)

I build simple, clean personal websites using HTML and CSS — ideal for portfolios, resumes, or freelancer profiles. I can also help you host it on GitHub Pages for free access online.

Let's Work Together

Get In Touch

Ready to transform your data into insights? Let's discuss your project and how I can help you achieve your goals.

Location

212, 5th cross, Vyalikaval HBCS Layout, Nagavara

Bengaluru, Karnataka 560045

Resume

GAGAN B P

Data Analyst / Business Analyst

7892329607
databygagan@gmail.com
Bangalore, Karnataka 560045

SKILLS

  • SQL (MySQL)
  • Python (Pandas, NumPy, Matplotlib)
  • Tableau
  • Excel (VLOOKUP, HLOOKUP, Conditional Formatting, Pivot Tables)
  • Data Visualization (Dashboards, Graphs)
  • Microsoft Power BI
  • ETL (Extract, Transform, Load)
  • Data Analysis

PROJECTS

HR ANALYTICS DASHBOARD

Personal Project - Mysore, KA | June 2024
  • Designed an HR Analytics Dashboard in Power BI to analyze employee attrition trends across 3 departments
  • Processed and visualized data on attrition by age, job role, education, and salary using Power BI, identifying attrition rates of 22.0% and 13.8%
  • Delivered actionable insights on key HR metrics, driving data-driven decisions that reduced attrition rates by 20%
  • Customized the dashboard to focus on attrition by years and salary brackets, improving analysis efficiency by 30%

ANALYSIS ON SUICIDE TRENDS IN INDIA

Academic Project - Mysore, KA | April 2024
  • Conducted an in-depth analysis of 2021 suicide trends in India using the NCRB dataset, organizing data across 28 states, 8 UTs, and 53 cities
  • Identified regions with highest/lowest suicide rates and analyzed gender-specific trends across 28 states, UTs and 53 cities
  • Predicted future suicide rates for 2024 using linear regression with Python (Pandas, Matplotlib, Seaborn, Scikit-learn) with 85% accuracy
  • Generated insights and created 10 visualizations as a part of a collaborative team project, contributing to a 25% improvement in decision-making efficiency

INTERNSHIP EXPERIENCE

POWER BI INTERN

Cognifyz Technologies - Remote August 2024 - September 2024
  • Leveraged Power BI to perform detailed data analysis and create visualizations, enhancing decision-making efficiency by 10%
  • Created and maintained interactive dashboards and reports, reducing manual reporting time by 25%
  • Developed data models and visualizations for 7 tasks, collaborating with cross-functional teams to align with business objectives and improve reporting
  • Conducted data quality checks and validation, improving data accuracy by 15% and ensuring reliable reporting

PYTHON FULL-STACK INTERN

Orion Web Services Pvt Ltd - Mysore, KA October 2023 - December 2023
  • Applied Python full-stack development skills in academic projects, leading to a 15% increase in project efficiency
  • Strengthened proficiency in the Flask framework through hands-on practice, achieving a 50% improvement in skills, which contributed to more efficient coding
  • Practiced using the Flask framework by developing a basic web application, resulting in a 20% improvement in deployment time and a deeper understanding of web development concepts

EDUCATION

MASTER OF COMPUTER APPLICATIONS

VVIET - Mysore, KA September 2024

Relevant Coursework: Data Analysis in Python, Internet of Things (IoT), Database Management Systems (DBMS), Data Structures and Algorithms

BACHELOR OF COMPUTER APPLICATIONS

SDM College - Ujire, KA June 2019 - September 2022

Relevant Coursework: Python, Internet of Things (IoT), Database Management Systems (DBMS), Data Mining