Unit 3: Data sourcing and analytics techniques
Analytics for Competitive Advantage notes · PTU syllabus (MBA 963-26)
On this page
Unit summary
Good analytics needs good data, robust infrastructure and the right techniques. This unit covers types and sources of data, big data infrastructure — data warehousing and cloud computing — data quality and bias, descriptive, predictive and prescriptive analytics, text, speech and image analytics, machine learning and AI, and data visualisation and storytelling.
After this unit you can
- Identify types and sources of data and assess data quality and bias
- Explain big data infrastructure
- Distinguish descriptive, predictive and prescriptive analytics
- Explain text, speech and image analytics, ML and AI, and storytelling
PTU syllabus topics
- Types and sources of data
- big data infrastructure (data warehousing, cloud computing)
- data quality and bias
- descriptive/predictive/prescriptive analytics
- text/speech/image analytics
- machine learning and AI
- data visualization and storytelling
- Prescriptive
What should we do?
- Predictive
What will happen?
- Diagnostic
Why did it happen?
- Descriptive
What happened?
Topic 1
Types and sources of data
- Types: structured, semi-structured, unstructured; internal and external; first-, second- and third-party; transactional, behavioural, sensor, text, image, audio.
- Sources: ERP and CRM, websites and apps, social media, IoT, public data (data.gov.in, RBI, MOSPI), commercial data providers, partner data, account aggregators.
Topic 2
Big data infrastructure
- Data warehouse: structured, integrated data for reporting and BI.
- Data lake: raw data of all types stored cheaply for exploration and machine learning; lakehouse combines both.
- Cloud computing: scalable storage and processing (AWS, Azure, Google Cloud); distributed processing (Spark); streaming platforms (Kafka).
Topic 3
Data quality and bias
Accuracy
Completeness
Consistency
Timeliness
Validity
Uniqueness
- Bias: sampling bias, historical bias (past discrimination in data), measurement bias, survivorship bias, confirmation bias in analysis — can produce unfair or wrong decisions.
- Remedies: data profiling, cleaning, representative sampling, bias testing of models, documentation (data sheets).
Topic 4
Descriptive, predictive and prescriptive analytics
Descriptive
What happened?
Reports, dashboards, OLAP, summary statistics
Diagnostic
Why did it happen?
Drill-down, correlation, root-cause analysis
Predictive
What will happen?
Regression, classification, time series, machine learning
Prescriptive
What should we do?
Optimisation, simulation, recommendation engines
Topic 5
Text, speech and image analytics
- Text analytics: sentiment analysis, topic modelling, entity extraction, classification of emails and complaints — natural language processing.
- Speech analytics: converting call-centre audio to text to detect sentiment, compliance and reasons for calls.
- Image and video analytics: quality inspection, facial and object recognition, retail shelf monitoring, medical imaging.
Topic 6
Machine learning and AI
- Machine learning: algorithms learn patterns from data — supervised (classification, regression), unsupervised (clustering), reinforcement learning.
- Deep learning: neural networks with many layers for images, speech and language.
- Generative AI: large language models that create text, code and images — used for summarisation, customer service, content and analysis assistance.
Topic 7
Data visualisation and storytelling
Data storytelling combines data, visuals and narrative to explain what happened, why it matters and what to do.
- 1. Data: Accurate, relevant evidence
- 2. Visuals: Charts that reveal the insight
- 3. Narrative: Context, conflict and resolution
- 1Context
Where we are
- 2Complication
What changed or went wrong
- 3Insight
What the data reveal
- 4Recommendation
What we should do
- 5Impact
Expected result and next steps
- Other frameworks: Minto's pyramid principle (answer first, then supporting arguments), SCQA (situation, complication, question, answer), "What? So what? Now what?".
Key terms
- Data lake
- Repository of raw data of all types
- Lakehouse
- Combination of data lake and warehouse
- Historical bias
- Past inequities reflected in data
- Prescriptive analytics
- Recommending optimal actions
- Natural language processing
- Computer analysis of human language
Quick revision
- Data types and sources.
- Warehouse, lake, lakehouse; cloud, Spark, Kafka.
- Data quality dimensions; bias types and remedies.
- Descriptive, diagnostic, predictive, prescriptive.
- Text, speech, image analytics; ML, deep learning, generative AI; storytelling.
Important exam questions
Practice questions written to the PTU exam pattern for this unit's syllabus: short answers (Section A style) and long answers (Sections B and C style).
Short-answer questions
- Q1.Distinguish structured and unstructured data.
- Q2.Distinguish a data warehouse and a data lake.
- Q3.Name four dimensions of data quality.
- Q4.What is historical bias?
- Q5.Distinguish predictive and prescriptive analytics.
- Q6.What is speech analytics?
Long-answer questions
- Q1.Explain types and sources of data and big data infrastructure.
- Q2.Discuss data quality and bias in analytics.
- Q3.Compare descriptive, predictive and prescriptive analytics with examples.
- Q4.Explain text, speech and image analytics and the role of ML and AI.
Stuck on this unit?
Message SBS on WhatsApp for help with Analytics for Competitive Advantage, or to ask about studying MBA at Synetic.
