Leveraging Business Intelligence through ETL Processes and Power BI Dashboard Development

This report aims to outline the tasks accomplished during the internship at LGG Advisors as part of the Master’s in Data Analytics for Business program at ISEG. The main goal of the internship was to enhance the intern's skills in data analytics, with a particular emphasis on refining methods related to data acquisition, processing, and integration within a database framework, as well as improve the ability to create dynamic and informative dashboards. During the internship, the intern was placed with the Data Transformation team at LGG Advisors, where their primary duties involved ETL processes and generating Power BI reports for LGG clients. The acquired skills in ETL processes streamlined data acquisition and preparation and laid the foundation for developing robust and insightful dashboards. The developed dashboards allowed store directors and executives to effectively compare performance across different locations, identify areas for improvement, and implement data-driven decisions that boosted profitability. The internship reinforced the invaluable role of data analytics and business intelligence principles, actionable insights that drive business success.