Posts

Showing posts from March, 2022

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...

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 ...

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...

Introduction of Power BI

Image
               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; Power BI Desktop Power BI Service 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...