IIT Madras BDM Lectures: Business Data Management
BSMS2001145 lectures12 weeks
Weeks
- Week 15 lecturesIntroduction to economics | part 1 | economic flow · Introduction to economics | part 2 | demand & supply · Introduction to spreadsheets | excel & google sheets basics · Functions in spreadsheets · Economics tutorial (using excel)
- Week 24 lecturesExternal data sources & survey methods · Exploring demographic data · Analysing demographic data | part 1 | consumption patterns in excel · Analysing demographic data | part 2 | rural spending & insights
- Week 33 lecturesEstimating market size | part 1 | two-wheeler loans & surveys · Estimating market size | part 2 | two-wheeler market (bottom-up) · Estimating market size | part 3 | fixed deposits, borrowing
- Week 47 lecturesIntroduction to pivot tables · Representing data visually · Understanding market share | part 1 · Understanding market share | part 2 | loan data & pivot tables · Understanding market share | part 3 | credit card lending trends · Understanding market share | part 4 | credit, microfinance & loans · Analysis of aspirational data
- Week 58 lecturesIntroduction to e-commerce · Introduction to the case study I · E-commerce data | post-covid sales analysis · Review of key questions · Review of data · Volume pareto · Revenue pareto & scatter plot | excel sales · Trend analysis | sales & revenue trends by date & weekday usingexcel
- Week 69 lecturesSales analysis presentation · Scatter chart presentation · Sales trend presentation · Ledger & average days of inventory | stockouts, opening stock & sales · Days of sales of inventory presentation · Presentation of ledger · Key learnings from the case · Vlookup & pivot table | excel data retrieval & summary tools · Course project instructions, guidelines | for reference
- Week 710 lecturesIntroduction to the manufacturing sector · ACE gears case introduction | production & profitability · Background context to the case · Introduction to the dataset - sales, production & inventory · Revenue trend working · Revenue analysis presentation · Portfolio management working · Product portfolio presentation · Region wise revenues working. · Region wise revenue & sales agent planning presentation
- Week 810 lecturesProduction scheduling data | plan vs actual · Scrap analysis working · OEE discussion · Unit level profitability & material re-ordering data · Unit level profitability working · Scrap costs & margin analysis presentation · Safety stock & re-order concept review | inventory planning · Safety stock & re-order working · Raw material inventory analysis presentation & closing remarks · Tutorial assignment
- Week 914 lecturesIntroduction to HR as a function | manpower planning & recruitment · Introduction to the tech Enterprises, and their immediate crisis · Internal sourcing · Review of data & basic statistics | customer insights · Internal sourcing: ranking of internal candidates · Caselet 2 introduction: job description · Sourcing channels & their analysis | recruitment strategy · Introduction to dataset & gender diversity · Selection criteria | analyzing recruitment channel effectiveness · Channel effectiveness | analyzing recruitment data & sources · Combining measurements into a composite score & ranking · Recruitment process & onboarding from offer to joining · Presentation of results & analysis · Summary: skills availability & role of HR | future talent trends
- Week 108 lecturesIntroduction to finance industry & Fintech · Introduction to the payments industry & money flow · Paybuddy case: credit product introduction · Nudge economics | consumer behavior in e-commerce · Paybuddy case: the main players & the dataset for credit marketing · Review of data & basic statistics | customer insights · Segment analysis working | pivoting customer behavior & PayBuddy later · Presentation of factors that can be used for nudge
- Week 118 lecturesA/B testing introduction · A/B testing of PayLater Nudges · A/B testing presentation · What is credit risk analysis · Explanation of the credit risk dataset · Credit risk analysis: review of data · Credit risk analysis: monthly trends · Credit risk analysis presentation
- Week 123 lecturesHow businesses operate · How businesses are managed · Processing data from business processes using spreadsheets