MONARCH DO MORE WITH YOUR VALUABLE TIME Product
MONARCH DO MORE WITH YOUR VALUABLE TIME
Product Overview What is Monarch? 2 versions of software! Why would you want to use Monarch? Who would I contact at Monarch? Use it with WVEIS Benefits of Monarch in today’s world. Who is best suited to use Monarch? AGENDA Other software resources. Build It Out Load the reports Extract the data from the reports Create a workspace to compare the reports. Run it How will Monarch run after I build my model? Report>Model>Export>Evaluate Sit back and relax. (or move on to the next disaster!)
What is Monarch? PRODUCT OVERVIEW 2 Versions of Software! Why would you want to use Monarch? Who would I contact at Monarch?
WHAT IS MONARCH? Altair Monarch is an industry-leading self-service data extraction and preparation tool, allowing end users to easily extract data from any source (including difficult, semi-structured report formats like PDF and TXT) into usable rows and columns, to normalize, cleanse and blend that data with other sources as needed for analysis. Monarch’s creation of repeatable, reusable “workspaces” enables users to streamline and automate repetitive reporting activities, while eliminating error-prone and cumbersome tasks like manual data entry or requests to IT for custom reporting. Monarch allows organizations of all kinds to reduce time spent on preparing reports and data sets, thus increasing the time spent on actual analysis and decision making.
ONE SOFTWARE PACKAGE – TWO PRODUCTS MONARCH CLASSIC DATA PREP STUDIO Benefits Experience Features Quickly review one report Simple and easy to learn Able to print Summary Robust Flexible table options Compare multiple reports Clear summary options Faster model building Easy Export to Excel Multiple levels available See all changes made Group and pivot in the table
WHY WOULD YOU WANT MONARCH • Do you print out 3 years of 6 reports to highlight, review, just to make a list of the needed LESS PAPER corrections? • Do you spend hours (or days) looking for an error or variation? LESS TIME MORE ACCURATE
MONARCH TEAM GARRETT DUCEY JACK LYNCH Account Executive, State/Local Government Solutions Architect, State/Local Government and Education – Garrett support’s Altair’s customer base in the state & local government and education sector, maintaining relationships with existing customers to help them use Altair solutions as effectively as possible, while developing Altair’s data analytics business with new organizations by helping them save time and improve the efficiency of their analytics and reporting strategies. and Education – Jack supports the State/Local Government and Education business of Altair by providing pointed technical guidance and solutions for existing and new customers alike. Jack has experience providing high-level, broad overviews and training on our data analytics solutions, as well as success in building customized, use-case specific applications for our tools based on individual client needs. Phone number: 978 -275 -8240 Phone number: 978 -275 -8249 Email: gducey@altair. com Email: jlynch@altair. com
YES! YOU CAN USE IT WITH WVEIS! Benefits of Monarch in today’s world. Who is best suited to use Monarch? How does Monarch work with other software I already know and love?
BENEFITS OF MONARCH IN TODAY’S WORLD Monarch was a major factor in my success when I was allowed to work from home. Comparing reports Evaluating the general ledger Making huge journal entries Paying all Payroll AP
WHO IS BEST SUITED TO USE MONARCH TREASURER YOUR AMAZING STAFF PAYROLL Find discrepancies before running PR. ACCOUNTS PAYABLE and PURCHASING GENERAL LEDGER Check invoice and P-Card batches Evaluate GL regularly Create PO listings Create JE to import into WVEIS FIXED ASSETS/SBA Compare fixed assets to GL HUMAN RESOURSES BENEFIT COORIDINATOR Build employee profiles in Excel Review deductions with a proforma before PR Use the Certified List in a valuable way Reconcile Payroll AP invoices FINANCE FACILITIES PERSONNEL
OTHER PRODUCTS BECOME ADDITIONAL RESOURCES Adobe Extract data from PDF to compare to other reports. Sequel Create a viewpoint to pull data from WVEIS to use as a lookup. Excel Use as a report to extract data from, or export Monarch table to Excel to manipulate or Email.
Jack Lynch is going to create a workspace – Step by BUILD IT OUT Step Open Gov/WVEIS Validation Use this workspace for years to come
Trap data in report Create a model by “trapping” the data you want, while excluding the rest. HOW TO BUILD A WORKSPACE FROM SCRATCH See your selected info in table format Rows and columns are created from your trapped data. Manipulate your data Add formulas, filters, and calculations to your data. Group or pivot your rows to Add multiple reports create a useable from various sources database. to automatically compare data. Combine Reports Result See your comparison in full to see everything, or show only differences that require your attention.
How will Monarch run once I have completed my EXECUTION PLAN model? Report>Model>Export>Evaluate Sit back and relax (or move on the next disaster!)
HOW WILL MONARCH RUN AFTER I BUILD MY MODEL? Report Table Choose the report(s) you want to use and export them from WVEIS, then upload into Monarch. Review the table (add or update lookups if needed) Model Build or overlay an existing model. Summary Export to Excel or create a Summary to review and manipulate your data.
THANK YOU SAM HEFLIN, CPA SHEFLIN@K 12. WV. US LEWIS COUNTY SCHOOLS
- Slides: 16