Albert Nogués Knihy

Transition from Excel-based business intelligence (BI) analysis to open-source BI tools tailored for your company. This guide helps you select and implement the best free and freemium BI tools, design, and integrate BI automation using agile methodologies. It offers hands-on demonstrations of tools suitable for small businesses, drawing on the authors' extensive experience as BI consultants and developers. You will learn the extract-transform-load/data warehousing (ETL/DWH) process, including how to extract data from an ERP database, transform it, and load it into a relational database. The guide illustrates how to extract, report, and visualize key performance indicators (KPIs) from a relational database management system (RDBMS). It covers the selection and implementation of tools like Pentaho Data Integrator and Talend for ETL, Oracle XE and MySQL/MariaDB for RDBMS, and Qliksense, Power BI, and MicroStrategy Desktop for reporting. Richly illustrated, it models the deployment of a BI stack on cost-effective cloud platforms such as AWS. Learn to manage and automate BI processes by implementing tools to establish BI/DWH infrastructure, extract data from ERP systems, process and integrate BI data, analyze it using visualization tools, and deploy BI solutions on cloud platforms efficiently.