Practical:8 How to build a simple dashboard using Power BI.

In this blog, we’ll develop a dashboard on which we can view our data using various types of charts and have a better understanding of it.


Power BI dashboard

A Power BI dashboard is a single page, often called a canvas, that uses visualizations to tell a story. Because it is limited to one page, a well-designed dashboard contains only the most-important elements of that story.The visualizations on a dashboard come from reports and each report is based on one dataset.

How to Create a Power BI Dashboard

To start creating your Power BI Dashboard, there are a few things that you need to prepare including:
1. Microsoft Account
2. Power BI Desktop
3. Reports and datasets

The Microsoft account is essential in creating your Power BI Dashboard as you will need your account to download the Power BI Desktop software. Power BI Desktop is becoming the users’ most favorite Business Intelligence tool since it offers a lot of advantages over other BI tools available.

Having the software also helps a lot when creating reports and importing datasets to create visually stunning reports. You can also enjoy the option of the simplified data visualization capabilities available on the Cloud.

That way, you can do it even when your Operating System is not from Microsoft. Make sure to also have your datasets ready and available — I mean, it’s the main content of your dashboard after all.

Creating Dashboards

In Power BI, you can create a dashboard by pinning visualizations from BI reports that are published using the Power BI desktop. All the visualizations that are created using the Power BI service are also available for pinning to create dashboards.

1. Import data to Power BI Dashboard.

2. Importing excel sheet to PowerBI


3. Create Data Visualization in Power BI Dashboard.

Power BI provides several charts for comparative data charts, these are:
Bar, Column, Pie, Doughnut Charts, Tree map Visual, Scatter Charts

Power BI provided visuals for trend data charts are:
Line , Area, Combo, Ribbon, Waterfall and Funnel Charts

You can choose the visualization type by simply clicking on any Bar, Pie, or Donut chart or any other Data Visualization methods and types under the Visualizations tab on the right side of the panel.
Here, I have created a stacked bar chart of Sales by Product name.

Stacked bar chart of Sales and Profit by Product Name.


Thank you:)

Comments

Post a Comment

Popular posts from this blog

18IT100_Practical_Exam_Work

Image
Task-1: Dataset Description using Orange tool. What is need to be done to improve the accuracy of the classification result of the given dataset? Get the maximum classification accuracy possible by performing the following methods. -->Pre-processing o Encoding o Normalization o Missing value handling o Feature Selection Compare your accuracy with and without applying pre-processing steps. Perform the Classification and visualize accuracy before and after preprocessing in Orange/Python. What is Data Pre-processing? In any Machine Learning process, Data Preprocessing is that step in which the data gets transformed, or Encoded, to bring it to such a state that now the machine can easily parse it. In other words, the features of the data can now be easily interpreted by the algorithm. Encoding Encoding is the process of converting data from one form to another. While "encoding" can be used as a verb, it is often used as a noun, and refers to a specific type of encoded data Nor...
Read more

Practical:10 Getting started with Neo4j and Gephi Tool

Image
This blog contains two different tools , Neo4j and Gephi tool for data visualization in graphical form . Neo4j Neo4j delivers the lightning-fast read and write performance you need, while still protecting your data integrity. It is the only enterprise-strength graph database that combines native graph storage, scalable architecture optimized for speed, and ACID compliance to ensure the predictability of relationship-based queries. In simple words, Neo4j is the MySQL of the graph databases. It provides a graph database management system, a language to query the database, a.k.a CYPHER, and a visual interface with the neo4j browser. Advantages of Neo4j Following are the advantages of Neo4j. Flexible data model − Neo4j provides a flexible simple and yet powerful data model, which can be easily changed according to the applications and industries. Real-time insights − Neo4j provides results based on real-time data. High availability − Neo4j is highly available for large enterprise real-time...
Read more

Practical:11 PREDICTING GENDER AND AGE USING IMAGE DATA IN PYTHON

Image
What is OpenCV? OpenCV is short for Open Source Computer Vision. Intuitively by the name, it is an open-source Computer Vision and Machine Learning library. This library is capable of processing real-time image and video while also boasting analytical capabilities. It supports the Deep Learning frameworks TensorFlow, Caffe, and PyTorch. What is a CNN? A Convolutional Neural Network is a deep neural network (DNN) widely used for the purposes of image recognition and processing and NLP. Also known as a ConvNet, a CNN has input and output layers, and multiple hidden layers, many of which are convolutional. In a way, CNNs are regularized multilayer perceptrons. Age and gender, two of the key facial attributes, play a very foundational role in social interactions, making age and gender estimation from a single face image an important task in intelligent applications, such as access control, human-computer interaction, law enforcement, marketing intelligence and visual surveillance, etc. Her...
Read more