Scribd
Upload
22 views19 pages

BI Manual

The document outlines a series of practical exercises for data analysis and visualization using Excel, R, and Python. It includes steps for creating pivot tables and charts, performing what-if analysis, data classification, clustering, linear and logistic regression, reading CSV files, and visualizing data with Python and Power BI. Each practical aims to enhance skills in handling data from a data warehouse and generating insights through various analytical methods.

Uploaded by

redarrowperfect
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views19 pages

BI Manual

The document outlines a series of practical exercises for data analysis and visualization using Excel, R, and Python. It includes steps for creating pivot tables and charts, performing what-if analysis, data classification, clustering, linear and logistic regression, reading CSV files, and visualizing data with Python and Power BI. Each practical aims to enhance skills in handling data from a data warehouse and generating insights through various analytical methods.

Uploaded by

redarrowperfect
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 19

PRACTICAL 1

AIM: Import the Datawarehouse data in Excel and create Pivot


table and Pivot Chart.
Step 1: - Open Excel.
Step 2: - Import Data from ‘From other source’ in ‘Data tab’.

Step 3: - Select the Data


Step 4: - Click on insert tab → Select Pivot Table.

Step 5: - Select the table to Create Pivot Table.

Step 6: - From Pivot table field list → Drag items and drop ‘Drag fields
between areas below’.
Click the Desired Pivot Chart.
PRACTICAL 2
AIM: Apply the What-If Analysis for data visualization. Design an
generate necessary reports based on Datawarehouse data use excel.
Step 1: - Open Microsoft Excel
Step 2: - Insert the Value.

Step 3: - Click on data tab → Select What-if analysis → Goal Seek.

Click OK
Click OK

Step 4: - Again, Click on What-if analysis Select Scenario Manager

The Scenario Manager dialog box appears.


Step 5: - Add a scenario by clicking on Add
Step 6: - Type a name (60% highest), select cell C4 for the Changing
cells and click on OK

Step 6: - Next, add 4 other scenarios (70%, 80%, 90% and 100%)
PRACTICAL 3
AIM: Perform the data classification using classification algorithm
using R/Python.

OUTPUT:
PRACTICAL 4
AIM: Perform the data clustering using clustering algorithm using
R/Python.

Compare the Species label with the clustering result

Plot the clusters and their center


OUTPUT:
PRACTICAL 5
AIM: Perform the linear regression on the given Datawarehouse
using R/Python.

Visualize the Regression Graphically

OUTPUT:
PRACTICAL 6
AIM: Perform the logistic regression on the given Datawarehouse
using R/Python.
Step 1: - Download “quality.csv” file from GitHub.
Step 2: - Make a variable & read the “quality.csv” file & store it in that
variable.
OUTPUT:
PRACTICAL 7
AIM: Write a Python program to read a data from a csv file.
Perform the simple analysis and generate basic insights (Use pandas
is a Python library)

OUTPUT:
PRACTICAL 8
AIM: Perform the data visualization.
A) Perform data visualization using Python on any sales data

OUTPUT:
B) Perform data visualization using Power BI on any sales data
Step 1: - Open Power BI.
Step 2: - Take Blank report Template.

Step 3: - Download “Products.xlsx” file from google chrome.


Step 4: - Go to Home table → Excel workbook.

select Products.xlsx file from download → click open


Select Product.

Transform Data.

Step 5: - Your data will be enabled in power query editor window.


Step 6: - Go to again Power BI desktop window → click on “apply
changes” button.

Step 7: - Below the file menu click on “report view”

right side of the window you will see visualization.

Step 8: - Take any graph whatever you want


beside the visualization you will see the data click on product and select
the column whatever you want visualize.

Step 9: - You will see the visualized graph of your given data.

You might also like