Business Intelligence Tools for Small Companies: A Guide to Free and Low-Cost Solutions
by: Albert Nogués – Juan Valladares
ISBN-10: 1484225678
ISBN-13: 9781484225677
Edition 版次: 1st ed.
Publication Date 出版日期: 2017-06-24
Print Length 页数: 326
Book Description
By finelybook
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
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: ETL 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
了解如何从基于Excel的商业智能（BI）分析过渡到企业级的开源BI工具。选择并实施最佳的免费和免费增值的开放源码商业智能工具，满足您公司的需求，并使用敏捷方法设计，实施和整合BI自动化。
小型企业的商业智能工具提供适合小企业BI要求的开源工具的实际演示。作者利用他们作为BI顾问，开发人员和管理员的深刻经验，指导您完成从企业资源规划（ERP）数据库提取数据的提取 – 转换加载/数据仓库（ETL / DWH）序列，互联网，转换数据，操纵它们，并将它们加载到关系数据库中。
作者演示如何从关系数据库管理系统（RDBMS）以视觉吸引人的格式提取，报告和仪表板关键绩效指标（KPI）。他们模拟免费和免费增值工具的选择和实施，例如Pentaho Data Integrator和Talend for ELT，Oracle XE和MySQL / MariaDB for RDBMS，以及Qliksense，Power BI和MicroStrategy Desktop进行报告。这个丰富的说明指南模拟了在诸如AWS之类的廉价云平台上部署小型公司BI堆栈。
你会学到什么
您将学习如何通过选择和实施工具来管理，集成和自动化BI流程:
实施和管理商业智能/数据仓库（BI / DWH）基础设施
从任何企业资源规划（ERP）工具中提取数据
使用开放源代码提取 – 转换加载（ETL）工具来处理和集成BI数据
使用开源可视化和仪表板工具查询，报告和分析BI数据
使用MOLAP工具来定义明年的预算，将实际数据与目标场景进行整合
在云平台上低成本地部署BI解决方案和大数据实验
这本书是谁
工程师，DBA，分析师，顾问和管理人员在资源有限但其BI要求超出Excel电子表格限制的小公司;具有成熟BI系统的中型企业的人员正在探索技术更新和更具成本效益的解决方案
目录
第一章: 大家的商业智能
第2章: BI项目的敏捷方法
第3章: SQL基础知识
第4章: 项目初始化 – 数据库和源ERP安装
第5章: BI解决方案的数据建模
第6章: ETL基础知识
第7章: 性能改进
第8章: BI报告界面
第9章: MOLAP预算工具
第10章: BI流程调度: 如何协调和更新运行的进程
第11章: 转向生产环境
第12章: 将BI流程移动到云端
第13章: 结论和后续步骤
