Exploratory Data Analytics Techniques

Question 1

True or false: A data scientist typically spends almost 70% of their work time performing EDA on datasets.

Answer 1

TRUE

The time invested in EDA provides a comprehensive understanding of the data.

Question 2

What does EDA stand for?

Answer 2

Exploratory Data Analysis

EDA is a systematic approach to uncovering insights and preparing data for further analysis or modeling.

Question 3

What is the sequence of steps known as in data analytics?

Answer 3

Exploratory Data Analysis (EDA)

EDA is crucial for exploring data and uncovering insights.

Question 4

List the five steps learned with the Pandas tools for data analysis.

Answer 4

• Import data from various sources
• Select specific rows and columns
• Identify and handle missing and duplicate values
• Explore unique values and calculate summary statistics
• Visualize data distributions, relationships, and trends

These steps are essential for preparing data for analysis.

Question 5

What are the five steps learned with the Feature-engine tools?

Answer 5

• Import data from various sources
• Encoding techniques for categorical variables
• Handle outliers and impute missing values
• Transformation techniques for variable distribution
• Select relevant variables for analysis

These steps enhance the robustness and reliability of data.

Question 6

Who pioneered the concept of Exploratory Data Analysis (EDA)?

Answer 6

John W. Tukey

Tukey introduced EDA in the 1970s as a critical step in data analysis.

Question 7

What are the nine steps crucial for EDA?

Answer 7

• Initial Insight
• Error Detection
• Understanding Patterns
• Outlier Detection
• Variable Relationships
• Data Transformation
• Univariate Feature Visualization
• Hypothesis Testing
• Multivariate Data Visualization

These steps guide the analysis process and help uncover insights.

Question 8

Fill in the blank: EDA allows us to look at data in its raw form and get a feel for what it contains, providing ________ for guiding subsequent steps in the analysis.

Answer 8

preliminary insight

This insight is invaluable for effective data analysis.

Question 9

What is the purpose of Error Detection in EDA?

Answer 9

Identify obvious errors in the data

Early detection prevents skewed results in analysis.

Question 10

What does EDA help us uncover regarding patterns and trends?

Answer 10

It helps form hypotheses and make informed decisions

Understanding patterns is essential for applying analytical techniques.

Question 11

What is the significance of Outlier Detection in EDA?

Answer 11

Identifies anomalous events that can impact analysis

Proper handling of outliers is crucial for accurate results.

Question 12

How does EDA assist in understanding Variable Relationships?

Answer 12

Finds interesting relationships among variables

These relationships can lead to new insights and further investigation.

Question 13

What is the role of generative AI in the context of EDA?

Answer 13

Streamline and enhance analysis

Generative AI can assist in gathering detailed statistics and creating visualizations.

Question 14

What should be provided in prompts to effectively leverage AI for visualizations?

Answer 14

Clear and detailed instructions

This helps in creating meaningful visualizations that highlight trends.

Question 15

What is the importance of model evaluation in the context of data analysis?

Answer 15

Ensures the effectiveness of the models built

Model evaluation will be covered in a future lesson.

Question 16

Fill in the blank: Generative AI can propose meaningful actions based on the data, providing valuable suggestions that can inform ________.

Answer 16

policy-making and decision-making processes

This enhances the relevance of insights derived from data.

Question 17

What is the purpose of a dashboard in a business context?

Answer 17

To provide key insights into sales performance, inventory levels, and customer behaviour

A well-planned dashboard translates complex data into actionable insights.

Question 18

Effective dashboard planning involves understanding which three key elements?

Answer 18

• Purpose
• Audience
• Data

These elements ensure the dashboard meets user needs and delivers valuable insights.

Question 19

True or false: A well-planned dashboard can become cluttered and confusing without careful planning.

Answer 19

TRUE

Careful planning is essential to create a visually appealing and functionally robust dashboard.

Question 20

Who are typical stakeholders involved in the dashboard planning process?

Answer 20

• Business managers
• Data analysts
• IT professionals
• End-users

Engaging with stakeholders helps gather diverse perspectives on dashboard needs.

Question 21

What is the first step in engaging with stakeholders for dashboard planning?

Answer 21

Identifying all key individuals and groups who will interact with or benefit from the dashboard

This helps ensure that all stakeholder voices are heard and understood.

Question 22

After gathering input from stakeholders, what is the next step in the dashboard planning process?

Answer 22

Documenting the requirements clearly and comprehensively

Visual aids like diagrams can help illustrate data flow and relationships.

Question 23

What approach is valid for dashboard planning to ensure user-centric solutions?

Answer 23

Design thinking approach

This approach focuses on understanding user needs and creating tailored solutions.

Question 24

What are Key Performance Indicators (KPIs) used for?

Answer 24

• Tracking progress toward business objectives
• Assessing strategies and actions
• Motivating employees

KPIs link strategic goals to day-to-day operations.

Question 25

Fill in the blank: Each KPI should be **_______**, Measurable, Achievable, Relevant, and Time-bound.

Answer 25

Specific ## Footnote This approach helps select KPIs that are clear and actionable.

Question 26

What are the primary goals of effective **dashboard design**?

Answer 26

* Clarity * Simplicity * Functionality ## Footnote The design should communicate complex information quickly and accurately.

Question 27

What is the purpose of creating **wireframes** and **mockups** before developing a dashboard?

Answer 27

* Wireframes outline structure and layout * Mockups include design elements like colours and fonts ## Footnote These tools provide a visual blueprint for the dashboard.

Question 28

What enhances the **usability** of dashboards?

Answer 28

Interactivity ## Footnote Features like clickable elements and drill-down capabilities allow users to explore data dynamically.

Question 29

Which tool is known for its integration with Microsoft products and robust data visualisation capabilities?

Answer 29

Microsoft Power BI ## Footnote It is highly regarded for its features and ease of use.

Question 30

What should be evaluated when choosing the right tool for **dashboard creation**?

Answer 30

* Compatibility with data sources * Ease of use * Visualisation capabilities * Scalability * Cost * Integration * Security * User support ## Footnote These criteria ensure the tool meets project and organisational needs.

Question 31

What should a comprehensive **dashboard plan document** include?

Answer 31

* Requirements from stakeholders * Purpose and objectives * Target audience * Key Performance Indicators (KPIs) * Design wireframes and mockups * Interactivity and usability considerations * Tool selection rationale ## Footnote This document guides the dashboard development process.