Video Library

Learn how to get up and running in next to no time with Info-Explorer, Orchid's powerful yet affordable Business Intelligence (BI) tool. Examples in this video refer to Sage 300, but the same method applies to other databases, such as Spire Systems. 

00:00 Introduction & Overview
01:00 Download and Install Info-Explorer
02:08 Download AP Open Payables Sample Cube
03:35 Working with Info-Explorer
03:56 Connect to your Company Database
04:21 Refresh a Cube
04:45 Slice and Dice / create a View
08:37 Filter and Sort
10:03 Add Formulas and Formatting
13:48 Add Charts and Dashboards
15:08 Drill-Down / Drill-Through
21:27 Info-Explorer Editions

Anne demonstrates budgeting in Sage 300 using Orchid's Optional Tables Spreadsheet Add-in for Microsoft Excel, plus Info-Explorer Writeback.
(Jan-2020)

Nathalie shows how the Writeback feature of Orchid's Info-Explorer can be used to support detailed budgeting . Examples refer to Sage 300, but most of the spread methods and worksets feature can assist budgeting in other applications too. 
(Dec-2019)

Nathalie conducts advanced training on how to get the most out of Orchid's Info-Explorer BI tool, including tips and tricks on some lesser known features. 
(Sep-2018)
00:00 Introduction
01:15 Security Best Practices
02:30 Performance Consideration and refresh
11:03 Advanced SQL Query Tips (using parameter, Group by, filter and parameters)
19:00 Dimension and facts - Using UNION ALL to include data across databases and transaction types
33:45 Drill-down and drill-through tips
38:52 Dynamic reporting, Date functions, Cube formulas, for % column, Rank, Top 5
47:50 Dashboard

Anne gives a detailed demonstration of Orchid's Info-Explorer module. Business Intelligence at an affordable price, with integrated budgeting & forecasting.

00:00 Orchid Overview
05:16 Info-Explorer Overview
10:38 Creating a cube – the basics
17:30 Calculated fields
20:15 Creating a new view, and pre-filters
22:30 Graphs and Dashboards
24:36 Using Sample Cubes – slice & dice, formulas
27:47 Sorting, filtering, styles, formatting
31:20 Cubes across multiple databases
33:45 Budgeting and write back to GL Budgets
40:44 Drill Down and Drill Through
43:47 Summary
44:30 Info-Explorer Lite (free, try before you buy)

Robert Lavery gives a brief overview of Orchid's Info-Explorer module.
Business Intelligence at an affordable price, with integrated budgeting & forecasting.

00:00 Introduction & About Orchid
01:02 Key Feature & Benefits of Info-Explorer
03:41 Budgeting & Forecasting benefits
04:16 Info-Explorer Lite (free edition)
04:56 Compatibility & wrap-up
 

What Orchid's Sage Business Partners have to say about working with Orchid Systems.
(Jun-2014)

Anne shows in detail how Orchid's Optional Tables and Info-Explorer (with Writeback) can be used in partnership to easily create and maintain detailed budgets and forecasts within Sage 300.

00:00 Introduction to Orchid
02:15 Info-Explorer & Optional Tables – Overview
07:04 Scenario 1 (GL level budgeting)
28:13 Scenario 2 (Customer + Item level budgeting)
41:49 Wrap-up and Q&A session

Anneke Chamy talks about the benefits Protect-A-Bed have experienced from implementing Orchid's Info-Explorer.

Info-Explorer is a powerful, intuitive, yet affordable analysis tool that lets you explore data from Sage 300 (and other databases), providing insight to help you increase the performance of your business.
(Jun-2014)

Users who work with Orchid's Sage 300 add-on modules every day discuss their experiences.
(Jun-2014)

Hear what users and business partners think of Info-Explorer from Orchid Systems.