RE: Altair personal slc creating and analyzing tables created from multiple pdf and excel files
Too long to post on listserv, see github
github
https://github.com/rogerjdeangelis/utl-altair-personal-slc-creating-and-analyzing-tables-created-from-multiple-pdf-and-excel-files
community.altair.com
https://community.altair.com/discussion/38559/monarch-learning-series-2023-exercise-9-ap-expense-report-analysis#latest
Due to a bug in sqlite passthru you need to run some solutions using sqlite code in either R or Python
Proc sql does not support some common sql functions like partition.
PROBLEM
You are an Accounts Payable Accountant at a Software Company and you need
to analyze 3 months worth of expense reports to answer the following questions:
What is the Total Expense in USD for the 3 Expense Reports (2016-12, 2017-01, 2017-02)?
(HINT: You will need to convert any expenses not in USD by using the Currency Rate Pair.xlsx file
and creating Formula field for the USD rate for the non-USD expenses)
Who are the Top 3 Employees that spent the most on any Expense that contains
"Travel"
"Taxi"
"Airfare"
"Airline"
"Hotel"
"Lunch"
"Breakfast"
"Dinner"
