What is Business Intelligence?

First of all, to briefly touch on what business intelligence means; Business intelligence is a definition that encompasses all of the different software used to analyze an organization's data. Business intelligence software provides ease of management of all business processes of the organization from a single environment.

The main reasons why organizations need business intelligence are;

• Facilitate reporting and data analysis processes
• Ensuring data integration between different systems
• Increase efficiency
• Ability to make strategic decisions

Microsoft Power BI (Business Intelligence) What is it?

Power BI is a business intelligence platform offered as a cloud service by Microsoft. It allows us to design effective reports or panels by visualizing data from many independent data sources. In addition, thanks to its effective designs, it can draw attention to the points we consider important, allowing us to easily share them with everyone.

What to do in short;

• It can be connected to data from multiple data sources,
• You can shape data with queries,
• You can visualize all this data in reports,
• You can share these visualized reports with anyone.

What Are Power BI Components?

Power BI components consist of:

• Power BI Desktop (Windows desktop app)
• Power BI service (online SaaS service)
• Power BI mobile apps for Windows, iOS and Android devices.

 

 

 

 

 

 

 

What is the Licensing Model?

There are 3 types of licensing models;

• Microsoft Power BI Free / Desktop
• Microsoft Power BI Pro
• Microsoft Power BI Premium

 

Microsoft Power BI Free / Desktop : It is the version we install on our local system to access Power BI core features and accompany the cloud-based application. It's the ideal version to get started and lets you connect to over 70 data sources, analyze data, publish to the web, and export to Excel. Ideal for small businesses and professionals where large-scale integrations are not always necessary. You don't need an Office 365 subscription for this. You can start using it by downloading it from this link. https://powerbi.microsoft.com/en-us/downloads/

 

Microsoft Power BI Pro : Power BI; It is the full version that offers both creating dashboards and reports, and unlimited viewing, sharing, or use of reports shared by others. It can also be used with Power BI Desktop. The biggest difference from the free version; you have the option and ability to share data, reports, dashboards with many other users who also have Power BI Pro license. The Pro plan costs around $9.99 per user. Users are given the opportunity to try this subscription free of charge for 60 days before purchasing it. These costs and the number of trial days are valid as of the date of this article and may vary.

 

Microsoft Power BI Premium : If the number of users who will access the reports we will create on Power BI is very high, for example, more than 500, or situations where on-prem should be used instead of cloud service (such as being subject to regulations about going to the cloud) are mentioned. subject, Premium license can be preferred.

Pro ve Premium özellikleri arasındaki tüm farkları https://powerbi.microsoft.com/tr-tr/pricing/

You can see it via the link.

You can get the Power BI Cloud service as a service, or you can use Power BI Desktop, which works integrated with cloud services. There is also the Power BI Mobile application to view all reports and dashboards.

I would like to add this as a note. We can see that Power BI is the leader among Analytics and Business Intelligence platforms at Gartner this year as well.

 

 

 

 

 

 

 

 

 

 

 

 

 

How Power BI Desktop Works

Let's take a brief look at the software with Power BI Desktop. First of all, you can download the software from this link. https://powerbi.microsoft.com/en-us/desktop/

When we run the software after installation, the following screen will greet us.

 

 

 

 

 

 

 

 

On this screen, we can get data from a different source, open the sources we used before, or open the Power BI format pbit or pbix format files that we saved before by saying "Open other reports". Let's continue by saying Get Data.

 

 

 

 

 

 

 

 

 

 

 

 

 

When we come to the get data part, we are greeted by an area where we can get data from many sources. If we want here, an Excel document from the File section; We can connect a SQL server database by selecting a database, or we can pull data from a Platform or Azure. In the Online Services area, we can pull data from many online services such as Dynamics 365. In this example, we will connect a data over the Web by selecting the other option.

 

 

 

 

 

 

 

 

 

 

 

 

Here, I will work on the statistical data shared by our ministry of health about covid19. Paste the link below and continue with the “OK” button.

https://covid19.saglik.gov.tr/TR-66935/genel-koronavirus-tablosu.html

 

 

 

 

 

 

We will log in by clicking “Connect” on the screen that comes up.

 

 

 

 

 

 

 

It asks us what we want to do on the Table, we can continue by saying "Load".

 

 

 

 

 

 

 

 

 

Now we can create reports as we want, based on the data provided to us by the Ministry of Health.

 

 

 

 

 

 

 

Conclusion:

In this article, we introduced Business Intelligence and tried to provide information about Microsoft's Power BI service. It is a fact that every small, medium and large scale, private or public institution needs business intelligence to see where it is in line with its strategic goals and to take new decisions. Power BI, on the other hand, is a powerful BI software that maintains its leadership among the same platforms for many years. If you need a Business Intelligence platform in your organization, you can quickly integrate your software with the free version or trial versions and start receiving reports in a very short time.

---