Level 300 Module 302 Section "One Time Bulk Load of Sales and Expense Data for New Stores"

Options
Kurt Widmer
Kurt Widmer Active Partner
First Comment Level 200: Leveraging Board for Business Insights Photogenic Level 100: Foundations of Building in Board
edited March 5 in Academy

Why do I don't get data after running the data model procedure "MANUAL - ONE TIME - Load Sales and Expenses"?

Accepted Answer

  • Kristin Dimitrova
    edited March 26 Answer ✓
    Options

    Hi Kurt,

    Thanks for raising these issues. They were reported previously by other learners who helped us identify several errors in the Data Model preset. We fixed the preset, but it seems that you had already spun your instance and are working off the old preset. You've identified two of the issues, and there are several other ones that you can follow the steps in the attached file to fix and get your data cleaned up and corrected. The time estimate to complete the steps is 30 minutes, but since you've already addressed some, it might take you half the time.

    Thank you,

    Kristin

Answers

  • Kurt Widmer
    Kurt Widmer Active Partner
    First Comment Level 200: Leveraging Board for Business Insights Photogenic Level 100: Foundations of Building in Board
    Options

    The One Time Bulk Load of Sales and Expense Data for New Stores does not work properly.
    In the Step 6 & 7 of the data model procedure "MANUAL - ONE TIME - Load Sales and Expenses" is no file selected for the upload.

    In the data reader ONE TIME - ACT - Units and Sales the mapping mode for the salesperson is defined as "Discard new items". Therefore records with new salespersons get discarded.
    I had to change the mode to "Add new items" to get all records loaded.