Data Visualization in Marketing and Sales Department

Widi, Annelies Nafisa (2023) Data Visualization in Marketing and Sales Department. Other thesis, Institut Teknologi Sepuluh Nopember.

Text 05211942000011-Undergraduate_Thesis.pdf - Accepted Version Restricted to Repository staff only until 1 September 2025. Download (2MB) | Request a copy

Abstract

Makalah ini menguraikan tugas, perkembangan, dan hasil magang di Departemen Pemasaran & Penjualan DAF Trucks N.V. Proyek magang kelulusan dilakukan oleh Annelies Nafisa Widi, seorang mahasiswa ICT Business di Fontys University of Applied Science, sebagai batu loncatan saya tugas untuk menyelesaikan gelar sarjananya. Tugasnya adalah untuk memecahkan masalah Manajer Program Pemasaran dengan proses pelaporan mingguan mereka. Proses saat ini dilakukan secara manual dalam file Excel datar, yang hanya dapat diakses pada hari Senin setiap minggunya. Selain itu, datanya entah bagaimana tidak cukup bersih untuk memenuhi kebutuhan bisnis. Untuk mengatasi masalah ini, para manajer menugaskan saya untuk memecahkan hambatan yang ada di dalam departemen. Tujuan dari proyek ini adalah untuk memberi para manajer sebuah dasbor interaktif yang dapat memenuhi semua kebutuhan bisnis dan memenuhi persyaratan. Metode manajemen proyek yang digunakan adalah metode waterfall yang dibagi menjadi lima milestone berdasarkan pertanyaan penelitian. Kerangka DOT juga digunakan untuk menyelaraskan setiap pertanyaan penelitian dengan output spesifiknya, memastikan semuanya tetap pada jalur yang diinginkan. Pertanyaan Penelitian menjawab setiap masalah tidak secara berurutan. Langkah pertama dari proses tersebut melibatkan pendefinisian informasi yang akan ditampilkan di dasbor. Hal ini dicapai dengan melakukan wawancara dengan beberapa pemangku kepentingan yang memiliki pengalaman dengan laporan mingguan saat ini dan dengan menganalisis dokumen yang relevan. Meskipun ada beberapa kendala selama fase definisi data, informasi yang diperlukan akhirnya diperoleh. Setelah informasi ditentukan, langkah selanjutnya adalah menentukan alat yang paling cocok untuk mengimplementasikan proyek. Dokumen penelitian alat disiapkan, dan metodologi perbandingan fitur digunakan untuk mengevaluasi opsi yang berbeda. Setelah mempertimbangkan dengan hati-hati, keputusan akhir tercapai. Tujuan selanjutnya adalah membuat model data yang optimal untuk dasbor. Meskipun ada beberapa tantangan di sepanjang jalan, model data akhir berhasil dikembangkan melalui berbagai wawancara dengan pemangku kepentingan terkait. Setelah model data dan persyaratan diselesaikan, proses pembuatan dasbor dimulai. Karena perubahan dinamis dalam persyaratan bisnis, prototipe dikembangkan beberapa kali secara iteratif untuk memastikannya benar-benar memenuhi kebutuhan pemangku kepentingan. Langkah terakhir melibatkan pengunggahan dasbor yang telah selesai ke Tableau Server dengan bantuan seorang analis data.
====================================================================================================================================
This paper outlined the tasks, developments, and outcomes of the internship at the Marketing & Sales Department of DAF Trucks N.V. The graduation internship project was carried out by Annelies Nafisa Widi, an ICT Business student at the Fontys University of Applied Science, as my capstone assignment for completing her bachelor's degree. The assignment was to solve Marketing Program Manager’s issue with their weekly reporting process. The current process was done manually in a flat Excel file, which could only be accessed on Mondays every week. Additionally, the data was somehow not clean enough to meet the business needs. To overcome this problem, the managers assigned me to solve the current bottleneck within the department. The goal of the project was to provide the managers with an interactive dashboard that could address all the business needs and meet the requirements. The project management method used was the waterfall method, which was divided into five milestones based on the research questions. The DOT Framework was also utilized to align each research question with its specific output, ensuring everything stayed on track as desired. The Research Questions answered each problem not sequentially. The first step of the process involved defining the information to be displayed on the dashboard. This was achieved by conducting interviews with several stakeholders who had experience with the current weekly report and by analyzing relevant documents. Although there were some obstacles during the data definition phase, the necessary information was eventually obtained. Once the information was defined, the next step was to determine the most suitable tool for implementing the project. A tool research document was prepared, and a feature comparison methodology was used to evaluate different options. After careful consideration, a final decision was reached. The subsequent objective was to create the optimal data model for the dashboard. Although there were some challenges along the way, the final data model was successfully developed through multiple interviews with the relevant stakeholders. Once the data model and requirements were finalized, the dashboard creation process began. Due to dynamic changes in the business requirements, the prototype was iteratively developed several times to ensure it truly met the stakeholders' needs. The final step involved uploading the completed dashboard to the Tableau Server with the assistance of a data analyst.

Item Type:	Thesis (Other)
Uncontrolled Keywords:	DAF, Visualisasi Data, SQL, Tableau; DAF, Data Visualization, SQL, Tableau
Subjects:	T Technology > T Technology (General) T Technology > T Technology (General) > T385 Visualization--Technique T Technology > T Technology (General) > T57.5 Data Processing
Divisions:	Faculty of Intelligent Electrical and Informatics Technology (ELECTICS) > Information System > 57201-(S1) Undergraduate Thesis
Depositing User:	Annelies Nafisa Widi
Date Deposited:	10 Oct 2023 02:18
Last Modified:	02 May 2024 04:29
URI:	http://repository.its.ac.id/id/eprint/102948

Actions (login required)

View Item