A space for data analytics & AI related technical resources and discussions.
Exercise Info * Application (Classic vs Data Prep Studio): Data Prep Studio * Level of Difficulty (Beginner, Intermediate, Advanced): Beginner * Skills/Features Tested: Append, Join (LookUp), Join (Inner Join), Analyze * Systems of Record: Salesforce * Estimated Time to Solve: 10 mins * Exercise files required are attached…
Exercise Info * Application (Classic vs Data Prep Studio): Data Prep Studio * Level of Difficulty (Beginner, Intermediate, Advanced): Beginner * Skills/Features Tested: Merge Columns, Show Statistics, Filter, GroupBy, Pivot, Duplicate * Systems of Record: Not Applicable * Estimated Time to Solve: 10 mins * Exercise files…
Exercise Info * Application (Classic vs Data Prep Studio): Data Prep Studio * Level of Difficulty (Beginner, Intermediate, Advanced): Beginner * Skills/Features Tested: Append, Unpivot, GroupBy, Analyze * Systems of Record: Not Applicable * Estimated Time to Solve: 10 mins * Exercise files required are attached * Vendor…
Exercise Info * Application (Classic vs Data Prep Studio): Data Prep Studio * Level of Difficulty (Beginner, Intermediate, Advanced): Beginner * Skills/Features Tested: Split, Group By, Duplicate, Analyze (Summary) * Systems of Record: Not Applicable * Estimated Time to Solve: 10 mins * Exercise files required are attached…
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 *…
Exercise Files You can download all Monarch exercise files here: Monarch Sample Files for Exercises * Customer-Membership Demographics.csv * Checking Accounts.csv * Debit Card Masterfile.csv * Credit Card Masterfile.csv * Consumer Loans.csv * Mortgage Loans.csv Exercise Overview You are a Business Operations Analyst at a…
Exercise Files You can download all Monarch exercise files here: Monarch Sample Files for Exercises * Debit Card Transactions.txt * Debit Card Masterfile.csv * Customer-Membership Demographics.csv Exercise Overview You are a Debit Card Analyst working at a Financial Institution and you need to identify the list of Active…
Exercise Files You can download all Monarch exercise files here: Monarch Sample Files for Exercises * Credit Background.pdf * Credit Delinquency.pdf * Credit Reference.accdb * Credit Values.xlsx Exercise Overview You are a Credit Analyst and you need to prepare data that will be useful for developing a Credit Risk Model,…
Exercise Files You can download all Monarch exercise files here: Monarch Sample Files for Exercises * Classic.pdf * Tax Rates for Classic.xlsx Exercise Overview You are a Tax Accountant and you need to apply the appropriate tax rates to sales orders on the Classic.pdf file, so you can file taxes with the appropriate…
Exercise Files You can download all Monarch exercise files here: Monarch Sample Files for Exercises * Patient.txt * Service Codes Rejected.xlsx Exercise Overview You are a Patient Financial Services (PFS) Operations Analyst, and you need to identify the list of recently rejected services that were provided to patients, and…
There's a wealth of content waiting for you to explore! Need support or have a question? Login or join our community.