By incorporating Fivetran, Snowflake and Tableau into the company’s daily business, kemb could help Keller Sports regain time previously spent writing scripts and manually extracting data and present the business with data it can trust.
Key Benefits of the collaboration
- Keller Sports could avoid hiring at least one more engineer to keep up with the work that Fivetran does now
- The IT department can save about 20 hours a week that used to be dedicated to writing scripts and solving issues
- The Purchasing department has regained 75% of its time that was previously spent exporting raw data from MySQL into Excel
- With Snowflake, the business can scale and maintain everything without any dev ops or server needs
- The business has multiple Tableau reports across departments that enable data-backed decisions, including purchasing, marketing and sales
Keller Sports, founded in 2005 in Munich, Germany, is an eCommerce company selling sporting goods across over 20 different online shops in different European countries.
In 2019, kemb GmbH was given the opportunity to support the company in optimizing its IT infrastructure, namely the ERP and business intelligence setup, to meet the rapid growth of the company and the requirements resulting from it. We were working closely together with Florian Otte, who joined the business in the early days, and was responsible for developing the online shops. Now as CTO, he is responsible for all IT, which includes supporting the BI team as it builds out the company’s new reporting structure.
From Excel to BI
Before kemb accompanied the development, Otte had already helped bring the business forward from where it was 10-12 years ago: “We used to use Excel for our BI. At the time it wasn’t that big of a problem but we quickly grew out of it. With millions of rows, Excel is not your friend. It took a couple of hours each week to generate a report.”
As the business grew and people started to use Google Analytics, Otte also developed an interface where people could search for revenue and other data. Eventually, it was no longer convenient to develop scripts and maintain the system, so Otte exported the data into MySQL and ran Tableau on top of it. This process, too, couldn’t scale as the business wanted to connect new sources and bring in different data types that would require hiring more developers.
At that point Keller Sports brought on Kemb, to help it find the right tools to build a more scalable and reliable data stack. This was initiated by a requirements workshop and interview phase. We conducted interviews with the department heads on concurrent and future reporting needs as well as regular issues with the then established set of numbers. Structuring out an infrastructure that could scale as well as being accessible to a broad range of employees without needing loads of training in advance, we compared several possible solutions in terms of ETL, data warehousing and data visualization. After Kemb was fully aware of the needs and requirements of Keller sports, we proposed a setup of Fivetran and Snowflake.
Fivetran Reduces Development Time
Without Fivetran, Keller Sports would have needed to hire more engineers to keep up with the company’s growth, to connect additional online shops and keep reliable data flowing from its sources into its warehouse.
“With Fivetran, we require fewer development resources,” says Otte. “In the past people would come to me to tell me numbers were inaccurate or that data hadn’t updated in days. Now, our team can connect things to Fivetran on their own. If something breaks or there is an issue, they can see it themselves in the Fivetran UI. They don’t need IT help anymore.”
Fivetran saved Keller Sports’ IT department about 20 hours a week that used to be dedicated to writing scripts and solving issues. The Purchasing department regained 75% of its time that was previously spent exporting raw data from MySQL into Excel. “Our teams have new tools and numbers that they trust now. People don’t have to go into Excel to look for numbers and don’t have to confirm these numbers with other people.”
Bringing Data into Snowflake and Visualising it With Tableau
In addition to implementing Fivetran into Keller Sports’ day-to-day operations, significant benefits have been achieved with the use of Snowflake and Tableau. Fivetran standard connectors bring the data into Snowflake automatically.
“We currently have 140 GB of data in Snowflake and we can scale and maintain everything without any dev ops or server needs on our end. In the past, I had to make sure the MySQL database worked, had to fix it when it broke and decide on whether to delete data or buy additional discs. None of that is necessary anymore.”Florian Otte, CTO Kellersports
Keller Sports’ IT department experienced the process of setting up Fivetran, Snowflake and Tableau together to be very simple. “We didn’t need any IT resources, we simply connected everything to Fivetran within a few minutes and the data was automatically pushed to Snowflake and the BI team could work with the data.” After the business moved from MySQL to Snowflake, it changed its Tableau Server instance to Tableau Online. “Having all of these SaaS applications has made our data more reliable and more accessible. All three work together well and we don’t have to maintain anything on our end.”
Keller Sports has around 20-25 people across different departments actively using reports in Tableau. The Purchasing department now has a report that enables the business to do efficient stock analysis and re-ordering. The Marketing department can view revenue by channel and analyse customer lifetime value. A margin report shows daily sales and margins that are critical for re-pricing. With transparent data, it is easier for Keller Sports’ BI team to build or change reports that impact the entire business.
More About the Toolset
Shaped by the real-world needs of data analysts, Fivetran technology is the smartest, fastest way to replicate your applications, databases, events and files into a high-performance cloud warehouse. Fivetran connectors deploy in minutes, require zero maintenance, and automatically adjust to source changes — so your data team can stop worrying about engineering and focus on driving insights.
Snowflake is the leading data warehouse built for the cloud. Its unique architecture delivers proven breakthroughs in performance, concurrency and simplicity. For the first time, multiple groups can access petabytes of data at the same time, up to 200 times faster and 10 times less expensive than solutions not built for the cloud. Snowflake is a fully managed service with a pay-as-you-go-model that works on structured and semi-structured data.
Tableau helps people see and understand their data. The Tableau platform provides the breadth and depth of capabilities that enterprises need, and adapts to your environment with unmatched flexibility and choice, while meeting the toughest governance and security requirements. People love using Tableau because it is both powerful and intuitive. Tableau leads the industry with the most passionate user community, over 86,000 customer accounts, and a commitment to customer-focused innovation.
Are you having similar challenges?
We’re more than happy to have a chat about how we can support you with your Data Challenges. Do not hesitate and book a free consultation call at a time that suits you best.