Using this tool presents an opportunity to change for the better how MS Excel is used to gain business relevant perspective and understanding from data in a database.
Old way
-
Manual exports from Source System DBs into a BI layer, then pull large CSV files
-
VLookups-a-palooza to assemble subsets of tablular information
-
Develop analysis, charts, etc to present business information
Incremental Improvement
-
Connect to one DB in the Cloud
-
Pull large CSV files
-
VLookups-a-palooza to assemble subsets of tabular information
-
Develop analysis, charts, etc to present business information
New and better way with FlowObjects Excel Add-in Tool
-
Connect directly to DB
-
Using SQL queries, pull into excel only what is required for the business analysis
-
Let the DB do the heavy lifting
-
No more choking on million+ row CSV files
-
No more VLookups
-
More accurate and performant
