Implementation of Business Intelligence for Analysis Data of Drug Sales Using Exploratory Data Analysis (EDA) and Visualization Data Using Looker Studio

Abstract

This study aims to analyze pharmaceutical sales performance by leveraging big data and advanced information technology tools, providing insights for improved business strategies. Using the Exploratory Data Analysis (EDA) method, the study processes raw sales data through spreadsheet applications to identify key patterns and trends. The findings are then visualized with Looker Studio on an intelligent dashboard tailored to the needs of the marketing team. The dashboard enables quick, data-driven decision-making by displaying performance metrics and trends relevant to sales and marketing strategies. The results reveal critical insights into sales behavior, including high-performing products, regional sales variations, and temporal sales trends. The analysis equips the marketing team with actionable data to refine their strategies, prioritize product focus, and adjust marketing efforts in response to identified patterns. In conclusion, the use of EDA and data visualization provides a structured approach to big data interpretation, allowing the company to optimize business and marketing performance. The study underscores the potential of data-driven dashboards to enhance strategic planning, suggesting broader applications in various data-intensive business environments.