SGBAU TY AI & DS syllabus

SGBAU · Third Year B.E. Artificial Intelligence and Data Science · NEP 2020

Data Visualization Techniques

6AD235PE2 · Elective III · Semester VI · 3 credits · IE 40 + ESE 60

One of the Elective III options.

  1. Unit 1: Introduction to Data Visualisation

    6 hours

    Data visualisation and its key factors, its importance in BI, tools and types of data; data abstraction — data, dataset and attribute types — task abstraction and the four levels of validation.

    Examined in the 60-mark end-semester paper

    • History of visualisation and the visualisation process
    • Data foundations for visualisation
    • The visualisation reference model, visual mapping and visual analytics
  2. Unit 2: Visualisation Techniques

    6 hours

    Scalar and point visualisations, vector and multidimensional visualisations, cluster visualisation and matrix visualisation in Bayesian data analysis.

    Examined in the 60-mark end-semester paper

    • Higher-dimensional displays
    • Visualising groups, clusters and software
    • Comparing and evaluating visualisation techniques
  3. Unit 3: Getting Started with pandas

    8 hours

    Arrays and vectorised computation, pandas data structures and essential functionality, descriptive statistics; loading and storing data — text, web scraping, binary formats, web APIs and databases; cleaning and preparation — missing data, transformation and string manipulation.

    Examined in the 60-mark end-semester paper

    • Merging, reshaping and pivoting data
    • Group-by and split-apply-combine
    • Reading CSV, XML and JSON data for visualisation
    • Pandas data frames
    • Handling missing data
  4. Unit 4: Data Visualisation Tools in Python

    6 hours

    Matplotlib and its basic plots, specialised and advanced visualisation tools, waffle charts and word clouds.

    Examined in the 60-mark end-semester paper

    • Plotting with matplotlib and seaborn
    • Plotting with pandas: line, bar, scatter, histogram and heat map
    • 3D plotting
    • Text and document visualisation
  5. Unit 5: Data Analysis in Excel

    8 hours

    Excel data analysis — range names, tables, cleaning, conditional formatting, sorting, advanced filtering, lookups, pivot tables, charts and data validation; the Analysis ToolPak — ANOVA, correlation, covariance, moving average, descriptive statistics, exponential smoothing, Fourier analysis, random numbers, sampling, t- and F-tests and regression.

    Examined in the 60-mark end-semester paper

    • Excel functions, lookups and data cleaning
    • Pivot tables and cross-tabulation
    • Excel charts and dashboards
    • Hypothesis tests: Z, t, F and chi-square
  6. Unit 6: Visualising Big Data and Visualisation Tools

    6 hours

    Visualising big data — volume, variety and velocity — interactive treemaps and sunburst charts, and Tableau and Power BI.

    Examined in the 60-mark end-semester paper

    • Visualising trees, graphs and networks
    • Interaction techniques and animated transformations
    • Tableau visualisations and dashboards
    • Power BI reports and dashboards

Unit contents are summarised from the official SGBAU syllabus . AiCanCode.org is not affiliated with Sant Gadge Baba Amravati University (SGBAU).