Data Visualization
Which chart is best to show trends over time?
Line chart
Predictive analytics mainly uses?
Historical data
Descriptive analytics focuses on the ______.
Past Data
What type of data is stored in warehouse?
Structured Data
3Vs of Big Data: Volume, Variety, and?
Velocity (Speed of data generation)
Which chart is best for showing the relationship between two variables?
Scatter plot
Predictive analytics helps businesses ______ future demand.
Forecast
Descriptive analytics mainly answers which question: (a) What happened? (b) Why it happened? (c) What will happen?
a. What happened?
Method used to reduce query time in data warehouse?
Data Indexing
Popular tool for data visualization?
Power BI and Tableau
Which visualization is best for showing ranking (like Top 10 products)?
Bar/Column chart
Why is data cleaning important for predictive analytics?
Ensures accuracy and reliability of predictions
What does a KPI stand for in descriptive analytics?
Key Performance Indicator
What is the warehouse model that stores summarized data?
Online Analytical Processing (OLAP)
Name a large-scale cloud data warehouse?
BigQuery (Google BigQuery)
A company wants to compare sales vs. profit margin across products. Which chart would you suggest?
Scatter plot / Bubble chart
Predictive models often split data into ______ and ______ sets.
Training and Testing sets
Which measure of central tendency is most used in descriptive analytics?
Mean
This approach to building a data warehouse starts with small, subject-specific data marts that are later integrated.
Bottom-Up Approach
Framework used for distributed machine learning?
MLlib (Machine Learning Library in Spark)
If you want to analyze customer behavior by hour of day across a week, which visualization is best?
Heatmap
Explain the difference between predictive and prescriptive analytics.
Predictive forecasts what might happen, prescriptive suggests actions to take.
Differentiate descriptive analytics from diagnostic analytics.
Descriptive shows what happened, diagnostic explains why it happened
The data warehousing process of transforming raw data into a useful format and storing it for analysis is called?
ETL (Extract, Transform, Load) process
Technique for reducing storage size in database?
Compression (Data compression)