Business intelligence & E-Commerce: um estudo na área de chás e produtos naturais

Abstract

The objective of this research is to extract data from a ERP system to analyze in a Business Intelligence software making knowledge and insights for the managers of a recently acquired store. A literature revision was created about the Business Intelligence and the theory that supports this kind of software. The methodological procedure applied to this case study, of one tea and natural products e-commerce, was qualitative. Accounting the recently growing seen in the market, been the on-line sales or the natural products niche. Data from the business’s ERP was collected, processed locally and imported in the PowerBI. The data analysis evidenced that the majority of the clients are situated in the large urban centers and that, the company's own base city has few clients taking into consideration that they would pay the lowest freight rate. In addition, it was possible to observe that certain products have a seasonal sales characteristic, which may be related to the seasons of the year or even festive dates. The final considerations are that Business Intelligence software provides the facility of crossing data and plotting it on graphs, which visually highlight certain characteristics and patterns. Managers can then use this information confidentially for decision-making. The limitation of the study is the use of only one database to feed information in BI, this type of software really shows its power when it crosses data that was previously isolated in different applications used by a company, creating the called silos of information.