Manisha Senapati

Data Analyst/ BI Developer

[email protected] +91 7780365251

Resume

Hello, I am

Manisha Senapati.

1

Excel
Project

4

PowerBI
Projects

1

SQL
Project

About Me

Hey there, Welcome to my Portfolio! I'm Manisha, I am a passionate Data Analyst with a knack for transforming raw data into actionable insights. With a strong foundation in MySQL, an advanced skillset in Power BI, and Microsoft Excel. I thrive on the challenge of making data not just understandable but also impactful. My journey in the world of data analysis has been all about turning complex datasets into visually appealing and informative dashboards. I take pride in my ability to uncover hidden patterns, trends, and opportunities that drive informed decision-making.

Key Skills

Stakeholder management

Effective Communication

SQL

PowerBI

Excel

Adaptibility

My Projects

Sales Analytics(FMCG)

Domain/Function: Sales and Finance

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Business Analytics

Ad-hoc Insights (Consumer Domain)

Domain/Function: Consumer Goods-Executive Management

Electric Vehicle sales Analysis

Domain/Function: Automotive

Customer Retention: Unveiling Demographics and Insights

Domain/Function: HR Analytics

Healthcare Dataset- Patients Waitlist Analysis

Domain/Function: Hospitality Analysis

My Experience

Data Analyst Intern I AtliQ Technologies July 2024- Present

● Debugged and corrected SQL queries to ensure accurate data extraction from MySQL workbench.

● Performed data variance analysis to identify discrepancies between benchmark and current data (order quantity, delivery quantity).

● Created two reports showcasing insights on the telecom industry and insurance sector, focusing on revenue, KPIs, and customer trends. Presented findings using PowerPoint.

Data Analyst Intern I Technohacks Edutech Jan 2024 - June 2024

● Conducting in-depth data analysis utilizing SQL, proficiently managing data extraction, transformation, and loading processes to extract meaningful insights.
● Leveraging Excel for advanced data manipulation and analysis, employing functions and tools to uncover patterns, trends, and anomalies within datasets, contributing to data-driven decision-making.
● Designing and developing dynamic dashboards in Power BI, creating visually impactful representations of complex datasets to facilitate effective communication of insights to stakeholders.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Google Data Analytics Professional Certification

PwC Switzerland Power BI Job Simulation

Introduction to Data Analytics

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/manishasenapati/

Call Me

+91 7780365251

GitHub

https://github.com/ManishaSenapati27

Excel Project

Sales Analytics(FMCG)

Domain/Function: Sales and Finance

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Business Analytics

This Power BI project focuses on unlocking critical business insights by visualizing key performance metrics such as sales trends, financial health, customer behavior, and market dynamics. It empowers stakeholders to make informed decisions, optimize strategies through data-driven analysis.

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project
1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics.

Live Interactive Dashboard

SQL Project

Ad-hoc Insights (Consumer Domain)

Domain/Function: Consumer Goods-Executive Management

AtliQ Hardwares, a leading computer hardware producer in India with global reach, lacks sufficient insights for quick, data-informed decisions. The management identified critical ad-hoc requests needing insights. SQL queries were executed to address these requests and visualize the findings.

View Project
Engagement

View Project
on GitHUB

In the APAC region, our Exclusive store has solidified its position in 8 key markets.

Retailers accounted for 75% of total sales, whereas Direct and Distributor channels contributed only a small percentage

Project Details

Handled 10 Unexpected SQL Tasks:
Managed a range of immediate SQL requests to help the company make better decisions. Gained a deeper understanding of important SQL concepts like Common Table Expressions (CTE), different ways to join data, and using window functions. Used these skills to work with and analyzed the database information.
Skillfully applying these concepts, I successfully transformed raw data into actionable insights, contributing to a more informed and strategic approach for the company's future endeavors.

PowerBI Project

Electric Vehicle sales Analysis

Domain/Function: Automotive

This project aims to comprehensively understand the landscape of electric vehicles (EVs), encompassing Battery Electric Vehicles (BEVs) and Plug-in Hybrid Electric Vehicles (PHEVs). Key performance indicators (KPIs) are identified to assess the market size, growth, and technological advancements.

View Project
Engagement

View Project
on GitHUB

Glimpse of my dashboard

Dashboard

Project Details

Key Performance Indicators (KPIs):
1)Total Vehicles:
Objective: Understand the overall market size and growth of electric vehicles.

2) Average Electric Range:
Objective: Determine the average electric range of EVs to assess technological advancements and efficiency.

3) Total BEV Vehicles and % of Total BEV Vehicles:
Objective: Identify and analyze the total number of BEVs, calculating the percentage relative to total EVs.

4) Total PHEV Vehicles and % of Total PHEV Vehicles:
Objective: Identify and analyze the total number of PHEVs, calculating the percentage relative to total EVs.

Live Interactive Dashboard

PowerBI Project

Customer Retention: Unveiling Demographics and Insights

Domain/Function: HR Analytics

Task was to create a dashboard that highlighted customer characteristics and behaviors contributing to retention. Through the power of Power BI, I constructed visuals that showcased the distribution of age groups, and purchasing patterns among loyal customers.

View Project
Engagement

View Project
on GitHUB

Customer Churn Dashboard

Customer Risk Dashboard

Project Details

Problem Statement : Analyze the customer retention dataset and provide insights that is helpful for the business to track and monitor their customer retention efforts in real time.

Here's a quick rundown of the steps I took in the project:
1️⃣ Data Preparation: Ensured the data was clean, organized, and ready for analysis.
2️⃣ Data Modeling: Structured the data for effective analysis using Power BI.
3️⃣ Data Analysis (DAX): Leveraged DAX functions to dig deep into the numbers.
4️⃣ Data Visualization (Dashboard): Created visually compelling dashboards to make complex data easily understandable.
5️⃣ Insights: Unearthed some fascinating findings!

Live Interactive Dashboard

PowerBI Project

Healthcare Dataset- Patients Waitlist Analysis

Domain/Function: Hospitality Analysis

This dataset is an publicly available dataset of patients waitlist. This dataset contains two types of data categories: 1) Inpatient Data : A patient who stays in hospital while under treatment. 2) Outpatient data: A patient who receives medical treatment without getting admitted to hospital.

View Project
Engagement

View Project
on GitHUB

Summary Page: An overview of critical metrics, providing a snapshot of the patients' waitlist landscape.

Details Page of Granular Analysis: A deep dive into specialty-level and age profile analyses, offering nuanced insights for targeted improvements.

Project Details

Overall Objectives - Project Goals:
1️⃣ Track Current Status: This project enables real-time tracking of patients' waitlists, providing healthcare professionals with up-to-the-minute information to make informed decisions.
2️⃣ Analyze Historical Trends: Unveiling historical monthly trends in inpatient and outpatient categories sheds light on patterns, enabling proactive measures for improved patient care.
3️⃣ Specialty-Level and Age Profile Analysis: Granular analysis at the specialty and age levels empowers healthcare professionals with detailed insights for targeted interventions.

🚀 Steps Involved:
1) Requirement gathering
2)Data Collection
3) Transformation and Modelling
4)Data Visualization Blueprint
5) Dashboard design and Layout
6) Interactivity and Navigation
7)Testing and Publishing
8) Maintainance and Refresh