DBATU Final Year AI & ML syllabus

DBATU · Final Year B.Tech Artificial Intelligence & Machine Learning · Non-NEP

Data Engineering

BTAIC703 · Semester VII · 3 credits · Continuous assessment 20 + mid-semester 20 + end-semester 60

All notes for this subject
  1. Unit 1: Introduction to Data Engineering and Data Analysis

    7 hours

    Data engineering concepts, workflows and pipelines, data sources and integration; data types and distributions, central tendency and dispersion; histograms, box plots and scatter plots; preprocessing, cleaning and exploratory analysis.

    Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then

    • Data engineering workflow and pipelines
    • Univariate and bivariate analysis
    • Data validation and transformation
  2. Unit 2: Advanced Excel for Data Manipulation and Analysis

    7 hours

    Sorting and filtering; SUMIFS, COUNTIFS, IFERROR, TEXTJOIN, INDIRECT, OFFSET and more; VLOOKUP, INDEX and MATCH; text to columns, data validation and conditional formatting; PivotTables, what-if analysis, data tables, Goal Seek and Solver.

    Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then

    • Excel functions, lookups and data cleaning
    • PivotTables and PivotCharts
    • What-if analysis, Goal Seek and Solver
  3. Unit 3: Power BI for Data Transformation and Visualisation

    7 hours

    Power BI components, Desktop and Service; Power Query shaping, data modelling and relationships, calculated columns and measures, DAX; visualisations, drill-through and drill-down, filters, slicers and hierarchies.

    Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then

    • Power BI: Power Query and data modelling
    • DAX measures and calculated columns
    • Power BI reports and dashboards
  4. Unit 4: Tableau for Data Preparation and Advanced Visualisation

    7 hours

    Tableau Desktop and Server; connections, joins, blending and reshaping; metadata, calculations and extracts; charts, interactive filters and parameters, dashboard design.

    Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then

    • Tableau data preparation and blending
    • Tableau visualisations and dashboards
  5. Unit 5: Data Sharing, Collaboration and Integration

    8 hours

    Integrating data from several sources and automating pipelines; Excel automation with VBA macros and user-defined functions; Power BI workspaces and gateways; publishing Tableau dashboards, roles and permissions.

    Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then

    • Automating data pipelines
    • Excel automation with VBA
    • Sharing and collaboration in Power BI and Tableau

Unit contents are summarised from the official DBATU syllabus . AiCanCode.org is not affiliated with Dr. Babasaheb Ambedkar Technological University (DBATU).