Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

One Spreadsheet, All My Data

No description
by

Matt Milella

on 20 June 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of One Spreadsheet, All My Data

One Spreadsheet, All My Data
Let's Explore Data Sources
Ad-Hoc Data Source
Planning, Essbase, FM
Formula Based Data Sources
FM
Form Based Sources
FM, Planning
Imported Data
OBI, FR
Ad-Hoc Data Sources
Optimized for free-form use.
Zoom, Pivot, Keep and Remove.
Supported by most EPM providers including HFM, Essbase and Planning.
Will issue one operation to the provider based on the operation performed on the client.
Performance is directly tied to the providers query performance.
Not optimal for ‘data export’ type functionality.
May require query performance tuning on the provider.

Lets See it In Action!
Connection Setup
Get your Connections Setup
Consider Private Connections for Easy Access.
Administrators Should Consider a Shared Connection XML File
Setup Options
Understand Data Options and How Suppression and Other Options can impact Data Position
Use Excel Formatting!!
Default Options vs Sheet Options
Formula Based Sources
Optimized for querying low volume unique data points.
Ideal for showing data from more than one source of data on a worksheet and for unique formatting needs.
Supported by most EPM providers including HFM, Essbase and Planning.
Is directly tied to the Excel calculation engine and its performance.
Each cell can issue an individual query on the provider even with only one request sent from Smart View.

Form Based Sources
Supported by EPM providers including HFM and Planning.
Queries to the provider are optimized by the provider.
Structure is fixed and often times designed but an Administrator.
Generally used for Data Input.

Keys to Success
Know Your Providers and How they Work Best
Forms, Ad-Hoc, Functions
Leverage Office Tools and Excel Features
Formulas
Charting
VBA
More
Imported Sources
Supported by OBI and FR
Queries to the provider are optimized by the provider.
Structure is fixed and often times designed but an Administrator.
Generally used for structured reporting.
Full transcript