Basics of Power BI
Power BI is a data visualisation tool which is developed by Microsoft. It is combination of strong data visualisation, data sharing.
With this tool end users can create dashboards and reports with out knowing where the data is stored and not involving database people to access the data if the data is stored on database.
Power BI gateways can be used to connect Microsoft excel, access, SQL server databases
Data sources: To analyse and visualise the data we need first where the data is present and we have to load the data into the Power BI. For loading of data from various data sources we have a module called Data Sources.
Power BI Desktop: Software that is allowed to connect with data sources. We can clean the data and visualise the data in our local computer.
Power BI service: Power BI Service is an On-Cloud service with a web-based platform and used to share and publish the reports made on Power BI Desktop.
Power BI Gateways: These gateways are used to fetch the latest information of organisation and push it to Power BI services where we can visualise the data.
Benefits of Power BI:
- pre built dashboards and other visualisation stuff like bar chat, pie diagram
- Less coding is required to get good knowledge of Power BI
- Can work with fresh data with the help of PowerBI gateways and give insights of the data
- Secure connection to all the data sources.
- Immediate deployment
How the Power BI works:
Data integration: In large companies data is present in various data formats and also stored in different data sources. Now the data is extracted from the data sources and then it is integrated in standard format and stored in the area called Staging.
Data cleaning: Once the data is in staging, we need to clean the data like removing NAN values, removing duplicate rows. Once the cleaning of data is done, we move the cleaned data into data warehouse . Now the ETL pipeline is completed.
Visualisation: Once we have cleaned data we sent to the visualisation, and then we plot different graphs and analyse the data
The business user see the visual data and take important decision so that they could increase the profits of their business.
Reference: https://mindmajix.com/power-bi-architecture