Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

My Experience

Certificates

Contact

Kavya Rana

Kavya Rana

Data Analyst

[email protected]

Hello, I am

Kavya Rana.

1

Excel
Project

3

PowerBI
Projects

2

SQL
Projects

About Me

I’m an aspiring Data Analyst who has discovered a natural ability for turning data into actionable insights. While I haven’t worked in an organization as a data analyst yet, I’ve successfully completed several business projects that are showcased in my portfolio below.

With skills in Excel, Power BI, SQL, and Python, I’ve worked on real-world projects like ATLIQ Hardware's sales analysis, creating impactful dashboards and reports that help businesses make smarter decisions. My background in team management in the hospitality industry also gave me practical experience in process optimization and data-driven strategies.

I’m excited to bring my passion for data to a forward-thinking company and help unlock the potential hidden in their data. Let’s work together to drive success through insights!

My Projects

Excel-Sales-Analytics
Excel-Sales-Analytics

Domain/Function: sales analytics

Business-Insights-360
Business-Insights-360

Domain/Function: sales analytics

Hospitality Industry Analysis - Hotel Chain Business
Hospitality Industry Analysis - Hotel Chain Business

Domain/Function: Hospitality

Consumer Goods Ad hoc Insights
Consumer Goods Ad hoc Insights

Domain/Function: Consumer Goods

Wavecon 5G Analysis Project
Wavecon 5G Analysis Project

Domain/Function: Telecommunications and technology

Shield-Insurance
Shield-Insurance

Domain/Function: Insurance and Financial services

My Experience

    EXPERIENCE

    Junior Data Analyst Intern

    Fortray Global Services Ltd, London, UK Mar 2025 – Present

    • Engineered and optimized complex SQL queries, improving data extraction efficiency by 30% for business-critical analysis.

    • Performed data profiling and cleaning, increasing dataset accuracy by 25% to ensure reliable reporting.

    • Designed and automated reports and dashboards using Excel, Power BI, and Looker, reducing manual reporting time by

    40%.

    • Analyzed A/B testing results and presented actionable insights, contributing to a 15% increase in conversion rates.

    • Translated business requirements into technical solutions through data modeling and visualization, enhancing stakeholder

    decision-making speed by 20%.

    • Maintained data integrity and validation throughout ETL processes, achieving a 98%+ accuracy rate in cleaned datasets

    used for decision-making.




    PROJECTS:

    Consumer Goods Ad-hoc Insights Project [Power BI | SQL] - Oct 2024

    GitHub Link | Live DashboardVideo presentation

    o   Extracted and analyzed sales data using complex SQL queries for a hardware company.

    o   Designed interactive Power BI dashboards that enabled data-driven decision-making for senior management.

    o   Provided actionable insights, leading to a 15% improvement in decision accuracy.

    Business 360 - AtliQ Hardware [Power BI | SQL | Excel | DAX Studio] — Sep 2024

    GitHub Repo | Live Dashboard | Video presentation

    o   Customized a multi-functional Power BI dashboard consolidating sales data from Excel/CSV and SQL database.

    o   Built a data model and visualizations in Power BI, optimizing the report performance by 5% using DAX Studio.

    o   Enabled AtliQ Hardware to analyze sales trends, leading to a 20% reduction in data-related expenses.

     

    Hospitality Industry Analysis - Hotel Chain Business [Power BI | Excel] — Sep 2024

    GitHub Repo | Live Dashboard  | Video presentation

    o   Conducted market and competitor analysis, uncovering factors contributing to a 20% decline in revenue.

    o   Enhanced online booking platforms and digital presence, boosting online reservations by 30% while cutting booking abandonment rates by 20%.

    o   Executed strategic promotions, leading to a 10% rise in market share and revenue within six months.

     
    Wavecon 5G Analysis

      • Objective: Analysed 5G performance metrics to measure impact post-launch and ensure data accuracy.

      • Technology Used: Power BI, Excel, DAX.

      • Process: Created KPI reports, performed data cleaning and validation, and generated actionable insights for planning.

      • Result/Impact: Revealed a 25% increase in metrics post-launch with 100% validated data supporting strategic decisions.



Awards & Certificate

Google Data Analytics Professional Certificate

Google Data Analytics Professional Certificate

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.