Explore Data In PowerBI

Quick insights in Power BI

The Power BI service can automatically look for insights in a dashboard, report, or dataset.

From the Datasets section, select the ellipsis beside the dataset that we are interested in and then select Get quick insights. 

When we select Get quick insights, Power BI searches the data for patterns. After about 15 seconds, the notification changes to let you know that Power BI found some insights.

When we select the View insights button on the notification, we are presented with a page of visuals. We can scroll down through the page to view and consider the visuals.

Create and configure a dashboard

Dashboards in Power BI are one-page collections of visualizations that are created from within the Power BI service. You can create dashboards by pinning visuals from different reports.

Pinning a visual to a dashboard is a lot like pinning a picture on a wall, where the visual is pinned to a particular spot for others to see. To pin a visual, open its report on the Power BI service. Hover over the visual that we want to pin and select the pin icon.

We can select a destination dashboard for the visual from the drop-down menu or create a new dashboard. We can pin visualizations from multiple reports and pages to a single dashboard, allowing us to combine different datasets and sources into a single page of insights.

Ask questions of your data with natural language

Sometimes, the fastest way to get answers about our data is by asking questions in the Q&A feature of Power BI.
We can use Q&A to explore your data by using the intuitive, natural language capabilities of Power BI and receive answers in the form of charts and graphs.


Share dashboards with your organization


Power BI reports help you find data, collect it in a data model, and build reports and visualizations. These features are even more powerful when you share your insights with others in your organization.
To share a dashboard, open it in the Power BI service and select the Share link in the top left-hand corner.
From the Share dashboard page, select the Share tab. In the Email address field, enter the names of people whom you'd like to grant access to your dashboard.

Display visuals and tiles in full screen


When we are looking at dashboards or reports in the Power BI service, it can be helpful to expand and focus on an individual chart or visual. Hover over a dashboard tile and select the ellipsis to see possible actions for the tile. Select Open in focus mode to expand the tile to encompass the full dashboard space. Focus mode allows you to see more detail in your visuals and legends. 

Conclusion 

In this blog, I have explained how to get quick insights from data, How to ask questions in natural language to the data, How to display visuals and tiles in full screen and How to share dashboard with organization.

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