SPPU TE IT syllabus

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.

All notes for this subject
  1. Unit 1: Business Intelligence and Visualization

    9 hours

    BI, 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
  2. Unit 2: Power BI Fundamentals

    9 hours

    Power 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
  3. Unit 3: Advanced Power BI and Dashboards

    9 hours

    DAX 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
  4. Unit 4: Tableau Fundamentals

    9 hours

    Tableau 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
  5. Unit 5: Advanced Tableau

    9 hours

    Advanced 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.