JMP Connections

The Art of Utilizing Connections In Your Data
Wiley (Verlag)
  • erschienen am 9. Oktober 2017
  • |
  • 240 Seiten
E-Book | ePUB mit Adobe DRM | Systemvoraussetzungen
978-1-119-45372-7 (ISBN)
Achieve best-in-class metrics and get more from your data with JMP
JMP Connections is the small- and medium-sized business owner's guide to exceeding customer expectations by getting more out of your data using JMP. Uniquely bifunctional, this book is divided into two parts: the first half of the book shows you what JMP can do for you. You'll discover how to wring every last drop of insight out of your data, and let JMP parse reams of raw numbers into actionable insight that leads to better strategic decisions. You'll also discover why it works so well; clear explanations break down the Connectivity platform and metrics in business terms to demystify data analysis and JMP while giving you a macro view of the benefits that come from optimal implementation. The second half of the book is for your technical team, demonstrating how to implement specific solutions relating to data set development and data virtualization. In the end, your organization reduces Full Time Equivalents while increasing productivity and competitiveness.
JMP is a powerful tool for business, but many organizations aren't even scratching the surface of what their data can do for them. This book provides the information and technical guidance your business needs to achieve more.
* Learn what a JMP Connectivity Platform can do for your business
* Understand Metrics-on-Demand, Real-Time Metrics, and their implementation
* Delve into technical implementation with information on configuration and management, version control, data visualization, and more
* Make better business decisions by getting more and better information from your data
Business leadership relies on good information to make good business decisions--but what if you could increase the quality of the information you receive, while getting more of what you want to know and less of what you don't need to know? How would that affect strategy, operations, customer experience, and other critical areas? JMP can help with that, and JMP Connections provides real, actionable guidance on getting more out of JMP.
1. Auflage
  • Englisch
  • Newark
  • |
  • USA
John Wiley & Sons
  • 6,17 MB
978-1-119-45372-7 (9781119453727)
1119453720 (1119453720)
weitere Ausgaben werden ermittelt
JOHN WUBBEL is a data science software engineer with a decade of experience using JMP to manufacture products in the life science pharmaceutical industry. His most recent work includes using structured data in graph database systems for advanced analytics, as well as modeling and structuring data for artificial intelligence and machine learning.
Preface xv
Chapter 1 Generalized Context for Decision Process Improvement 1
1.1 Situational Assessment (Current State) 3
1.2 Problem Statement 11
1.3 Visualizing State Transition 15
1.4 Metrics On-Demand 20
Chapter 2 Real-Time Metrics Business Case 25
2.1 Project Description and Objectives--A Case Study 27
2.2 Solution Description 31
2.3 Cost and Benefit Analysis 34
2.4 Financial Assessment 37
2.5 Implementation Timeline 42
2.5.1 Contemplating Startup 42
2.5.2 Skills Dependencies and Timeline Consideration 44
2.5.3 Implementation Starting Point 46
2.5.4 Implementation to Deployment 49
2.6 Critical Assumptions and Risk Assessment 50
2.6.1 Critical Assumptions 50
2.6.2 Risk Assessment 51
2.7 Recommendations: Transmigrate the Enterprise 58
Chapter 3 Technical Details and Practical Implementation 63
3.1 Hardware Foundations 69
3.2 Solution Stack 70
3.3 Integration of Hardware and Software Infrastructure 72
3.4 Build Out 72
3.5 The Construction of a Metric 79
3.6 Metric Case Study 80
Chapter 4 Harvesting Benefits and Extensibility 99
4.1 Benefits Example 100
4.2 Extensibility 101
4.3 Configuration Management Version Control 102
Chapter 5 So What About a Bad Economy? 107
5.1 Overachievement--Data Virtualization 110
5.2 JMP Connection as the Universal Server 114
5.3 Well-Formed Data 117
5.4 Linked Data 120
Chapter 6 Decision Streams 133
Chapter 7 Delivery and Presentations 139
7.1 Push Versus Pull Delivery 140
7.2 Presentation 143
7.3 DIY, But Leave the Poor Bi Person Alone! 156
7.4 Advanced Presentation Method 157
Chapter 8 In Closing (As-Built) 163
Glossary 169
Appendix A Server-Side PHP Code 173
Appendix B JMP JSL Time Constant Learning Curve Script 175
Appendix C JMP GUI User Interface Code Example 181
Appendix D Resource Description Framework File Example 185
Appendix E Sample Hardware Requirements 191
Appendix F Early Warning Deliverable 193
Appendix G JMP PRO Connections: The Transversality of the Capability Maturity Model 203
G.1 Tangential Concept 204
G.2 Transversal Concept 205
G.3 Univariate to Multivariate Process Control 206
G.4 JMP Process Screening 208
G.5 Transversal Maturity Space in Relation to JMP PRO Features 210
G.6 Summary 212
References 213
Suggested Reading 217
Index 219

Generalized Context for Decision Process Improvement

  1. 1.1 Situational Assessment (current state)
  2. 1.2 Problem Statement
  3. 1.3 Visualizing State Transition
  4. 1.4 Metrics On-Demand


Business is making clear that to stay competitive in the market we need to make decisions quickly and often with disparate data sets. JMP CONNECTIONS should be viewed as a business-oriented data discovery tool and is not an information technology (IT) or enterprise SAP®1 Centric model because as is so often the case, data sets are not under the control of the IT department. Data may reside in silos, dozens of spreadsheets, or proprietary database applications. Thus, we can best describe this exercise as the "decision process improvement." If we can improve on the way metrics are produced, it can directly improve the timely implementation of actual decisions for corporate performance management.

The Holy Grail of the Information Age particularly in the information technology (IT) shop is the notion of data integration and interoperability. The Institute of Electrical and Electronics Engineers defines interoperability as:

The ability of two or more systems or components to exchange information and to use the information that has been exchanged.

Unfortunately, interoperability has never been entirely achieved across a large enterprise before.

However, in support of staying competitive, the popular business press and IT periodicals have been pushing "business intelligence" (BI). Business intelligence is a broad category of applications and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions.

As postulated in the Preface, a tough economy implies a propensity to cut back on expenditures across a wide cross section of the enterprise that may also include BI software acquisitions. Utilizing JMP Pro®, the following pages will show precisely how the development of state-of-the-art metrics can be facilitated without the need for a major capital expenditure (CAPEX) project.



Before describing the common state of affairs that may be typical from small to large businesses, a framework for visualizing capability maturity with regard to the development of metrics and their use is outlined in Figure 1.1.

Figure 1.1 JMP CONNECTIONS Capability Maturity Model Levels 0 and 1

  1. The lowest level of capability maturity (Level 0) would be a business or organization that may not have an IT department. Most of the management and reporting of business data is done using spreadsheets and perhaps the facilities of software office suites/applications for presentations. Reporting may be ad hoc or sporadic due to such factors as data that is not readily in a form for use in conducting statistical analysis when required. Companies often have so much data that they realize knowledge is locked up; however, they have no practical, inexpensive way to develop and utilize it.
  2. The first level of maturity (Level 1) is where companies produce dashboards, scorecards, and KPIs on a regular basis. Perhaps on an annual basis, metrics are reviewed for relevance as needs change over time. Metrics retained may be refined and presentation and timely delivery mechanisms are level set2 depending on who is to be receiving them and at what levels of the enterprise they are to be receiving and using them. Publishing BI tools like dashboards (DBs) and scorecards (SCs) have measurable cycle times.
  3. The second level of maturity (Level 2) for an organization would be a realization that some subset of deliverable metrics could be converted to metrics "on-demand." In identifying these on-demand metrics, the cycle time to generate or refresh a set of deliverable dashboards would be completely eliminated. (See Figure 1.2.)

    Figure 1.2 JMP CONNECTIONS Capability Maturity Model Levels 2 and 3

  4. The third and highest level of maturity (Level 3) is a two-part configuration. (See Figure 1.2.)

Level 3, Part 1

  • Eliminate cycle time to create on-demand metrics resulting in reduction in FTEs.

Level 3, Part 2

  • Human capital resource reallocation for:
    • Performing advanced statistical analysis
    • Predictive analytics and modeling

Level 3, Part 1, maturity level, focuses on reducing the time it takes (cycle time) to produce the metrics on a scheduled basis, thus in turn reducing the number of FTEs required to produce those metrics. One FTE required to update a dashboard every week does not leave enough time for any other production tasks for metrics. The amount of time for an FTE is finite. As hours are freed up, other knowledge within the data sets can be developed and utilized. Achieving the second level of maturity leads into Level 3, Part 2 because now predictive analytics and the full power of JMP Pro can be leveraged perhaps without the addition of more FTEs. The graphic view in Figure 1.3 summarizes the reference model for maturity capability for business intelligence metrics.

Figure 1.3 JMP CONNECTIONS Capability Maturity Reference Model

The development of JMP CONNECTIONS is applicable to literally every type of business. All examples cited in this book are totally fictional and for illustrative purposes, which can be adapted to any business. The examples are generic in the sense that the common fuel crucial to business execution is the enterprise data, mature knowledge assets, and performance indicators across the spectrum of organizations that desire optimal results. In many circumstances, particularly in larger firms, one expects to find whatever data they need on the large enterprise database applications. In fact, the information is out there but its access is less than ideal. It may in no way be in a format to provide any statistical analysis capability. It lacks a certain agility for manipulative processes for generating BI tools or data. It is a "what you see is what you get" due to the hard-coded requirements built into the application. Consequently, a query returned is often a table of data or records that do not necessarily communicate or impart knowledge to the recipient. Something extra needs to be done.

Additionally, one would think that, especially within technology firms or scientific and engineering firms, data management would be state of the art. For many and perhaps for a majority, business is conducted using spreadsheets, small desktop database applications, web applications, text files, and sticky notes. In fact, the proliferation of spreadsheets from one year to the next with no sense of version control is prevalent where many sheets act as placeholders for data rather than actually doing any computations or analysis.

Given the standard corporate desktop environment, when a set of metrics are required, they are likely prepared using a combination of the office suite applications. These may include the word processor, spreadsheet, and presentation software applications. A chart or graph may be present with some annotation explaining the meaning of the numbers and is the bare minimum or Level 0 of maturity for making metrics. Thus, it is useful to point out here exactly what types of BI solutions exist.

  1. Executive scorecards and dashboards
  2. Online Analytical Processing (OLAP) analysis
  3. Ad hoc reporting
  4. Operational reporting
  5. Forecasting
  6. Data mining
  7. Customer intelligence

Each of the BI solutions has a data analysis ingredient or function that derives the reported out metric for a particular BI solution. While features and functions may be alike, what sets these apart is how they are applied to support decision making.

To be more precise in thinking about analytic metrics, there are three areas of data analysis derived from data science, information technology, and business applications that can be categorized as follows:

  1. * PREDICTIVE (Forecasting)
  2. * DESCRIPTIVE (Business Intelligence and Data Mining)
  3. * PRESCRIPTIVE (Modeling, Optimization, and Simulation)

Without efficient sharing of operational business intelligence, a company is going to suffer breakdowns from small to large, be unable to properly grow, and could even be flirting with massive disaster. A small issue, for example, can escalate into something very large very quickly if there's not good sharing of business intelligence. No operational intelligence, or incorrect intelligence, means that a company will create and execute strategies and plans (i.e., make decisions) that could inadvertently be bad for the company.

Beyond the Level 3 capability maturity, one may begin to get a sense about the concept of a BI Competency Center. A competency center is inclusive of all three areas when it comes to data analysis-PREDICTIVE, DESCRIPTIVE, and PRESCRIPTIVE-with respect to applying BI solutions to support various decision-making units within the enterprise. The competency center concept also can act as a facilitator for efficiently...

Dateiformat: EPUB
Kopierschutz: Adobe-DRM (Digital Rights Management)


Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).

Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions (siehe E-Book Hilfe).

E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat EPUB ist sehr gut für Romane und Sachbücher geeignet - also für "fließenden" Text ohne komplexes Layout. Bei E-Readern oder Smartphones passt sich der Zeilen- und Seitenumbruch automatisch den kleinen Displays an. Mit Adobe-DRM wird hier ein "harter" Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Download (sofort verfügbar)

34,99 €
inkl. 19% MwSt.
Download / Einzel-Lizenz
ePUB mit Adobe DRM
siehe Systemvoraussetzungen
E-Book bestellen

Unsere Web-Seiten verwenden Cookies. Mit der Nutzung des WebShops erklären Sie sich damit einverstanden. Mehr Informationen finden Sie in unserem Datenschutzhinweis. Ok