Advertisement

Business Intelligence Tools for Small Companies

A Guide to Free and Low-Cost Solutions

  • Albert Nogués
  • Juan Valladares

Table of contents

  1. Front Matter
    Pages i-xxiii
  2. Albert Nogués, Juan Valladares
    Pages 1-28
  3. Albert Nogués, Juan Valladares
    Pages 29-56
  4. Albert Nogués, Juan Valladares
    Pages 57-92
  5. Albert Nogués, Juan Valladares
    Pages 93-116
  6. Albert Nogués, Juan Valladares
    Pages 117-146
  7. Albert Nogués, Juan Valladares
    Pages 147-183
  8. Albert Nogués, Juan Valladares
    Pages 185-205
  9. Albert Nogués, Juan Valladares
    Pages 207-233
  10. Albert Nogués, Juan Valladares
    Pages 235-253
  11. Albert Nogués, Juan Valladares
    Pages 255-272
  12. Albert Nogués, Juan Valladares
    Pages 273-294
  13. Albert Nogués, Juan Valladares
    Pages 295-314
  14. Albert Nogués, Juan Valladares
    Pages 315-318
  15. Back Matter
    Pages 319-326

About this book

Introduction

Learn how to transition from Excel-based business intelligence (BI) analysis to enterprise stacks of open-source BI tools. Select and implement the best free and freemium open-source BI tools for your company’s needs and design, implement, and integrate BI automation across the full stack using agile methodologies.

Business Intelligence Tools for Small Companies provides hands-on demonstrations of open-source tools suitable for the BI requirements of small businesses. The authors draw on their deep experience as BI consultants, developers, and administrators to guide you through the extract-transform-load/data warehousing (ETL/DWH) sequence of extracting data from an enterprise resource planning (ERP) database freely available on the Internet, transforming the data, manipulating them, and loading them into a relational database.

The authors demonstrate how to extract, report, and dashboard key performance indicators (KPIs) in a visually appealing format from the relational database management system (RDBMS). They model the selection and implementation of free and freemium tools such as Pentaho Data Integrator and Talend for ELT, Oracle XE and MySQL/MariaDB for RDBMS, and Qliksense, Power BI, and MicroStrategy Desktop for reporting. This richly illustrated guide models the deployment of a small company BI stack on an inexpensive cloud platform such as AWS. 

You will learn how to manage, integrate, and automate the processes of BI by selecting and implementing tools to:

  • Implement and manage the business intelligence/data warehousing (BI/DWH) infrastructure
  • Extract data from any enterprise resource planning (ERP) tool
  • Process and integrate BI data using open-source extract-transform-load (ETL) tools
  • Query, report, and analyze BI data using open-source visualization and dashboard tools
  • Use a MOLAP tool to define next year's budget, integrating real data with target scenarios
  • Deploy BI solutions and big data experiments inexpensively on cloud platforms

Keywords

BI ERP ETL dashboard KPI DHW data modeling Oracle XE MySQL/MariaDB Pentaho Data Integrator Talend Qlikview Tableau AWS cloud platform big data DW optimization reporting interface process scheduling

Authors and affiliations

  • Albert Nogués
    • 1
  • Juan Valladares
    • 2
  1. 1.BarcelonaSpain
  2. 2.BarcelonaSpain

Bibliographic information