Subject Code Subject Title L T P C H
BME32---- Data Visualization with Power BI 2 1 0 3 3
Pre-requisite --
Course Objective:
• Learn the importance of data visualization in engineering and business intelligence
for informed decision-making.
• Gain skills in importing, cleaning, and transforming data from diverse sources
using Power BI tools.
• Develop proficiency in building and formatting basic and advanced charts and
graphs to convey insights.
• Learn to combine visuals, filters, and slicers to create interactive dashboards for
dynamic data analysis.
Modules L
Module I: Introduction to Data Visualization
Importance of Data Visualization in Engineering, Types of Data Visualizations
7
(Charts, Graphs, Maps), Introduction to Power BI and its Interface, Basics of
Business Intelligence (BI), Exploring the workspace and importing data.
Module II: Data Importing and Transformation
Importing Data from Multiple Sources (Excel, CSV, etc.), Data Cleaning and
Transformation Essentials, Using Power Query for Data Preparation, 7
Understanding Data Models and Relationships, Cleaning and transforming data
using Power Query Editor on Power BI Desktop.
Module III Creating Basic Visualizations
Building Basic Charts (Bar, Line, and Pie), Adding Filters and Slicers for Data
Manipulation, Formatting and Customizing Visuals, Visual Design Best Practices, 8
Building bar, line, and pie charts on Power BI, Adding filters and slicers to manage
data views, Enhancing visual appeal through formatting options.
Module-IV: Intermediate and Advanced Visualizations
Working with Hierarchical Visualizations (Matrix, Tree Maps), Analysing Time
Series and Trends, Using Drill-Downs for Detailed Analysis, Working with tree
8
maps and matrices on Power BI, Visualizing time-based data for trend analysis on
Power BI, Creating Interactive Dashboards with User Controls, Building an
Interactive Dashboard: Combining visuals and slicers for interactivity.
Total Hours 30
COURSE OUTCOMES:
On completion of the course the student should be able to;
CO1 Understand and apply data visualization principles to support engineering decisions.
CO2 Import, clean, and transform data from various sources using Power Query.
CO3 Create basic visualizations with filters, slicers, and customized formatting.
CO4 Build advanced visuals and interactive dashboards for in-depth data analysis.
CORRELATION OF COS WITH POS
CO/P PO PO PO PO PO PO PO PO PO PO1 PO1 PO1 PSO
O 1 2 3 4 5 6 7 8 9 0 1 2 1
CO1 3 2 2 1 2 1 1 0 1 1 1 2
CO2 3 3 2 3 3 1 1 0 1 1 1 2
CO3 2 2 3 2 3 1 1 0 1 2 2 2
CO4 2 3 3 2 3 2 2 1 2 3 3 3
Text books/Reference books
• Pro Microsoft Power BI Administration" by Markus Ehrenmueller-Jensen
and Ásgeir Gunnarsson
• Data Analysis and Visualization Using Power BI: A Step-by-Step Guide to
Understand Data and Create Effective Dashboards" by Suren Machiraju
and Siva Mahesh
• Storytelling with Data: A Data Visualization Guide for Business
Professionals" by Cole Nussbaumer Knaflic
• Microsoft Power BI Cookbook: Creating Business Intelligence Solutions
of Analytical Data Models, Reports, and Dashboards" by Chandraish Sinha
Evaluation scheme
MID End
Class
Internal Assessment Semester Semester
Participation
Exam Exam
30% 20 % 40% 10%
Assignment, MCQ, Report
MCQ or Theory Attendance/Active
Submission, Quiz, Class Test,
Test Paper Participation
Presentation
