Skip to content

sanamkandar/CONSUMER-COMPLAINT-ANALYSIS-EXCEL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 

Repository files navigation

CONSUMER-COMPLAINT-ANALYSIS-EXCEL

Analyzed consumer complaints dataset where it has 1400+ complaints from different companies with their issues, dates when complaints are logged and resolution period from which state, complaints are logged from multiple mediums.

  1. Data manipulation using functions
  2. Worked with dates data (calculated resolution time , categorization dataset into qtr. 3: Reporting - Create a report (Summarize the data at Company level)
  • total number of complaints
  • the timely response
  • complaints disputed
  • Average delay
  1. Interactive Dashboard - showed KPIs, proportion complaints by different products, month seasonality, pareto analysis.

🛠 Skills

Reporting & Analysis · Excel Dashboards · Microsoft Excel

Screenshots

App Screenshot

🚀 About Me

I'm an aspiring Data Analyst with a strong foundation in data manipulation and statistical analysis. I thrive on uncovering insights that drive decisions and am passionate about learning.

As a Data Analyst, I specialize in transforming raw data into clear, impactful insights using Python, SQL, and visualization tools like Matplotlib and Power BI. My educational background includes a Post Graduate Diploma in Business Administration in Finance, and I'm currently pursuing a Data Science program at AnalytixLabs.

My technical skills encompass Python, SQL, Statsmodel, and various statistical techniques, with a focus on machine learning libraries like Scikit-Learn and TensorFlow. I'm dedicated to turning data into compelling stories that influence business outcomes.

🔗 Links

linkedin

About

Excel consumer complaint project

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published