Don't take our word for it, take theirs!
Daniel Shuman
Luca Ferretti
Ondrej Hradec
at Mascot Online B.V.
“Justin helped us implement robust product and marketing reporting which has guided our development roadmap, and growth strategy. Justin is a wizard with data and always met the challenge when we needed answers to specific questions. His strategic guidance has helped accelerate our growth and engagement with our customers.”
Daniel Shuman
“Before working with Justin and his team, we were doing very little with our data. Justin's guidance and the systems we've put in place with his help have transformed our business immensely. When needing to make critical business decisions, Justin has provided the necessary reports and analyses to effectively come to the right decision. I can highly recommend Justin & the projectBI team.”
Luca Ferretti
“Justin helped us moving from a full manual process to a semi-automated one, allowing our team to have not only a robust reporting process, but also easily accessible historical data of sales, marketing and other key components. He fulfilled our expectations and was professional in every aspect of his work. With the data pipeline we built with his guidance, we are now able to make faster and more reliable decisions, and we are taking the business to the next level.”
Ondrej Hradec
How projectBI helped Laura Geller implement a data warehouse and replace their excel reports with automated Tableau reports
Data Sources Integrated
Infrastructure Implemented
Dashboards Launched
.png)
ProjectBI has taken our messy data, with inconsistent metrics across multiple, siloed sources, and helped us make better sense of our business.
They have used technical expertise and business savvy to understand our pain points and develop a customized data solution. The environment they have created allows us to create and pull our summarized data reports in multiple ways, while also creating more nuanced dashboards and views.
By bringing our disparate data sources together, we now have a much more robust view of our trends and the ability to answer ad-hoc questions - which had previously been elusive.
Justin and team have also been willing partners, patiently working to train and engage with multiple team members on the new environment, as well as pivoting when we have changed our minds or added new requests.
I highly recommend projectBI!
Senior Director of CRM at AS Beauty, parent company of Laura Geller
Intoduction
Laura Geller is a fast-growing direct-to-consumer cosmetics brand based in the USA. Laura Geller approached projectBI in mid 2024 with the goal of implemening automated business reports to replace manually-maintained excel reports.
Since then the projectBI team has worked with Laura Geller to build a number of custom business reports, and provide ongoing analytics services.
The Challenge
As Laura Geller scaled its DTC business it became increasingly more difficult to conduct indept customer cohort and lifecycle analyses and reporting.
The business managed to build excel-based reports that could provide insight into these areas of the business, but it was challenging to maintain and scale these reports.
Laura Geller needed to automate these reports to free up man-hours to focus more time on learning from the data.
The Solution
To solve this challenge for Laura Geller, the projectBI team implemented a full BI tech stack, coded over 400 custom SQL-based data models, and developed a number of advanced Tableau dashboards.
The BI tech stack was made up of Fivetran (ETL), BigQuery (data warehouse), dbt (data modeling), Github (code repository), Tableau (data visualization) and Project Echo (tests).
14 different data sources were connected to Fivetran and their data was extracted into the data warehouse. Over 400 SQL-based models were coded in dbt to make it easy for the Laura Geller data team to leverage their data, as well as supporting the Tableau dashboards.
By the end of the project, Laura Geller had replaced their excel reports with fully automated cloud-based Tableau reports.
See the Flash Report in action
