BACHELOR OF COMPUTER APPLICATIONS

YEAR 20 - 20

Department of Computer Science

Padmashree Institute of Management and Science
Bengaluru - 560060
 Padmashree Institute of Management and Science
Bengaluru - 560060
(Affiliated Bangalore University)

DEPARTMENT OF COMPUTER SCIENCE

LABORATORY RECORDS

NAME: ROLL No.:

SEMESTER: YEAR:

SUBJECT:

Certified Bonafide Record of Work Done by

Mr / Ms

Staff In Charge HOD

Place:

Date:

University Register No.

Submitted for the University Practical Examination held on

Internal Examiner External Examiner

 INDEX

[Link] Date Content Page Date of Signature

No Submission
Part – A Spreadsheet (Excel)
1.

2.

3.

4.

5.

6.

7.

8.

9.

Part –B Data Analysis Using Python

1.

2.

3.
 Part – C Power BI

1.

2.

3.

4.
 Part A: Spreadsheet (Excel)

1. CONDITIONAL FORMATTING, IF, COUNTIF, SUMIF, AVERAGE, CONCAT

a) CONDITIONAL FORMATTING:
 Explanation: Used to apply formatting to cells that meet a specific condition.
 Example: Highlight cells greater than 80.
 Steps:
1. Select range → Go to Home > Conditional Formatting > Highlight Cell Rules
>= Greater Than or equal to.
2. Enter 80 and choose a format (e.g., fill with color).
 Output:

b) IF
 Formula: =IF (condition, value_if_true, value_if_false)
 Explanation: Checks a condition and returns one value if true, another if false.
 Example:
Formula: =IF(C2>60, "Pass", "Fail")
If C2=60, the result is "Pass".
  Output:

c) COUNTIF
 Formula: = COUNTIF (range, criteria)
 Explanation: Counts cells in a range that meet the condition.
 Example:
Formula: =COUNTIF (A2:A20, ">50")
Counts how many numbers in the range A2:A20 are greater than 50.
 Output:

d) SUMIF
 Formula: =SUMIF (range, criteria, sum_range)
  Explanation: Sums values in a range based on a condition.
 Example:
Formula: =SUMIF(C2:C20,">60",D1:D20)
Sums values in B2:B20 where A2:A20 values are greater than 50.
 Output:

e) AVERAGE
 Formula: =AVERAGE(range)
 Explanation: Calculates the average of a range of numbers.
 Example:
Formula: =AVERAGE(A2:A20)
Averages the numbers in A2:A20.
 Output:
f) CONCAT
 Formula: =CONCAT (text1, text2, ...)
 Explanation: Combines values from multiple cells into one.
 Example:
Formula: =CONCAT (C2, " ", D2)
Combines values in A1 and B1 with a space.
 Output:
2. INDEX, MATCH, UNIQUE, IFS, COUNTIFS, SUMIFS, AVERAGEIFS
a) INDEX
 Formula: =INDEX (array, row_num, column_num)
 Explanation: Returns the value of a cell in a specific row and column.
 Example:
Formula: =INDEX (A2:C20, 12, 3)
Returns the value in the 2nd row and 3rd column of A2:C20.
 Output:

b) MATCH
 Formula: =MATCH (lookup_value, lookup_array, match_type)
 Explanation: Finds the position of a value in a range.
 Example:
Formula: =MATCH (90,C2:C20,0)
Finds the position of 50 in the range A1:A10.
 Output:
c) UNIQUE
 Formula: =UNIQUE (array)
 Explanation: Extracts unique values from a range.
 Example:
Formula: =UNIQUE (C2:C20)
Lists unique values in C2:C20.
 Output:

d) IFS
 Formula: =IFS(condition1, result1, condition2, result2, ...)
 Explanation: Checks multiple conditions and returns corresponding values.
 Example:
Formula: =IFS(B2>=90, "A", B2>=75, "B", B2 >=60, "C", B2 >=30, "D")
Returns grades based on scores.
 Output:
e) COUNTIFS
 Formula: =COUNTIFS (criteria_range1, criteria1, ...)
 Explanation: Counts cells that meet multiple conditions.
 Example:
Formula: =COUNTIFS(B2:B20,E2)
 Output:

f) SUMIFS
 Formula: =SUMIFS (sum_range, criteria_range1, criteria1, ...)
 Explanation: Sums values based on multiple conditions.
 Example:
Formula: =SUMIFS(C2:C13,A2:A13,E4,B2:B13,F4)
 Output:
g) AVERAGEIFS
 Formula: =AVERAGEIFS(average_range, criteria_range1, criteria1, ...)
 Explanation: Averages values based on multiple conditions.
 Example:
Formula: =AVERAGEIFS(C2:C13,A2:A13,E4,B2:B13,F4)
 Output:
3. VLOOKUP, HLOOKUP, XLOOKUP, COUNT, COUNTA
a) VLOOKUP
 Formula: =VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)
 Explanation: Looks for a value in the first column and returns a value in the same row
from another column.
 Example:
Formula: =VLOOKUP(A9,A2:C7,2,TRUE)
 Output:

b) HLOOKUP
 Formula: =HLOOKUP (lookup_value, table_array, row_index_num, range_lookup)
 Example: Similar to VLOOKUP, but searches horizontally.
 Formula: =HLOOKUP(B2,A1:A6,4,1)
 Output:

c) XLOOKUP
 Formula: =XLOOKUP(lookup_value, lookup_array, return_array)
 Example: =XLOOKUP(C2, A1:A6, B1:B6)
  Output:

d) COUNT, COUNTA
 COUNT Formula: =COUNT(range)
Counts only numeric cells.
 COUNTA Formula: =COUNTA(range)
Counts non-empty cells.
 COUNT Formula: = COUNT((B2:B6)
 Output:

 COUNTA Formula: =COUNTA(A2:A6)

 Output:
4. LEFT, MID, RIGHT, LEN, SUBSTITUTE, SEARCH, ISNUMBER
a) LEFT, MID, RIGHT
 LEFT: =LEFT(text, num_chars)
 Formula: =LEFT(A2,6)
 Output:

 MID: =MID(text, start_num, num_chars)

 Formula: =MID(A2,8,4)
 Output:

 RIGHT: =RIGHT(text, num_chars)

 Formula: =RIGHT(A2,2)
 Output:

 Example:
For A1 = "Excel",
=LEFT(A1, 2) → "Ex"
=MID(A1, 2, 2) → "xc"
=RIGHT(A1, 2) → "el"
b) LEN, SUBSTITUTE, SEARCH
 LEN: =LEN(text) → Returns the length of text.
 Formula: Len with space =LEN(A2)
Len Without space =LEN(SUBSTITUTE(A2," ",""))
 Output:

 SUBSTITUTE: =SUBSTITUTE(text, old_text, new_text) → Replaces text.

 Formula: =SUBSTITUTE(A2,"a","t")
 Output:

 SEARCH: =SEARCH(find_text, within_text) → Finds the position of text.

 Formula: =SEARCH("a",A2,1)
 Output:

c) ISNUMBER
 Formula: =ISNUMBER(value)
 Example: =ISNUMBER(A1) checks if A1 contains a number.
 Formula: =SUM(B2:B6)
=SUM(C2:C6)
=ISNUMBER(C2)
 Output:
5. TODAY, NOW, YEAR, MONTH, NETWORKDAYS, EOMONTH
TODAY
 Formula: =TODAY()
 Explanation: Returns the current date without the time.
 Example: If today is November 25, 2024, the result will be 25/11/2024.
 Output:

2. NOW
 Formula: =NOW()
 Explanation: Returns the current date and time.
 Example: If the current date and time are November 25, 2024, 2:30 PM, the result will
be 25/11/2024 14:30.
 Output:

3. YEAR
 Formula: =YEAR(date)
 Explanation: Extracts the year from a date.
 Example: =YEAR("25/11/2024") → 2024
 Output:
 Formula: YEAR(A1)

4. MONTH
 Formula: =MONTH(date)
 Explanation: Extracts the month (1–12) from a date.
 Example: =MONTH("25/11/2024") → 11
  Output:
 Formula: =MONTH(A1)

5. NETWORKDAYS
 Formula: =NETWORKDAYS(start_date, end_date, [holidays])
 Explanation: Calculates the number of working days between two dates, excluding
weekends and optional holidays.
 Example: =NETWORKDAYS("01/11/2024", "30/11/2024") → 21
 Output:
 Formula: =NETWORKDAYS(A2,B2)

6. EOMONTH
 Formula: =EOMONTH(start_date, months)
 Explanation: Returns the last day of the month for a given date and number of months
offset.
 Example: =EOMONTH("15/11/2024", 0) → 30/11/2024
 Output:
 Formula: =EOMONTH(A2,0)
6. OFFSET, CHOOSE, LET, MAX, SORT, SORTBY, RANK
a) OFFSET
 Formula: =OFFSET(reference, rows, cols, [height], [width])

 Explanation: Returns a range offset from a starting cell.

 Example: =OFFSET(A1, 2, 3) → Returns the value two rows down and three columns to
the right of A1.
 Output:

 Formula: =OFFSET(A1,2,1,3,3)

b) CHOOSE
 Formula: =CHOOSE(index_num, value1, value2, ...)
 Explanation: Returns a value from a list based on an index number.
 Example: =CHOOSE(2, "Apple", "Banana", "Cherry") → "Banana"
 Output:

 Formula: =CHOOSE(A6,A1,A2,A3,A4)

c) LET
 Formula: =LET(name, value, calculation)
 Explanation: Assigns names to calculations to simplify formulas.
  Example:
=LET(x, 10, y, 20, x + y) → 30
 Output:

 Formula:=LET(x,A2,y,B2,x+y)

d) MAX
 Formula: =MAX(range)
 Explanation: Returns the largest value in a range.
 Example: =MAX(A1:A10) → Finds the maximum value in A1:A10.
 Output:

 Formula: =MAX(A1:A4)

e) SORT
 Formula: =SORT(array, [sort_index], [sort_order])
 Explanation: Sorts a range or array.
 Example: =SORT(A1:A10, 1, 1) → Sorts A1:A10 in ascending order.
 Output:
  Formula: =SORT(A2:C6,2,-1,FALSE)

f) SORTBY
 Formula: =SORTBY(array, sort_by_array, [order])
 Explanation: Sorts data based on another array.
 Example: =SORTBY(A1:A10, B1:B10, 1) → Sorts A1:A10 based on B1:B10.
 Output:

 Formula: =SORTBY(A2:A6,C2:C6,-1)

g) RANK
 Formula: =RANK(number, ref, [order])
 Explanation: Returns the rank of a number in a range.
 Example: =RANK(85, A1:A10, 0) → Ranks 85 in the range A1:A10 in descending
order.
 Output:

 Formula: =RANK(65,A2:A6,0)
7. FILTER, FREQUENCY, SEQUENCE, RANDARRAY, IFERROR
a) FILTER
 Formula: =FILTER(array, include, [if_empty])
 Explanation: Returns rows that meet a condition.
 Example: =FILTER(A1:A10, B1:B10>50, "No Match") → Filters A1:A10 where
B1:B10 > 50.
 Output:

 Formula: =FILTER(A2:C7,B2:B7="Delhi")

b) FREQUENCY
 Formula: =FREQUENCY(data_array, bins_array)
 Explanation: Returns a frequency distribution.
 Example:
Data: {1, 2, 2, 3, 4, 5}
Bins: {2, 4}
Formula: =FREQUENCY(A1:A10, {2, 4}) → {2, 2, 1}
 Output:

 Formula:=FREQUENCY(B1:B10,D2:D4)
c) SEQUENCE
 Formula: =SEQUENCE(rows, [columns], [start], [step])
 Explanation: Creates a sequence of numbers.
 Example: =SEQUENCE(5, 1, 1, 1) → Generates {1; 2; 3; 4; 5}
 Output:

 Formula: =SEQUENCE(10,1,56,2)

d) RANDARRAY
 Formula: =RANDARRAY(rows, columns, min, max, integer)
 Explanation: Generates an array of random numbers.
 Example: =RANDARRAY(3, 2, 1, 100, TRUE) → Random integers in a 3x2 array.
 Output:

 Formula:=RANDARRAY(10,1,56,92,TRUE)
e) IFERROR
 Formula: =IFERROR(value, value_if_error)
 Explanation: Returns an alternate value if there’s an error.
 Example: =IFERROR(1/0, "Error") → "Error"
 Output:

 Formula: =IFERROR(A1*1,"")
8. PIVOT TABLES, WHAT-IF ANALYSIS, DATA VALIDATION, SUBTOTALS WITH
RANGES
a) PIVOT TABLES
 Explanation: Summarizes data in a dynamic table.
 Steps:
1. Select data → Insert → Pivot Table.
2. Select the range → Select New Workbook → click OK.
3. Drag fields into Rows, Columns, and Values.
 Output:

 Dataset:

 Pivot Table:
b) WHAT-IF ANALYSIS
 Explanation: Helps perform scenario analysis.
 Types: Goal Seek, Scenario Manager, Data Table.
 Example:
o Scenario Manager:
Use Data > What-If Analysis > Scenario Manager
 Output:

Scenario Manager:

Price 220:

Price 250:

c) DATA VALIDATION
 Explanation: Restricts input to specific values.
 Steps:
1. Select cells → Data → Data Validation.
2. Set rules (e.g., list, date, or number).
  Output:

d) SUBTOTALS WITH RANGES

 Formula: =SUBTOTAL(function_num, range)
 Explanation: Calculates totals with filters applied.
 Example:
=SUBTOTAL(9, A1:A10) → Sums filtered values in A1:A10.
 Output:

 Formula: =SUBTOTAL(9, D1:D9)

9. Develop an interactive dashboard for the Financial Sample Excel workbook (Microsoft
Excel Financial Sample) or Sample-Superstore Excel data.

Steps to Create an Interactive Dashboard in Excel

1. Prepare the Data:

o Load the dataset into Excel.
o Ensure the column names are clear and consistent.
o Convert the data range into an Excel table ( Ctrl + T).

2. Set Up Pivot Tables:

o Create multiple pivot tables for key insights:
 Sales Overview: Total Sales, Profit, and Discounts by Region, Segment,
or Category.
 Top Products: Highest sales or profits by Product Name.

 Customer Analysis: Customer-specific metrics like total sales or order

counts.

 Monthly Trends: Sales and profit trends over time.

3. Create Pivot Charts:
o Insert visualizations for your pivot tables:
 Bar charts for sales by category.

 Line charts for monthly trends.

 Pie charts for regional sales distribution.

 o Add slicers for interactivity:

 Allow filtering by Segment, Region, Category, or Year.

4. Integrate Key Metrics:

o Use SUMIFS, AVERAGEIFS, or COUNTIFS to calculate metrics like:
 Total Sales.

 Average Discount.

 Total Profit.
5. Design the Dashboard:
o Create a new sheet for the dashboard.
o Arrange charts, slicers, and key metrics visually.
o Use colors, shapes, and labels for clear organization.
 Part – B: Data Analysis Using Python

1. Probability

a) Calculating Simple Probabilities: To calculate simple probabilities, you can use Python's
basic mathematical functions or libraries like math or scipy.

Code:

# Simple probability calculation

red_cards = 26
total_cards = 52
probability_red_card = red_cards / total_cards
print(f"Probability of drawing a red card: {probability_red_card}")

Output:

b)Applications of Probability Distributions to Real-Life Problems: You can use [Link] to

work with probability distributions like Normal, Binomial, etc.

Code:

import numpy as np
import [Link] as plt
from [Link] import norm

# Mean and standard deviation for height

mean_height = 170 # in cm
std_dev_height = 10 # in cm

# Generate data points

x = [Link](140, 200, 100)
y = [Link](x, mean_height, std_dev_height)

# Plot the distribution

[Link](x, y)
[Link]('Normal Distribution of Heights')
[Link]('Height (cm)')
[Link]('Probability Density')
[Link]()
Output:
[Link] of Significance

a) T-Test: One Sample, Two Independent Samples, and Paired: The [Link] library
provides the function ttest_1samp() for a one-sample T-test, ttest_ind() for two independent
sample T-tests, and ttest_rel() for paired sample T-tests.

One-Sample T-Test:

Code:

from [Link] import ttest_1samp

import numpy as np

# Sample data
sample_data = [Link]([15, 16, 14, 16, 18, 19, 15, 16, 17, 14])

# Hypothesis: Mean height is 16

t_stat, p_value = ttest_1samp(sample_data, 16)
print(f"T-statistic: {t_stat}, p-value: {p_value}")

Output:

Two Independent Samples T-Test:

Code:

from [Link] import ttest_ind

# Sample data for two groups

group1 = [Link]([15, 16, 14, 16, 18, 19, 15])
group2 = [Link]([13, 14, 15, 16, 15, 14, 16])

t_stat, p_value = ttest_ind(group1, group2)

print(f"T-statistic: {t_stat}, p-value: {p_value}")

Output:
Paired T-Test:

Code:

from [Link] import ttest_rel

# Sample data before and after treatment

before_treatment = [Link]([15, 16, 14, 16, 18])
after_treatment = [Link]([16, 17, 15, 17, 19])

t_stat, p_value = ttest_rel(before_treatment, after_treatment)

print(f"T-statistic: {t_stat}, p-value: {p_value}")

Output:

b) ANOVA & Chi-Square Test:

ANOVA:

Code:
from [Link] import f_oneway

# Sample data for three groups

group1 = [Link]([15, 16, 14, 16, 18])
group2 = [Link]([19, 20, 21, 20, 22])
group3 = [Link]([10, 12, 14, 13, 11])

f_stat, p_value = f_oneway(group1, group2, group3)

print(f"F-statistic: {f_stat}, p-value: {p_value}")

Output:
Chi-Square Test (Goodness of Fit):

Code:

from [Link] import chisquare

# Observed and expected frequencies

observed = [15, 30, 45, 10]
expected = [25, 25, 25, 25]

chi2_stat, p_value = chisquare(observed, expected)

print(f"Chi-square statistic: {chi2_stat}, p-value: {p_value}")

Output:
3. Correlation and Regression Analysis

a) Scatter Plot & Correlation Coefficient: Use matplotlib for plotting and numpy to
calculate the correlation coefficient.

Code:

import [Link] as plt

import numpy as np

# Sample data
x = [Link]([1, 2, 3, 4, 5])
y = [Link]([5, 6, 7, 8, 9])

# Scatter plot
[Link](x, y)
[Link]('Scatter Plot')
[Link]('X')
[Link]('Y')
[Link]()

# Calculate correlation coefficient

correlation = [Link](x, y)[0, 1]
print(f"Correlation coefficient: {correlation}")

Output:
b) Linear Regression: Fitting Use scikit-learn to perform linear regression.

Code:

from sklearn.linear_model import LinearRegression

import numpy as np
import [Link] as plt

# Sample data
X = [Link]([1, 2, 3, 4, 5]).reshape(-1, 1) # Independent variable
y = [Link]([5, 6, 7, 8, 9]) # Dependent variable

# Fit the model

model = LinearRegression()
[Link](X, y)

# Predict values
y_pred = [Link](X)

# Plotting the regression line

[Link](X, y, color='blue', label='Actual Data')
[Link](X, y_pred, color='red', label='Regression Line')
[Link]('Linear Regression')
[Link]('X')
[Link]('Y')
[Link]()
[Link]()

print(f"Intercept: {model.intercept_}, Coefficient: {model.coef_}")

Output:
 Part – C: Power BI
1. Introduction to Power BI- Get Started with Power BI - Sign up for Power BI - Overview:
Power BI data sources - Connect to a SaaS solution - Upload a local CSV file - Connect to
Excel data that can be refreshed - Create a Report with Visualizations. Give me the step by
step procedure.

1. Sign Up for Power BI

1. Go to the Power BI official website.

2. Click on "Start Free" or "Sign Up".
3. Use your work or school email address to sign up (personal email domains like Gmail are
not allowed).
4. Follow the instructions to verify your account and set up your Power BI workspace.

2. Overview: Power BI Data Sources

 Power BI can connect to a variety of data sources, including:

o SaaS solutions like Salesforce, Google Analytics, etc.
o Files (Excel, CSV, JSON).
o Databases (SQL Server, Oracle, etc.).
o Azure and other cloud services.
o APIs and custom sources.
3. Connect to a SaaS Solution

1. Open Power BI Service (browser-based Power BI app).

2. In the Home or Workspace, click "Get Data".
3. Choose "Services" (under SaaS solutions).
4. Search for the service you want to connect (e.g., Salesforce, Google Analytics).
5. Provide the required credentials or API keys to establish the connection.
6. The connected SaaS data will appear in your workspace.

4. Upload a Local CSV File

1. Open Power BI Desktop or Power BI Service.

2. Click "Get Data" and choose "Text/CSV".
3. Browse your local system to locate and select the CSV file.
4. In the preview window:
o Verify that the data appears as expected.
o Adjust settings like delimiter type, encoding, or headers if necessary.
5. Click "Load" to import the data into Power BI.
5. Connect to Excel Data (With Refresh Capability)

1. Open Power BI Desktop.

2. Click "Get Data" and choose "Excel Workbook".
3. Browse your local system and select the Excel file.
4. In the Navigator window:
o Select the sheets or tables you want to import.
o Click "Load" or "Transform Data" for advanced cleaning and shaping.
5. To enable data refresh:
o Ensure your file is saved in a OneDrive or SharePoint location.
o Schedule a refresh in Power BI Service after publishing the report.

6. Create a Report with Visualizations

1. After loading data into Power BI Desktop:

o Navigate to the Report View (default screen).
2. Select the Fields from the right panel to add data to your visualizations.
3. Choose a visualization type from the Visualizations pane (e.g., bar chart, pie chart,
table).
4. Drag and drop fields onto the visualization to display the data.
o X-Axis/Y-Axis: For charts.
o Values: For metrics or numerical data.
o Legend: For categories.
5. Format the visualizations:
o Use the Format pane to adjust colors, fonts, axis titles, etc.
6. Save your report.
7. Publish the Report

1. Save your work in Power BI Desktop.

2. Click "Publish" in the top ribbon.
3. Select the Power BI workspace where you want to publish.
4. After publishing, go to Power BI Service to view, share, or schedule data refresh for the
report.
2. Using visualizations - Create a new report - Create and arrange visualizations - Format a
visualization - Use text, map, and gauge visualizations and save a report - Use a slicer to
filter visualizations - Sort, copy, and paste visualizations.

1. Create a New Report

1. Open Power BI Desktop or Power BI Service.

2. Load your dataset:
o Click "Get Data" to import data (e.g., Excel, CSV, database).
o Choose your data source, connect, and load the data into Power BI.
3. Once the data is loaded, navigate to the Report View (default screen in Power BI
Desktop).

2. Create and Arrange Visualizations

1. In the Fields pane (right side), drag the desired field to the canvas.
2. A default visualization (e.g., a table) will appear.
3. To change the visualization type:
o Use the Visualizations pane (middle right) to select a chart type (e.g., bar, line,
pie).
4. Add additional visualizations:
o Drag more fields to the canvas.
o Repeat the process for each visualization type.
5. Arrange the visualizations by:
o Clicking and dragging to reposition them on the canvas.
o Resizing them by dragging the corners.
3. Format a Visualization

1. Select a visualization on the canvas.

2. Go to the Format pane (paint roller icon in the Visualizations pane).
3. Customize the appearance:
o General: Adjust size, position, or background.
o Data Colors: Change the color scheme for data points.
o Title: Modify the font, size, and alignment of the title.
o Data Labels: Show or hide data values and adjust their format.
o Axes: Change labels, scales, and gridlines.
4. Use Text, Map, and Gauge Visualizations

Text Visualization

1. Use a Card visualization to display a single value (e.g., total sales).

o Drag a numeric field to the canvas and select the Card visual.
2. For detailed text:
o Use the Textbox tool from the ribbon to add annotations or labels.

Map Visualization

1. Drag a field with geographic data (e.g., country, city) to the canvas.
2. Select a Map visual from the Visualizations pane.
3. Ensure your data includes recognized location names or coordinates.

Gauge Visualization

1. Drag a numeric field to the canvas and select the Gauge visual.
2. Set a target value:
o Use the Value and Target Value fields in the Visualizations pane.

5. Save a Report

1. Click File → Save As.

2. Choose a location and name your report.
o If using Power BI Desktop, save it as a .pbix file.
 o If using Power BI Service, the report is saved automatically in your workspace.

6. Use a Slicer to Filter Visualizations

1. From the Visualizations pane, select the Slicer visual.

2. Drag a field to the Field area in the slicer.
3. Use the slicer on the canvas to filter data across all connected visualizations.

7. Sort, Copy, and Paste Visualizations

Sort

1. Select a visualization.
2. Click the More options (•••) menu on the top-right corner of the visual.
 3. Choose Sort by and select a field to sort (ascending/descending).

Copy and Paste

1. Select a visualization.
2. Press Ctrl + C to copy.
3. Press Ctrl + V to paste the visualization anywhere on the canvas.
3. Modify and Print a Report - Rename and delete report pages - Add a filter to a page or
report Set visualization interactions - Send a report to PowerPoint.

1. Modify and Print a Report

Modify the Report

1. Open the Report:

o Launch Power BI Desktop or Power BI Service and open the report you want to
modify.
2. Edit Visualizations:
o Click on a visualization to edit.
o Use the Fields and Format pane to make changes (e.g., change fields, update
chart types, or customize formatting).
3. Save Changes:
o Click File > Save (Power BI Desktop).
o In Power BI Service, changes are saved automatically.

Print the Report

1. Go to File > Print (Power BI Desktop) or use the Export > PDF option in Power BI
Service.
2. Adjust print settings (e.g., page layout, orientation).
3. Print or save as a PDF for offline use.
2. Rename and Delete Report Pages

Rename a Page

1. Navigate to the bottom of the Power BI Desktop/Service window where the report tabs
are displayed.
2. Right-click on the tab you want to rename.
3. Select Rename and type the new name.

Delete a Page

1. Right-click on the page/tab you want to delete.

2. Select Delete Page.
3. Confirm the deletion (this cannot be undone).

3. Add a Filter to a Page or Report

Page-Level Filter

1. Open the report page where you want to apply a filter.

2. Go to the Filters pane (right side).
3. Drag a field into the Page Level Filters section.
 4. Configure the filter (e.g., select specific values or use advanced filtering).

Report-Level Filter

1. In the Filters pane, drag a field into the Report Level Filters section.
2. The filter will now apply to all pages in the report.

4. Set Visualization Interactions

1. Select a visualization on the report canvas.

2. Go to the Format ribbon at the top and select Edit Interactions.
3. Icons will appear on all other visualizations:
o Filter: Filters other visualizations based on the selected data.
o Highlight: Highlights relevant data in other visuals.
o None: No interaction occurs.
4. Click the desired interaction option for each visualization.
5. Send a Report to PowerPoint

From Power BI Service

1. Open the report in Power BI Service.

2. Click on Export > PowerPoint (top menu).
3. Select:
o Current Values: Exports the report as it appears.
o Default Values: Exports the report with default filters.
4. Power BI will generate a PowerPoint file where each page of the report becomes a slide.
5. Download the PowerPoint file.

From Power BI Desktop

1. Save the report and publish it to Power BI Service.

2. Follow the steps above to export from the service.
4. Create a Dashboard - Create and manage dashboards - Pin a report tile to a dashboard -
Pin a live report page to a dashboard - Pin a tile from another dashboard - Pin an Excel
element to a dashboard - Add a tile to a dashboard.

1. Create and Manage Dashboards

Create a Dashboard

1. Open Power BI Service (dashboards are not available in Power BI Desktop).

2. Click on "Create" from the left navigation pane.
3. Select "Dashboard" and provide a name for your new dashboard.
4. The dashboard canvas will open, ready for customization.

Manage Dashboards

 To rename a dashboard:
o Go to the dashboard.
o Click the More options (•••) menu and choose Rename Dashboard.
 To delete a dashboard:
o In the left navigation pane, click the More options (•••) next to the dashboard and
choose Delete.

2. Pin a Report Tile to a Dashboard

1. Open a report in Power BI Service.

2. Hover over a visualization you want to pin.
 3. Click the Pin icon in the top-right corner of the visualization.
4. Select the dashboard where you want to pin the tile or create a new dashboard.
5. Click Pin to add the tile.

3. Pin a Live Report Page to a Dashboard

1. Open a report in Power BI Service.

2. Click on More options (•••) in the top-right corner of the page.
3. Select Pin to a dashboard.
4. Choose an existing dashboard or create a new one.
5. The live report page will now appear in the selected dashboard. Any updates to the report
will automatically reflect on the dashboard.
4. Pin a Tile from Another Dashboard

1. Open the source dashboard.

2. Click the More options (•••) on the tile you want to pin.
3. Select Pin to another dashboard.
4. Choose the destination dashboard or create a new one.
5. The tile will be added to the selected dashboard.

5. Pin an Excel Element to a Dashboard

1. Ensure your Excel file is uploaded to OneDrive or SharePoint.

2. Open Power BI Service.
3. Go to Get Data > Files > OneDrive - Business or SharePoint and import the Excel file.
4. Open the imported dataset or workbook.
5. Select a specific chart, table, or range of data in Excel and click Pin to add it to a
dashboard.
6. Add a Tile to a Dashboard

1. Open the dashboard where you want to add the tile.

2. Click "Edit" or "Add Tile" (usually found on the top menu).
3. Choose the type of tile you want to add:
o Web Content: Embed content from a URL.
o Image: Upload an image.
o Text Box: Add a custom note or description.
o Video: Embed a video link.
4. Configure the tile’s settings (e.g., size, position, and content).
5. Click Add to place it on the dashboard.