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
Unit 1: Introduction to Data Engineering and Data Analysis
7 hoursData 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
Unit 2: Advanced Excel for Data Manipulation and Analysis
7 hoursSorting 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
Unit 3: Power BI for Data Transformation and Visualisation
7 hoursPower 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
Unit 4: Tableau for Data Preparation and Advanced Visualisation
7 hoursTableau 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
Unit 5: Data Sharing, Collaboration and Integration
8 hoursIntegrating 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).