MDM Answers
MDM Answers
👉 Question Number: 1
👉 Unit Number: 1
Question: Explain in detail about data analytics life cycle
👉 Answer:
Definition:
As referenced in Geeks for Geeks, the Data Analytics Life Cycle is a structured framework that
outlines the roadmap of how data is generated, collected, processed, analyzed, and visualized
to solve a specific business problem and drive strategic decision-making.
Explanation:
The Data Analytics Life Cycle generally consists of six major phases:
● Phase 1: Discovery: The team learns the business domain, assesses the resources
available (people, technology, time), and formulates the primary business problem into a
strategic analytics goal.
● Phase 2: Data Preparation: This is the most time-consuming phase. It involves extracting
data from various sources, cleaning it (handling missing values and anomalies), and
transforming it into a structured format suitable for analysis.
● Phase 3: Model Planning: The team determines the methods, techniques, and workflow
to build the model. They select algorithms (like regression or clustering) based on the
data variables and business goals.
● Phase 4: Model Building: The analytical models are developed and executed on the
prepared datasets. The data is usually split into training and testing sets to evaluate the
model's accuracy.
● Phase 5: Communicate Results: The findings are interpreted and presented to the
business stakeholders. Data visualization tools are used to showcase whether the project
succeeded or failed in achieving its initial objectives.
● Phase 6: Operationalize: The final model is deployed into a real-time production
environment to deliver ongoing business value.
👉 Question Number: 2
👉 Unit Number: 1
Question: Explain in short about application of data analytics across different industries
👉 Answer:
Definition:
As highlighted by Geeks for Geeks application case studies, Data Analytics applications refer to
the practical implementation of statistical algorithms, machine learning, and data modeling
techniques to solve domain-specific challenges, optimize business operations, and create new
revenue streams across various sectors.
Explanation:
● Retail and E-commerce: Used for inventory forecasting, dynamic pricing, and
personalized customer recommendations to enhance the shopping experience and
boost sales.
● Healthcare: Applied in predicting disease outbreaks, optimizing hospital staffing,
improving patient care through personalized medicine, and accelerating drug discovery.
● Banking and Finance: Essential for detecting fraudulent transactions in real-time,
assessing credit risk for loan approvals, and algorithmic trading.
● Logistics and Supply Chain: Utilized for route optimization, fleet management, and
predicting shipping delays to ensure timely deliveries and reduce fuel consumption.
● Entertainment and Media: Used to analyze viewer preferences, optimize content
streaming quality, and recommend movies or music to keep users engaged.
👉 Question Number: 3
👉 Unit Number: 1
Question: Explain in detail about data analytics with examples
👉 Answer:
Definition:
According to Geeks for Geeks, Data Analytics is the scientific process of collecting, inspecting,
cleansing, transforming, and modeling raw datasets to discover hidden patterns, unseen
trends, and correlations. The ultimate goal is to draw meaningful conclusions that support
strategic business decision-making.
Explanation:
Data Analytics is broadly categorized into four main types, each answering a specific business
question:
● Descriptive Analytics: Amazon generates a monthly report showing that sales of winter
jackets increased by 40% in November.
● Diagnostic Analytics: Analysts drill down into the data and discover that the spike in
sales was due to a sudden drop in temperature combined with a successful targeted
email campaign.
● Predictive Analytics: Based on past years' data and upcoming weather forecasts,
Amazon predicts that they will need 200,000 winter jackets in their New York fulfillment
centers by December 1st.
● Prescriptive Analytics: The analytics system automatically generates purchase orders to
suppliers and optimally routes the inventory to specific regional warehouses to prevent
stockouts and minimize shipping times.
PART 2
👉 Question Number: 4
👉 Unit Number: 1
Question: Differentiate data analytics from data analysis - with minimum 10 differences
👉 Answer:
Definition:
As per Geeks for Geeks, both terms are often used interchangeably but hold distinct
meanings:
● Data Analysis Workflow: Examines Past Data ➔ Cleans & Organizes ➔ Identifies Trends
➔ Answers "What happened?"
● Data Analytics Workflow: Encompasses Analysis ➔ Applies Machine Learning ➔
Predicts Future Trends ➔ Answers "What should we do next?"
4. Key Questions "What happened?" and "Why "What will happen next?" and
did it happen?" "How can we influence it?"
● Data Analysis: An Amazon Business Analyst uses SQL to find out that sales of "Kindle
Paperwhite" dropped by 15% last August.
● Data Analytics: An Amazon Data Scientist builds a machine learning model that predicts
next August's Kindle sales based on weather, marketing spend, and competitor pricing,
automatically adjusting the price to maximize profit.
👉 Question Number: 5
👉 Unit Number: 1
Question: Explain in detail about significance of data analytics in IOT Domain
👉 Answer:
Definition:
The Internet of Things (IoT) refers to physical devices connected to the internet, collecting and
sharing data. As referenced in Geeks for Geeks, Data Analytics acts as the "brain" of IoT.
● The IoT Analytics Flow: IoT Sensors Collect Raw Data ➔ Cloud Storage ➔ Data
Analytics Processing ➔ Actionable Insights ➔ Automated Machine Response
● Volume & Velocity Handling: IoT devices generate terabytes of data per second.
Analytics platforms are significant because they can ingest, filter, and process this
massive streaming data in real-time.
● Predictive Maintenance: Analytics constantly evaluates sensor data (like temperature or
vibration) to predict when a machine is likely to break down, preventing costly factory
halts.
● Cost Optimization: By analyzing energy consumption patterns from smart meters,
businesses can automate heating and lighting, significantly reducing operational costs.
● Enhanced Customer Experience: Wearable IoT devices track user health metrics, and
analytics personalize fitness goals or alert doctors in case of heart anomalies.
● Edge Analytics: Instead of sending all data to the cloud, analytics can now happen
directly on the IoT device (the "edge"), allowing for split-second autonomous decisions
without internet latency.
In Amazon Fulfillment Centers, thousands of Kiva robots (IoT devices) move inventory.
● Sensors track robot battery & wheel friction ➔ Analytics processes this data instantly ➔
Predicts a wheel failure ➔ Automatically routes the robot to the maintenance bay before
it breaks down and blocks a busy aisle.
👉 Question Number: 6
👉 Unit Number: 2
Question: Mention the various data sources and collection methods with examples
👉 Answer:
Definition:
According to Geeks for Geeks, a Data Source is the original location where data is born or
stored, while a Collection Method is the technical or manual process used to extract that data.
● The Collection Flow: Identify Source ➔ Choose Method (e.g., API/Scraping) ➔ Extract
➔ Store in Database
1. Data Sources:
● Internal Sources: Data generated within the organization. (e.g., CRM systems, HR
databases, Sales transactional databases).
● External Sources: Data gathered from outside the organization. (e.g., Government
census portals, public financial datasets, social media platforms).
● Web Scraping: Using software bots to extract large amounts of unstructured data
directly from website HTML.
● APIs (Application Programming Interfaces): A secure, structured method where
computers talk to each other to request and deliver specific data in JSON format.
● Transactional Tracking: Automatically recording user behavior (clicks, purchases, time
spent) using web cookies and backend server logs.
● Surveys & Questionnaires: Manual collection of qualitative and quantitative data directly
from users.
As this is a Unit 2 data handling concept, here is a basic implementation of collecting data from
different sources.
Python
Code Explanation:
● import pandas as pd: Brings in the primary Python library used for data analytics and
collection.
● pd.read_csv(): Method used to extract structured tabular data from a comma-separated
values file (common for internal databases).
● pd.read_html(): Method that acts as a basic web scraper, automatically finding and
extracting HTML tables from a given website link.
● pd.read_json(): Method used to parse JSON formatted data, which is the standard format
for collecting data via modern web APIs.
PART 3
👉 Question Number: 7
👉 Unit Number: 2
Question: Explain the API (APPLICATION PROGRAMMING INTERFACE) and how it is going
to collect the data with example
👉 Answer:
Definition:
Instead of writing complex web scrapers, analysts use APIs to collect data directly in a clean,
structured format (usually JSON). The flow can be remembered as:
Client Sends Request ➔ API Receives Request ➔ Database Searched ➔ Data Packaged
(JSON) ➔ API Delivers Response to Client
When you use a third-party price-tracking app (like CamelCamelCamel) to check Amazon
prices:
● The app does not guess the price. Instead, it sends a request to the Amazon Product
API.
● The API fetches the exact current price of a "Kindle Paperwhite" from Amazon's database.
● The API returns this data instantly to the tracking app to display to the user.
Python Code (Data Collection via API):
Python
Code Explanation:
● import requests: Imports the standard Python library used for making HTTP requests to
APIs.
● [Link](api_url): Instructs the program to hit the API link and ask for the data.
● [Link](): Automatically parses the structured text data returned by the API into a
usable Python dictionary format.
● [Link]([data]): Converts the raw JSON data into a neat, tabular format (rows and
columns) for easy data analysis.
👉 Question Number: 8
👉 Unit Number: 2
Question: What do you mean by data cleaning and how it is processed with python
programming
👉 Answer:
Definition:
Data Cleaning (or data cleansing) is the process of identifying and correcting (or removing)
errors, inconsistencies, missing values, and duplicates in a dataset to improve its quality for
analytics.
Raw Data ➔ Remove Duplicates ➔ Handle Missing Values ➔ Fix Formatting/Typos ➔ Remove
Outliers ➔ Clean Data Ready for Modeling
● Handling Missing Data: Filling in blank spaces with averages (mean/median) or dropping
the incomplete rows entirely.
● Removing Duplicates: Deleting identical repeated entries that could skew the analysis.
● Standardizing Formatting: Ensuring all text is consistent (e.g., converting all dates to
YYYY-MM-DD format or all text to lowercase).
● Handling Outliers: Identifying extreme values that don't make sense (e.g., a customer
age of 999 years) and correcting or removing them.
● The Problem: Some users accidentally submit the same review twice (duplicates), or
leave a star rating but forget to write text (missing values).
● The Fix: Amazon's data analysts write Python scripts to automatically drop the duplicate
reviews and fill empty text fields with "No comment provided" before feeding the data
into their sentiment analysis models.
Python
Code Explanation:
👉 Question Number: 9
👉 Unit Number: 2
Question: What do you mean by data quality and what are the significance of it
👉 Answer:
Definition:
As per Geeks for Geeks, Data Quality is a measure of the condition of a dataset based on
factors like accuracy, completeness, consistency, reliability, and timeliness. It dictates whether
the data is fit for its intended purpose.
High-quality data is the foundation of accurate analytics. Poor data leads to a concept known
as GIGO (Garbage In ➔ Garbage Out).
Accurate (No errors) + Complete (No blanks) + Consistent (Same format) + Timely (Up-to-date)
= High Data Quality
● Poor Data Quality: If an Amazon customer's address data is inconsistent or missing a zip
code, the package will be delayed, leading to shipping refunds, lost money, and an angry
customer.
● High Data Quality: If Amazon's recommendation engine has accurate, complete data on
a user's past purchases, it will successfully recommend a highly relevant product,
resulting in an immediate sale and increased profit.
Python
Code Explanation:
● [Link]().sum(): This is a standard data quality check in pandas that scans every column
and counts exactly how many missing/blank values exist.
● df[df['Age'] < 0]: This is a logical rule check to ensure data accuracy by identifying rows
where the age is an impossible negative number.
👉 Unit Number: 2
Question: Differentiate database from the data warehouse
👉 Answer:
Definition:
According to Geeks for Geeks, a Database is a collection of current, operational data designed
to process quick, day-to-day transactions (OLTP). A Data Warehouse is a massive, centralized
repository that stores historical, aggregated data from multiple sources specifically designed for
complex data analytics and reporting (OLAP).
App/User Action ➔ Database (Quick Save) ➔ ETL Process (Extract, Transform, Load) ➔ Data
Warehouse (Deep Analytics)
Key Differences:
2. Data Age Current, up-to-date, real-time data. Historical data (months or years
old).
3. Processing Optimized for fast writes (inserting Optimized for fast reads (querying
Speed data). large data).
● Database: When you add a pair of shoes to your Amazon cart and checkout, that
transaction is instantly processed and saved in an Amazon Database to ensure your
payment goes through quickly.
● Data Warehouse: Amazon copies that transaction into a massive Data Warehouse
containing 10 years of shoe sales. A data analyst queries this warehouse to find out
which shoe brand sold the most during winters from 2015 to 2025.
👉 Question Number: 11
👉 Unit Number: 2
Question: Explain in detail about structure data with example
👉 Answer:
Definition:
As per Geeks for Geeks, Structured Data is highly organized information that is formatted into
a strictly defined schema, typically consisting of rows and columns. This makes it easily
searchable by algorithms and relational databases.
Raw Data Input ➔ Define Data Types (Int, String, Float) ➔ Map to Rows
& Columns ➔ Store in SQL Database ➔ Query instantly
Key Characteristics:
👉 Question Number: 12
👉 Unit Number: 2
Question: Differentiate Spatial data from non Spatial data
👉 Answer:
Definition:
● Spatial Data: Also known as geospatial data, it is information that is physically linked to
a specific geographical location on Earth (requires coordinates).
● Non-Spatial Data: Also known as attribute data, it is information that describes
characteristics, traits, or qualities without any geographical or location-based context.
Key Differences:
● Spatial Data: The live GPS coordinates (Lat: 40.7128° N, Long: 74.0060° W) showing
exactly where the truck is currently driving.
● Non-Spatial Data: The data detailing that the truck is a "Ford Transit", colored "Blue",
carrying "150 packages" weighing "500 lbs".
👉 Question Number: 13
👉 Unit Number: 3
Question: Differentiate correlation and regression
👉 Answer:
Definition:
According to Geeks for Geeks, Correlation is a statistical technique used to measure the
strength and direction of the linear relationship between two variables. Regression is a
statistical measurement used to determine the exact equation of that relationship, allowing
analysts to predict the value of a dependent variable based on an independent variable.
● The Statistical Flow: Identify 2 Variables ➔ Check Correlation (Are they related?) ➔
Apply Regression (Predict exact future values based on the relationship)
👉 Answer:
Definition:
As referenced in Geeks for Geeks, a Continuous Random Variable is a statistical variable that
can take on an infinite number of possible values within a given continuous range or interval.
Unlike discrete variables (which are counted), continuous variables are always measured.
Mathematical Equations:
Continuous random variables are described by a Probability Density Function (PDF), denoted as
Non-negativity condition: The probability density must be zero or positive.
1. Total Probability: The total area under the probability density curve must exactly equal 1
(representing 100% probability).
Probability of an Interval: The probability that the variable X falls between two values (a
and b) is the integral (area under the curve) between those points.
PART 6
👉 Question Number: 16
👉 Unit Number: 4
Question: Define data visualization and it’s methods
👉 Answer:
Definition:
As referenced in Geeks for Geeks, Data Visualization is the graphical representation of raw
information and data. By using visual elements like charts, graphs, and maps, data visualization
tools provide an accessible way to see and understand trends, outliers, and patterns in data.
Raw Text Data ➔ Choose Visual Method ➔ Map Data to Shapes/Colors ➔ Discover Hidden
Trends ➔ Make Business Decisions
There are three primary methods used by data professionals, depending on their goal:
● 1. Exploratory Visualization (Finding the Story): Used internally by data analysts. The
goal is to explore massive datasets without a specific hypothesis to see if any unknown
patterns or anomalies exist.
● 2. Explanatory/Declarative Visualization (Telling the Story): Used when presenting to
stakeholders or executives. The analyst already knows the answer and uses clean,
simple visuals to explain that specific finding to a non-technical audience.
● 3. Interactive Visualization (Exploring the Story): Dashboards where the user can
actively filter, zoom, and drill down into the data themselves to answer their own specific
questions.
● Exploratory: An Amazon Data Scientist creates a massive 3D scatter plot of user clicks
to see if they can find any weird patterns in how people search for products.
● Explanatory: The analyst finds that users click "Next Page" less on mobile. They make
a simple Bar Chart showing "Mobile Clicks vs. Desktop Clicks" to present to the CEO.
● Interactive: Amazon vendors are given an Interactive Dashboard where they can filter
their product sales by date, region, or device type.
👉 Question Number: 17
👉 Unit Number: 4
Question: Explain in detail about different types of charts and graphs
👉 Answer:
Definition:
Charts and graphs are specific visual tools used in data analytics to represent relationships,
comparisons, distributions, and compositions within a dataset. According to Geeks for Geeks,
selecting the right chart is entirely dependent on the specific business question being asked.
● Bar/Column Charts: Best for comparing discrete, categorical data. (e.g., Sales of
Laptops vs. Phones).
● Line Charts: Best for displaying continuous data over a period of time to show trends,
accelerations, or decelerations.
● Pie/Donut Charts: Best for showing "part-to-whole" relationships. They show how a
total amount is divided into proportional slices.
● Scatter Plots: Best for showing the correlation between two numeric variables. Data
points are plotted on an X and Y axis to see if they cluster or form a line.
● Histograms: Best for showing the distribution of a single continuous variable (e.g.,
grouping customers by age ranges: 10-20, 20-30, 30-40).
● Line Chart: Shows the total number of Prime subscriptions purchased per hour from
12:00 AM to 11:59 PM.
● Pie Chart: Shows the percentage breakdown of device usage (60% Mobile App, 30%
Desktop Browser, 10% Smart TV).
● Bar Chart: Compares total revenue generated in "North America" vs. "Europe" vs.
"Asia".
👉 Question Number: 18
👉 Unit Number: 4
Question: What do you mean by block charts and what are the significance when
compared to other charts
👉 Answer:
Definition:
A Block Chart (most commonly known in Geeks for Geeks data viz tutorials as a Treemap or
Block Diagram) is a method for displaying complex, hierarchical data using a set of nested
rectangles (blocks). The size and color of each block are directly proportional to a specific data
value.
Total Entire Dataset (One Giant Box) ➔ Split into Major Categories (Large Blocks) ➔ Split into
Sub-Categories (Smaller Blocks inside Large Blocks) ➔ Color-Coded by Performance
● 1. Extreme Space Efficiency: While a Bar Chart might get messy and unreadable if you
have 500 categories, a Block Chart can easily fit thousands of tiny blocks onto a single
laptop screen, making the best use of spatial area.
● 2. Superior Hierarchical View: Unlike a Pie Chart (which can only show one level of
data), a Block Chart shows "parts-of-a-whole" across multiple levels. You can see the
whole parent category and all its "children" inside it simultaneously.
● 3. Dual-Variable Visualization: It allows you to visualize two metrics at once. The Size
of the block represents one metric (like Total Sales), while the Color represents another
(like Profit Margin: Green = Good, Red = Bad).
Amazon's executive team uses a massive Block Chart to view their entire global revenue.
● The entire screen is one giant square representing Amazon's Total Revenue.
● It is divided into two main massive blocks: "Amazon E-Commerce" and "Amazon Web
Services (AWS)".
● Inside the "E-Commerce" block, there are hundreds of smaller blocks representing
departments ("Electronics", "Clothing", "Groceries").
● The size of the "Electronics" block shows it brings in the most money. However, the
block is colored Red, instantly warning executives that while revenue is high, the profit
margin is currently dropping compared to last year.