Project Title: Developing a Predictive Model on a Net Promoter Score to Improve Product Quality
BASIS Advisor: Ms. Liu
Internship Location: Cisco Systems
Onsite Mentor: Julia Zhu
In company management, products must be maximized and minimized in certain locations. My project addresses the importance of a net promoter score. A net promoter score is a scale—similar to rating system that is typically out of five stars—used to indicate to corporations which product should be maximized and where it ought to be implemented. With large corporations, they often lack the resources to conclude where to execute certain products, so they resort to their previous product. As time progresses, new products will inevitably set new trends. To help Cisco Systems Inc., where I will be completing my project, I will work with data scientists to efficiently calculate a net promoter score via python algorithms and effectively plot trends of these net promoter scores over a period of time. Through my project, I hope to further understand data science and help Cisco Systems with their Catalyst 3650 series—a networking switch which aids the travel of information from different parts of organizations to the desired location. This project is substantially important in keeping companies up-to-date with their products. As customers, we do not want to constantly use old, outdated products when there are new products being manufactured. Alerting corporations of the demand for certain products in specific locations is vital for company growth and prosperity.
My Posts
Week 10 – Creating Power Point + Documenting results
Apr 28, 2019
Hi all, During this week, I documented my results and started to create a power point presentation that illustrates my findings. I put all the non-cisco factors in a table with the amount it affected the NPS during a certain quarter. Similarly, I plotted some general data points on how to create the most efficient […]
Week 9 – finishing outlining
Apr 18, 2019
Hi all, This week, I finished outlining my research paper. My research paper will include data cleansing and the methods of documenting data, what a typical data science project entails, and a description of what the NPS is and helps accomplish. Additionally, it will contain a brief introduction to the Tableau software. Finally, the final […]
Week 8 – Starting Research Paper + documenting results
Apr 18, 2019
I have started to document all my results and findings. I have been able to pinpoint the non-Cisco factors that affect the net promoter score the most and have found the amount it changed the NPS. This week, I am going to start outlining my research paper, and the following week I will finish outlining […]
Week 7 – Analyzing causes
Apr 08, 2019
Hi all, In week 7, I analyzed what are some leading non-performance related factors that affect the NPS score. Some of these factors include the management systems, ease of use, managing contracts and ordering, renewing, and/or updating the products. In week 8, I will start to understand how the NPS changes over quarter 2 and […]
Week 6 – Plotting data points
Apr 01, 2019
Hi all, In week 6, I started to extract data from my data spreadsheet and started to plot the data on the Tableau Desktop application. I organized all the comments into categories and separated them by company and product type. I also calculated the actual Net Promoter Score, which I will be analyzing in the […]
Week 5 – Understanding the NPS data
Mar 24, 2019
Hi all, In Week 5, I worked with Dr. Ibraimova to further understand the data for the net promoter score I calculated for a Cisco product. I have been extensively working in Tableau – a program that allows me to plot my data for the analysis in the Net Promoter Score. I will continue to […]
Week 4 – NPS Analyst
Mar 18, 2019
Hi, In week 4, I worked with an NPS Analyst and started to plot out the data to calculate the NPS for some Cisco products. After understanding how to create this NPS, I am learning how to organize comments into specific categories. I will spend most of my week 5 organizing the comments and […]
Week 3 – Data + Data cleansing
Mar 11, 2019
Hi, In week 3, I received the data from the networking switch series. I will spend the next couple of weeks trying to create a Net promoter score for the networking switches. For the data, I started to cleanse the data via python. Additionally, I worked with various data scientists to understand the primary use […]
Week 2 – Regular expressions and Tableau Reader
Mar 03, 2019
Hey guys, I started working on regular expressions, and I started to understand the mechanisms of Tableau reader – a tool that aids the calculation of the Net Promoter Score and allows for the visualization of data. I applied python regular expressions and chain of responsibility on a “regex.yaml” file. I refreshed on my python […]
Week 1 – understanding the Net Promoter Score
Feb 19, 2019
Hi! My name is Shreyas Melanahalli, and I am a senior at BISV. I have added my senior project abstract below: In company management, products need to be maximized and minimized in certain locations. This project addresses the importance of a net promoter score. A net promoter score is a scale – similar to a […]