Introduction of Power BI

-

             MICROSOFT POWER BI




1) Introduction : 

    Microsoft Power BI is Business Intelligence software used for creating interactive, immersive dashboards and reports that provide actionable insights from historical data and drive business results. The Power Bi software easily connects more than 80 + data sources, visualize what's important and share that with anyone or everyone who wants. 

1.1) Parts of Power BI

The Power BI tool comprises 3 parts given below;

  1. Power BI Desktop
  2. Power BI Service
  3. Mobile App

1] Power BI Desktop:  

    The raw data of enterprises can collect through a Power BI Desktop. It is an open-source application you can install on your computer and lets you collect data from different sources (datasets) and prepare reports on your data. The desktop helps you collect the number of reports on canvas and make a dashboard. The Cleaning of data task you can do in Power Query Editor.


2] Power BI Service : 
    Power BI is a Cloud-Based Service or Software As Service(SaaS). It is also known as Power BI Online. It enables anyone to visualize and analyze the data with greater efficiency, speed, and ease of interpretation. Due Power BI Service it is easy to share dashboards, reports, and visualizations with users.

1.2) The Flow Work  of Power BI:

  • Bring the data in Power BI Desktop & prepare reports and Dashboards.
  • Publish Reports and Dashboard on Power BI Service.
  • Share Dashboard with others.
  • View and interact with shared dashboard & reports in Power BI Mobile App.

1.3) Use of Power BI:

  1. Easy to connect Data Sources.
  2. Preparing Reports, Dashboards.
  3. Providing SaaS to present reports.
  4. Easy to Interpretation and share dashboards.
  5. Findings the Insights from raw data.

2) Building Blocks of Power BI

Following are the Blocks of Power BI
  • Visualizations
  • Datasets
  • Reports
  • Dashboards
  • Tiles

Visualization: It is a visual representation of Data. Data represented in Pie Charts, Line Graphs, Treemap Etc.



Dataset: It is the collection of raw data from different sources. Ex. CSV File, Excel sheets, Cloud service data.



Reports: A report is a collection of visualizations that seem together on one or more pages.




Dashboards: A dashboard is a collection of visuals on a single page. The single page is also known as "Canvas". It's a selected group of visuals that provide quick insights into data or tell the story you are trying to present.



Tile: Tile is single visualization on a dashboard. It's a rectangular block that holds a single visual. In creating a dashboard you can move the tile to any location as per requirement.
















Comments

Post a Comment

Popular posts from this blog

Modelling Data in Power BI

-
Image
 Introduction of Data Modelling The Power BI Data Modelling is a feature used to connect multiple data sources in the BI tool using a relationship. In data modeling, the data sources are connected to each other and you can create interesting data visualization on multiple data resources. If none of the tables selected for the relationship has a unique value you will see the error and fix this error by adding an intermediary table made of the distinct key values to the model. In the above image, you can see the relation between the two tables. The tables are joined by a column named "ID". Similarly, in Power BI, you set the relationship between two objects. To set the relationship, you have to drag a line between the common columns. You can also view the “Relationship” in a data model in Power BI. To create a data model in Power BI, you need to add all data sources in Power BI's new report option. To add a data source, go to the Get data option. When you add multiple data ...
Read more

Power BI Desktop

-
Image
  Power BI Desktop is an open-source application for  Computers that  Gather, Transform, and Visualizes  your data. The Power BI Desktop creates reports and dashboards and publishes them in the Power BI Service. With Power BI Desktop, you can connect multiple sources of data and combine them ( Data Modelling) . Most of the users use the Power BI desktop to solve Business Intelligence problems to create reports, visual and share it on Power BI Service. Power BI Desktop Uses: Connect to different data sources. Transform and Clean data (Data Modelling) Create visuals (such as charts, graphs) Create reports (collection of visuals) Share reports on Power BI Service In Power BI Desktop windows there are 3 types of views: Report: In this view, we spent more time creating reports and visuals. Data: In this view, you see the tables, measures, and other data used in the data model. Model:  In the model view, we make the relationships among the tables. Power BI Desktop W...
Read more

Visuals in Power BI

-
Image
  Visualization is a building block of Power BI  and is used to present your data visually. It is the process of taking raw data and transforming it into graphical visualization. In Power BI a wide variety of features such as Bar Chart, Column Chart, Pie Chart, Waterfalls, Funnels & Map, etc. Data visualization is a quick and easy way to convey concepts to the end-user. There are more than 30+ features of visualization in Power BI. Let's see one by one; 1] Bar Chart & Column Chart: This is one of the most familiar &  standard types of charts used to display specific values across different categories. A bar & column chart is used to represent categorical data in rectangular bars by the length of the rectangle denoted by a specific measure value. Bar Chart Stacked Bar Chart & Clustered Bar Chart A stacked bar chart is a visual representation of parts of a whole & is often used to compare. In a stacked bar chart each bar represents a whole and segmen...
Read more