By Albert Nogués,Juan Valladares

Learn the way to transition from Excel-based enterprise intelligence (BI) research to firm stacks of open-source BI instruments. opt for and enforce the simplest unfastened and freemium open-source BI instruments in your company’s wishes and layout, enforce, and combine BI automation around the complete stack utilizing agile methodologies.

Business Intelligence instruments for Small Companies provides hands-on demonstrations of open-source instruments compatible for the BI specifications of small companies. The authors draw on their deep adventure as BI experts, builders, and directors to lead you thru the extract-transform-load/data warehousing (ETL/DWH) series of extracting facts from an company source making plans (ERP) database freely to be had on the net, reworking the information, manipulating them, and loading them right into a relational database.

The authors show how one can extract, record, and dashboard key functionality symptoms (KPIs) in a visually beautiful layout from the relational database administration method (RDBMS). They version the choice and implementation of unfastened and freemium instruments corresponding to Pentaho information Integrator and Talend for ELT, Oracle XE and MySQL/MariaDB for RDBMS, and Qliksense, energy BI, and MicroStrategy computing device for reporting. This richly illustrated consultant versions the deployment of a small corporation BI stack on a cheap cloud platform equivalent to AWS. 

What you are going to Learn

You will the right way to deal with, combine, and automate the procedures of BI through identifying and imposing instruments to:

  • Implement and deal with the company intelligence/data warehousing (BI/DWH) infrastructure
  • Extract facts from any company source making plans (ERP) tool
  • Process and combine BI facts utilizing open-source extract-transform-load (ETL) tools
  • Query, file, and study BI information utilizing open-source visualization and dashboard tools
  • Use a MOLAP instrument to outline subsequent year's price range, integrating actual information with goal scenarios
  • Deploy BI options and large facts experiments inexpensively on cloud platforms

Who This booklet Is For

Engineers, DBAs, analysts, specialists, and executives at small businesses with restricted assets yet whose BI standards have outgrown the constraints of Excel spreadsheets; body of workers in mid-sized businesses with validated BI platforms who're exploring technological updates and extra low cost solutions

Show description

Read Online or Download Business Intelligence Tools for Small Companies: A Guide to Free and Low-Cost Solutions PDF

Best open source programming books

Instant Apache Stanbol

In DetailStanbol is a software program software which is helping conventional content material administration structures to prepare for the rising associated information net. It additionally offers a versatile framework for development modularized RESTful purposes and comprises Apache Clerezza for processing RDF information. Its aim is to supply internet and CMS builders with a collection of HTTP/RESTful companies to aid them combine semantic applied sciences into their items and websites.

Mastering Zabbix

In DetailMonitoring platforms are a very important a part of any IT atmosphere. they are often tremendous important not just to spot particular difficulties, but in addition to degree your system’s functionality and locate how one can increase it. notwithstanding, they are often deceptive and complicated if now not properly configured and controlled.

Infinispan Data Grid Platform Definitive Guide

Grasp Infinispan to create scalable and high-performance applicationsAbout This BookCreate hugely scalable functions utilizing the Infinispan info Grid PlatformMaximize your application’s functionality in any cluster environmentBecome knowledgeable in growing robust options utilizing Infinispan via ready-to-use examplesWho This booklet Is ForThis useful consultant is meant in case you are looking to construct super scalable functions.

Test-Driven Development with Python: Obey the Testing Goat: Using Django, Selenium, and JavaScript

Through taking you thru the improvement of a true internet software from commencing to finish, the second one version of this hands-on consultant demonstrates the sensible benefits of test-driven improvement (TDD) with Python. You’ll write and run exams sooner than development each one a part of your app, after which boost the minimal quantity of code required to cross these exams.

Extra info for Business Intelligence Tools for Small Companies: A Guide to Free and Low-Cost Solutions

Example text

Download PDF sample

Business Intelligence Tools for Small Companies: A Guide to by Albert Nogués,Juan Valladares
Rated 4.65 of 5 – based on 10 votes