SPPU · Third Year Information Technology · 2024 Pattern
Power BI & Tableau
PEC-362A-IT · Elective III · Semester VI · 3 credits · CCE 30 + end-semester 70
One of the Elective III options.
Unit 1: Business Intelligence and Visualization
9 hoursBI, its evolution, architecture and role in decision-making; descriptive, diagnostic and prescriptive analytics; Power BI and Tableau; chart types; data sources and import.
Marks: 14 in the end-semester exam · CCE: Unit test (12 marks, Units 1 & 2)
- Business intelligence and its architecture
- Types of analytics
- Choosing charts and visualisations
Unit 2: Power BI Fundamentals
9 hoursPower BI Desktop, Service and Mobile; Power Query; data modelling and relationships; charts, tables, filters, slicers and drill-down.
Marks: 14 in the end-semester exam · CCE: Unit test (12 marks, Units 1 & 2)
- Power BI components
- Power Query
- Data modelling and relationships in Power BI
- Filters, slicers and drill-down
Unit 3: Advanced Power BI and Dashboards
9 hoursDAX aggregation, logical, time-intelligence and filter functions (SUM, IF, SWITCH, DATEADD, TOTALYTD, CALCULATE, FILTER, ALL); interactive dashboards and reports; publishing, sharing and real-time monitoring.
Marks: 14 in the end-semester exam · CCE: Assignments or case study (12 marks, Units 3 & 4)
- DAX basics and calculated measures
- DAX time intelligence and CALCULATE
- Designing interactive dashboards
- Publishing and sharing reports
Unit 4: Tableau Fundamentals
9 hoursTableau architecture and interface; file and database connections; data blending and preparation; worksheets, dashboards and stories; geographic and statistical visualisations.
Marks: 14 in the end-semester exam · CCE: Assignments or case study (12 marks, Units 3 & 4)
- Tableau architecture and interface
- Connecting and blending data
- Worksheets, dashboards and stories
- Geographic and statistical visualisations
Unit 5: Advanced Tableau
9 hoursAdvanced calculations, LOD expressions and IF and CASE logic; interactive dashboards and filters; forecasting and trends; publishing.
Marks: 14 in the end-semester exam · CCE: Seminar, open-book test or quiz (6 marks, Unit 5)
- Calculated fields and LOD expressions
- Interactive filters and parameters
- Forecasting and trend analysis
Unit contents are summarised from the official SPPU syllabus . AiCanCode.org is not affiliated with Savitribai Phule Pune University.