Pr-9. Perform Data Analytics using PowerBI using the given dataset

Aim: Perform Data Analytics using PowerBI using the given dataset. Generate a report that contains various visualizations.

What is data analytics?

The term data analytics refers to the process of examining datasets to draw conclusions about the information they contain. Data analytic techniques enable you to take raw data and uncover patterns to extract valuable insights from it.

What is the role of data analytics?

Data Analysis is a process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, suggesting conclusions, and supporting decision-making. Data analytics allow us to make informed decisions and to stop guessing.

Advantages of making reports of data

A Power BI report is a multi-perspective view of a dataset, with visuals that represent different findings and insights from that dataset. A report can have a single visual or pages full of visuals.

Power BI bases a report on a single dataset. The visuals aren’t static. They update as the underlying data changes. You can interact with the visuals and filters as you dig into the data to discover insights and look for answers. As a dashboard, but more so, a report is highly interactive and highly customizable. The extent of what you can do with a report will depend on the role and permissions assigned by the report designer.

About the dataset

For preparing the report, I have used data regarding the sales details and other data necessary for it. The excel sheet for various data are as follows:

• Customer Details: The sheet has details about the customer id and customer name.
• Order Details: This datasheet has attribute values for Order id and Order Date.
• Sales Details: The sales details have data regarding Order ID, Customer ID, Place ID, Product ID, Sales ID, Sales, Quantity, Discount, and Cost.
• Region Details: The region details have data regarding the city, state, and the place id.
• Product Details: The product details has data about Product ID, Category, Sub-Category, and Product Name

Here for finding gross profit I have added one extra column to the given data and applied the formula which is “gross profit = sales_details[Sales]-sales_details[Cost ]”. and we can also convert the data or make symbolic the data. like here gross profit is in dollars so I have used the $ symbol.

Table relationships are implemented to normalize the database, which is crucial to data integrity and avoids data duplication. There are four main types of relationships between database tables: One to Many, Many to One, Many to Many, and One to One. we can add relationships between two tables or attributes according to our needs

Now to generate a report that visualizes the data in an efficient manner. got that power give such many options like a stacked bar chart, stacked column chart, area chart, multi-row card, pie chart, donut chart, etc…

Here below is 3 chart. The first one represents how much sale is done by category in a particular state. the second one is sales and gross profit by order date. and the third one is the donut chart which counts the state by the product name and category.

Here I have used KPI visualization to show the sales and the name of the city by the gross profit and other one s gross profit by city.

A KPI visualization compares a base value to a target value and shows the variance between the two measures. For example, this KPI visualization shows the actual revenue in green with an up arrow to indicate that revenue is up compared to the target.

The third one shows the number of quantities by the product name and its sub-category.

Here the first report is the count of subcategories by the state and I have used funnel visualizing to show this. The other one is a pie chart which shows gross profit by quantity.

That’s all for this Data Analytics using PowerBI. Thank You!