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.
Comienza El Curso Gratis3 horas4 vídeos27 ejercicios
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.¿Entrenar a 2 o más personas?
Probar DataCamp for BusinessPreferido 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.
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.
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.¿Entrenar a 2 o más personas?
Obtén a tu equipo acceso a la plataforma DataCamp completa, incluidas todas las funciones.- 1
Data Exploration
GratuitoIn 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.
Analyzing ecommerce data in Tableau50 xpBuild a product sales data source100 xpProduct costs exercise100 xpData clean up100 xpCreate calculated metrics for customers100 xpCreate order and shipping metrics100 xpData source for market basket analysis100 xpStandardize attribute names and values100 xpMarket basket visualization100 xp - 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.
- 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.
Creating a cohesive story50 xpRevenue by location and top sellers100 xpKPIs in Big Angry Numbers (BANs)100 xpBuild an executive summary100 xpProfit percentage treemap100 xpProfit percentage exercise100 xpGrowth opportunities dashboard100 xpShipping costs dashboard100 xpPresent your story100 xpWrap-up50 xp
¿Entrenar a 2 o más personas?
Obtén a tu equipo acceso a la plataforma DataCamp completa, incluidas todas las funciones.colaboradores
requisitos previos
Analyzing Data in TableauDev Bhosale
Ver MásPrincipal Cloud and Data Engineer
¿Qué tienen que decir otros alumnos?
¡Únete a 15 millones de estudiantes y empieza Case Study: Ecommerce Analysis in Tableau hoy mismo!
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.