Library Hours
Monday to Friday: 9 a.m. to 9 p.m.
Saturday: 9 a.m. to 5 p.m.
Sunday: 1 p.m. to 9 p.m.
Naper Blvd. 1 p.m. to 5 p.m.
LEADER 00000cam a2201045Ii 4500
001 988865934
003 OCoLC
005 20240129213017.0
006 m o d
007 cr cnu---unuuu
008 170603s2017 cau o 001 0 eng d
015 GBB8M4493|2bnb
016 7 019139983|2Uk
019 992450705|a992892064|a1005139020|a1005801249|a1008943297
|a1012076709|a1048139477|a1066522007|a1066692466
|a1086444406|a1103255387|a1132589276
020 9781484225684|q(electronic bk.)
020 1484225686|q(electronic bk.)
020 |q(print)
024 7 10.1007/978-1-4842-2568-4|2doi
029 1 AU@|b000060382146
029 1 GBVCP|b1014935822
029 1 UKMGB|b019139983
029 1 AU@|b000067100189
029 1 AU@|b000068984901
029 1 AU@|b000075796292
029 1 AU@|b000075843591
029 1 AU@|b000075866519
029 1 AU@|b000075882691
035 (OCoLC)988865934|z(OCoLC)992450705|z(OCoLC)992892064
|z(OCoLC)1005139020|z(OCoLC)1005801249|z(OCoLC)1008943297
|z(OCoLC)1012076709|z(OCoLC)1048139477|z(OCoLC)1066522007
|z(OCoLC)1066692466|z(OCoLC)1086444406|z(OCoLC)1103255387
|z(OCoLC)1132589276
037 CL0500000897|bSafari Books Online
040 EBLCP|beng|erda|epn|cEBLCP|dOCLCQ|dGW5XE|dN$T|dYDX|dUAB
|dESU|dAZU|dUPM|dOCLCF|dIOG|dCOO|dMERER|dOCLCQ|dUMI|dVT2
|dSTF|dIDB|dOH1|dK6U|dU3W|dMERUC|dOCLCQ|dLIV|dD6H|dOCLCQ
|dVVB|dCEF|dKSU|dUWW|dAU@|dWYU|dUKMGB|dAUD|dLEAUB|dUKAHL
|dCNCEN|dG3B|dERF|dUKBTH|dUHL|dOCLCQ|dDKDLA|dOCLCQ|dSRU
|dBRF|dAJS|dTOH|dEYM|dSNK|dNLW|dOCLCO|dOCL|dOCLCQ|dOCLCO
049 INap
066 |cZsym
082 04 658.4/03
082 04 658.4/03|223
099 eBook O'Reilly for Public Libraries
100 1 Nogués, Albert.
245 10 Business intelligence tools for small companies :|ba guide
to free and low-cost solutions /|cAlbert Nogués, Juan
Valladares.|h[O'Reilly electronic resource]
264 1 Berkeley, CA :|bApress,|c2017.
300 1 online resource
336 text|btxt|2rdacontent
337 computer|bc|2rdamedia
338 online resource|bcr|2rdacarrier
347 text file|bPDF|2rda
500 Full Outer Join (or Full Join).
500 Includes index.
505 0 At a Glance; Contents; About the Authors; About the
Technical Reviewer; Acknowledgments; Introduction; Chapter
1: Business Intelligence for Everybody; What Is Business
Intelligence?; BI Evolution; From Strategic to Tactical;
Big Data; Internet of Things; BI Characteristics; Hidden
Relevant Information; Accuracy; Significant KPIs; On Time;
Company Analytics Life Cycle and Continuous Improvement;
Benefits of BI; Direct Benefits; Indirect Benefits;
Objectives; Who Can Get Benefit from BI?; BI Platform
Components; Source ERP; Database; ETL; Front-End Tool;
Budgeting Tool.
505 8 BI Platform LocationBI Concepts; Datawarehouse; DataMart;
Logical Model; Relational Model; Normalized Model;
Denormalized Model; Star Model; Snowflake Model; Physical
Model; BI Main Objects; Project; Tables; Facts;
Dimensions; Reports; BI Approaches; Query and Reporting;
Information Sharing; Dashboarding; Data Import; Data
Discovery; MOLAP; Data Mining; Incoming Approaches; BI
Capabilities; Drilling; Pivoting; Visualizations; Map
Visualizations; Sorting; Grouping; Filtering; Conditional
Expressions; Subtotals; Administration; User Interface;
Conclusion.
505 8 Chapter 2: Agile Methodologies for BI ProjectsIntroduction
to Agile Methodologies; Agile Approaches; Our Recommended
Mix between Scrum and Kanban; Developing Projects with
Scrum; Roles; Product Owner; Scrum Master; Development
Team; Stakeholders; Users; Product Owner Assistant;
Sprint; Specific Scrum Meetings; Release; Artifacts Used
in Scrum; User Story; Developer Story; Product Backlog;
Definition of Done; When to Start -- Ready Definition;
Product Backlog Burndown Chart; Sprint Backlog; Sprint
Backlog Burndown Chart; Impediment List; Improvement List;
Limiting Spent Time with Timeboxing.
505 8 SpikeMaintenance with Kanban; Kanban Concepts; Task
Workflow; Task Board and Visual Management; Work In
Progress; Lead Time; Mix of Both Methodologies, Scrumban;
Peculiarities of Scrum for BI; Sprint 0 -- Longer Initial
Analysis; BI Project Segmentation; Front-End vs. Back-End
Activities; Role Isolation -- Specific Knowledge;
Developer Story Types in BI; Data Modeling Developer
Stories; ETL Developer Stories; BI Model Developer
Stories; Report and Dashboarding Developer Stories; MOLAP
Developer Stories; Agile Management Tools; Trello; JIRA
Software; Conclusion; Chapter 3: SQL Basics.
505 8 What Is SQL?The Relational Model; Databases and Database
Vendors; ACID Compliance; Types of SQL Statements; SQL
Datatypes; Numeric Datatypes; Text Datatypes; Date
Datatypes; Other Datatypes; Retrieving Data from a Table;
The select * Statement; The select column Statement; The
select count (*) or count (column) Statement; The select
distinct Clause; Sorting; Filtering; The Where Clause;
Operators; Logical Operators; Grouping Data; Using
Subqueries; Joining Tables; Types of Joins; Cartesian
Join; Inner Join; Outer Join; Left Outer Join (or Left
Join); Right Outer Join (or Right Join).
520 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.
588 0 Print version record.
590 O'Reilly|bO'Reilly Online Learning: Academic/Public
Library Edition
650 0 Management information systems.
650 0 Cloud computing.
650 0 Business|xData processing.
650 0 Management|xData processing.
650 6 Systèmes d'information de gestion.
650 6 Infonuagique.
650 6 Gestion|xInformatique.
650 7 Databases.|2bicssc
650 7 Information retrieval.|2bicssc
650 7 Business mathematics & systems.|2bicssc
650 7 Computer programming / software development.|2bicssc
650 7 Management|xData processing|2fast
650 7 Business|xData processing|2fast
650 7 Cloud computing|2fast
650 7 Management information systems|2fast
650 14 Computer Science.
650 24 Open Source.
650 24 Database Management.
650 24 Information Storage and Retrieval.
650 24 Big Data/Analytics.
700 1 Valladares, Juan.
776 08 |iPrint version:|aNogués, Albert.|tBusiness intelligence
tools for small companies.|dBerkeley, CA : Apress, 2017
|z9781484225684
856 40 |uhttps://ezproxy.naperville-lib.org/login?url=https://
learning.oreilly.com/library/view/~/9781484225677/?ar
|zAvailable on O'Reilly for Public Libraries
880 00 |6245-00/Zsym|aBusiness intelligence tools for small
companies|h[electronic resource] :|ba guide to free and
low-cost solutions /|cAlbert Nogu�es, Juan Valladares.
880 4 |6264-00/Zsym|c�2017
938 Askews and Holts Library Services|bASKH|nAH33062859
938 ProQuest Ebook Central|bEBLB|nEBL4866423
938 EBSCOhost|bEBSC|n1527245
938 YBP Library Services|bYANK|n14530481
994 92|bJFN