{"title":"PT Transmart货物数据仓库设计验收使用工具Pentaho和Tableu","authors":"Emi Purwati, Syam Gunawan","doi":"10.30873/simada.v1i2.1142","DOIUrl":null,"url":null,"abstract":"The purpose of this research is to process the data of receipt of goods at PT Transmart Central Park, analyze the existing database in the information system of receipt of goods to get the necessary information and design the data warehouse to integrate the existing data so that obtained information to take a decision. Business Intelligence (BI) is one of information technology that can be solution to collect, store and analyze company data. Online Analytical Processing (OLAP) consists of a set of tools in use to help the process of analysis and comparison of data in the database. OLAP tools and methods help users analyze data in a data warehouse by providing a variety of dynamic graphical display data. The data warehouse design method is implemented by applying the 9 steps (Nine-Step Methodology) used by Ralph Kimball in designing the star scheme. The results achieved are data warehouse that provides the desired information and provide summary information in the form of tables and charts, can be compared between the purchase order data with receiving report is global, relevant, and integrated that can be seen from various points of view so useful for the leaders to make a decision.Keywords : Bussinesn Intelligent,Datawarehouse,OlapNine-Step Methodology","PeriodicalId":166722,"journal":{"name":"SIMADA (Jurnal Sistem Informasi & Manajemen Basis Data)","volume":"1 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2018-10-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"DataWarehouse Design Acceptance of Goods In PT Transmart Using Tools Pentaho and Tableu\",\"authors\":\"Emi Purwati, Syam Gunawan\",\"doi\":\"10.30873/simada.v1i2.1142\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"The purpose of this research is to process the data of receipt of goods at PT Transmart Central Park, analyze the existing database in the information system of receipt of goods to get the necessary information and design the data warehouse to integrate the existing data so that obtained information to take a decision. Business Intelligence (BI) is one of information technology that can be solution to collect, store and analyze company data. Online Analytical Processing (OLAP) consists of a set of tools in use to help the process of analysis and comparison of data in the database. OLAP tools and methods help users analyze data in a data warehouse by providing a variety of dynamic graphical display data. The data warehouse design method is implemented by applying the 9 steps (Nine-Step Methodology) used by Ralph Kimball in designing the star scheme. The results achieved are data warehouse that provides the desired information and provide summary information in the form of tables and charts, can be compared between the purchase order data with receiving report is global, relevant, and integrated that can be seen from various points of view so useful for the leaders to make a decision.Keywords : Bussinesn Intelligent,Datawarehouse,OlapNine-Step Methodology\",\"PeriodicalId\":166722,\"journal\":{\"name\":\"SIMADA (Jurnal Sistem Informasi & Manajemen Basis Data)\",\"volume\":\"1 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2018-10-23\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"SIMADA (Jurnal Sistem Informasi & Manajemen Basis Data)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.30873/simada.v1i2.1142\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"SIMADA (Jurnal Sistem Informasi & Manajemen Basis Data)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.30873/simada.v1i2.1142","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
摘要
本研究的目的是对PT Transmart Central Park的收货数据进行处理,对收货信息系统中现有的数据库进行分析,得到必要的信息,并设计数据仓库对现有的数据进行整合,从而得到信息做出决策。商业智能(BI)是一种能够收集、存储和分析公司数据的信息技术。联机分析处理(OLAP)由一组工具组成,用于帮助分析和比较数据库中的数据。OLAP工具和方法通过提供各种动态图形显示数据来帮助用户分析数据仓库中的数据。数据仓库的设计方法是采用Ralph Kimball在设计星型方案时使用的9步方法来实现的。所取得的结果是数据仓库提供了所需的信息并以表格和图表的形式提供了汇总信息,可以将采购订单数据与接收报告进行比较,具有全局性、相关性和集成性,可以从各个角度看到,因此对领导者做出决策非常有用。关键词:智能商务,数据仓库,olap九步法
DataWarehouse Design Acceptance of Goods In PT Transmart Using Tools Pentaho and Tableu
The purpose of this research is to process the data of receipt of goods at PT Transmart Central Park, analyze the existing database in the information system of receipt of goods to get the necessary information and design the data warehouse to integrate the existing data so that obtained information to take a decision. Business Intelligence (BI) is one of information technology that can be solution to collect, store and analyze company data. Online Analytical Processing (OLAP) consists of a set of tools in use to help the process of analysis and comparison of data in the database. OLAP tools and methods help users analyze data in a data warehouse by providing a variety of dynamic graphical display data. The data warehouse design method is implemented by applying the 9 steps (Nine-Step Methodology) used by Ralph Kimball in designing the star scheme. The results achieved are data warehouse that provides the desired information and provide summary information in the form of tables and charts, can be compared between the purchase order data with receiving report is global, relevant, and integrated that can be seen from various points of view so useful for the leaders to make a decision.Keywords : Bussinesn Intelligent,Datawarehouse,OlapNine-Step Methodology