Building blocks of Power BI


1.        Visualizations

2.        Datasets

3.        Reports

4.       Dashboards

5.       Tiles

a. Visualization

A graphical representation of data is nothing but visualization. For example, a diagram, chart, shading coded outline, other intriguing things we can make to speak to our information outwardly. Power BI has a wide range of various perception writes, and additionally coming constantly. The accompanying picture demonstrates  various visualization that provided by Power BI .


b. Datasets

A dataset is an accumulation of information that Power BI uses to make its representations. We can have a basic dataset in light of a solitary table from Excel exercise manual, like what’s appeared in the accompanying picture.



c. Reports

In Power BI, a report is a gathering of perceptions that seem together on at least one pages. Much the same as some other report you may make for a business introduction, or a report you would compose for a school task, in Power BI a report is an accumulation of things that identify with each other. The accompanying picture demonstrates a report in Power BI Desktop – for this situation, it’s the fifth page in a six-page report. You can likewise make reports in the Power BI benefit.
Reports let you make numerous perceptions, on various diverse pages if fundamental and gives you a chance to organize them in the way best recount your story.






d. Dashboards

When we prepare to share a solitary page from a report or offer an accumulation of perceptions, we make a dashboard. Much like the dashboard in an auto. A Power BI Dashboard is a gathering of visuals from a solitary page that we can impart to others. Frequently, it’s a chosen gathering of visuals that give snappy understanding into the information or story we are attempting to exhibit.
A dashboard needs to fit on a solitary page, frequently called a canvas. Consider it like the canvas that a craftsman or painter utilizes. A workspace where we make, consolidate, and adjust fascinating and convincing visuals. We can impart dashboards to different clients or gatherings, who would then able to communicate with our dashboard when they are in Power BI benefit, or on their cell phone.




e. Tiles

In Power BI, a tile is a solitary representation found in a report or on a dashboard. It’s the rectangular box that contains every individual visual. In the below picture, you see one tile (featured by a splendid box) which additionally encompass by different tile



Conclusion :

In this article, I have explored Building Blocks of Power BI

Comments

Post a Comment

Popular posts from this blog

Use DAX iterator functions in Power BI Desktop models

Data Analysis Expressions (DAX) include a set of functions known as  iterator functions . Iterator functions enumerate all rows of a given table and evaluate a given expression for each row. They provide you with flexibility and control over how your model calculations will summarize data. Some DAX Functions are Complex summarization 1. SUMX e.g. : 1.  Revenue = SUMX (Sales, Sales[Sales Amount]) 2. Revenue = SUMX (Sales, Sales[Order Quantity] * Sales[Unit Price] * ( 1 - Sales[Unit Price Discount Pct.])) 3. Discount = SUMX ( Sales, Sales[Order Quantity] *( RELATED ('Product'[List Price]) - Sales[Unit Price] ) ) 2. AVERAGEX e.g :1. Revenue Avg = AVERAGEX ( Sales, Sales[Order Quantity] * Sales[Unit Price] * ( 1 - Sales[Unit Price Discount Pct.]) ) 2. Revenue Avg Order = AVERAGEX ( VALUES ('Sales Order'[Sales Order]), [Revenue] ) 3. RANKX The  RANKX  DAX function is a special iterator function you can use to calculate ranks. Its syntax is as follows: RANKX (<...
Read more

Different charts in Power BI

Image
  An overview of Chart Types in Power BI As everyone might be aware, Power BI is one of the SaaS offerings from Microsoft in the field of BI and Analytics. It provides a very intuitive way for non-technical users to do analyses and create reports on their own without having to rely on a technical team. One of the main purposes of Microsoft behind Power BI is to promote self-service BI and it is one of the BI tools in the market with a comparatively lower learning curve as there are many similarities compared to Microsoft Excel.  In this blog, I am going to give an overview of the most widely used chart types in Power BI.   Let's look at some of the most frequently used chart types in Power BI Bar and column charts Stacked Bar and Stacked Column Chart Clustered Bar and Clustered Column Chart Line Chart Area Chart Stacked Area Chart Line and Stacked Column Chart/ Combo Chart Line and Clustered Column Chart/ Combo Chart Ribbon Chart Waterfall Chart Funnel Chart Scatter Chart...
Read more

Modify DAX filter context in Power BI Desktop models

Summary CALCULATE  DAX function to modify filter context in the formulas. The syntax for the CALCULATE function is as follows: CALCULATE (<expression>, [[<filter1>], <filter2>]…) I learned about filter context. And also learned why and how to work with the CALCULATE function to modify filter context by passing in filters. These filters can add or overwrite the filter context, and they can modify filter context when we are passing in special functions like REMOVEFILTERS or KEEPFILTERS. Additionally, I learned that the CALCULATE function can transition row context to filter context, which can be required when we are using measure expressions in calculated columns or iterator functions.
Read more