Author: David Loshin
Publisher: Newnes
ISBN: 0123858909
Category : Computers
Languages : en
Pages : 401
Book Description
Business Intelligence: The Savvy Managers Guide, Second Edition, discusses the objectives and practices for designing and deploying a business intelligence (BI) program. It looks at the basics of a BI program, from the value of information and the mechanics of planning for success to data model infrastructure, data preparation, data analysis, integration, knowledge discovery, and the actual use of discovered knowledge. Organized into 21 chapters, this book begins with an overview of the kind of knowledge that can be exposed and exploited through the use of BI. It then proceeds with a discussion of information use in the context of how value is created within an organization, how BI can improve the ways of doing business, and organizational preparedness for exploiting the results of a BI program. It also looks at some of the critical factors to be taken into account in the planning and execution of a successful BI program. In addition, the reader is introduced to considerations for developing the BI roadmap, the platforms for analysis such as data warehouses, and the concepts of business metadata. Other chapters focus on data preparation and data discovery, the business rules approach, and data mining techniques and predictive analytics. Finally, emerging technologies such as text analytics and sentiment analysis are considered. This book will be valuable to data management and BI professionals, including senior and middle-level managers, Chief Information Officers and Chief Data Officers, senior business executives and business staff members, database or software engineers, and business analysts. - Guides managers through developing, administering, or simply understanding business intelligence technology - Keeps pace with the changes in best practices, tools, methods and processes used to transform an organization's data into actionable knowledge - Contains a handy, quick-reference to technologies and terminology
Business Intelligence
Author: David Loshin
Publisher: Newnes
ISBN: 0123858909
Category : Computers
Languages : en
Pages : 401
Book Description
Business Intelligence: The Savvy Managers Guide, Second Edition, discusses the objectives and practices for designing and deploying a business intelligence (BI) program. It looks at the basics of a BI program, from the value of information and the mechanics of planning for success to data model infrastructure, data preparation, data analysis, integration, knowledge discovery, and the actual use of discovered knowledge. Organized into 21 chapters, this book begins with an overview of the kind of knowledge that can be exposed and exploited through the use of BI. It then proceeds with a discussion of information use in the context of how value is created within an organization, how BI can improve the ways of doing business, and organizational preparedness for exploiting the results of a BI program. It also looks at some of the critical factors to be taken into account in the planning and execution of a successful BI program. In addition, the reader is introduced to considerations for developing the BI roadmap, the platforms for analysis such as data warehouses, and the concepts of business metadata. Other chapters focus on data preparation and data discovery, the business rules approach, and data mining techniques and predictive analytics. Finally, emerging technologies such as text analytics and sentiment analysis are considered. This book will be valuable to data management and BI professionals, including senior and middle-level managers, Chief Information Officers and Chief Data Officers, senior business executives and business staff members, database or software engineers, and business analysts. - Guides managers through developing, administering, or simply understanding business intelligence technology - Keeps pace with the changes in best practices, tools, methods and processes used to transform an organization's data into actionable knowledge - Contains a handy, quick-reference to technologies and terminology
Publisher: Newnes
ISBN: 0123858909
Category : Computers
Languages : en
Pages : 401
Book Description
Business Intelligence: The Savvy Managers Guide, Second Edition, discusses the objectives and practices for designing and deploying a business intelligence (BI) program. It looks at the basics of a BI program, from the value of information and the mechanics of planning for success to data model infrastructure, data preparation, data analysis, integration, knowledge discovery, and the actual use of discovered knowledge. Organized into 21 chapters, this book begins with an overview of the kind of knowledge that can be exposed and exploited through the use of BI. It then proceeds with a discussion of information use in the context of how value is created within an organization, how BI can improve the ways of doing business, and organizational preparedness for exploiting the results of a BI program. It also looks at some of the critical factors to be taken into account in the planning and execution of a successful BI program. In addition, the reader is introduced to considerations for developing the BI roadmap, the platforms for analysis such as data warehouses, and the concepts of business metadata. Other chapters focus on data preparation and data discovery, the business rules approach, and data mining techniques and predictive analytics. Finally, emerging technologies such as text analytics and sentiment analysis are considered. This book will be valuable to data management and BI professionals, including senior and middle-level managers, Chief Information Officers and Chief Data Officers, senior business executives and business staff members, database or software engineers, and business analysts. - Guides managers through developing, administering, or simply understanding business intelligence technology - Keeps pace with the changes in best practices, tools, methods and processes used to transform an organization's data into actionable knowledge - Contains a handy, quick-reference to technologies and terminology
Business Intelligence
Author: Marie-Aude Aufaure
Publisher: Springer Science & Business Media
ISBN: 3642273572
Category : Business & Economics
Languages : en
Pages : 215
Book Description
Business Intelligence (BI) promises an organization the capability of collecting and analyzing internal and external data to generate knowledge and value, providing decision support at the strategic, tactical, and operational levels. Business Intelligence is now impacted by the Big Data phenomena and the evolution of society and users, and needs to take into account high-level semantics, reasoning about unstructured and structured data, and to provide a simplified access and better understanding of diverse BI tools accessible trough mobile devices. In particular, BI applications must cope with additional heterogeneous (often Web-based) sources, e.g., from social networks, blogs, competitors’, suppliers’, or distributors’ data, governmental or NGO-based analysis and papers, or from research publications. The lectures held at the First European Business Intelligence Summer School (eBISS), which are presented here in an extended and refined format, cover not only established BI technologies like data warehouses, OLAP query processing, or performance issues, but extend into new aspects that are important in this new environment and for novel applications, e.g., semantic technologies, social network analysis and graphs, services, large-scale management, or collaborative decision making. Combining papers by leading researchers in the field, this volume will equip the reader with the state-of-the-art background necessary for inventing the future of BI. It will also provide the reader with an excellent basis and many pointers for further research in this growing field.
Publisher: Springer Science & Business Media
ISBN: 3642273572
Category : Business & Economics
Languages : en
Pages : 215
Book Description
Business Intelligence (BI) promises an organization the capability of collecting and analyzing internal and external data to generate knowledge and value, providing decision support at the strategic, tactical, and operational levels. Business Intelligence is now impacted by the Big Data phenomena and the evolution of society and users, and needs to take into account high-level semantics, reasoning about unstructured and structured data, and to provide a simplified access and better understanding of diverse BI tools accessible trough mobile devices. In particular, BI applications must cope with additional heterogeneous (often Web-based) sources, e.g., from social networks, blogs, competitors’, suppliers’, or distributors’ data, governmental or NGO-based analysis and papers, or from research publications. The lectures held at the First European Business Intelligence Summer School (eBISS), which are presented here in an extended and refined format, cover not only established BI technologies like data warehouses, OLAP query processing, or performance issues, but extend into new aspects that are important in this new environment and for novel applications, e.g., semantic technologies, social network analysis and graphs, services, large-scale management, or collaborative decision making. Combining papers by leading researchers in the field, this volume will equip the reader with the state-of-the-art background necessary for inventing the future of BI. It will also provide the reader with an excellent basis and many pointers for further research in this growing field.
Integrated Business Information Systems
Author: Klaus-Dieter Gronwald
Publisher: Springer
ISBN: 3662532913
Category : Computers
Languages : en
Pages : 206
Book Description
Enterprise Resource Planning (ERP), Supply Chain Management (SCM), Customer Relationship Management (CRM), Business Intelligence (BI) and Big Data Analytics (BDA) are business related tasks and processes, which are supported by standardized software solutions. The book explains that this requires business oriented thinking and acting from IT specialists and data scientists. It is a good idea to let students experience this directly from the business perspective, for example as executives of a virtual company. The course simulates the stepwise integration of the linked business process chain ERP-SCM-CRM-BI-Big Data of four competing groups of companies. The course participants become board members with full P&L responsibility for business units of one of four beer brewery groups managing supply chains from production to retailer.
Publisher: Springer
ISBN: 3662532913
Category : Computers
Languages : en
Pages : 206
Book Description
Enterprise Resource Planning (ERP), Supply Chain Management (SCM), Customer Relationship Management (CRM), Business Intelligence (BI) and Big Data Analytics (BDA) are business related tasks and processes, which are supported by standardized software solutions. The book explains that this requires business oriented thinking and acting from IT specialists and data scientists. It is a good idea to let students experience this directly from the business perspective, for example as executives of a virtual company. The course simulates the stepwise integration of the linked business process chain ERP-SCM-CRM-BI-Big Data of four competing groups of companies. The course participants become board members with full P&L responsibility for business units of one of four beer brewery groups managing supply chains from production to retailer.
Business Intelligence Strategy and Big Data Analytics
Author: Steve Williams
Publisher: Morgan Kaufmann
ISBN: 0128094893
Category : Computers
Languages : en
Pages : 241
Book Description
Business Intelligence Strategy and Big Data Analytics is written for business leaders, managers, and analysts - people who are involved with advancing the use of BI at their companies or who need to better understand what BI is and how it can be used to improve profitability. It is written from a general management perspective, and it draws on observations at 12 companies whose annual revenues range between $500 million and $20 billion. Over the past 15 years, my company has formulated vendor-neutral business-focused BI strategies and program execution plans in collaboration with manufacturers, distributors, retailers, logistics companies, insurers, investment companies, credit unions, and utilities, among others. It is through these experiences that we have validated business-driven BI strategy formulation methods and identified common enterprise BI program execution challenges. In recent years, terms like "big data and "big data analytics have been introduced into the business and technical lexicon. Upon close examination, the newer terminology is about the same thing that BI has always been about: analyzing the vast amounts of data that companies generate and/or purchase in the course of business as a means of improving profitability and competitiveness. Accordingly, we will use the terms BI and business intelligence throughout the book, and we will discuss the newer concepts like big data as appropriate. More broadly, the goal of this book is to share methods and observations that will help companies achieve BI success and thereby increase revenues, reduce costs, or both. - Provides ideas for improving the business performance of one's company or business functions - Emphasizes proven, practical, step-by-step methods that readers can readily apply in their companies - Includes exercises and case studies with road-tested advice about formulating BI strategies and program plans
Publisher: Morgan Kaufmann
ISBN: 0128094893
Category : Computers
Languages : en
Pages : 241
Book Description
Business Intelligence Strategy and Big Data Analytics is written for business leaders, managers, and analysts - people who are involved with advancing the use of BI at their companies or who need to better understand what BI is and how it can be used to improve profitability. It is written from a general management perspective, and it draws on observations at 12 companies whose annual revenues range between $500 million and $20 billion. Over the past 15 years, my company has formulated vendor-neutral business-focused BI strategies and program execution plans in collaboration with manufacturers, distributors, retailers, logistics companies, insurers, investment companies, credit unions, and utilities, among others. It is through these experiences that we have validated business-driven BI strategy formulation methods and identified common enterprise BI program execution challenges. In recent years, terms like "big data and "big data analytics have been introduced into the business and technical lexicon. Upon close examination, the newer terminology is about the same thing that BI has always been about: analyzing the vast amounts of data that companies generate and/or purchase in the course of business as a means of improving profitability and competitiveness. Accordingly, we will use the terms BI and business intelligence throughout the book, and we will discuss the newer concepts like big data as appropriate. More broadly, the goal of this book is to share methods and observations that will help companies achieve BI success and thereby increase revenues, reduce costs, or both. - Provides ideas for improving the business performance of one's company or business functions - Emphasizes proven, practical, step-by-step methods that readers can readily apply in their companies - Includes exercises and case studies with road-tested advice about formulating BI strategies and program plans
Business Intelligence Guidebook
Author: Rick Sherman
Publisher: Newnes
ISBN: 0124115284
Category : Computers
Languages : en
Pages : 551
Book Description
Between the high-level concepts of business intelligence and the nitty-gritty instructions for using vendors' tools lies the essential, yet poorly-understood layer of architecture, design and process. Without this knowledge, Big Data is belittled – projects flounder, are late and go over budget. Business Intelligence Guidebook: From Data Integration to Analytics shines a bright light on an often neglected topic, arming you with the knowledge you need to design rock-solid business intelligence and data integration processes. Practicing consultant and adjunct BI professor Rick Sherman takes the guesswork out of creating systems that are cost-effective, reusable and essential for transforming raw data into valuable information for business decision-makers. After reading this book, you will be able to design the overall architecture for functioning business intelligence systems with the supporting data warehousing and data-integration applications. You will have the information you need to get a project launched, developed, managed and delivered on time and on budget – turning the deluge of data into actionable information that fuels business knowledge. Finally, you'll give your career a boost by demonstrating an essential knowledge that puts corporate BI projects on a fast-track to success. - Provides practical guidelines for building successful BI, DW and data integration solutions. - Explains underlying BI, DW and data integration design, architecture and processes in clear, accessible language. - Includes the complete project development lifecycle that can be applied at large enterprises as well as at small to medium-sized businesses - Describes best practices and pragmatic approaches so readers can put them into action. - Companion website includes templates and examples, further discussion of key topics, instructor materials, and references to trusted industry sources.
Publisher: Newnes
ISBN: 0124115284
Category : Computers
Languages : en
Pages : 551
Book Description
Between the high-level concepts of business intelligence and the nitty-gritty instructions for using vendors' tools lies the essential, yet poorly-understood layer of architecture, design and process. Without this knowledge, Big Data is belittled – projects flounder, are late and go over budget. Business Intelligence Guidebook: From Data Integration to Analytics shines a bright light on an often neglected topic, arming you with the knowledge you need to design rock-solid business intelligence and data integration processes. Practicing consultant and adjunct BI professor Rick Sherman takes the guesswork out of creating systems that are cost-effective, reusable and essential for transforming raw data into valuable information for business decision-makers. After reading this book, you will be able to design the overall architecture for functioning business intelligence systems with the supporting data warehousing and data-integration applications. You will have the information you need to get a project launched, developed, managed and delivered on time and on budget – turning the deluge of data into actionable information that fuels business knowledge. Finally, you'll give your career a boost by demonstrating an essential knowledge that puts corporate BI projects on a fast-track to success. - Provides practical guidelines for building successful BI, DW and data integration solutions. - Explains underlying BI, DW and data integration design, architecture and processes in clear, accessible language. - Includes the complete project development lifecycle that can be applied at large enterprises as well as at small to medium-sized businesses - Describes best practices and pragmatic approaches so readers can put them into action. - Companion website includes templates and examples, further discussion of key topics, instructor materials, and references to trusted industry sources.
Business Intelligence
Author: Jerzy Surma
Publisher: Business Expert Press
ISBN: 1606491865
Category : Business & Economics
Languages : en
Pages : 161
Book Description
This book is about using business intelligence as a management information system for supporting managerial decision making. It concentrates primarily on practical business issues and demonstrates how to apply data warehousing and data analytics to support business decision making. This book progresses through a logical sequence, starting with data model infrastructure, then data preparation, followed by data analysis, integration, knowledge discovery, and finally the actual use of discovered knowledge. All examples are based on the most recent achievements in business intelligence. Finally this book outlines an overview of a methodology that takes into account the complexity of developing applications in an integrated business intelligence environment. This book is written for managers, business consultants, and undergraduate and postgraduates students in business administration.
Publisher: Business Expert Press
ISBN: 1606491865
Category : Business & Economics
Languages : en
Pages : 161
Book Description
This book is about using business intelligence as a management information system for supporting managerial decision making. It concentrates primarily on practical business issues and demonstrates how to apply data warehousing and data analytics to support business decision making. This book progresses through a logical sequence, starting with data model infrastructure, then data preparation, followed by data analysis, integration, knowledge discovery, and finally the actual use of discovered knowledge. All examples are based on the most recent achievements in business intelligence. Finally this book outlines an overview of a methodology that takes into account the complexity of developing applications in an integrated business intelligence environment. This book is written for managers, business consultants, and undergraduate and postgraduates students in business administration.
Business Intelligence Techniques
Author: Murugan Anandarajan
Publisher: Springer Science & Business Media
ISBN: 3540247009
Category : Business & Economics
Languages : en
Pages : 271
Book Description
Modern businesses generate huge volumes of accounting data on a daily basis. The recent advancements in information technology have given organizations the ability to capture and store data in an efficient and effective manner. However, there is a widening gap between this data storage and usage of the data. Business intelligence techniques can help an organization obtain and process relevant accounting data quickly and cost efficiently. Such techniques include: query and reporting tools, online analytical processing (OLAP), statistical analysis, text mining, data mining, and visualization. Business Intelligence Techniques is a compilation of chapters written by experts in the various areas. While these chapters stand on their own, taken together they provide a comprehensive overview of how to exploit accounting data in the business environment.
Publisher: Springer Science & Business Media
ISBN: 3540247009
Category : Business & Economics
Languages : en
Pages : 271
Book Description
Modern businesses generate huge volumes of accounting data on a daily basis. The recent advancements in information technology have given organizations the ability to capture and store data in an efficient and effective manner. However, there is a widening gap between this data storage and usage of the data. Business intelligence techniques can help an organization obtain and process relevant accounting data quickly and cost efficiently. Such techniques include: query and reporting tools, online analytical processing (OLAP), statistical analysis, text mining, data mining, and visualization. Business Intelligence Techniques is a compilation of chapters written by experts in the various areas. While these chapters stand on their own, taken together they provide a comprehensive overview of how to exploit accounting data in the business environment.
AI Meets BI
Author: Lakshman Bulusu
Publisher: CRC Press
ISBN: 1000281957
Category : Computers
Languages : en
Pages : 0
Book Description
With the emergence of Artificial Intelligence (AI) in the business world, a new era of Business Intelligence (BI) has been ushered in to create real-world business solutions using analytics. BI developers and practitioners now have tools and technologies to create systems and solutions to guide effective decision making. Decisions can be made on the basis of more reliable and accurate information and intelligence, which can lead to valuable, actionable insights for business. Previously, BI professionals were stymied by bad or incomplete data, poorly architected solutions, or even just outright incapable systems or resources. With the advent of AI, BI has new possibilities for effectiveness. This is a long-awaited phase for practitioners and developers and, moreover, for executives and leaders relying on knowledgeable and intelligent decision making for their organizations. Beginning with an outline of the traditional methods for implementing BI in the enterprise and how BI has evolved into using self-service analytics, data discovery, and most recently AI, AI Meets BI first lays out the three typical architectures of the first, second, and third generations of BI. It then takes an in-depth look at various types of analytics and highlights how each of these can be implemented using AI-enabled algorithms and deep learning models. The crux of the book is four industry use cases. They describe how an enterprise can access, assess, and perform analytics on data by way of discovering data, defining key metrics that enable the same, defining governance rules, and activating metadata for AI/ML recommendations. Explaining the implementation specifics of each of these four use cases by way of using various AI-enabled machine learning and deep learning algorithms, this book provides complete code for each of the implementations, along with the output of the code, supplemented by visuals that aid in BI-enabled decision making. Concluding with a brief discussion of the cognitive computing aspects of AI, the book looks at future trends, including augmented analytics, automated and autonomous BI, and security and governance of AI-powered BI.
Publisher: CRC Press
ISBN: 1000281957
Category : Computers
Languages : en
Pages : 0
Book Description
With the emergence of Artificial Intelligence (AI) in the business world, a new era of Business Intelligence (BI) has been ushered in to create real-world business solutions using analytics. BI developers and practitioners now have tools and technologies to create systems and solutions to guide effective decision making. Decisions can be made on the basis of more reliable and accurate information and intelligence, which can lead to valuable, actionable insights for business. Previously, BI professionals were stymied by bad or incomplete data, poorly architected solutions, or even just outright incapable systems or resources. With the advent of AI, BI has new possibilities for effectiveness. This is a long-awaited phase for practitioners and developers and, moreover, for executives and leaders relying on knowledgeable and intelligent decision making for their organizations. Beginning with an outline of the traditional methods for implementing BI in the enterprise and how BI has evolved into using self-service analytics, data discovery, and most recently AI, AI Meets BI first lays out the three typical architectures of the first, second, and third generations of BI. It then takes an in-depth look at various types of analytics and highlights how each of these can be implemented using AI-enabled algorithms and deep learning models. The crux of the book is four industry use cases. They describe how an enterprise can access, assess, and perform analytics on data by way of discovering data, defining key metrics that enable the same, defining governance rules, and activating metadata for AI/ML recommendations. Explaining the implementation specifics of each of these four use cases by way of using various AI-enabled machine learning and deep learning algorithms, this book provides complete code for each of the implementations, along with the output of the code, supplemented by visuals that aid in BI-enabled decision making. Concluding with a brief discussion of the cognitive computing aspects of AI, the book looks at future trends, including augmented analytics, automated and autonomous BI, and security and governance of AI-powered BI.
Business Intelligence
Author: Carlo Vercellis
Publisher: John Wiley & Sons
ISBN: 1119965470
Category : Mathematics
Languages : en
Pages : 314
Book Description
Business intelligence is a broad category of applications and technologies for gathering, providing access to, and analyzing data for the purpose of helping enterprise users make better business decisions. The term implies having a comprehensive knowledge of all factors that affect a business, such as customers, competitors, business partners, economic environment, and internal operations, therefore enabling optimal decisions to be made. Business Intelligence provides readers with an introduction and practical guide to the mathematical models and analysis methodologies vital to business intelligence. This book: Combines detailed coverage with a practical guide to the mathematical models and analysis methodologies of business intelligence. Covers all the hot topics such as data warehousing, data mining and its applications, machine learning, classification, supply optimization models, decision support systems, and analytical methods for performance evaluation. Is made accessible to readers through the careful definition and introduction of each concept, followed by the extensive use of examples and numerous real-life case studies. Explains how to utilise mathematical models and analysis models to make effective and good quality business decisions. This book is aimed at postgraduate students following data analysis and data mining courses. Researchers looking for a systematic and broad coverage of topics in operations research and mathematical models for decision-making will find this an invaluable guide.
Publisher: John Wiley & Sons
ISBN: 1119965470
Category : Mathematics
Languages : en
Pages : 314
Book Description
Business intelligence is a broad category of applications and technologies for gathering, providing access to, and analyzing data for the purpose of helping enterprise users make better business decisions. The term implies having a comprehensive knowledge of all factors that affect a business, such as customers, competitors, business partners, economic environment, and internal operations, therefore enabling optimal decisions to be made. Business Intelligence provides readers with an introduction and practical guide to the mathematical models and analysis methodologies vital to business intelligence. This book: Combines detailed coverage with a practical guide to the mathematical models and analysis methodologies of business intelligence. Covers all the hot topics such as data warehousing, data mining and its applications, machine learning, classification, supply optimization models, decision support systems, and analytical methods for performance evaluation. Is made accessible to readers through the careful definition and introduction of each concept, followed by the extensive use of examples and numerous real-life case studies. Explains how to utilise mathematical models and analysis models to make effective and good quality business decisions. This book is aimed at postgraduate students following data analysis and data mining courses. Researchers looking for a systematic and broad coverage of topics in operations research and mathematical models for decision-making will find this an invaluable guide.
Business Intelligence Tools for Small Companies
Author: Albert Nogués
Publisher: Apress
ISBN: 1484225686
Category : Computers
Languages : en
Pages : 340
Book Description
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
Publisher: Apress
ISBN: 1484225686
Category : Computers
Languages : en
Pages : 340
Book Description
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