國立高雄大學圖資館 |

Language: English

Back

Business intelligence tools for smal...

Nogues, Albert.

Business intelligence tools for small companiesa guide to free and low-cost solutions /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Business intelligence tools for small companiesby Albert Nogues, Juan Valladares.
Reminder of title:	a guide to free and low-cost solutions /
Author:	Nogues, Albert.
other author:	Valladares, Juan.
Published:	Berkeley, CA :Apress :2017.
Description:	xxiii, 326 p. :ill., digital ;24 cm.
Contained By:	Springer eBooks
Subject:	BusinessData processing.
Online resource:	http://dx.doi.org/10.1007/978-1-4842-2568-4
ISBN:	9781484225684$q(electronic bk.)

Business intelligence tools for small companiesa guide to free and low-cost solutions /
Nogues, Albert.

Business intelligence tools for small companiesa guide to free and low-cost solutions /[electronic resource] :by Albert Nogues, Juan Valladares. - Berkeley, CA :Apress :2017. - xxiii, 326 p. :ill., digital ;24 cm.

Chapter 1: Business Intelligence for Everybody -- Chapter 2: Agile Methodologies for BI Projects -- Chapter 3: SQL Basics -- Chapter 4: Project Initialization - Database and Source ERP Installation -- Chapter 5: Data Modeling for BI Solutions -- Chapter 6: ELT Basics -- Chapter 7: Performance Improvements -- Chapter 8: The BI Reporting Interface -- Chapter 9: MOLAP Tools for Budgeting -- Chapter 10: BI Process Scheduling: How to Orchestrate and Update Running Processes -- Chapter 11: Moving to a Production Environment -- Chapter 12: Moving BI Processes to the Cloud -- Chapter 13: Conclusions and Next Steps.

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.

ISBN: 9781484225684$q(electronic bk.)

Standard No.: 10.1007/978-1-4842-2568-4doiSubjects--Topical Terms:

199085
Business
--Data processing.

LC Class. No.: T58.6 / .N64 2017

Dewey Class. No.: 658.403

Business intelligence tools for small companiesa guide to free and low-cost solutions /
LDR:03525nmm a2200289 a 4500 001 514959
003 DE-He213
005 20170526133209.0
006 m d
007 cr nn 008maaau
008 180126s2017 cau s 0 eng d
020 $a 9781484225684$q(electronic bk.)
020 $a 9781484225677$q(paper)
024 7 $a 10.1007/978-1-4842-2568-4 $2 doi
035 $a 978-1-4842-2568-4
040 $a GP $c GP
041 0 $a eng
050 4 $a T58.6 $b .N64 2017
082 0 4 $a 658.403 $2 23
090 $a T58.6 $b .N778 2017
100 1 $a Nogues, Albert. $3 785203
245 1 0 $a Business intelligence tools for small companies $h [electronic resource] : $b a guide to free and low-cost solutions / $c by Albert Nogues, Juan Valladares.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2017.
300 $a xxiii, 326 p. : $b ill., digital ; $c 24 cm.
505 0 $a Chapter 1: Business Intelligence for Everybody -- Chapter 2: Agile Methodologies for BI Projects -- Chapter 3: SQL Basics -- Chapter 4: Project Initialization - Database and Source ERP Installation -- Chapter 5: Data Modeling for BI Solutions -- Chapter 6: ELT Basics -- Chapter 7: Performance Improvements -- Chapter 8: The BI Reporting Interface -- Chapter 9: MOLAP Tools for Budgeting -- Chapter 10: BI Process Scheduling: How to Orchestrate and Update Running Processes -- Chapter 11: Moving to a Production Environment -- Chapter 12: Moving BI Processes to the Cloud -- Chapter 13: Conclusions and Next Steps.
520 $a 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.
650 0 $a Business $x Data processing. $3 199085
650 0 $a Cloud computing. $3 378527
650 0 $a Management information systems. $3 199355
650 1 4 $a Computer Science. $3 212513
650 2 4 $a Open Source. $3 758930
650 2 4 $a Database Management. $3 273994
650 2 4 $a Information Storage and Retrieval. $3 274190
650 2 4 $a Big Data/Analytics. $3 742047
700 1 $a Valladares, Juan. $3 785204
710 2 $a SpringerLink (Online service) $3 273601
773 0 $t Springer eBooks
856 4 0 $u http://dx.doi.org/10.1007/978-1-4842-2568-4
950 $a Computer Science (Springer-11645)