We discussed about preparing datasets using files from different environment (Local drive & OneDrive) in my previous articles. Go through here.
We have another option under files section which is “SharePoint – Team Sites”.
It is very easy to get a file (dataset) from SharePoint as we are using business email to connect Power BI so no need to provide the credentials again.
Select the file from SharePoint and connect to Power BI. File will be added in to Datasets.
In my last article, we discussed about how to prepare a dataset from local file.
This article speaks about how we can create a dataset which is stored in OneDrive. It can be personal or business OneDrive.
There is no changes up to 4th step from my previous article, after that follow the below steps
As we discussed the levels in Power BI, the first level is creating dataset.
To start prepare the dataset, first sign in to the power BI here,
This article will talk about, how to create a dataset from local file.
Steps to import the local file,
Check my previous post about introduction to Power BI before going through this article.
Creating a report and dashboards are very easy in Power BI by simply pointing to the correct data source.
Levels in Power BI,
1. Create a dataset
2. Create a report on top of above dataset
3. Create a dashboard – Just pin a charts to display in dashboard from report.
Power BI is an application which we can use in online as well as in desktop. The steps provided in my previous article (Link) is for online version of Power BI.
To download the desktop version, click here. It has more options compare than online version.
Power BI has gateways which helps to keep the data fresh by connecting the on-premises data sources. It provides the flexibility to individuals as well as organization.
Power BI is one of the best visualization tool and it can be used by anyone. Initially this tool was available for office 365 SharePoint site. It was something like an add-on but now they have upgraded and it is available externally.
Power BI team from Microsoft has put their ideas and innovations to make this tool available to everyone and it is not required much technical knowledge to use.
There are lots of improvement has been taking place from day one of power BI by Microsoft power BI team.
Steps to Use Power BI
There are many visualization tools available from different companies.
Microsoft always concentrates more on visualization tools because visual tools are going to play a major role in the future.
What is the use of visualization tools?
visualization tools to visualize and analyze the data in an easy way. In this digitized environment, we are producing data from different kinds of machines and gadgets which are not easy to process and understand. To understand those data, we need to process first and once we get proper format, then using visualization tools, we can able to understand.
Microsoft innovations are always awesome since those are very easy to learn and use. The most famous tool from Microsoft is office tools, in that Microsoft excel is the best which can be used from very basic users to advanced users.
In excel, Microsoft added a few more options in terms of visualization. Those options are,
Data is the most valuable asset in almost all the places.
Understanding the data is not easy for a layman. Visualization tools are playing a vital role to make the layman to understand about the data. Most of business decisions based on best data visualization.
This article speaks about simple visuals based on data about cancer statistics.
Just collected a few facts about the estimated number of new cancer cases in US 2015.
Visualization tools always helping us to see the facts very clearly. I just converted the data to graphs by using simple and effective Microsoft Excel.
Estimated New Cases for Both Male and Female:
Estimated New cases for Male Vs Female:
This is just to help you understand the facts about cancer diseases.
The following table presents an overview of the components of a business intelligence system, and the corresponding Microsoft SQL Server 2000 and SQL Server 2005 components.
|Component||SQL Server 2000||SQL Server 2005|
|Extract, transformation, and load||Data Transformation Services (DTS)||SQL Server 2005 Integration Services|
|Relational data warehouse||SQL Server 2000 relational database||SQL Server 2005 relational database|
|Multidimensional database||SQL Server 2000 Analysis Services||SQL Server 2005 Analysis Services|
|Data mining||SQL Server 2000 Analysis Services||SQL Server 2005 Analysis Services|
|Managed reporting||SQL Server 2000 Reporting Services||SQL Server 2005 Reporting Services|
|Ad hoc reporting||SQL Server 2005 Reporting Services|
|Ad hoc query and analysis||Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal)||Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal)|
|Database development tools||SQL Server 2000 Enterprise Manager, Analysis Manager, Query Analyzer, various other||SQL Server 2005 Business Intelligence Development Studio (New!)|
|Database management tools||Enterprise Manager, Analysis Manager||SQL Server 2005 SQL Server Management Studio (New!)|
I will get back to you in my next post. All the best for your definition PLUS hunt.