Transcript Document

Getting To Your Data
Mike Glue
Data Collection
process of gathering information on
variables of interest
Why do it?
To capture quality evidence that
translates to rich data analysis and
allows the building of a convincing and
credible answer to questions that have
been posed
Data Analysis
process of inspecting, cleaning, transforming, and modeling
data with the goal of discovering useful information,
suggesting conclusions, and supporting decision making
Defining data is the most important part of data analysis
- wisegeek.org
What do you want to know?
Database
an organized collection of data
1,749 tables
in JF 2013 R2 !
So How Do I Get To All That Data?
XMLPort
• Export
• Import
• XML/text format
• Business logic
• Handles flowfields
• Requires object
Configuration
Packages
• User-definable
• Export direct to Excel
• RapidStart
• No business logic
• Handles flowfields
• “Get Related Tables”
Pull Direct From Table
• Security concerns
• Security
management
• Need to know table
names
• Need to know table
relations
• Does not handle
flowfields
Send to Excel
Query
• NAV security applies
• Handles flowfields
• Limited business
logic
• Executes directly on
SQL Server
• Publish controlled
data models to users
• Object required
• OData
Send to Excel: demo
Configuration Packages: demo
Query: demo
Recap
• Data collection
• Data analysis
• Multiple methods to get data
– Different technical skills required
Questions