SUBJECT NAME: ANALYZING AND VISUALIZING DATA WITH

POWER BI AND EXCEL

Question $1$:

You and your team are hired to develop a data analysis for a client$**.$ Before proceeding to

develop the business intelligence $($BI$)$ visualization, you are required to submit a proposal

report of how you are going to go about it$,$ including the tool of your choice $($Microsoft

Power BI$).$ Prepare the report base on the following criteria$/$structure:

$1\mathrm{.}0$ Introduction

$1\mathrm{.}1$ Scope of Power BI

$1\mathrm{.}2$ Features of Power BI

$1\mathrm{.}3$ Advantages of Power BI Dashboard

$2\mathrm{.}0$ Aims and Objectives

$2\mathrm{.}1$ The Aims of the Report

$2\mathrm{.}2$ The Objectives of Power BI

$3\mathrm{.}0$ Results and Outcomes$*$

$3\mathrm{.}1$ Data Collection

$3\mathrm{.}2$ Data Processing

$3\mathrm{.}3$ Power BI Steps for using data from Excel

$3\mathrm{.}4$ Preparing Environment for Data Analysis

$3\mathrm{.}5$ Steps in Power BI for Using Excel Data

$*$ For the Result and Outcomes, you are required to create ONE $(1)$ example of data or any

available data and key in the Power BI to illustrate the steps and visualizations.

$**$ You may use any assumptions on the client$$s nature of business and their needs of the

BI$.$