PRACTICAL FILE
Data Visualization using Power BI
Instructor: Dr. Suhel Ahmad
Student Name: Priyansh Tailor
Enrollment Number: 022024015
Semester: II Section: A
Batch: 2024-27
Academic Year: 2024-25
Lists of Experiments
Exp. No. Unit Experiment Name Date Remark
1 1 ● Overview of Power BI
● Importance of Visualization in
Business Analytics
2 1 Setting up Power BI:
● Installation
● Configuration
● Interface navigation
3 1 Connecting to data sources:
● CSV
● Excel
● Web
4 2 Understanding data
● Data Table
● Data Model
● Relationship and Keys
5 2 Data Transformations: Power Query
● Changing data type
● Null values
● Duplicate values
● Replacing values
● New column/measure
6 2 DAX (Data Analysis Expressions) basics:
● Calculated columns and measures
7 3 Dashboard with basic visuals
● Bar
● Pie/donut
● Line
● Scatter
● Map
8 3 Customizing the Visuals-1
● Colour
● Font
● Axis and Labels
● background
9 3 Customizing the Visuals-2
● Filter
● Slicer
● Legend
10 4 Advance DAX
Experiment 1
Objective: Introduction to Data Visualization and Power BI
a) Importance of Visualization in Business Analytics
b) Overview of Power BI for Data Visualization
A) Simplify Complex Data
Transforms raw data into an easily digestible visual format
Helps non-technical audiences understand insights without diving deep into numbers
Identify Patterns and Trends
Enables quick detection of patterns, correlations, and outliers that
might not be evident in raw data
Enhance Decision-Making
Supports informed decision-making by presenting key metrics and
trends visually
Encourages evidence-based strategies in business and management
Support Communication and Storytelling
Makes presentations more engaging and persuasive
Helps convey complex ideas or findings concisely and precisely
Monitor and Track Performance
Utilized in dashboards to provide real-time updates on performance
indicators
Facilitates constant monitoring of organizational goals
Drive Innovation
Visual exploration of data can lead to new insights and ideas
Promotes creative problem-solving by presenting data from new
perspectives
B) Data visualization is the graphical representation of
information and data. It uses visual elements like charts,
graphs, and maps to make complex data more accessible,
understandable, and actionable.
Experiment No: 2
Objective: Setting up Power BI
a) Installing Power BI Desktop
b) Configuring Power BI
c) Interface navigation
d) Different views
Process - Downloaded and installed Power BI Desktop, configured initial settings, and
navigated different views like Report, Data, and Model View.
Result - Successfully set up Power BI and understood how to navigate its workspace.
Discussion - Knowing the interface helps streamline the workflow for data loading, modeling,
and report building.
Experiment No: 3
Objective: Connecting data sources
a) Connecting to CSV file
b) Connecting to Excel file
c) Importing Data from the Web
Process - Imported data from a CSV, Excel, and a sample web data source using the “Get Data”
feature in Power BI.
Result - All data sources were successfully loaded and visible in the Fields pane.
Discussion - Power BI supports a wide range of data sources. Easy integration helps build data
models efficiently from multiple file types.
Experiment No: 4
Objective: Understanding Data Model
a. Data Tables
b. Data Model
c. Relationships and keys
Process - Reviewed imported tables, analyzed their structures, and created relationships using
primary and foreign keys in Model View.
Result - Defined relationships between tables using key fields. The model structure was
established.
Discussion -Creating relationships is key for building dynamic and responsive reports. It allows
combining data from multiple sources effectively.
Experiment No: 5
Objective: Data Transformations: Using Power Query
a) Changing data type
b) Null Values
c) Duplicate Values
d) Replacing Values
e) New column/measure
Process - Used Power Query Editor to change data types, handle nulls, remove duplicates,
replace values, and create new columns.
Result - Cleaned and structured dataset ready for analysis.
Discussion - Data transformation ensures accuracy in reporting and reduces inconsistencies,
making analysis more reliable.
Lab no: 6
Objective: DAX (Data Analysis Expressions)
a. Calculated columns and Measures
Process - Created calculated columns for derived data (e.g., Total Price = Quantity * Unit Price)
and simple measures (e.g., SUM, AVERAGE) using DAX.
Code - Total Revenue = SUM(Sales[Quantity] * Sales[Price])
Result - Successfully added columns and measures which dynamically updated with the data
Discussion - DAX expressions provide powerful ways to calculate and summarize data beyond
what is directly available in the source.
Lab No. 7
Objective: Dashboard with basic visuals
a) Bar Chart
b) Pie/Donut Chart
c) Line Chart
d) Scatter Diagram
e) Map
Process - Created multiple visuals using the data: bar chart, pie chart, line graph, scatter plot, and
map using location data.
Result - Created multiple visuals using the data: bar chart, pie chart, line graph, scatter plot, and
map using location data.
Discussion - Using different chart types helps convey specific insights. Maps visualize
geographic data, while bar and line charts highlight trends.
Experiment No: 8
Objective: Customizing Visuals
a) Setting colour of plot
b) Setting Font
c) Axis and Labels
d) Background of plot and Dashboard
Process - Customized visuals by adjusting colors, fonts, axes, labels, and backgrounds using the
Format pane.
Result - The dashboard was made more readable and visually appealing.
Discussion - Customizations enhance user experience and make the dashboard more intuitive for
stakeholders.
Experiment No: 9
Objective: Customizing the Visuals-2
a) Applying Filter
b) Slicer
c) Legend
Process:Applied filters, added slicers for interactivity, and configured legends to guide data
interpretation.
Result:The dashboard became interactive, allowing users to slice data by different categories.
Discussion:Interactivity increases the utility of the report, enabling users to drill down into the
data on demand.
Experiment No: 10
Objective: Advance Dax for Basic calculations and Metrics
Process - Created time intelligence and conditional calculations like YTD (Year-to-Date),
running totals, and calculated ratios using advanced DAX.
Code Example - Sales YTD = TOTALYTD(SUM(Sales[Amount]), 'Date'[Date])
Result -Created metrics that reflect advanced insights across time periods.
Discussion -Advanced DAX enables the creation of complex KPIs and metrics that are essential
for performance analysis.
