DSW Photo Studio Tracking and Reporting

Photo Studio Reporting

Utilizing the extensive capabilities of a Microsoft Sharepoint backend, I collaborated with the IT and Business Intelligence departments to pull additional information and create customizations within the system. The DSW Photo Studio reporting used excel connected to the Sharepoint database to track retoucher, stylist, and online merchant activities from the robust Sharepoint list to automatically generate detailed reporting to reflect changes in the state of the business. These reports were distributed amongst the staff, supporting departments, and executive leadership. The reports were designed to be easy to read and cater to answering the specific questions that each audience would need to derive from the data. The information was used on a daily bassis to plan out work load among the staff and warn about possible capacity issues.

Photo Studio Reporting