Tableau and One Six Solutions

Data visualization is an essential component to realizing the full potential of advanced analytics, which turns vast quantities of seemingly impenetrable data into easy-to-digest reports and graphics. Tableau is one of the premier data visualization platforms available and has all the tools companies need to transform their data repositories into treasure troves of valuable information. One Six Solutions is an official member of Tableau's partner program, reflecting our deep knowledge of the platform and how to get the best performance possible out of it.

What is Tableau and what can it do for you?

Tableau's data visualization platform makes it quick and easy to bring real value out of your business's data. Pull in data from virtually any source or location and create engaging visualizations within minutes. It's the simplest way to make sense of all available information and extract actionable insights from even the largest data sets.

Tableau was designed with business users in mind, providing:

  • Drag-and-drop navigation
  • Intuitive dashboards to enable anyone to effortlessly create and share powerful visualizations
  • Ability to share metrics and reports and display your analytics findings so they resonate with a business audience

One Six Solutions: Your Tableau partner

Tableau is designed to be as seamless and easy-to-use as possible, but implementing, configuring, and integrating the platform with your existing tech platforms and systems requires an expert touch. One Six Solutions' data visualization services can help with:

  • Building focused dashboards to communicate key metrics to guide decision-making through data-driven insights
  • Integrating Tableau with existing essential databases and applications and jump start your next data analytics project
  • Educating your team so they are ready to spearhead your data visualization and analytics efforts once implementation is complete.

One Six Solutions' data visualization services can help you integrate Tableau into your technology stack and give you all the tools you need to begin extracting the actionable insights that propel businesses forward. Contact One Six Solutions to hear more today.

Examples of our Tableau work include...

Entertainment Retailer's Analytics Platform

A 2X performance improvement for analytical queries supporting inventory and marketing analytics in the cloud.

Entertainment

Data Lakes and Warehouses

Entertainment Retailer's Analytics Platform

What was the problem?

The retailer’s Strategy and Analytics teams were experiencing run times ranging from hours to days for queries against the largest data sources on their existing data warehouse, negatively impacting the teams’ turn times for new analyses.

How we helped?

One Six Solutions worked with the retailer’s teams to prioritize problem data sources to be ported into Amazon Redshift, and to gather requirements for content and structural changes to those sources in their new environment.  We implemented the data loads for those sources into Redshift.  One Six Solutions converted Tableau workbooks that the teams had been running against the existing SQL Server Data Warehouse environment to the new Redshift platform.

What were some of the tools used?

Data loads were implemented using SSIS, extracting data from SQL Server then using the ZappySys suite of extensions to interface to Amazon S3 / Redshift.  Tableau workbooks were rebuilt and tested in Tableau 10.5.  The new workbooks’ data sources were a mix of extracts (using Hyper) and live query as appropriate, taking advantage of Amazon Redshift’s processing power for aggregate queries.

What were the results?

Queries from the rebuilt Tableau workbooks showed performance improvements of 1 – 2 orders of magnitude compared with the prior versions sourced against SQL Server.  The retailer’s highest-volume data sources (in the 10’s of billions of records) are now available on Amazon Redshift for general use by the Strategy and Analytics teams.

National Autobody Retail Chain’s Analytics Platform

A cloud based analytics environment for a national auto-body retail chain enables compliance reporting and employee training measurement.

Automotive

Data Analytics

National Autobody Retail Chain’s Analytics Platform

What was the problem?

Our client is one of the largest autobody and mechanical repair shops in the nation.  Their retail stores and regional managers were in need of a consolidated reporting and analytics platforms to better understand overall corporate performance, compliance adherence and training programs for their technicians.

How we helped?

The One Six team assisted the client with defining the set of KPIs across each level in the corporate hierarchy.  We worked with the CTO and COO to standardize measurement criteria so they can evaluate their performance against insurance carrier standards for the services they provide.  Interactive dashboards and reports were built allowing for on-demand analysis.

What were some of the tools used?

The Data Warehouse was built in the cloud using Snowflake as the underlying database technology operating in an AWS cloud. Tableau Desktop and Tableau Online were leveraged to create compelling data visualizations to support corporate leadership, regional and retail managers in their decision making.

What were the results?

All levels of the management team down to an individual retail location were now able to consistently view their teams performance and quickly identify areas where action was required.  Compliance reporting with respect to insurance carrier metrics was available online in an easy to use dashboard with the capability to drill into as much detail as required. Corporate training was also able to leverage the reporting to identify what training programs needed to be completed and by which employees.

Healthcare Tech Company’s Big Data And Analytics Platform

Big data challenges solved by a cloud data architecture across billions of rows of data.

Healthcare

Data Lakes and Warehouses

Healthcare Tech Company’s Big Data And Analytics Platform

What was the problem?

Our client is a healthcare education, product and technology firm whose primary focus is to activate the best possible health outcome for all patients across the globe.  The organization was generating massive amounts of data and had no way to centrally organize and report on this data across the enterprise.

How we helped?

The solution was built using Treasure Data’s cloud based Data Management platform to support the Data Lake implementation and automated ingestion of data sources.  HIVE and Presto SQL based ELT development was done to aggregate massive volumes of data to support end user reporting and dashboarding.  Tableau data sets were generated on the fly from the Data Lake and published directly to Tableau Online for end user consumption.  Additionally, Data Marts were created in Amazon RedShift to support other reporting needs via Tableau Online.

What were some of the tools used?

The solution was built using Treasure Data’s cloud based Data Management platform to support the Data Lake implementation and automated ingestion of data sources.  HIVE and Presto SQL based ELT development was done to aggregate massive volumes of data to support end user reporting and dashboarding.  Tableau data sets were generated on the fly from the Data Lake and published directly to Tableau Online for end user consumption.  Additionally, Data Marts were created in Amazon RedShift to support other reporting needs via Tableau Online.

What were the results?

Billions of rows of data were housed and aggregated to support end user on-demand analysis and executive dashboards which allowed senior management to report on the performance of their business across their various sales, marketing and content delivery channels.  Advertising data, educational content and platform performance metrics were now easily reportable from the same platform.  The platform laid the architecture to easily support reporting on future systems of record.

Flavor Manufacturer’s Self Service Reporting Platform

A cloud analytics platform enables easy to understand product and sales performance.

Food and Beverage

Data Analytics

Flavor Manufacturer’s Self Service Reporting Platform

What was the problem?

A manufacturer of flavors for the food and beverage industry needed insight into sales and product performance across the enterprise. There was no consolidated platform to help them make data driven decisions.

How we helped?

The One Six team helped the client pick a technology platform that would address their requirements but also provide long term flexibility in a low cost, low maintenance platform.  We worked with the executive team to formulate a set of KPI’s to measure business performance and set a direction for the data integration strategy and analytics platform selection.

What were some of the tools used?

Our team implemented a Microsoft SQL Azure based Data Warehouse to provide a single platform for product and sales analytics. Data was integrated from custom ERP platforms, Excel and HubSpot CRM leveraging Azure Data Factory v2 and SSIS on Azure.  Azure Blob storage and Azure Automation were used for automating the data loads. Reports and Dashboards were developed with Tableau Online for leadership reporting.

What were the results?

Our client was now able to use a single platform to engage with their enterprise product and sales data. They no longer had different reports in different systems with silos of information. The sales teams were better able to target their best customers for upsell and resell opportunities and the product teams were able to understand which products were performing best in the market.

Third Party Logistics Provider’s Analytics Platform

Accurately measure labor productivity and associated costs affecting the bottom line.

Supply Chain

Data Lakes and Warehouses

Third Party Logistics Provider’s Analytics Platform

What was the problem?

Our client is a third party logistics, warehousing and supply chain solution company. Their goal was to obtain insights into employee productivity and financials to improve overall efficiency and reduce operating costs.

How we helped?

The One Six team assisted the client with analysis, architecture and development of their Data Warehouse to provide a single source for employee, financial and warehouse activity data. We worked with the clients executive team to develop a reporting platform to measure KPI’s for employee productivity and worked with them to define a set of standards to measure against these KPI's against.  We also consolidated general ledger financials with the Warehouse Management System’s activity/picking data.

What were some of the tools used?

The Data Warehouse solution was built on a SQL Server 2016 utilizing SSIS for ETL to extract data from various SQL databases and flat files. Tableau Desktop and Server were used to develop data visualizations, dashboards and end user reports. Financial data marts were sourced from Microsoft Dynamics Great Plains.

What were the results?

One Six Solutions implemented a Data Warehouse solution integrating activity and labor hours which then enabled our client to successfully measure employee productivity against their end customers goals to improve efficiency across the company. Visibility into the general ledger combined with costs associated to the use of temporary staffing agencies was now easily visible and consistent.

Thank you! We will be in touch shortly.
Oops! Something went wrong while submitting the form.
One Six Solutions
Privacy Policy