Our Story of Team 4
Welcome to Group 4 Section Jayapura Independent Study PT Revolusi Cita Edukasi. Find out our story in building a capstone project where we are a business data analytics group for a Vending Machine company.
Dashboard
Background Brunswick Square Mall
Brunswick Square mall is a single story shopping mall located in East Brunswick, New Jersey, at the intersection of Route 18 and Rues Lane. This mall has a strategic location where pedestrians pass every day of the week. Brunswick Square Mall is the right choice if you want to spend time with your family because the facilities provided are family friendly and this mall is a suitable destination for all ages. Not only that, Brunswick Square Mall also provides free parking and access to get there can be done using public transportation. Brunswick Square Mall also provides two vending machines, namely BSQ Mall x1364 - Zales & BSQ Mall x1366 - ATT. Even though its position is profitable, revenues at the Brunswick Square Mall were relatively lower for the year in 2022 when compared to vending machines in other public places.
Project Background
Increasing average revenue peaks in Juni
Increasing revenue shows an uptren
| PROBLEM STATEMENT | How to increase the average vending machine revenue by 5% at Brunswick SQ Mall, from January 1, 2023 to June 30, 2023? |
|---|
Conclusion
- Adding variety without considering customer preferences can increase the risk of low demand and stock wastage.
- Poland spring water occupies the first position in the most popular products because consumers are looking for healthier beverages with a natural filtered spring water source.
- Affordable pricing is much sought after by consumers because it allows consumers with various income levels and financial priorities to access the products they need or want.
- The availability of various payment methods in vending machines attracts consumers who prefer to use credit due to user-friendliness and the ease and speed of transactions. Credit payment methods account for 54% of the total, which is a larger share compared to cash payments, which reach 46%.
Recommendation
- Conduct further market research to understand more specific consumer preferences and trends.
- Offer sales strategies such as discounts for popular products during certain periods.
- Place affordably priced products in easily accessible positions to optimize inventory, which should always be available in sufficient quantities.
- Introduce credit payment methods to reach different types of consumers and diversify through QR codes, mobile banking, virtual accounts, and e-wallets.
About Us
About Team 4
We are Team 4 data analytics Section Jayapura PT Revolusi Cita Edukasi dedicated to exploring the meaning of every data point. With a rigorous approach and sophisticated algorithms, we turn raw data into valuable insights for your business. We believe that hidden within every dataset is great potential, and we are committed to helping you unlock it for greater success.
Business understanding
March 6 2024 - March 21 2024
Determine the problem statement for a capstone project aimed at increasing the average vending machine revenue by 5% at Brunswick SQ Mall, from January 1, 2023 to June 30, 2023 Analyze the background and main causes of the current sales situation.
Data Cleaning
26 Maret 2024 - 4 April 2024
Cleaning data in the Spreadsheet to tidy up and correct the data to be performed by the analyst. The result is data that is ready to use after checking for duplicates, missing values, and outliers by category and average Rprice with standard deviation and IQR.
Data Analyst
April 4-April 17 2024
Data Analysts interpret data to support business decisions by analyzing patterns and trends from various sources, and using queries to strengthen arguments in decision making.
Data Visualization
April 17, 2024 – April 19, 2024
Creating and designing displays of analyzed data to facilitate communication between related parties. Data visualization provides useful information for business purposes, where decision makers can easily see and understand the company's work.
Data Communication
19 April 2024
Create and select data on slides to show the results of data analysis in the decision-making process in an easy-to-understand manner for relevant stakeholders as a basis for strengthening business decision-making arguments.
MEET OUR GREAT TEAM
A team called Team 4 - Jayapura which consists of 13 people from various different divisions
Reyhan Fahrezi M
Project Leader DA
&
Deployment Team
Ghozi Abdullah
Project Leader SE
&
Data Communication
Intania S Kirana
Data Visualization
&
Front End Engineering
Qalbi Karunia
Data Cleaning
&
Front End Engineering
Alyatisa
Data Communication
&
Front End Engineering
Naufal Nurrohmat
Data Cleaning
&
Front End Engineering
Dimas Agustia S
Data Analyst
&
Front End Engineering
Lydia Yuliantika
Data Visualization
&
Pitch Deck Team
Hilary Gita Wangi
Data Analyst
&
Pitch Deck Team
Ifah Fatmawati
Data Cleaning
&
Pitch Deck Team
M Alid Rizky Ma`Aly
Data Analyst
&
Quality Assurance
Anisa Rahmawati
Data Visualization
&
Quality Assurance
Hailar Kharisma Z
Data Communication
&
Quality Assurance