Business Intelligence Tools for Small Companies

Publisher : Apress

ISBN-13 : 1484225686

Page : 340 pages

Rating : 4.5/5 from 686 voters

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. What You'll Learn 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 Who This Book Is For Engineers, DBAs, analysts, consultants, and managers at small companies with limited resources but whose BI requirements have outgrown the limitations of Excel spreadsheets; personnel in mid-sized companies with established BI systems who are exploring technological updates and more cost-efficient solutions

More Books:

Business Intelligence Tools for Small Companies
Language: en
Pages: 340
Authors: Albert Nogués
Categories: Computers
Type: BOOK - Published: 2017-05-25 - Publisher: Apress

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 an
Business Intelligence Tools for Small Companies
Language: en
Pages: 330
Authors: Albert Nogués
Categories: Computers
Type: BOOK - Published: 2017-06-29 - Publisher: Apress

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 an
Contemporary Perspectives in Data Mining
Language: en
Pages: 169
Authors: Kenneth D. Lawrence
Categories: Computers
Type: BOOK - Published: 2017-09-01 - Publisher: IAP

The series, Contemporary Perspectives on Data Mining, is composed of blind refereed scholarly research methods and applications of data mining. This series will
Business Intelligence: Concepts, Methodologies, Tools, and Applications
Language: en
Pages: 2284
Authors: Management Association, Information Resources
Categories: Computers
Type: BOOK - Published: 2015-12-29 - Publisher: IGI Global

Data analysis is an important part of modern business administration, as efficient compilation of information allows managers and business leaders to make the b
QlikView Your Business
Language: en
Pages: 800
Authors: Oleg Troyansky
Categories: Computers
Type: BOOK - Published: 2015-07-22 - Publisher: John Wiley & Sons

Unlock the meaning of your data with QlikView The Qlik platform was designed to provide a fast and easy data analytics tool, and QlikView Your Business is your
Competing on Analytics
Language: en
Pages: 243
Authors: Thomas H. Davenport
Categories: Business & Economics
Type: BOOK - Published: 2007 - Publisher: Harvard Business Press

"In Competing on Analytics: The New Science of Winning, Thomas H. Davenport and Jeanne G. Harris argue that the frontier for using data has shifted dramatically
Microsoft Business Intelligence Tools for Excel Analysts
Language: en
Pages: 384
Authors: Michael Alexander
Categories: Computers
Type: BOOK - Published: 2014-04-17 - Publisher: John Wiley & Sons

Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts w
Improving Business Performance Through Innovation in the Digital Economy
Language: en
Pages: 272
Authors: Oncioiu, Ionica
Categories: Business & Economics
Type: BOOK - Published: 2019-09-06 - Publisher: IGI Global

In the 21st century, advancements in the digital world are bringing about rapid waves of change in organizational management. As such, it is increasingly impera
Integration of Data Mining in Business Intelligence Systems
Language: en
Pages: 314
Authors: Azevedo, Ana
Categories: Computers
Type: BOOK - Published: 2014-09-30 - Publisher: IGI Global

Uncovering and analyzing data associated with the current business environment is essential in maintaining a competitive edge. As such, making informed decision
Advanced Research in Technologies, Information, Innovation and Sustainability
Language: en
Pages: 741
Authors: Teresa Guarda
Categories: Computers
Type: BOOK - Published: 2021-11-17 - Publisher: Springer Nature

This book constitutes the refereed proceedings of the First International Conference on Advanced Research in Technologies, Information, Innovation and Sustainab