Power BI & Tableau syllabus
PEC-362A-IT · Third Year Information Technology, SPPU 2024 pattern. Every unit, the marks scheme, course outcomes and books, copied from the official syllabus PDF.
Unit-wise syllabus
Introduction To Business Intelligence And Data Visualization
9 hoursDerived reading outline. Source text split at semicolons, line breaks and sentence boundaries, not an official topic hierarchy.
- Introduction to Business Intelligence (BI): Definition of Business Intelligence Evolution of BI Systems Importance of BI in modern organizations Data-driven decision-making Components of BI Architecture Concepts of Data Analytics and Visualization: Types of Analytics, Descriptive Analytics, Diagnostic Analytics, Prescriptive Analytics.
- Introduction to Power BI and Tableau, Types of Charts and Visualizations, Data Sources and Data Import Techniques, Applications of BI in Industry Case Studies: Hospital Management BI Dashboard
Preserved official unit paragraph
Introduction to Business Intelligence (BI): Definition of Business Intelligence Evolution of BI Systems Importance of BI in modern organizations Data-driven decision-making Components of BI Architecture Concepts of Data Analytics and Visualization: Types of Analytics, Descriptive Analytics, Diagnostic Analytics, Prescriptive Analytics. Introduction to Power BI and Tableau, Types of Charts and Visualizations, Data Sources and Data Import Techniques, Applications of BI in Industry Case Studies: Hospital Management BI Dashboard
Power BI Fundamentals
9 hoursDerived reading outline. Source text split at semicolons, line breaks and sentence boundaries, not an official topic hierarchy.
- Power BI Interface and Components: Overview of Microsoft Power BI Business Intelligence using Power BI Applications of Power BI in organizations Power BI ecosystem Components of Power BI: Power BI Desktop, Power BI Service (Cloud Platform), Power BI Mobile Applications, Power Query Editor, Data Modeling and Relationships, Creating Charts, Graphs, and Tables, Filters ,Slicers and Drill-down Features.
- Case Studies: E-Commerce Customer Analytics Dashboard
Preserved official unit paragraph
Power BI Interface and Components: Overview of Microsoft Power BI Business Intelligence using Power BI Applications of Power BI in organizations Power BI ecosystem Components of Power BI: Power BI Desktop, Power BI Service (Cloud Platform), Power BI Mobile Applications, Power Query Editor, Data Modeling and Relationships, Creating Charts, Graphs, and Tables, Filters ,Slicers and Drill-down Features. Case Studies: E-Commerce Customer Analytics Dashboard
Advanced Power BI and Dashboard Design
9 hoursDerived reading outline. Source text split at semicolons, line breaks and sentence boundaries, not an official topic hierarchy.
- DAX Functions and Calculated Measures: Introduction to DAX (Data Analysis Expressions) Common DAX Functions: Aggregation (SUM, AVERAGE, COUNTROWS)Logical (IF, SWITCH), Time Intelligence (DATEADD, SAMEPERIODLASTYEAR, TOTALYTD), Filter Functions (CALCULATE, FILTER, ALL) Interactive Dashboard Development and Business Reports, Publishing and Sharing Reports, Real-Time-Data-Monitoring.
- Case Studies: Sustainable Waste Management Monitoring (aligned with your research interest)
Preserved official unit paragraph
DAX Functions and Calculated Measures: Introduction to DAX (Data Analysis Expressions) Common DAX Functions: Aggregation (SUM, AVERAGE, COUNTROWS)Logical (IF, SWITCH), Time Intelligence (DATEADD, SAMEPERIODLASTYEAR, TOTALYTD), Filter Functions (CALCULATE, FILTER, ALL) Interactive Dashboard Development and Business Reports, Publishing and Sharing Reports, Real-Time-Data-Monitoring. Case Studies: Sustainable Waste Management Monitoring (aligned with your research interest)
Tableau Fundamentals And Visualization Techniques
9 hoursDerived reading outline. Source text split at semicolons, line breaks and sentence boundaries, not an official topic hierarchy.
- Introduction to Tableau Environment: Introduction to Business Intelligence using Tableau Features and capabilities of Tableau Tableau Architecture, Tableau Interface Components, Connecting Data Sources in Tableau: File-Based Data Connections, Database Connections Data Blending and Data Preparation, Worksheets, Dashboards, and Stories, Visualization Techniques in Tableau, Geographical and Statistical Visualizations.
- Case Studies: Smart City Traffic Analytics Dashboard
Preserved official unit paragraph
Introduction to Tableau Environment: Introduction to Business Intelligence using Tableau Features and capabilities of Tableau Tableau Architecture, Tableau Interface Components, Connecting Data Sources in Tableau: File-Based Data Connections, Database Connections Data Blending and Data Preparation, Worksheets, Dashboards, and Stories, Visualization Techniques in Tableau, Geographical and Statistical Visualizations. Case Studies: Smart City Traffic Analytics Dashboard
Advanced Tableau And Industry Applications
9 hoursDerived reading outline. Source text split at semicolons, line breaks and sentence boundaries, not an official topic hierarchy.
- Advanced Calculations and Parameters: Overview of Advanced Calculations in Tableau, Level of Detail (LOD) Expressions, Conditional logic (IF, CASE statements), Interactive Dashboards and Filters, Forecasting and Trend Analysis, Publishing Tableau Reports.
- Case Studies: Airline Passenger Trend Forecasting
Preserved official unit paragraph
Advanced Calculations and Parameters: Overview of Advanced Calculations in Tableau, Level of Detail (LOD) Expressions, Conditional logic (IF, CASE statements), Interactive Dashboards and Filters, Forecasting and Trend Analysis, Publishing Tableau Reports. Case Studies: Airline Passenger Trend Forecasting
Marks and credits
| Head | Marks | Credit |
|---|---|---|
| CCE (continuous comprehensive evaluation) | 30 | 3 |
| End-semester exam | 70 |
Prerequisite: 1.Basic knowledge of Computer Fundamentals 2.Understanding of Database Management Systems (DBMS) concepts 3. Basic knowledge of MS Excel and Spreadsheet operations.
Course outcomes
- CO1To Understand the fundamentals of Business Intelligence and Data Analytics tools.
- CO2To Perform data cleaning, transformation, and visualization using Power BI.
- CO3To Design interactive dashboards and analytical reports using Tableau.
- CO4To Apply data analysis techniques for solving business and engineering problems.
- CO5To Develop complete visualization solutions for real-world datasets.
Books
Text books
- Learn Power BI: A beginner’s guide to developing interactive business intelligence solutions using Microsoft Power BI by Greg Deckler.
- Tableau Desktop Specialist Guide by Tyler Monroe.
Reference books
- Storytelling with Data: A Data Visualization Guide for Business Professionals Cole Nussbaumer Knaflic ISBN-97811190022532.
- Practical Tableau: 100 Tips, Tutorials, and Strategies from a Tableau Zen Master, Ryan Sleeper ISBN- 9781491977316.
- Microsoft Power BI Cookbook: Creating Business Intelligence Solutions of Analytical Data Models, Reports, and Dashboards, Brett Powell ISBN- 9781788290142
- Data Visualization: Principles and Practice (Second Edition), Alexandru C. Telea ISBN- 9781466585263
FAQ
How many units are in Power BI & Tableau?
Power BI & Tableau (PEC-362A-IT) has 5 units and 45 hours of theory: Unit I Introduction To Business Intelligence And Data Visualization (9 h); Unit II Power BI Fundamentals (9 h); Unit III Advanced Power BI and Dashboard Design (9 h); Unit IV Tableau Fundamentals And Visualization Techniques (9 h); Unit V Advanced Tableau And Industry Applications (9 h).
What is the marks scheme for Power BI & Tableau?
The official Information Technology 2024 pattern syllabus lists continuous comprehensive evaluation (CCE) for 30 marks and the end-semester exam for 70 marks, for 3 credits.
What should I know before Power BI & Tableau?
Prerequisite listed in the syllabus: 1.Basic knowledge of Computer Fundamentals 2.Understanding of Database Management Systems (DBMS) concepts 3. Basic knowledge of MS Excel and Spreadsheet operations.