0% found this document useful (0 votes)
23 views3 pages

Data Visualization and Analysis Guidelines

The document outlines suggested teaching guidelines for Data Visualization and Practical Machine Learning for the PG-DBDA program at ACTS, Pune, scheduled for August 2024. It includes topics such as BI user segmentation, data analytics life cycle, visualization techniques, and machine learning fundamentals, with a focus on practical applications using tools like Excel and Tableau. The curriculum emphasizes hands-on lab work and evaluation through theory and lab exams.

Uploaded by

Raghav
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
23 views3 pages

Data Visualization and Analysis Guidelines

The document outlines suggested teaching guidelines for Data Visualization and Practical Machine Learning for the PG-DBDA program at ACTS, Pune, scheduled for August 2024. It includes topics such as BI user segmentation, data analytics life cycle, visualization techniques, and machine learning fundamentals, with a focus on practical applications using tools like Excel and Tableau. The curriculum emphasizes hands-on lab work and evaluation through theory and lab exams.

Uploaded by

Raghav
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

ACTS, Pune

Suggested Teaching Guidelines for


Data Visualization - Analysis and Reporting
PG-DBDA August 2024
o BI User Segmentation,
o Gathering BI Requirements,
o Content and Knowledge Management,
o Strategic Approach to BI
o Significance of visual analytics Information Visualization
o Data Representation
o Data collection and binding
 Structured Data
 Unstructured data

Session 3, 4 & 5:
MS EXCEL
o Functions
o Formula
o Charts
o Pivots and Lookups
o Data Analysis Tool
pack
1. Descriptive Summaries
2. Correlation
3. Regression

Session 6
Data analytics Life Cycle:
o Discovery,
o Data preparation
o Model planning
o Model building implementation
o Quality assurance
o Documentation
o Management approval
o Installation
o Acceptance and operation

Session 7 & 8
o Introduction to Tableau
o Intelligent data analysis
o Nature of Data
o Analytics Processes and tools
o Analysis vs. Reporting
o Modern Data Analytic Tools
o Data sources in Tableau

PG-DBDA
Page 2 of 3
ACTS, Pune

Suggested Teaching Guidelines for


Data Visualization - Analysis and Reporting
PG-DBDA August 2024
Session 9, 10 & 11
o Visualization
Algorithms
o Visual Encodings
 color, size, shape, lines, axes, scaling, annotation
o Taxonomy of data visualization (Some Types of charts, but not limited to)
 Comparison charts – types of Bar chart, Box plots, Histograms, Gantt charts,
Bullet graphs, side-by-side bar chart etc.
 Tables – Text Tables, Highlight tables
 Hierarchies and relationships – Pie chart, stacked bar, Tree map etc.
 Changes over time – Line chart, dual lines, Area charts etc.

 Connections and relationships – scatter plots, Symbol maps, map, heat maps,
packed bubble chart etc.

Session 12 &13:
o Choosing appropriate visuals
o Applying calculations using functions, statistics
 Numeric Calculations
 String Calculations
 Date calculations
 LOD (Level of Detail) Expressions

o Data sorting, filters


o Interactive visualization
 Event listeners/callbacks
 Data updation
 Visual
updation
o Dashboard Design

Assignment-Lab:
 Load coffee chain dataset in Tableau and create required visuals. Also create the
report for the same dataset using VBA tools in Excel.

PG-DBDA
Page 3 of 3
ACTS, Pune

Suggested Teaching Guidelines for


Practical Machine Learning PG-DBDA
August 2024
Duration: 60 hours Theory and 80 hours Lab
Objective: Practicing Machine Learning Algorithms

Prerequisites: Good knowledge of Python Programming and Statistics

Evaluation method: Theory exam– 40% weightage


Lab exam – 40% weightage
Internal exam– 20% weightage

List of Books / Other training material

Textbook:
1. Machine Learning using Python , Manaranjan Pradhan , U Dinesh Kumar
Wiley India, 1st Edition, 9788126579907
Reference Book:

Note:
 PyTorch Framework should be taught in Lab Hours

Note: Each session having 2 Hours

Session 1, 2 & 3:
 Fundamentals of information theory
 What is machine learning?
 Algorithm types of Machine learning
 Probably Approximately Correct (PAC) Learning
 Uses of Machine learning
 Evaluating ML techniques
 Bias complexity trade off
 Vapnik-Chervonenkis (VC) Dimension
 Non-uniform learnability (Structural risk minimization, Occam’s
Razor and No Free Lunch Theorem)
 Regularization and Stability
 Model Selection and Validation
 Introduction to Scikit Learn
 Performing ML using Scikit Learn

Assignments:
 Explore scikit learn Library.
 Explore Datasets Online (can refer Kaggle, UCI ML, etc.)
• Load dataset in google colab.
• Print first five values and last five values in dataset.
• check correlation between fields present in dataset

PG-DBDA Page 1 of 5

Common questions

Powered by AI

Structured data is organized in a predefined manner, often in tabular form, making it easy to search and analyze. Unstructured data lacks this organization, comprising formats like text, images, and videos. Understanding these differences is crucial for data analysis as it determines which tools and techniques can be applied. Techniques suitable for structured data, like SQL queries, might not work for unstructured data, which requires machine learning and natural language processing methods. Acknowledging these differences ensures effective and efficient data processing and analysis .

The primary phases of the data analytics life cycle include discovery, data preparation, model planning, model building, implementation, quality assurance, documentation, management approval, installation, and acceptance and operation. The discovery phase involves understanding the objectives and requirements of the analysis. Data preparation comprises cleaning and organizing data. Model planning and building involve selecting and applying analytical techniques to develop predictive models. Implementation integrates these models into decision-making processes. Quality assurance ensures the models function correctly, while documentation provides a record of processes and decisions. Management approval and installation finalize the adoption of the analytics solutions, leading to accepted operations for continued use .

The 'bias complexity trade-off' refers to the balance between the error due to bias (error from overly simplistic models) and the error due to variance (error from overly complex models). This trade-off is significant because achieving an optimal model requires minimizing both errors to improve prediction accuracy. High bias can lead to underfitting, where the model fails to capture underlying trends, while high variance can result in overfitting, where noise is mistaken as signal. Evaluating this trade-off is crucial in model selection and validation to ensure models generalize well to new data .

The 'No Free Lunch Theorem' implies that no single machine learning algorithm is universally best for all problems. Each algorithm performs well only on certain types of tasks or datasets, presenting challenges in selecting the most effective algorithm for a specific problem. This theorem affects algorithm selection by necessitating a tailored approach to each task, testing multiple algorithms to identify which performs best based on the problem's characteristics. It highlights the importance of understanding dataset properties and problem context to optimize algorithm choice and performance .

Interactive visualizations enhance user engagement and data analysis effectiveness by allowing users to explore data dynamically and intuitively. Features like event listeners, callbacks, data updates, and visual updates enable users to interact with visual representations, modify views, filter information, and drill down into specific data points. This interactivity leads to better understanding, discovery of insights, and more informed decision-making processes by allowing users to tailor their exploration to their specific needs and interests .

Model selection and validation are crucial for the success of machine learning projects as they ensure that the chosen model achieves the best performance on unseen data, preventing overfitting or underfitting. It involves choosing the right algorithm, tuning parameters, and assessing performance metrics. Scikit Learn facilitates these tasks with its libraries that offer numerous tools for splitting data, performing cross-validation, and comparing model performance. This capability aids in selecting and validating models efficiently, ensuring robust predictive models .

The educational objectives of the practical machine learning course with ACTS, Pune, are to practice machine learning algorithms thoroughly. The prerequisites for this course include a good knowledge of Python programming and statistics, ensuring participants have the foundational skills necessary to engage with and understand the course material. This prepares students to effectively apply machine learning techniques using the PyTorch framework and other relevant tools .

Content and knowledge management are integral to effective business intelligence (BI) strategies as they involve organizing, storing, and retrieving business information. This management ensures that accurate, pertinent, and timely information is available for decision-making. By maintaining a centralized repository of knowledge, organizations can enhance their analytical processes, make informed decisions faster, and gain insights into market trends and operational efficiencies, ultimately driving strategic BI initiatives .

Visualization algorithms play a critical role in converting data into visual representations that can be easily understood and analysed. These algorithms determine how data is processed and presented visually. Examples of visual encodings used for better data representation include color, size, shape, lines, axes, scaling, and annotation. Proper application of these encodings allows for clear, intuitive visualization of complex datasets, enabling quicker and more accurate insights .

The Vapnik-Chervonenkis (VC) Dimension is a measure of the capacity of a statistical model, reflecting the model's ability to classify datasets with different distributions. This concept is significant in machine learning as it helps in assessing the model's complexity and capacity to generalize learned patterns to unseen data. A higher VC dimension indicates a model capable of capturing complex patterns but also increasing the risk of overfitting. Thus, evaluating the VC dimension assists in selecting models that balance complexity with generalization ability .

You might also like