Portfolio - Priya Raj

Priya Raj

Data Aspirant

3

PowerBI Projects

About Me

As a dedicated Data Analyst with a master's degree in Data Science, I possess a strong command of Excel, Power BI, SQL, and Python to extract valuable insights from data. Through a series of impactful business projects showcased in my portfolio, I have honed my analytical skills and demonstrated a track record of delivering tangible results. With a passion for transforming raw data into actionable strategies, I am committed to driving success in data-driven environments. Explore my portfolio below to witness the depth of my expertise

Key Skills

machine learning

python

sql

power bi

excel

data science

My Projects

CUSTOMER CHURN ANALYSIS

Domain/Function: Telecom firm

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

Domain/Function: Finance

Electric Vehicle Sales Analysis

Domain/Function: Automotive

My Experience

SYSTEM ENGINEER - TCS, BENGALURU -- JUL 2022 - PRESENT

Developed Power BI dashboard for service management with real time insights on ticket volumes, resolution time and customer satisfaction scores.
Created custom visual elements for data analysis platforms, improving report clarity and usability; designed features that reduced analysis time for team members
Served as Incident Manager, responsible for managing critical incidents.
Led cross-functional teams in identifying, prioritizing and resolving incidents in alignment with SLAs.
Collaborated with stakeholders to communicate incident updates and RCA.
Conducted post incident reviews to identify improvement areas and implemented corrective actions to enhance incident management process.

Awards & Certificate

Excel: Mother of Business Intelligence

Python: Beginner to Advanced For Data Professionals

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

SQL Beginner to Advanced For Data Professionals

Microsoft Certified: Power BI Data Analyst Associate

Microsoft Certified: Azure Data Scientist Associate

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/priyaraj-9y5k6/

GitHub

https://github.com/Priya9987

PowerBI Project

CUSTOMER CHURN ANALYSIS

Domain/Function: Telecom firm

This project is built to analyze customer churn rate by collecting and exploring relevant data points, including customer demographics and usage patterns. And built predictive models using random forest logistic regression to identify churn risk factors.

View Project
Engagement

View Project
on GitHUB

Designed a Power BI dashboard to showcase customer churn insights, including visualizations such as line charts and bar charts.

Built predictive models using random forest logistic regression to predict future churners

Project Details

In today's competitive business environment, customer retention is crucial. Churn analysis helps identify reasons for customer departures through data analysis and machine learning. By predicting at-risk customers and understanding their motivations, businesses can take proactive steps to improve satisfaction and loyalty, ensuring long-term success.Key components of the project:
1. ETL process in SQL Server
2. Data Cleaning in SQL Server
3. Power BI Transformations
4. Power BI Visualization & Enhancing Visuals
5. Building a Machine Learning Model - Random Forest in Jupyter Notebook
6. Visualizing Predicted Data in Power BI - Predicted Churner Profile
Project Goals:
- Visualize & Analyze Customer Data across various levels: Demographic, Geographic, Payment & Account Info, and Services.
- Study Churner Profile & Identify Areas for Implementing Marketing Campaigns.
- Identify a Method to Predict Future Churners.

Live Interactive Dashboard

PowerBI Project

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

Domain/Function: Finance

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights

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

PowerBI Project

Electric Vehicle Sales Analysis

Domain/Function: Automotive

AtliQ Motors, a top U.S. EV company with a 25% market share in North America, plans to enter India where its share is under 2%. Bruce Haryali, head of AtliQ Motors India, has commissioned a market study. The data analytics team must analyze it to guide the company’s expansion strategy.

View Project
Engagement

View Project
on GitHUB

Designed a Power BI dashboard to visualize electric vehicle sales in India, providing key insights and trends to support strategic decision-making and

Compares electric vehicle sales across different states in India, offering a detailed view of regional performance and trends to inform targeted mark

Project Details

Designed a Power BI dashboard to visualize electric vehicle sales in India, providing key insights and trends to support strategic decision-making and market analysis.
𝐊𝐞𝐲𝐰𝐨𝐫𝐝𝐬 -
1. Fiscal Year: The fiscal year is a one-year period used for financial reporting and budgeting, starting on April 1st and ending on March 31st of the following year in India.
2. Penetration Rate: This metric represents the percentage of total vehicles that are electric within a specific region or category. It is calculated as: Penetration Rate = (Electric Vehicles Sold / Total Vehicles Sold) * 100
This indicates the adoption level of electric vehicles.
3. Compound Annual Growth Rate (CAGR): CAGR measures the mean annual growth rate over a specified period longer than one year. It is calculated as: CAGR = [(Ending Value / Beginning Value) ** 1/n] -1