Greetings users!
Thank you for joining us for today’s Intermediate Data Warehouse Training! We hope the session gave you some additional tools for working with Vantage Financial data and building more detailed reports.
Building on our previous SQL training, Khalel covered how to use Vantage’s Field Database Help feature and the Power BI crosswalk to identify Data Warehouse tables and fields. We also explored more targeted transaction searches, working with the Accounting Journal’s 99 columns, and using INNER and LEFT JOIN statements to combine information from multiple tables. These techniques offer additional flexibility when researching transactions and retrieving the financial data you need.
If you were unable to attend, you can view the recording here.
Here are a couple links for you:
- Our new Intermediate Data Warehouse: SQL Department Queries Basics eLearning course
- SQL Training Html
- Using SQL quick reference guide
Next month, we’ll be offering an Advanced Data Warehouse course on December 17th at 10am.
If you have any topics you’d like discussed in future training, we look to you, the Vantage Financial users for recommendations for training topics you’d like more knowledge on.