Saltar al contenido principal
InicioTableauCase Study: Ecommerce Analysis in Tableau

Case Study: Ecommerce Analysis in Tableau

In ecommerce, increasing sales and reducing expenses are top priorities. In this case study, you'll investigate data from an online pet supply company.

Comience El Curso Gratis
3 horas4 vídeos27 ejercicios

Crea Tu Cuenta Gratuita

GoogleLinkedInFacebook

o

Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.
Group

¿Entrenar a 2 o más personas?

Probar DataCamp for Business

Preferido por estudiantes en miles de empresas


Descripción del curso

Are you ready to apply your Tableau skills to solve practical business problems? For ecommerce businesses, increasing sales and reducing expenses are top priorities. In this Tableau case study, you'll investigate a dataset from a fictitious online pet supply company called Munchy's.

Use Your Tableau Skills With a Practical Case Study

First, you’ll analyze the sales dataset and find out which products are frequently bought together and in what quantity. You will then make upsell and cross-sell recommendations by building a market basket analysis.

Next, you’ll need to address the fact that shipping costs remain a big expense for online retailers. You’ll work on strategies such as shipping more of the same product to reduce per-unit costs. You will also need to understand where the customers are and what they buy to make recommendations to the management for a new warehouse location.

Analyze The Data and Visualize Your Findings

As you collate your findings, you’ll create calculated fields and various visualizations in Tableau, such as dual-axis graphs, highlight tables, and maps. Finally, you'll use filters and parameters to make your graphs dynamic and combine everything into a story to share your recommendations.
Empresas

Group¿Entrenar a 2 o más personas?

Obtenga acceso de su equipo a la biblioteca completa de DataCamp, con informes centralizados, tareas, proyectos y más
Pruebe DataCamp Para EmpresasPara obtener una solución a medida, reserve una demostración.
  1. 1

    Data Exploration

    Gratuito

    In this first chapter, you’ll build a dataset for sales and expense analysis. You’ll combine multiple files, filter out invalid data, and create metrics for customers and orders. Using a self-join on sales data, learn to create a correlation matrix. Use the correlation matrix to determine products that are frequently bought together.

    Reproducir Capítulo Ahora
    Analyzing ecommerce data in Tableau
    50 xp
    Build a product sales data source
    100 xp
    Product costs exercise
    100 xp
    Data clean up
    100 xp
    Create calculated metrics for customers
    100 xp
    Create order and shipping metrics
    100 xp
    Data source for market basket analysis
    100 xp
    Standardize attribute names and values
    100 xp
    Market basket visualization
    100 xp
  2. 2

    Ecommerce Analytics

    Next, you’ll create metrics for the most profitable products and customers. You’ll standardize location names and build a map of sales by state, before exploring the shipping cost metrics. Finally, you’ll build a what-if analysis to display the impact of shipping higher quantities on shipping costs.

    Reproducir Capítulo Ahora
  3. 3

    Visualize Your Analysis

    In the final chapter, you’ll build multiple dashboards and present them as a coherent story. You’ll display the product and customer attributes that will result in the highest ROI for the upsell/cross-sell campaign. To round off, you’ll recommend specific actions to reduce shipping expenses.

    Reproducir Capítulo Ahora
Empresas

Group¿Entrenar a 2 o más personas?

Obtenga acceso de su equipo a la biblioteca completa de DataCamp, con informes centralizados, tareas, proyectos y más

conjuntos de datos

Workbooks and DatasourcesMetadata sheet

colaboradores

Collaborator's avatar
Maarten Van den Broeck
Collaborator's avatar
Iason Prassides
Collaborator's avatar
Carl Rosseel

requisitos previos

Analyzing Data in Tableau
Dev Bhosale HeadshotDev Bhosale

Principal Cloud and Data Engineer

Ver Más

¿Qué tienen que decir otros alumnos?

¡Únete a 14 millones de estudiantes y empieza Case Study: Ecommerce Analysis in Tableau hoy mismo!

Crea Tu Cuenta Gratuita

GoogleLinkedInFacebook

o

Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.