Data Quality : Bank Consumer Database

Discovering whether data are of acceptable quality is a measurement task and not a very easy one. In this data quality project, I used excel and python to deal with Consumer Complaint Database, complaints about financial products and services.Data quality is important because, without high-quality data, you cannot understand or stay in contact with your customers.…

Optimization Problems and Advanced Excel

Scenario 1 : A company is taking bids on four construction jobs. Three contractors have placed bids on the jobs. Their bids (in thousands of dollars) are given in the table below. (A dash indicates that the contractor did not bid on the given job.) Note: Contractor 1 can do only one job, but contractors 2…

Optimization and Simulation : Decision Model

For the practical use of supply chain management powerful planning tools are needed to support production and logistics decisions at various planning levels. Instead of using an off-the-shelf planning tool, the company decided to develop its own linear programming based optimization model. Scenario 1: Empire State Ski Products makes downhill and cross- country skis. A…

Digital Taste : User Behavior Analysis

Increasingly, people are replacing soft drinks with natural fruit juices, since soft drinks usually contain excessive sugar and little nutrition. This project introduces a multimodal digital taste control system ‘D’Licious Vessel’ and the respective prototypes. The goal is to provide a digital solution to health concerns regarding overuse of sugar in our daily drinks by…