Hands-On Project

These are the 5 projects that we cover in this course:

Decision Support Using Excel Scenario Manager

The objective of this project is to gather data, perform analysis, and compare results across various business scenarios using Excel's Scenario Manager. Our goal is to leverage this tool to gain insights and make informed comparisons in different business situations based on the collected data.

Data Visualization Using Tableau & GIS

Tableau empowers individuals and organizations to embrace a data-driven approach. In the scope of this project, our objective is to condense the analysis into a visually appealing dashboard. Utilizing a minimum of four distinct chart types, we will compile a comprehensive report featuring data analysis, noteworthy observations, and conclusive insights, presented through screenshots from Tableau.

Linear Optimization using Excel Solver

Solver is an Excel add-in program designed for conducting what-if analyses. Among my preferred projects, this one stands out as I have the opportunity to utilize Solver to optimize the maximum profit in manufacturing golf clubs for the company. It allows me to explore various scenarios and determine the most profitable approach.

Systems Dynamics Simulation Modeling using Simile

As part of this project, our task is to build a dynamic simulation model for Personal Finances using Simile software. The model will incorporate various sources of income and expenses, representing a long-term period of life activities. It should include at least two compartments and incorporate an interest rate. Additionally, we are required to create effective visualization tools within the Model, Debug mode, such as different types of charts and tables.

In terms of my personal objective for this project, I aimed to save money for my first house. Based on the simulation, it appears that it will take approximately four years to accumulate $20,000, which will serve as the down payment for my desired property.

Data Mining using IBM SPSS Modeler

In this project, our task is to identify two items that exhibit the highest confidence, indicating a strong association between them. We will also determine the combination that demonstrates the highest support. Additionally, we need to analyze the types of sales that are most beneficial for Music CDs and identify the optimal timing for selling Gift Cards. Furthermore, we will identify the item with the highest refund rate and the item with the highest sales volume. Lastly, we will provide recommendations on how to enhance sales for the cafe, suggesting strategies for improvement.

Lay Wah, MN