VISUALISASI DASHBOARD SYSTEM DENGAN MENERAPKAN BUSINESS INTELLIGENCE PADA MINIMARKET TAMA MART KOTA SAWAHLUNTO

ABSTRAK Tama mart merupakan tempat perbelanjaan kebutuhan sehari-hari yang ada di kota Sawahlunto. Tama mart mengelola banyak data transaksi selama kurun waktu tiga tahun. Dalam menjalankan kegiatan operasionalnya, Tama Mart menggunakan aplikasi Ipos versi 3.0. Dimana data tersebut terdiri dari berbagai jenis kategori data. Pengelolaan data transaksi masih menggunakan cara manual yaitu dengan mengekstrak data dari database ke microsoft excel untuk kemudian dikalkulasikan dan diproses. Oleh sebab itu, salah satu cara dalam mengatasi permasalahan tersebut dengan melakukan penerapan business intelligence (BI) pada Tama Mart untuk menghasilkan visualisasi dashboard system menggunakan Tableau Public. Dalam penerapan BI ini, tahapan yang digunakan adalah BI Roadmap. BI Roadmap digunakan sebagai landasan dalam pelaksanaan penelitian yang dimulai dari identifikasi permasalahan yang dipilih. Setelah itu dilakukan fase perencanaan dengan melakukan evaluasi terhadap infrastruktur dan melakukan planning project. Kemudian fase analisis yang berfokus dalam melakukan analisis yang mendetail dari masalah dan peluang bisnis dari implementasi BI. Selanjutnya adalah fase desain dengan melakukan proses ETL untuk perancangan data warehouse dilakukan dengan Pentaho Data Integration (PDI), sedangkan visualisasi dashboard dengan menggunakan Tableau Public. Hasil dari penelitian ini adalah berupa visualisasi dashboard system yang menghasilkan informasi yang dibutuhkan oleh pemilik minimarket Tama Mart untuk membantu dalam sistem pengambilan keputusan. Kata Kunci: Business Intelligence, Dashboard System, Tableau Public, Tama Mar

A case of complete decapitation

Complete decapitation due to suicide by hanging is rare. We report the case of a decapitated man who was found in the sea near an estuary. A polyethylene rope was tied to the handrail of the bridge across a strait near the site of the body. The rope was 12 mm in diameter and 19 m in length from the handrail. It ended with a slip knot noose, and skin and mustache-like hair fragments were attached to it. The decapitated head was not found. The deceased weighed 82 kg and was 152 cm long without the head. The autopsy revealed coarse abrasions and intramuscular hemorrhage around the severed edge. The third cervical spine was not fractured. We reviewed the literature and suggested the conditions of body weight, fall height, rope diameter, and number of rolls in cases of decapitation by hanging. We calculated the hanging decapitation index (HDI) as the fall height (m) multiplied by the body weight (kg), divided by the rope diameter (mm), divided by the number of rolls ; and discussed the differences between complete and incomplete decapitation cases

Post-mortem volatiles of vertebrate tissue

Volatile emission during vertebrate decay is a complex process that is understood incompletely. It depends on many factors. The main factor is the metabolism of the microbial species present inside and on the vertebrate. In this review, we combine the results from studies on volatile organic compounds (VOCs) detected during this decay process and those on the biochemical formation of VOCs in order to improve our understanding of the decay process. Micro-organisms are the main producers of VOCs, which are by- or end-products of microbial metabolism. Many microbes are already present inside and on a vertebrate, and these can initiate microbial decay. In addition, micro-organisms from the environment colonize the cadaver. The composition of microbial communities is complex, and communities of different species interact with each other in succession. In comparison to the complexity of the decay process, the resulting volatile pattern does show some consistency. Therefore, the possibility of an existence of a time-dependent core volatile pattern, which could be used for applications in areas such as forensics or food science, is discussed. Possible microbial interactions that might alter the process of decay are highlighted

Analysis of phosphatidylcholine oxidation products in human plasma using quadrupole time-of flight mass spectrometry

We report here an application of the previous method for the analysis ofphosphatidylcholine (PC) and lysophosphatidylcholine (lysoPC) oxidation products inhuman plasma using quadrupole time of flight (Q-TOF) mass spectrometry withelectrospray ionization. We separated these products using an HPLC C8 column witha gradient of methanol and 10 mM aqueous ammonium acetate. Monohydroperoxides,epoxyhydroxy derivatives, oxo derivatives, and trihydroxides of palmitoyl-linoleoyl(C16:0/C18:2) PC and stearoyl-linoleoyl (C18:0/C18:2) PC were detected mainly asMH+ and [M+Na]+ ions in the plasma of alcoholic patients. Using standard syntheticPC-OH (C16:0/C18:2-OH), the lipid extract component was identified as(C16:0/C18:2-OH) PC based on the product ions of ESI-MS-MS. Using standardsynthetic PCOOH (C16:0/C18:2-OOH) as a reference, the PCOOH concentration inplasma was quantified. Two oxidatively modified lysoPCs were also detected. This isthe first report showing the presence of epoxyhydroxy derivatives,monohydroperoxides, oxo derivatives, and trihydroxides of (C16:0/C18:2) PC and(C18:0/C18:2) PC, and PC-OH (C16:0/C18:0-OH) in human plasma

Lack of Association between Endoplasmic Reticulum Stress Response Genes and Suicidal Victims

As lithium has been shown to have a protective effect against suicidal behavior,genes on which mood stabilizers act may be involved in biological susceptibility tosuicide. A recent study showed that endoplasmic reticulum (ER) stress response wasimpaired in the bipolar disorders and the impairment was ameliorated by a moodstabilizer, valproate. We hypothesized that an alteration of ER stress response isinvolved in the biological susceptibility to suicide through genetic polymorphisms, andexamined the association of polymorphisms of X-box binding protein 1 (XBP1) andheat shock 70-kDa protein 5 (HSPA5) genes with suicide. We found no significantdifference in the distribution of these polymorphisms between the suicide victims andthe controls. These results suggest that the polymorphisms examined in this study arenot involved in the susceptibility to suicide of the Japanese