Data Science👨‍💻: Introduction to Power BI & Import Data in Power BI

Welcome to the Data Science Blog Series. Do check out my previous blog from the data science blog series here.

Small Steps in the right direction are better than,

Big steps in the wrong direction

~ Sayan Bishwas

Power BI:

Microsoft Power BI is a collection of apps, software services, and connectors that come together to turn unrelated data into visually impressive and interactive insights. Power BI can work with simple data sources like Microsoft Excel and complicated ones like cloud-based or on-premises hybrid Data warehouses. Power BI has the capabilities to easily connect to your data sources, visualize and share and publish your findings with anyone and everyone.

As Power BI is a Microsoft product and has built-in connections to Excel, there are many functions that will be familiar to an Excel user.

Parts of The Power BI:

Power BI constitutes a Microsoft Windows desktop application called Power BI Desktop, an online SaaS (Software as a Service) called Power BI Service, and a mobile Power BI apps that can be accessed from Windows phones and tablets, and also available on Apple iOS and Google Android devices.

These three elements — Desktop, the Service, and Mobile apps — are the backbone of the Power BI system and let users create, share and consume the actionable insights in the most effective way.

Credits & Read More :- https://monashdatafluency.github.io/Power_BI/introduction-to-power-bi.html

Here I used Power BI Service for Explaining…

Get Started with Power BI:

Main Workspace Power BI Service

This is how it looks whenever you first time opens the Power BI. In the workspace, we create all our Dashboard, reports, and Analysis.

Import Data into Power BI

By Clicking on the new Option we get many options for importing data, creating the report, dashboards, Streaming Dataset, etc.

For Importing data from a local machine we have to select the Upload a File option.

Options for upload a file

As you can see we can upload a file from different sources like a local machine, one drive, SharePoint, etc. I chose Local File option for uploading CSV file from my device.

Data upload Successfully in Power BI

As you can see Power BI Automatically Detected Our CSV File as Dataset.

Now by Clicking on covid-report-statewise.csv we forwarded it to the workspace.

Simple Pie Chart from Dataset

As you can see on the right side( fields section ) we have our CSV file with all column details.

As you can power BI automatically detect Numemerical (∑ Sign) Column.

Now By Selecting States and Total Recovered Cases from Fields and Selecting Pie Chart from the Visualizations section I got the above result. You Can also play with different visualizations.

Tabular View of Dataset

In the Visualization Select Table and By Selecting All the Columns in Field We can visualize our dataset into Tabular Format.

Now to view this table clearly we have to do the following steps:

Click for option Select ‘Show as a Table’

Table View of Dataset

That is how we can import and visualize our dataset in tabular form. I hope you will understand this. Give it a try by yourself.

Explore Power BI more HERE…

Conclusion:

I hope you will get an idea about Power BI.

There is a lot more remain to explore check out here.

LinkedIn:

Manthan Bhikadiya - CHAROTAR UNIVERSITY OF SCIENCE AND TECHNOLOGY - Surat, Gujarat, India |…

Github:

manthan89-py - Overview

Thanks for reading! If you enjoyed this article, please hit the clap 👏button as many times as you can. It would mean a lot and encourage me to keep sharing my knowledge. If you like my content follow me on medium I will try to post as many blogs as I can.