Info-Explorer - Advanced Training

Product Training
Budgeting, Reporting & BI

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. 
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