2019-03-12 Meeting notes

Previous Action Items

• Stacey: Impressions not based on Nielsen - waiting on stuff from Scott Marden & team

• Abe: follow up with Core Value about Looker Multi Environment - done, in progress with Core Value

• Abe: follow up with Allison and Sarah re: Axper reporting requirements - done, Frank loaded it but it turns out that the dates were all wrong

• Frank: provide geckoboard fields to John so they can be mapped to NetSuite instances - Done, Karen and Frank has been working on it… it has changed so it will be provided to John

Abe

• Snowflake data sync frequency debugging for Core Value / roman's model

• Lucien Data model questions…

• Axper reporting requirements elicitation

• Helped Scott Marden and Allie use Looker model. They saw the gaps in data and are going to monitor new data collection

• RE Sales Year over Year time dimension filtering and % change analysis

• Work with Looker Help for conditional formatting on single value viz (possible through a hack but not in the UI)

• Looker instances Snowflake connection configuration

• Elevator Health Log analysis; frank fixed everything in the backend and I provided reports to Stephanie, David Perl

Karen

• Completing Process to validate snowflake sync with prod

  • Last night ran everything at 1AM; everything matched!

• Moving data for Geckoboard to cloud (snowflake)

Stacey

• CRM to Netsuite Integrations (Contacts, ended up not being needed)

• Vistar Weekly Reporting from Mike with additional analysis

  • waiting to hear back from Vistar

  • rejected deals: followed up with campsite to see if a patch is working (spent spots greater than requested spots)

• Adding Programmatic Fields in Sandbox (NetSuite)

Frank

• Refactoring SSIS packages for Geckoboard to point to custom tables (which John will populate)

  • Temp solution while CoreValue rebuilds the entire project to come from SnowFlake

  • CoreValue has been working on it for a week; they are in the documentation stage

• Moving all geckoboard out of Crosswalk; doesn’t leave a lot left in CAPCORPSQL01

  • Goal to shut down CAPCORPSQL01 by the end of the Summer; everything will be on the SQL Cluster

    • in the process, will clean up, enable logging features

• Working on getting rid of DBAdmin login

• API Project kickoff next week

• Project Plan to Upgrade the Traffic System

  • waiting on ENG’s contributions

    • task list for how to get CAPROCAP01 move to a new server

• Fortified Data (3rd party): performing a Complete Assessment of our database infrastructure

  • output: redesign of Traffic System

Andrea

• RE Revamp’s tickets

• CoreValue tickets

• Matt Pocock included Andrea in a rogue project, nSuite-

• Met all departments!

• Warehouse: Vendor Reps, UPS, RFSmart Barcode Scanning,

  • Warehouse wants Material Review Board but Mike Levesque doesn’t like that

  • Pak has new thermal printer

• NOC: sales orders, approvers, what goes where

• Finance

• 2 Subsidiaries, vendors, issues with how the currency was set up

• Online Case Forms

• AMP

• Rules and Permissions must be brought under control

• Recommended changes: implement Departments

Julia

Wally

We must take away all Admin Rights