Skip to content
View kapasrilakshmi075's full-sized avatar

Block or report kapasrilakshmi075

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
kapasrilakshmi075/README.md

👋 Hi, I'm Kapa Sri Lakshmi

📊 Aspiring Data Analyst | SQL | Excel | Power BI | Python

🎓 Final-Year B.Tech Computer Science & Engineering Student
🏫 Mohan Babu University | 2023–2027
📍 India
🔎 Open to Data Analyst Internships & Full-Time Opportunities


👩‍💻 About Me

I'm a final-year B.Tech Computer Science and Engineering student focused on building my career as a Data Analyst.

I enjoy working with data to clean, analyze, visualize, and transform it into meaningful insights that support data-driven decision-making.

I have been developing my practical skills through hands-on projects using Excel, SQL, Power BI, and Python with real-world datasets.

I'm currently strengthening my analytical, visualization, SQL, and business problem-solving skills while building my Data Analytics portfolio.

🎯 Career Goal

To start my career as a Data Analyst where I can use data to identify trends, generate meaningful insights, build dashboards, and support better business decisions.


🛠️ Technical Skills

📊 Data Analytics

  • Data Cleaning
  • Data Transformation
  • Exploratory Data Analysis (EDA)
  • Data Visualization
  • KPI Analysis
  • Trend Analysis
  • Business Insights
  • Dashboard Development

📗 Microsoft Excel

  • Data Cleaning
  • Formulas & Functions
  • XLOOKUP
  • VLOOKUP
  • Conditional Formatting
  • Data Validation
  • Pivot Tables
  • Pivot Charts
  • Slicers
  • Power Query
  • Interactive Dashboards

🗄️ SQL

  • SELECT
  • WHERE
  • ORDER BY
  • GROUP BY
  • HAVING
  • Aggregate Functions
  • JOINs
  • CASE Statements
  • Subqueries
  • CTEs
  • Window Functions
  • Date Functions
  • String Functions
  • Data Aggregation
  • Business Analysis Queries

📈 Power BI

  • Data Import
  • Power Query
  • Data Cleaning
  • Data Transformation
  • Data Modeling
  • DAX Basics
  • KPI Cards
  • Interactive Dashboards
  • Charts & Visualizations
  • Slicers & Filters
  • Business Insights

🐍 Python for Data Analysis

  • Python
  • Pandas
  • NumPy
  • Matplotlib
  • Seaborn
  • Data Cleaning
  • Exploratory Data Analysis
  • Data Visualization

🐘 Database

  • PostgreSQL
  • pgAdmin 4

🔧 Tools

  • Git
  • GitHub
  • Google Colab
  • Jupyter Notebook

📊 Data Analytics Projects

🛒 E-Commerce Sales Analytics Dashboard

Tools: Microsoft Excel

  • Cleaned and analyzed e-commerce sales data.
  • Created important business KPIs.
  • Used Pivot Tables and Pivot Charts for analysis.
  • Created interactive dashboards using slicers.
  • Analyzed sales, profit, products, categories, and regions.
  • Generated meaningful business insights from the dataset.

🔗 Project:
https://github.com/kapasrilakshmi075


👥 HR Analytics Dashboard

Tools: Microsoft Excel

  • Analyzed employee and attrition data.
  • Created an interactive HR Analytics dashboard.
  • Calculated important HR KPIs.
  • Analyzed employee count, attrition, salary, and age.
  • Used Pivot Tables, charts, and slicers.
  • Identified patterns related to employee attrition.

Key KPIs

  • Total Employees
  • Attrition Count
  • Attrition Rate
  • Average Salary
  • Average Age

🔗 Project:
https://github.com/kapasrilakshmi075


📈 Sales Trend Analysis

Tools: Python, Pandas, Matplotlib

  • Cleaned and explored sales data.
  • Performed exploratory data analysis.
  • Analyzed sales trends over time.
  • Identified patterns and business trends.
  • Created visualizations to understand sales performance.
  • Generated insights from the dataset.

🔗 GitHub Repository:
https://github.com/kapasrilakshmi075/DataXLabs_Task6_Sales_Trend_Analysis


🌸 Iris Exploratory Data Analysis

Tools: Python, Pandas, NumPy, Matplotlib, Seaborn

  • Performed exploratory data analysis on the Iris dataset.
  • Cleaned and explored the dataset.
  • Analyzed relationships between different features.
  • Created data visualizations.
  • Identified patterns and distributions in the dataset.

🔗 GitHub Repository:
https://github.com/kapasrilakshmi075/DataXLabs_Task5_Iris_EDA


🏠 Airbnb Data Analysis

Tools: Excel, Python

  • Worked with Airbnb listing data.
  • Performed data cleaning and preprocessing.
  • Analyzed listing and pricing information.
  • Explored patterns and relationships within the dataset.
  • Generated insights from the data.

🔗 GitHub Profile:
https://github.com/kapasrilakshmi075


📱 Google Play Store Data Analysis

Tools: Python, Pandas

  • Cleaned and analyzed Google Play Store data.
  • Explored app ratings, reviews, categories, and installations.
  • Identified patterns in app performance.
  • Performed exploratory data analysis.
  • Generated insights from app-related data.

🔗 GitHub Profile:
https://github.com/kapasrilakshmi075


📈 Power BI Projects

🛍️ Superstore Sales Dashboard

Tools: Power BI, Power Query, DAX

  • Analyzed Superstore sales data.
  • Created KPI cards.
  • Built interactive visualizations.
  • Analyzed sales, profit, categories, and regions.
  • Used filters and slicers for interactive analysis.
  • Designed a business-focused dashboard.

🔗 GitHub Repository:
https://github.com/kapasrilakshmi075/PowerBI-Superstore-Sales-Dashboard


🗄️ SQL Projects

👨‍💼 Employee Management System

Tools: PostgreSQL, SQL

  • Created a relational database for employee information.
  • Created and populated database tables.
  • Used SQL queries for data retrieval and analysis.
  • Practiced filtering and aggregation.
  • Used JOINs and subqueries.
  • Solved practical business-related SQL questions.

🔗 GitHub Profile:
https://github.com/kapasrilakshmi075


📚 Library Management System

Tools: PostgreSQL, SQL

  • Designed a relational database for library management.
  • Created tables for books, members, and transactions.
  • Used SQL queries to analyze library data.
  • Practiced JOINs, GROUP BY, aggregate functions, and subqueries.
  • Solved practical SQL problems.

🔗 GitHub Profile:
https://github.com/kapasrilakshmi075


📊 Data Analytics Workflow

        Raw Data
            ↓
    Data Collection
            ↓
      Data Cleaning
            ↓
   Data Transformation
            ↓
 Exploratory Data Analysis
            ↓
   Data Visualization
            ↓
 Dashboard Development
            ↓
   Business Insights
            ↓
Recommendations / Decisions

Popular repositories Loading

  1. E-Commerce-Sales-Dashboard E-Commerce-Sales-Dashboard Public

    Interactive Excel Dashboard using Pivot Tables, Charts, KPI Cards, Slicers, and Business Insights.

  2. HR-Analytics-Dashboard HR-Analytics-Dashboard Public

    HR Analytics Dashboard built in Microsoft Excel using Pivot Tables, KPI Cards, Charts and Slicers.

  3. Personal-Finance-Dashboard Personal-Finance-Dashboard Public

    Personal Finance Dashboard built in Microsoft Excel using Pivot Tables, KPI Cards, Charts and Slicers.

  4. Employee-Management-System-SQL Employee-Management-System-SQL Public

    SQL Mini Project using PostgreSQL and pgAdmin 4

  5. Library-Management-System Library-Management-System Public

    PostgreSQL-based Library Management System showcasing database design, SQL queries, joins, views, triggers, and stored procedures.

  6. Student-Management-System-SQL Student-Management-System-SQL Public

    Student Management System using PostgreSQL