CDS512 – Business Intelligence & Decision Analytics 2018
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
Second Semester Examination
2017/2018 Academic Session
CDS512 – Business Intelligence & Decision Analytics
1. (a) Explain three (3) differences between Business Intelligence (BI) and Business Analytics (BA).
Terangkan tiga (3) perbezaan antara Kecerdasan Perniagaan (BI) dan Analitik Perniagaan (BA).
(6/100)
(b) (i) What is the relationship between statistics and business analytics?
Apakah hubungan antara statistic dan analitik perniagaan?
(1/100)
(ii) Briefly describe the following dispersion measures of descriptive
statistics:
Huraikan secara ringkas ukuran penyebaran statistik deskriptif yang berikut:
• The standard deviation.
Sisihan piawai
• Mean.
Purata.
• Quartiles.
Kuartil
(6/100)
(iii) Briefly describe each of the following variable type, and give one (1)
example for each:
Terangkan secara ringkas setiap jenis pembolehubah berikut, dan berikan satu (1) contoh untuk setiap satunya:
• Nominal/categorical.
Nominal/kategori.
• Ordinal.
Ordinal.
• Interval.
Selangan.
(c) Identify, with a brief description, each of the four steps in the sentiment analysis process.
Kenal pasti dengan penerangan ringkas, setiap satu daripada empat langkah dalam proses analisis sentimen.
(6/100)
2. (a) Explain the concept of data lake and describe three (3) points of how data lake contrasts data warehouse approach.
Huraikan konsep tasik data dan terangkan tiga (3) perkara tentang bagaimana data tasik berbeza dengan pendekatan gudang data.
(7/100)
(b) (i) Explain four (4) characteristics of the performance dashboard.
Jelaskan empat (4) ciri-ciri papan pemuka prestasi.
(4/100)
(ii) By incorporating all the above-mentioned characteristics, draw a
performance dashboard that depicts the analytic of a telco call centre.
Dengan menggabungkan semua 4 ciri-ciri yang dijelaskan di atas, lukis sebuah papan pemuka prestasi yang menggambarkan analitik sebuah pusat panggilan telco.
(4/100)
(iii) The Chicken Rice restaurant chain would like to further analyse their
strategic goals and one method to do this is by using the balanced scorecard (BSC). The restaurant management will present the BSC to their CEO in a meeting soon. The BSC should include the analysis from the perspective of the shareholders, customers, managers and employees that allow the company to gain a stronger understanding of how strategic initiatives will impact these relationships. Imagine you are one of the management staffs, and your task is to prepare a BSC that provides insight to the vision, mission and values of the company.
Rangkaian restoran The Chicken Rice ingin menganalisis matlamat strategik mereka dengan lebih lanjut dan satu kaedah untuk melakukannya adalah dengan menggunakan kad skor seimbang (BSC). Pihak pengurusan restoran akan membentangkan BSC kepada CEO mereka dalam satu mesyuarat tidak lama lagi. BSC harus merangkumi analisis dari perspektif para pemegang saham, pelanggan, pengurus dan pekerja yang membolehkan syarikat memperoleh pemahaman yang lebih baik tentang bagaimana inisiatif strategik akan memberi kesan terhadap hubungan ini. Bayangkan anda adalah salah seorang kakitangan pengurusan, dan tugas anda adalah untuk menyediakan sebuah BSC yang memberikan pandangan wawasan, misi dan nilai syarikat tersebut.
(4/100)
(c) Consider the following transaction database for Questions 2(c)(i) – (iii):
Pertimbangkan transaksi pangkalan data yang berikut bagi Soalan 2(c)(i) – (iii):
TransID |
Item |
T100 |
Apple,Berry,Egg,Fanta,Hacks |
T200 |
Apple,Berry,Ciku,Egg |
T300 |
Apple,Berry,Ciku,Durian |
T400 |
Apple,Ciku,Hacks |
(i) What is the maximum number of association rules that can be extracted from this data (including rules that have zero support)?
Apakah bilangan maksimum peraturan persekutuan yang boleh diekstrak daripada data ini (termasuk peraturan-peraturan yang mempunyai sokongan sifar)?
For questions (ii) and (iii), suppose that minimum support is set to 50% and minimum confidence to 60%.
Bagi soalan (ii) dan (iii) andaikan bahawa sokongan minimum ditetapkan kepada 50% dan keyakinan minimum ditetapkan kepada 60%.
(ii) List three (3) two-sized frequent itemsets together with their support,
that satisfy the given minimum support and confidence.
Senaraikan tiga (3) set item saiz-dua yang kerap bersama-sama sokongan mereka, yang memuaskan sokongan dan keyakinan minimum yang diberi.
(3/100)
(iii) Find the confidence for the association below:
Cari keyakinan bagi persatuan di bawah:
{Apple, Berry} >{Ciku}
Suppose that the minimum confidence is set to 60%, state whether this association is considered interesting.
Andaikan keyakinan minimum telah ditetapkan kepada 60%,
nyatakan sama ada persatuan ini dianggap menarik.
(2/100)
3. (a) With the aid of a diagram, describe the Traveling Salesman Problem. Explain a real-world application of the Traveling Salesman Problem.
Dengan bantuan satu gambar rajah, terangkan masalah jurujual kembara. Terangkan satu aplikasi dunia sebenar masalah jurujual kembara.
(5/100)
(b) Romley and Buns is a small food processing manufacturer which produces
burger patties and burger buns located in Penang. They grind flour for the burger buns at a maximum rate of 100 kg per week. Each burger bun needs 50 g of flour. The company also receives 400 kg of chicken product from the supplier on every Monday. Each burger patty needs 200 g of chicken product. All the other ingredients in the burger patties and burger buns are in ample supply. Romley and Buns hires 5 employees working full time, i.e. 40 hours per week each employee. Each burger patty needs 5 minutes of labour, and each burger buns needs 4 minutes of labour. The profit yielded by each burger patty and each burger buns is RM1.00 and RM0.50 respectively.
The management of Romley and Buns would like to know the quantity of the burger patties and burger buns which they need to produce each week such that the highest possible profit can be achieved.
Romley and Buns ialah sebuah pengilang makanan kecil terletak di Pulau Pinang yang menghasilkan patti burger dan roti burger. Mereka mengisar tepung untuk penghasilan roti burger pada kadar maksimum 100 kg seminggu. Setiap roti burger memerlukan 50 g tepung. Pengilang itu juga menerima 400 kg produk ayam daripada pembekal setiap hari Isnin. Setiap patti burger memerlukan 200 g produk ayam. Semua pembekalan ramuan lain yang diperlukan untuk menghasilkan patti burger dan roti burger adalah mencukupi. Romley and Buns menggaji 5 pekerja sepenuh masa, iaitu setiap pekerja bekerja 40 jam seminggu. Setiap patti burger memerlukan 5 minit kerja, dan setiap roti burger memerlukan 4 minit kerja. Keuntungan yang dijanakan oleh setiap patti burger dan roti burger ialah RM1.00 dan RM0.50 masing-masing.
Pihak pengurusan Romley and Buns ingin mengetahui kuantiti patti burger dan roti burger yang perlu dihasilkan setiap minggu untuk mencapai keuntungan yang setinggi mungkin.
(i) Formulate a linear programming model for this problem.
Rumuskan satu model pemprograman linear untuk masalah ini.
(6/100)
(ii) Solve this model graphically.
Selesaikan model ini secara grafik.
(6/100)
(iii) Use graphical analysis to find the shadow prices for the resources.
Based on the shadow prices, indicate whether each of the resources is a scarce goods or free goods.
Gunakan analisis grafik untuk mencari harga bayangan sumber- sumber dalam masalah ini. Berdasarkan harga-harga bayangan yang dicari, nyatakan setiap sumber sama ada ia barangan terhad atau barangan bebas.
(6/100)
(iv) Determine the quantity of additional chicken product (in kilograms)
that is needed to increase the optimal profit by RM100.
Tentukan kuantiti produk ayam tambahan (dalam kilogram) yang diperlukan untuk menaikkan keuntungan optimum sebanyak RM100.
(2/100)
4. (a) Briefly describe the operations research modelling approach with relevant example.
Terangkan secara ringkas pendekatan pemodelan penyelidikan operasi dengan contoh yang berkaitan.
(10/100)
(b) Ali and Ahmad are inventory managers for competing wholesale
distributors. Both of them are purchasing luxurious motorcycles for their inventories from the same manufacturer. Ali has found that the setup cost for initiating each order is RM800 and the unit holding cost is RM400. Via a private investigation, Ali has learned that Ahmad will be ordering 20 motorcycles each time. Ali assumes that Ahmad is employing the basic Economic Order Quantity (EOQ) model and has the same setup cost and unit holding cost as Ali’s company. Show how Ali can deduce what the annual demand rate must be for Ahmad’s company for these motorcycles.
Ali dan Ahmad ialah pengurus inventori syarikat pengedar borong yang saling bersaing. Kedua-dua mereka membeli motosikal mewah daripada pengilang yang sama sebagai inventori syarikatnya. Ali mendapati kos persediaan untuk memulakan setiap pesanan ialah RM800 dan kos penyimpanan inventori ialah RM400. Melalui satu penyiasatan peribadi, Ali mendapati Ahmad akan membuat pesanan 20 motosikal setiap kali. Ali mengandaikan Ahmad menggunakan model Kuantiti Pesanan Ekonomi asas dan menampung kos persediaan dan kos penyimpanan inventori yang sama seperti syarikat Ali. Tunjukkan cara Ali membuat kesimpulan berkenaan dengan kadar permintaan motosikal tahunan syarikat Ahmad.
(c) Chong Wei is a sport car dealer. He decides to use the stochastic continuous-review model to determine an (R, Q) inventory policy for his company. He estimates that the administrative cost for placing each order is RM2000, the holding cost for each car is RM4500 per year, and the shortage cost per car short is RM1500 per year. Chong Wei also agrees to maintain a 95% service level. Based on his sales history, Chong Wei sell at a relatively uniform rate of about 400 cars per year. The cars are delivered in about a month after an order is placed. Chong Wei estimates that the demand during the lead time has a normal distribution with a mean of 50 and a standard deviation of 20.
Chong Wei ialah peniaga kereta sport. Beliau membuat keputusan untuk menggunakan model sorotan selanjar berkebarangkalian untuk menentukan satu polisi inventori (R, Q) bagi syarikat beliau. Beliau menganggarkan kos pentadbiran untuk membuat setiap pesanan ialah RM2000, kos penyimpanan setiap kereta ialah RM4500 setahun, dan kos kekurangan inventori setiap kereta ialah RM1500 setahun. Chong Wei juga bersetuju untuk mengekalkan tingkat perkhidmatan pada 95%. Berdasarkan sejarah penjualan beliau, Chong Wei menjual pada kadar yang agak seragam iaitu 400 buah kereta setahun. Kereta-kereta yang dipesan akan tiba dalam masa sebulan selepas pesanan dibuat. Chong Wei menganggarkan permintaan ketika masa pendulu bertaburan secara normal dengan purata 50 dan sisihan piawai 20.
(i) What are the assumptions that Chong Wei has to make for the (R, Q) inventory model. List only three (3) assumptions.
Apakah andaian-andaian yang perlu dibuat oleh Chong Wei semasa pemodelan inventori (R, Q). Senaraikan tiga (3) andaian sahaja.
(3/100) (ii) Determine the order quantity and the corresponding cycle time.
Tentukan kuantiti pesanan dan juga masa kitar yang sepadan.
(5/100)
(iii) How much safety stock should Chong Wei maintain and what reorder
point should be used?
Berapakah stok keselamatan yang perlu dikekalkan oleh Chong Wei dan apakah titik pesanan semula yang perlu digunakan?
(5/100)
2022-07-19