Deepthi G Das

Data Analyst

[email protected]

Hello, I am

Deepthi G Das.

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

About Me

I am a healthcare professional with growing experience in the field of Data Analysis, data visualization, healthcare business operations, and creative writing.

Below, you’ll find projects I’ve worked on using tools like Excel, SQL, and Power BI. You can also explore my experience section for a detailed overview of my work history. Feel free to connect with me on LinkedIn or drop me a message via e-mail—I’m always open to a conversation!

Key Skills

SQL

Excel

Power BI

My Projects

Sales & Finance Analytics

Domain/Function: Sales & Marketing

Business 360 Insights

Domain/Function: Business Intelligence

Hospitality Domain Project

Domain/Function: Hospitality/Service

Revenue Analysis - Movie Industry Insights

Domain/Function: Finance

Insurance Analysis

Domain/Function: Insurance

My Experience

With 6 years of experience in the healthcare industry, including U.S. healthcare settings, I specialize in data analysis, healthcare business operations and data management.

Gained 6 months of hands-on experience in analyzing and interpreting complex datasets during my internships at AtliQ Technologies and KultureHire as a Data Analyst.

I have conducted variance analysis, ad-hoc analysis, exploratory data analysis, and statistical analysis using Excel, optimized SQL queries, performed data extraction and cleaning using Power Query, and utilized Power BI to create interactive dashboards for data visualization.

I’ve also worked on 8+ business projects across sales, finance, hospitality, insurance, & business domains handling datasets with over a million records.

Work History:

Previously, I spent over four years in healthcare operations, managing healthcare IT systems at Cognizant Technology (Sep 2022 - 2024) and collaborating with healthcare providers to resolve unclear documentation, which led to a 30% reduction in documentation queries and improved data accuracy. Prior to that, as a self-employed healthcare professional (Dec 2018 - Sep 2022), I successfully ran a newly established clinic, where I introduced a patient feedback system, increasing patient referrals by 20% in the first year. Additionally, I identified data inconsistencies and developed a staff training initiative, reducing errors by 30% in just three months.

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.

Mail Me

[email protected]

https://www.linkedin.com/in/deepthi-g-das

GitHub

https://github.com/DeepthiGDas

Excel Project

Sales & Finance Analytics

Domain/Function: Sales & Marketing

Developed Sales Performance & Finance reports to analyze sales trends, compare market performance with sales targets, track key metrics, and analyze financial performance. This helped improve decision-making and resource allocation using data insights.

View Project
Engagement

View Project
on GitHUB

Profit & Loss (P&L) report by Fiscal years to evaluate financial performance using key metrics such as Net sales, COGS, Gross Margin, & Gross margin%.

Market performance report by Fiscal year to compare market trends with sales targets.

Project Details

In this project, I created Sales Performance and Profit and Loss (P&L) reports to analyze customer performance, compare market trends with sales targets, and evaluate financial outcomes. Leveraging Power Query, Power Pivot, and DAX, I organized and analyzed data to identify key trends and track metrics. This experience sharpened my technical skills in understanding P&L statements and optimizing report generation, highlighting the role of data-driven reports in informed decision-making and business success.

Key learnings:
- Mastered ETL processes for clean, reliable data.
- Built data models for deeper analysis.
- Enhanced Power Query for advanced date table reporting.
- Utilized Power Pivot for insights.
- Developed sales analytics reports, supporting growth.
- Improved understanding of P&L dynamics, informing finance strategies.

PowerBI Project

Business 360 Insights

Domain/Function: Business Intelligence

This project focuses on enhancing knowledge of the e-commerce and brick-and-mortar platforms while building key technical skills in Power BI for data analysis and decision-making. Through hands-on experience, the project covers crucial areas such as finance, sales, marketing, and supply chain.

View Project
Engagement

Other Tools

Excel

MySQL

This Finance View displays net sales over time, top/bottom customers, key metrics in a P&L statement, & includes slicers and page navigation.

The Executive View provides a high-level overview with dynamic charts, visuals, including revenue breakdowns and insights into market share.

Project Details

Using Power BI, interactive dashboards for the homepage, finance view, sales view, marketing view, supply chain view, and executive views were created. These dashboards provide comprehensive insights into key business metrics, allowing for data-driven decision-making. Alongside technical skills in dashboard creation and data visualization, I developed essential soft skills, including stakeholder management and effective communication, ensuring that insights are clearly conveyed and actionable for strategic decisions. This combination of skills contributes to a holistic understanding of business performance and data analysis.

Key Learnings:
- Mastering Power Query: From Basics to Advanced Operations
- Data Modelling using Star & Snowflake Schemas
- Advanced DAX Formulas: From Basic Calculations to Complex Logic
- Analyzing Key Metrics: Sales, Marketing, Finance & Supply Chain
- Incorporating Stakeholder Feedback for Continuous Improvement

Live Interactive Dashboard

PowerBI Project

Hospitality Domain Project

Domain/Function: Hospitality/Service

The project focus is on analyzing the revenue trends of a hotel over a 3-month period. The project involves collecting and processing data on room bookings, revenue generated, occupancy rates, and other key financial indicators.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Dashboard illustrating all the key business metrices in tables, line charts, KPI cards, donut charts with slicer representing cities and room class.

Different properties with their respective key metrics in a table visual with conditional formatting applied to average rating & revenue.

Project Details

Performed analysis of hotel revenue data to assess financial performance and identify key trends. The project involves collecting data on room rates, bookings, occupancy, and total revenue. Created several Dax measures for calculating average daily rate (ADR), revenue per available room (RevPAR), occupancy percentage, and several other key metrices to evaluate the hotel's profitability and operational efficiency. The goal was to provide data-driven insights into seasonal trends, peak booking periods, and strategies to improve revenue management for the hotel industry.

Key learnings:
- Created over 30 DAX measures to compute key financial metrics like ADR, RevPAR, occupancy rate etc.
- Seasonal and Trend Analysis of revenue
- Profitability & Operational Efficiency Insights
- Dashboard Design & Visualization:

Live Interactive Dashboard

SQL Project

Revenue Analysis - Movie Industry Insights

Domain/Function: Finance

This project involved analyzing box office data to uncover revenue insights within the movie industry. Using SQL, I worked with a dataset containing movie titles, budgets, revenues, & production details to calculate profit margins, compare performance across genres, and identify top-grossing films.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Common Table Expression [CTE] to find all 'Hollywood' movies released after the year '2000' that made '500 million $' profit or more.

SQL query that uses a CASE statement & a JOIN clause to retrieve financial information about Bollywood movies from 2 tables: movies and financials.

Project Details

Key aspects of this project included utilizing SQL queries to join multiple tables, perform aggregation, and filter data based on criteria such as industry type (e.g., Bollywood, Hollywood), while handling various financial units (Thousands, Billions). The project provided actionable insights into movie profitability and industry trends.

Key learnings:
🔹 SQL Basics: SELECT, WHERE, BETWEEN, GROUP BY, ORDER BY, etc.
🔹 Joins: LEFT, RIGHT, INNER, FULL, CROSS
🔹 Subqueries, CTEs, Views, Temporary Tables
🔹 ETL Fundamentals: Data Warehouse, OLAP, OLTP
🔹 User Defined Functions, Stored Procedures
🔹 Window Functions: OVER, ROW_NUMBER, RANK, DENSE_RANK, etc.
🔹 Real Dataset Project: >1 million records with industry-style learning

PowerBI Project

Insurance Analysis

Domain/Function: Insurance

The project showcases an in-depth performance analysis of the fictional Shield Insurance company. The interactive Power BI dashboard delivers key metrics that provide valuable insights into sales, customer base, & revenue growth, helping businesses make data-driven decisions to optimize performance.

View Project
Engagement

View Project
on GitHUB

General view with all the 4 major KPIs and their breakdowns illustrated with the help of table and line chart visuals.

Age group Analysis View showcasing the revenue and customer performance for specific age groups.

Project Details

This project offers a performance overview of "Shield Insurance," leveraging data insights to enhance business decisions and customer strategies. The dataset includes variables such as city, sales mode, and age groups, allowing for detailed exploration of customer demographics and revenue patterns. The dashboard comprises three main views: a General View with revenue and customer distribution across regions, a Sales Mode View that analyzes customer sales channel preferences, and an Age Group Analysis View that examines revenue contributions by age segments. Visualizations include bar charts, line graphs, and tables, offering a clear, data-driven understanding of key performance indicators.