Financial Business Intelligence: Trends, Technology, Software Selection, and ImplementationTurn storehouses of data into a strategic tool Business intelligence has recently become a word used by almost every CFO, controller, and analyst. After having spent the last decade implementing Enterprise Resource Planning software and other mission critical solutions, companies now have large databases with transactional data sitting in their computer rooms. Now, finally, the technology has reached a point where it is possible- in almost real time-to quickly and easily analyze the financial data in the corporate databases, to be able to make more intelligent business decisions. This book will help financial managers understand the trends, technology, software selection, and implementation of financial business intelligence (financial BI) software. With a dictionary of business intelligence terms, a comprehensive list of Request for Proposal questions, and examples of popular financial business intelligence reroutes and user interfaces, this book enables managers to measure their companies' business intelligence and maximize its value. |
From inside the book
Results 1-5 of 31
Page xv
... interfaces. In addition to covering these technologies, Part Two looks at how the Web quickly is becoming a delivery vehicle and an important platform for most business intelligence solutions. Furthermore, this part of the book ...
... interfaces. In addition to covering these technologies, Part Two looks at how the Web quickly is becoming a delivery vehicle and an important platform for most business intelligence solutions. Furthermore, this part of the book ...
Page 6
... interface that has direct access to all the information that resides in their company's financial databases is that different software vendors have never been good at extracting and delivering data to each other's databases ...
... interface that has direct access to all the information that resides in their company's financial databases is that different software vendors have never been good at extracting and delivering data to each other's databases ...
Page 14
... interface to all the BI tools. Past Today Decentralized system Centralized and integrated Static users Scaleable Low security concerns High security concerns Mostly batch updates More real time Noncritical availability More critical ...
... interface to all the BI tools. Past Today Decentralized system Centralized and integrated Static users Scaleable Low security concerns High security concerns Mostly batch updates More real time Noncritical availability More critical ...
Page 15
... interface D) Use of possible integrated BI solution that comes from the ERP vendor E) Use a datawarehouse as the data source for the end-user BI tool Data- warehouse Web Portal FIGURE 1.9 Datawarehouse and data mart configurations ...
... interface D) Use of possible integrated BI solution that comes from the ERP vendor E) Use a datawarehouse as the data source for the end-user BI tool Data- warehouse Web Portal FIGURE 1.9 Datawarehouse and data mart configurations ...
Page 17
... interface—for report writing, report processing, and drill-down from a web browser • Intelligent trees—tree hierarchies are increasingly popular to automate consolidation report writing and drill-down. Intelligent trees can also provide ...
... interface—for report writing, report processing, and drill-down from a web browser • Intelligent trees—tree hierarchies are increasingly popular to automate consolidation report writing and drill-down. Intelligent trees can also provide ...
Contents
1 | |
Part Two BI Technology | 67 |
Part Three Software Evaluation and Selection | 107 |
Part Four Implementing a Business Intelligence System | 145 |
Appendix A Sample RFP | 199 |
Appendix B Software Candidate Evaluation and Rating Sheet | 221 |
Appendix C Sample License Agreement | 223 |
Appendix D Sample Confidentiality and Nondisclosure Agreement SalesDemo Process | 229 |
Appendix E Sample Support PlanAgreement | 233 |
Appendix F Sample Project Plan | 235 |
Appendix G Sample Consulting Agreement | 237 |
Appendix H Vendor Addresses | 241 |
Appendix I References and Further Reading | 249 |
Glossary | 251 |
Index | 279 |
Other editions - View all
Common terms and phrases
1999–2001 ProClarity Corporation account numbers Advantage Pty Limited Agreement analysis analytical application balanced scorecard budget business intelligence client company’s Consultant cost create customers data mart data model data sources database datawarehouse datawarehousing decision defined desktop dimension tables drill-down end users enterprise Enterprise Information Portal ETL process evaluation example Feature Description Y/N/P FIGURE formation functionality hierarchy implementation information consumers informational needs interface Internet Item Feature Description Licensee Microsoft Microsoft Analysis Services MOLAP multidimensional OLAP cube OLTP online analytical processing organization performance portal ProClarity Professional Advantage Pty project plan Reply Vendor Item report writers requirements revenue ROLAP server snowflake schema software selection solution source data specific spreadsheet star schema tion today’s Toll Free transaction typically updates Vendor Item Feature Vendor Reply Vendor warehouse web-based XBRL
Popular passages
Page 266 - Management control is the process by which managers assure that resources are obtained and used effectively and efficiently in the accomplishment of the organization's objectives.
Page 270 - Query Response Times The time it takes for the warehouse engine to process a complex query across a large volume of data and return the results to the requester. Query Tools Software that allows a user to create and direct specific questions to a database. These tools provide the means for pulling the desired information from a database. They are typically SQL-based tools and allow a user to define data in end-user language.
Page 273 - Standard Cost System A system by which production activities are recorded at standard costs and variances from actual costs are isolated. Standard Costs Production or operating costs that are carefully predetermined.
Page 272 - The ability to scale to support larger or smaller volumes of data and more or fewer users. The ability to increase or decrease size or capability in cost-effective increments with minimal impact on the unit cost of business and the procurement of additional services.
Page 267 - Normalization - The process of reducing a complex data structure into its simplest, most stable structure. In general, the process entails the removal of redundant attributes, keys, and relationships from a conceptual data model.
References to this book
Marktorientierte Steuerungsgrößen mit Hilfe von Datenbanken - dargestellt an ... Dennis Grzywatz No preview available - 2008 |