Bagi peserta MSIB yang akan mengumpulkan Retake Tugas dari Materi Pembelajaran yang sebelumnya sudah dikerjakan, silahkan gunakan halaman ini untuk mengunggahnya.
Pesiapkan terlebih dahulu semua tugasnya yang harus Retake sebelum mangakses halaman ini!
HANYA RETAKE SESUAI DENGAN INSTRUKSI MANA YANG HARUS DI RETAKE
Kuis Summary
0 of 19 Pertanyaan completed
Questions:
Information
You have already completed the kuis before. Hence you can not start it again.
Kuis is loading…
You must sign in or sign up to start the kuis.
You must first complete the following:
Results
Results
Your time:
Time has elapsed
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- Current
- Review
- Answered
- Correct
- Incorrect
-
Pertanyaan 1 of 19
1. Question
Unggah RETAKE TUGAS materi Data Warehouse disini.
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 2 of 19
2. Question
#TugasMateriSQL
Temukan total penjualan per negara
Tugas ini memerlukan penggabungan tabel customers dan orders. Fungsi SUM digunakan untuk menghitung total penjualan per negara.Hint:
SELECT …
FROM …JOIN … ON customers.customerNumber = orders.customerNumber
JOIN … ON orders.orderNumber = orderdetails.orderNumberGROUP BY …;
-
This response will be reviewed and graded after submission.
-
-
Pertanyaan 3 of 19
3. Question
#TugasMateriSQL
Temukan 10 produk terlaris
Tugas ini memerlukan penggabungan tabel products dan detail orders. Fungsi SUM digunakan untuk menghitung total kuantitas terjual untuk setiap produk, dan klausa ORDER BY dan LIMIT digunakan untuk mendapatkan 10 produk teratas.Hint:
SELECT …
FROM …JOIN … ON products.productCode = orderdetails.productCode
GROUP BY products.productNameORDER BY … DESC
LIMIT 10;-
This response will be reviewed and graded after submission.
-
-
Pertanyaan 4 of 19
4. Question
#TugasMateriSQL
Temukan total pendapatan per sales representative
Tugas ini memerlukan penggabungan tabel employees, customers, dan orders. Fungsi SUM digunakan untuk menghitung total pendapatan setiap perwakilan penjualan.Hint:
SELECT CONCAT(employees.firstName, ' ', employees.lastName) AS SalesRep, SUM(orderdetails.quantityOrdered * orderdetails.priceEach) AS TotalRevenue
FROM …JOIN … ON employees.employeeNumber = customers.salesRepEmployeeNumber
JOIN … ON customers.customerNumber = orders.customerNumber
JOIN … ON orders.orderNumber = orderdetails.orderNumberGROUP BY SalesRep;
-
This response will be reviewed and graded after submission.
-
-
Pertanyaan 5 of 19
5. Question
#TugasMateriSQL
Temukan kredit limit rata-rata per negara
Tugas ini memerlukan pemilihan data dari tabel customers. Fungsi AVG digunakan untuk menghitung rata-rata batas kredit setiap negara.
Hint:
SELECT … AS AverageCreditLimit
FROM …GROUP BY …;
-
This response will be reviewed and graded after submission.
-
-
Pertanyaan 6 of 19
6. Question
#TugasMateriSQL
Temukan jumlah pelanggan per kantor
Tugas ini memerlukan penggabungan tabel customers dan employees, lalu menggabungkan hasilnya dengan tabel offices. Fungsi COUNT digunakan untuk menghitung jumlah pelanggan setiap kantor.Hint:
SELECT offices.city, COUNT(customers.customerNumber) AS NumberOfCustomers
FROM officesJOIN … ON offices.officeCode = employees.officeCode
JOIN … ON employees.employeeNumber = customers.salesRepEmployeeNumberGROUP BY offices.city;
-
This response will be reviewed and graded after submission.
-
-
Pertanyaan 7 of 19
7. Question
#TugasMateriSQL
Hasil screenshot tugas. Satukan semua screenshot menjadi 1 file .pdf dengan format : namagrup-namapeserta-sstugas3sql.pdf
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 8 of 19
8. Question
#TugasMateriTalend
Kumpulkan Project yang sudah berisikan job dan metadata pada link upload dibawah!
Job dan Metadata
1.Helloworld
2.Uppercase
3.LookUpState
4.FilterState
5.Metadata StateCodes
FAQ
Q: Bagaimana cara mengerjakan tugas ini?
A: Export semua job dan metadata tersebut dalam satu file .zip. Detail langkah-langkah export job ada di bawah FAQ ini.
Q: Kapan deadline tugas ini?
A: Jum’at 8 September 2023 Jam 23.59
Q: Di mana tugas ini dikumpulkan?
A: Di website Kognitify, dengan format penamaan ETL_MSIB_(nama_kelas)_(nama_mahasiswa).zip
Contoh: ETL_MSIB_DE1_Jeni_Sudirman.zipHow to: Export Job
Klik kanan di JobDesign > pilih Export Items
Di Jendela Export items, pilih Select archive File:, lalu Browse lokasi penyimpanan file .zip, beri nama sesuai format. Pastikan semua item yang diminta sudah di ceklis semua. Lalu klik Finish
link deskripsi tugas: ETL_Talend – Task 1
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 9 of 19
9. Question
#TugasMateriPengantarDSdanBigData
Setelah melakukan presentasi, silahkan unggah file presentasinya disini.
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 10 of 19
10. Question
#TugasMateriStatistik
Unggah Tugas 1 Dasar Statistika untuk Data Science dan Struktur Data
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 11 of 19
11. Question
#TugasMateriStatistik
Silahkan unggah tugas Tugas 2 disini
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 12 of 19
12. Question
#TugasMateriDasarPython
Mencari penerapan data science di dunia nata dalam domain yang Anda minati (misalnya, keuangan, layanan kesehatan, pendidikan). Tulis ringkasan singkat tentang penerapannya, teknik data science yang digunakan, dan dampak yang dicapai.
Lalu unggah disini.
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 13 of 19
13. Question
#TugasMateriDasarPython
Kumpulkan Tugas ke 2 pada form upload dibawah ini!
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 14 of 19
14. Question
#TugasMateriMachineLearning
Tugas Materi Machine Learning di unggah disini.
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 15 of 19
15. Question
#TugasMateriKonsepDasarAnalitik
Unduh terlebih dahulu file tugas berikut :
Lalu kumpulkan tugasnya disini, gunakan format file yang sesuai dengan instruksi.
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 16 of 19
16. Question
#TugasMateriPengenalanDVTools
Unduh instruksi tugas pada link berikut :
Tugas_1_Pengantar_Visualisasi_Data (2)
Lalu kerjakan dan kumpulkan dengan format file yang sesuai dengan instruksi tugas.
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 17 of 19
17. Question
#TugasMateriPengenalanDVTools
Ikuti Instruksi tugas pada link berikut :
Tugas_2_Pengantar_Visualisasi_Data
Lalu unggah file tugasnya sesuai dengan instruksi tugas. Ekstensi yang diperbolehkan adalah .zip. Bila file terlalu besar bisa dengan cara mengunggah file ke drive pribadi dan share filenya, kemudian simpan link file-nya ke sebuah file dengan nama NOTE-TUGAS2-PENGANTARDV-namaPeserta.txt dan unggah disini.
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 18 of 19
18. Question
#TugasMateriSoftSkill
Silahkan upload tugasnya disini.
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-
-
Pertanyaan 19 of 19
19. Question
#TugasMateriSoftSkill
Silahkan unggah tugas 2 disini.
-
Upload your answer to this question.
This response will be reviewed and graded after submission.
-