-
Monarch Learning Series 2023 Exercise 2 - Grocery Analysis
Exercise Info * Application (Classic vs Data Prep Studio): Classic * Level of Difficulty (Beginner, Intermediate, Advanced): Beginner * Skills/Features Tested: Report Trapping, Calculated Fields, Filters, Summary * Systems of Record: Not Applicable * Estimated Time to Solve: 10 mins * Exercise files required are attached *…
-
How to utilize DPS's "SQL Server Connection" dialog box to filter by a dynamic date, such as "yesterday" or "last weekday"
Please be sure to read the previous article, found here, in order to have context for this one. In that article, we learned that by manually editing (or entering from scratch) a query, you can cut down the amount of data that need to be transmitted from the server to your machine. We also learned how to access that part of…
-
Monarch Learning Series 2023 Exercise 1 - Maynard Employee Analysis
Exercise Info * Application (Classic vs Data Prep Studio): Classic * Level of Difficulty (Beginner, Intermediate, Advanced): Beginner * Skills/Features Tested: Report Trapping, Calculated Fields, Filters, Summary, Top N Analysis * Systems of Record: Not Applicable * Estimated Time to Solve: 15 mins * Exercise files…
-
Altair Monarch Exercise 13 - 360 Degree View of Customer
Exercise Info * Application (Classic vs Data Prep Studio: Data Prep Studio * Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate * Skills/Features Tested: Report Trapping, Group By, Lookup, Negative Join * Systems of Record: Not Applicable * Estimated Time to Solve: 10 mins * Exercise files required are…
-
Altair Monarch Exercise 12 - Debit Card Analytics
Exercise Info * Application (Classic vs Data Prep Studio): Data Prep Studio * Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate * Skills/Features Tested: Report Trapping, Filters, Formula Fields, Group By, Join, Append * Systems of Record: Not Applicable * Estimated Time to Solve: 10 mins * Exercise…
-
Altair Monarch Exercise 11 - Credit Risk Model Data Prep
Exercise Info * Application (Classic vs Data Prep Studio): Data Prep Studio * Level of Difficulty (Beginner, Intermediate, Advanced): Advanced * Skills/Features Tested: Report Trapping, Floating Traps, Formula Fields, Group By * Systems of Record: Not Applicable * Estimated Time to Solve: 20 mins * Exercise files required…
-
Altair Monarch Exercise 10 - Classic Tax Rates
Exercise Info * Application (Classic vs Data Prep Studio): Data Prep Studio * Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate * Skills/Features Tested: Report Trapping, Calculated Fields, Analyze (Summary), Export by Key * Systems of Record: Not Applicable * Estimated Time to Solve: 15 mins * Exercise…
-
Altair Monarch Exercise 9 - Patient Service Codes
Exercise Info * Application (Classic vs Data Prep Studio): Data Prep Studio * Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate * Skills/Features Tested: Report Trapping, Filters, Formula Field, Group By * Systems of Record: Not Applicable * Estimated Time to Solve: 10 mins * Exercise files required are…
-
Altair Monarch Exercise 8 - Outstanding Official Checks
Exercise Info * Application (Classic vs Data Prep Studio): Data Prep Studio * Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate * Skills/Features Tested: Report Trapping, Group By, Join, Formula Field * Systems of Record: Not Applicable * Estimated Time to Solve: 15 mins * Exercise files required are…
-
Altair Monarch Exercise 7 - NAV for Mutual Funds
Exercise Info * Application (Classic vs Data Prep Studio): Data Prep Studio * Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate * Skills/Features Tested: Report Trapping, Group By, Join, Formula Fields * Systems of Record: Not Applicable * Estimated Time to Solve: 15 mins * Exercise files required are…