Exp 10: Demonstration of Market Basket & Pareto Analysis | BCU Tableau Lab | MBA 4th Semester
Kishore Chandrasekhar
0:00 / 0:00
Exp 10: Demonstration of Market Basket & Pareto Analysis | BCU Tableau Lab | MBA 4th Semester
196 просмотров · 4 дн. назад
Kishore Chandrasekhar
29 подписчиков
196 просмотров · 4 дн. назад
In this session, we explore advanced analytical techniques by building Market Basket Analysis (to evaluate product association and co-purchasing patterns using data relationships and count measures) and Pareto Analysis (implementing dual-axis charts, running totals, and percentage-of-total calculations to visualize the 80/20 rule).
University Course: BCU 4th Semester MBA – Business Analytics Lab
Dataset: https://docs.google.com/spreadsheets/...
⏱️ Timestamps / Chapters:
00:00 Introduction to Market Basket Analysis and Setting Up Data Relationships in Tableau
02:04 Building the Market Basket Matrix: Configuring Sub-Categories, Order IDs, and Count Measures
05:37 Introduction to Pareto Analysis: Understanding the 80/20 Principle and Loading Data
06:36 Creating Dual-Axis Charts with Bar Graphs and Line Graphs for Sales
07:33 Applying Table Calculations: Running Sums and Secondary Percentage of Total Calculations
#Tableau #BengaluruCityUniversity #BCUAnalytics #DataVisualization #TableauLab #BusinessAnalytics #BCUMBA #MBAAnalytics #MarketBasketAnalysis #ParetoAnalysis #BusinessIntelligence