PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
POWER BI is a data analysis tool [ Software] which can help us to analyze the data in the lightening speed.
CLICK HERE TO LEARN THE BASICS OF POWER BI
In our previous introductory post, we learnt the basics of the POWER BI environment. We also learnt that we can bring the data into the POWER BI from a large number of resources and analyze the data. Technically bringing the data into the POWER BI becomes the first step towards the analysis.
So, in this article, we will talk about the various ways and options of fetching the data into the POWER BI environment for the analysis.
We can utilize the data in POWER BI using the two main processes
POWER BI is very compatible in receiving the data from over 100 types of sources.
BROADLY, POWER BI can accept data from the databases like oracle, sql server, access etc. , from csv, text file, tabular data from the websites, cloud services etc.
Before we go further, let us try something practical so that it doesn’t become boring.
Let us create one visual using the MICROSOFT EXCEL.
We’ll do this using a standard procedure of importing the data into power bi.
It is also the solution of getting the data from the EXCEL to the POWER BI.
The first step is to create a connection to the data source.
For the example, we will take the data source as an EXCEL FILE, which is easily available for all the readers.
ALWAYS CREATE A TABLE IN EXCEL IF WE INTEND TO USE THE DATA IN POWER BI.
Let us create an excel file containing the following table. [The table can be copied easily]
SALES DATA | |||||
WEEK | ASIA | AMERICA | EUROPE | AUSTRALIA | AFRICA |
WEEK 1 | 23 | 32 | 24 | 56 | 67 |
WEEK 2 | 32 | 34 | 34 | 54 | 56 |
WEEK 3 | 79 | 97 | 55 | 81 | 77 |
WEEK 4 | 94 | 84 | 84 | 54 | 82 |
WEEK 5 | 81 | 80 | 94 | 73 | 52 |
WEEK 6 | 54 | 89 | 97 | 98 | 83 |
WEEK 7 | 77 | 98 | 90 | 55 | 78 |
Just by clicking on the EXCEL OPTION, FILE OPENING DIALOG BOX, will open directly.
FOR THE SERVICES OPTIONS, THE SERVICES WOULD ASK FOR AUTHENTICATION WITH YOUR USERNAME AND PASSWORD. ONCE DONE, IT’LL CREATE THE CONNECTION WITH THAT SERVICE AND FETCH THE DATA AVAILABLE.
ONCE THE DATA COMES TO THE NAVIGATOR, THE CONNECTION IS FORMED.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE