Hi,

I'm Purushotham, a Data Analyst

has a passion for converting data into Actionable Insights. I specialize in leveraging the power of data analytic tools and technologies to solve challenging business problems and drive Informed Decision-Making.

About Me

I am an experienced Data Analyst who is committed to transforming raw data into actionable insights. Having good knowledge of technologies such as MS-Excel, MySQL, and Power BI allows me to identify patterns and trends in data by creating visualizations.

Master's degree in business administration and internship experience enables me to provide a fresh perspective to company difficulties while defining appropriate KPI's.

I am good in data cleansing, data modelling, data processing, and data visualization, as evidenced by my accomplishments in both autonomous and collaborative projects. I feel exited when working as part of a team and passionately believe in the potential of collaboration to overcome complex data issues and generate innovation.

Now in 2024, I’m excited to be taking on a new challenges with an amazing company to identify business problems and help entrepreneurs build successful businesses. 

Skills & Tools

MS - Excel
  • Arthematic functions (SUM, AVG, MIN, MAX, COUNT, etc,.)
  • Text Functions & Date and Time functions
  • LOOKUP functions (VLOOKUP, HLOOKUP, XLOOKUP)
  • Conditional formatting
  • Data Cleaning and Validation
  • PivotTables and PivotCharts
  • Power Query editor
My SQL
  • SQL Basics: DDL, DQL, DML, DCL, and TCL
  • Joins: Inner Join, Right Join, Left Join, and Cross Join
  • CTE's and Sub-Queries
  • Window Functions: RANK, DENSE_RANK, and ROW_NUMBER, LEAD, and LAG
  • Operators, Text functions, Numeric Functions, Date & Time Functions
Power BI
  • Data loading, Transforming, and ETL
  • Data Modelling 
  • Data Visualization and Report generation
  • Data Analysis Expressions (DAX)
  • Measures and Calculated Columns
  • Power BI Service and Managing Roles
  • Row Level Security (RLS)
Python
  • Basics of Python: 
    • Data Types
    • Text Functions
    • Aggregate Functions
    • Conditional Statements
    • Loops
    • Lists
    • Tuples

Education

Sri Venkateswara University

August 2019 - October 2021

Full- Time

Master's of Business Administration (Marketing, HR)

Sri Krishnadevaraya University

June 2016 - April 2019

Full- Time

Bachelor of Commerce (Computer Applications)

Work Experience

PwC Switzerland Power BI Job Simulation on Forage

January 2024

Virtual Case

Remote

  • Completed a job simulation where I strengthened my PowerBI skills to better understand clients and their data visualisation needs.
  • Demonstrated expertise in data visualization through the creation of Power BI dashboards that effectively conveyed KPIs, showcasing the ability to respond to client requests with well-designed solutions.
  • Strong communication skills reflected in the concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis.
  • Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at the executive management level, highlighting a commitment to data-driven decision-making. 
Ai Variant

March 2023 - November 2023

Intern

Remote

  • Have been working with an motivated team size of 6 pepole
  • Each one of us have been performing different tasks to get work done on time without any delays
  • As my role includes cleaning of data using excel and power query editor and then share it with the team.
  • For verifying the KPI's that have been created by them I'm responsible in write MySQL queries
  • I'm also responsible for managing roles and restricting the data in Power BI service
Zolostays Property Solutions Pvt. Ltd

April 2022 - June 2022

HR Associate

Bangalore, KA

  • Worked as a reliable and dedicated team member in the HR department having team size of 6 members
  • Achieved daily, weekly, and monthly targets to improve the team efficiency
  • Updating the firm database with 1000’s of candidate details and utilized them for analysis when required
  • Collaborated with other team members and Increased productivity by 25%

Projects

Health Care Analysis

Defining some key performance indicators (KPIs) to assist hospitals, dialysis facilities, and chain organizations in making decisions.Number of Patients across various summaries

  • Profit Vs Non-Profit Stats
  • Chain Organizations w.r.t. Total Performance Score as No Score
  • Dialysis Stations Stats
  • # of Category Text - As Expected
  • Average Payment Reduction Rate
Call Centre Trends

Aim is to build a dashboard in Power BI for Client that reflects all relevant Key Performance Indicators (KPIs) and metrics in the dataset.

Possible KPIs include (to get you started, but not limited to):

  • Overall customer satisfaction
  • Overall calls answered/abandoned
  • Calls by time
  • Average speed of answer
  • Agent’s performance quadrant -> average handle time (talk duration) vs calls answered
Customer Retention Analysis
  • The aim is to create a Power BI report that the retention manager can readily understand. 
  • To do this, I used filters, DAX measures, calculated columns, and several types of graphs and charts.
  • Helped the retention manager to develop a better understanding of customers and the reasons for retention.

Pizza Order Analysis

The goal is to monitor pizza outlets' orders and sales depending on many characteristics such as pizza size, pricing, category, and so on.
Applied so many filters and also important possible KPI's as such

  • Total Sales & Number Orders
  • Total Quantity ordered
  • Total Revenrue Generated
  • Average Price Per Order
  • Monthly Wise Sales Analysis
HR Attrition Analysis
  • The aim is to create a Power BI report that the HR manager can readily understand about attrition rate based on different filters. 
  • To achieve this, I used filters, DAX measures, calculated columns, buckets and several types of graphs and charts.
  • Helped the manager to understand the report in an easiest way possible and helps to make informed decessions.

Certificates

  • IBM
  • PWC

Contact Me

Built with Dorik