The Resource Business Intelligence Tools for Small Companies : A Guide to Free and Low-Cost Solutions, by Albert Nogués, Juan Valladares, (electronic resource)

Business Intelligence Tools for Small Companies : A Guide to Free and Low-Cost Solutions, by Albert Nogués, Juan Valladares, (electronic resource)

Label
Business Intelligence Tools for Small Companies : A Guide to Free and Low-Cost Solutions
Title
Business Intelligence Tools for Small Companies
Title remainder
A Guide to Free and Low-Cost Solutions
Statement of responsibility
by Albert Nogués, Juan Valladares
Creator
Contributor
Author
Provider
Subject
Language
eng
Summary
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
http://library.link/vocab/creatorName
Nogués, Albert
Image bit depth
0
Literary form
non fiction
http://library.link/vocab/relatedWorkOrContributorName
  • Valladares, Juan.
  • SpringerLink
http://library.link/vocab/subjectName
  • Computer science
  • Big data
  • Database management
  • Information storage and retrieval
  • Computer Science
  • Open Source
  • Database Management
  • Information Storage and Retrieval
  • Big Data/Analytics
Label
Business Intelligence Tools for Small Companies : A Guide to Free and Low-Cost Solutions, by Albert Nogués, Juan Valladares, (electronic resource)
Instantiates
Publication
Antecedent source
mixed
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
not applicable
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
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
Dimensions
unknown
Extent
XXIII, 326 p. 168 illus., 163 illus. in color.
File format
multiple file formats
Form of item
electronic
Isbn
9781484225684
Level of compression
uncompressed
Media category
computer
Media MARC source
rdamedia
Media type code
c
Other control number
10.1007/978-1-4842-2568-4
Other physical details
online resource.
Quality assurance targets
absent
Reformatting quality
access
Specific material designation
remote
System control number
(DE-He213)978-1-4842-2568-4
Label
Business Intelligence Tools for Small Companies : A Guide to Free and Low-Cost Solutions, by Albert Nogués, Juan Valladares, (electronic resource)
Publication
Antecedent source
mixed
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
not applicable
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
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
Dimensions
unknown
Extent
XXIII, 326 p. 168 illus., 163 illus. in color.
File format
multiple file formats
Form of item
electronic
Isbn
9781484225684
Level of compression
uncompressed
Media category
computer
Media MARC source
rdamedia
Media type code
c
Other control number
10.1007/978-1-4842-2568-4
Other physical details
online resource.
Quality assurance targets
absent
Reformatting quality
access
Specific material designation
remote
System control number
(DE-He213)978-1-4842-2568-4

Library Locations

  • African Studies LibraryBorrow it
    771 Commonwealth Avenue, 6th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Alumni Medical LibraryBorrow it
    72 East Concord Street, Boston, MA, 02118, US
    42.336388 -71.072393
  • Astronomy LibraryBorrow it
    725 Commonwealth Avenue, 6th Floor, Boston, MA, 02445, US
    42.350259 -71.105717
  • Fineman and Pappas Law LibrariesBorrow it
    765 Commonwealth Avenue, Boston, MA, 02215, US
    42.350979 -71.107023
  • Frederick S. Pardee Management LibraryBorrow it
    595 Commonwealth Avenue, Boston, MA, 02215, US
    42.349626 -71.099547
  • Howard Gotlieb Archival Research CenterBorrow it
    771 Commonwealth Avenue, 5th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Mugar Memorial LibraryBorrow it
    771 Commonwealth Avenue, Boston, MA, 02215, US
    42.350723 -71.108227
  • Music LibraryBorrow it
    771 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Pikering Educational Resources LibraryBorrow it
    2 Silber Way, Boston, MA, 02215, US
    42.349804 -71.101425
  • School of Theology LibraryBorrow it
    745 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350494 -71.107235
  • Science & Engineering LibraryBorrow it
    38 Cummington Mall, Boston, MA, 02215, US
    42.348472 -71.102257
  • Stone Science LibraryBorrow it
    675 Commonwealth Avenue, Boston, MA, 02445, US
    42.350103 -71.103784
Processing Feedback ...