Project Title: Project Portfolio BI Reporting & Analysis

StudioLabs, LLC

Details
Project Title Project Portfolio BI Reporting & Analysis
Project Topics Data Management Operations Product Design & Development Reporting, Financial Planning & Analysis Software Design & Development
Skills & Expertise
Project Synopsis: Challenge/Opportunity
This project is with the company Studio Labs. Since 2003, StudioLabs has been trusted to help conceive, create, and produce various digital products for some of the world’s most well-known brands, agencies, and leading technology companies. We’ve got 20 years of experience creating engaging user experiences across many business verticals.

StudioLabs makes Software & Web Apps, Mobile Apps, PWA's Websites & E-Commerce Sites, OTT Channels/ Apps, Wearable Applications, Real World Activations, and IoT Platforms. 

StudioLabs works with TypeScript, React, Angular, ObjC, Swift, ReactNative, CSS3 (SCSS, Less, Tailwind), NodeJS, Python, Headless, WordPress, Drupal, Shopify, BigCommerce, Magento, Firebase, AWS/Lambda, Azure, GCP, GIT Workflows, Github, Bitbucket Pipelines, Atlassian Tools.

To learn more about the company, please visit the following link: https://www.studiolabs.com/

Project Information:

Our organization is a professional services team that builds digital products, ranging from marketing websites to entire SaaS platforms. We charge for our work based on two models: fixed scope/cost projects whose budgets are based on estimations (hrs x rate), or time & materials work, where we charge by the hour. 

We have a large amount of historical project related data (e.g., individual tasks, estimations, actual hours by employee, labor costs, etc.), but need help pulling this into intelligent reporting for us to make some key inferences:

  • What are the key areas we fall short in our estimations, relative to actual time on projects, and how to we need to accommodate for this?
  • Do we have project types that are higher margins, and why?
  • Can we measure efficiency by project / project type / team member?
  • Can we accurately project completion costs / profitability during the lifecycle of a project?
  • What data / view are we missing to help answer these questions?
Project Synopsis: Activities/Actions Required
  • Analysis of both business model, project lifecycle processes, and data
  • Analysis of current reporting methods
  • Implementation of BI reporting
  • Review and analysis of reporting
Project Synopsis: Expected Results
  • Increase in accuracy of estimations
  • Increase in margins on projects
  • Increase in efficiency of team members

Project Timeline

Touchpoints & Assignments Date Type

Initial Onboarding Information

Jan 02 2024 EST (UTC-05:00) Other

First Day of Classes & Academic Calendar

Jan 17 2024 EST (UTC-05:00) Event

Stevens Brand Guidelines

Jan 17 2024 EST (UTC-05:00) Other

Industry Capstone Program Webpage & Resources

Jan 17 2024 EST (UTC-05:00) Other

Student Pre-Kick-off Self-Assessment Form

Feb 10 2024, 23:59 PM EST (UTC-05:00) Evaluation

Student Temperature Check

Feb 23 2024, 23:59 PM EST (UTC-05:00) Evaluation

Midterm Presentation Information

Mar 18 2024 EST (UTC-05:00) Other

Midterm Presentation Submission

Apr 01 2024 EST (UTC-05:00) Action Item

Final Presentation Information

Apr 01 2024 EST (UTC-05:00) Other

Student Temperature Check

Apr 05 2024, 23:59 PM EST (UTC-05:00) Evaluation

Final Presentation Submission

May 14 2024 EST (UTC-05:00) Action Item

Student Post-Engagement Self-Assessment Form

May 14 2024, 23:59 PM EST (UTC-05:00) Evaluation

Industry Mentor Post-Engagement Team Assessment Form

May 17 2024, 23:59 PM EST (UTC-05:00) Evaluation