Tutorial -1
Date: 4/2/2026
Q.1. Explain the components of Power BI.
Answer : Following are components of Power BI
• Power BI Desktop
Power BI Desktop is the main platform where most of the work happens. It combines all the features like
Power Query (for cleaning data), Power Pivot (for modeling data) and Power View (for visualizing data)
into one tool. This is where you build complete reports and dashboards.
This interface is user-friendly and it allows you to design everything offline before publishing it online. It
is like workshop were we prepare everything here before sharing it with our team or organization.
• Power BI Service
After we create our reports in Power BI Desktop you can publish them to the Power BI Service which is
also known as the Power BI Website. Here we can share your reports with others, collaborate in teams
and access your data from any device using a browser.
It’s a cloud-based platform that also lets us schedule data refreshes and receive automatic updates. We
can also create dashboards here by pinning visuals from different reports into one view for easy
monitoring.
• Power BI Mobile Apps
Power BI has mobile apps for iPhone, Android and Windows devices. These apps allow you to access
your reports and dashboards anywhere and anytime. You can view the latest data, check KPIs (Key
Performance Indicator)and stay updated on business performance while traveling or during meetings.
The mobile interface is designed to be clean and responsive so you can scroll through your visuals easily
even on a small screen.
Following are the major Components of Power BI:
1. Power Query
It is the process of cleansing and transforming data and permits users to access datasets connecting
from multiple sources. It is included on the Power BI desktop. Business users may view the data from
distinct databases like MySQL, SQL servers, DB2, and many more.
2. Power View
It is a data visualization tool that assists users in developing stunning charts, and colorful maps, that turn
data into a story.
3. Power Map
It is a 3D map visualization tool to identify geospatial data on Map visuals. It seamlessly helps
organizations to examine the maximum sales production geographically, visualizing the demographic
populations of specific regions.
4. Power Pivot
It is a Data Modelling technique that is used to create relationships between datasets. It performs
complex computations by utilizing DAX (Data Analysis Expressions) functions.
5. Power Q & A
When dealing with giant datasets, it becomes crucial to get to know the in-depth details of the data.
Luckily, it is done through natural language where users may ask questions and obtain the answer
through Power Q & A.
Q.2. What are the steps in data visualization process? Explain.
Answer: Following are the steps in data visualization process:
1] Define the Goal
You can define a data visualization goal by identifying questions that your existing dataset can
potentially answer. A clear goal helps determine the type of:
The data you use
Analysis you do
Visuals you use to communicate your findings effectively
For example, a retailer may seek to understand which type of product packaging gets the most sales.
2] Collect the data
Data collection involves identifying internal and external data sources. There are massive datasets
available online for purchase and use. Your company may also have existing data archives available for
analytics.
For example, you could collect historical sales volume, marketing campaigns, and product packaging
data to find the best packaging.
3] Clean the data
Data cleaning involves removing redundant data, performing mathematical operations for further
analysis, or filtering and converting data to meet the question criteria. For instance, you may remove
sales volume data from the holiday months and after marketing campaigns to identify average sales by
packaging type.
4] Select the data visuals
You can choose from several different chart types for efficient visual discovery. Relationships between
the data points and the insights you want to communicate will determine the best graphical
representations. For example, you may use a bar graph to represent packaging sales by color in the last
month. However, a pie chart may be better suited to show the percentage of colored packaging in your
inventory. There are two main types of data visualizations.
a) Static visualization
A static visualization provides only a single view of a specific data story. An infographic is an
example of a static visualization.
b) Interactive visualization
Interactive visualization allows users to interact with graphs and charts. Viewers can change
variables in visualization parameters to find new insights or access in-depth information. Data
visualization software typically includes a dashboard for user interaction with the system
5] Create the data visuals
• You can create the data visuals you need by using data visualization tools. Most tools import
your final dataset and automatically generate the required reports. Some design principles for
effective data visualization include the following:
• Draw audience attention to important details using sizes, colors, fonts, and graphics
• Provide context to data using visual cues
• Choose the right color combinations
• Use explanatory titles to provide key insights to the audience and help them focus on the right
questions
• Add clear labels and numbers