Do you have a new dataset and not quite sure where to start? Need to build a dashboard quickly? Want to review insights that you may have missed? Power BI allows you to quickly create insights and generate interesting interactive visualisations based on your data. Quick insights can be run on an entire dataset (quick insights) or on a specific dashboard tile (scoped insights). You can also run insights on an insight!
NOTE: Insights do not work with DirectQuery – it only works with data uploaded to Power BI.
Run Quick Insights On A Dataset
1.From the Datasets tab, select the ellipses (…) and choose Get Insights.
2.Power BI uses a variety of algorithms to search for trends in your dataset.
3.Within seconds, your insights are ready. Select View Insights to display visualisations.
NOTE: Some datasets can’t generate insights because the data isn’t statistically significant.
4.The visualisations display in a special Quick Insights canvas with up to 32 separate insight cards. Each card has a chart or graph and a short description.
Interact With Insight Cards
1.Hover over a card and select the pin icon and the visualisation to a dashboard.
2. However over a card, select the ellipses (…) and choose View Insights. This opens the insight fullscreen.
3.In focus mode you can:
- Filter the visualisations. To display the filters, in the top right corner, select the arrow to expand the Filters pane.
- Pin the insight card to a dashboard by selecting the pin icon or pin visual.
- Run insights on the card itself. This is often referred to as scoped insights. In the top-right corner, select the lightbulb icon or Get Insights.
The insight displays on the left and new cards, based solely on the data in that single insight, display along the right.
4.To return to the original insights canvas, in the top-left corner, select Exit Focus Mode.
Run Insights On A Dashboard Tile
Instead of searching for insights against an entire dataset, narrow your search to the data used to create a single dashboard tile. This too is often referred to as scoped insights.
1.Open a dashboard.
2.Hover over a tile, select the ellipses (…) and choose View Insights. The tile opens in Focus Mode with the insights cards displayed along the right.
3.Does one insight pique your interest? Select that insight card to dig further into your data. The selected insight appears on the left and new insight cards, based solely on the data in that single insight, display along the right.
4.Continue analysing your data and when you find an interesting insight, pin it to your dashboard by selecting Pin Visual from the top-right corner.
As Microsoft Gold Partners, we are experts in Microsoft Technologies. Power BI is a business analytics tool that turns data into insights, allowing you to create informed decisions to help your business reach its strategic goals. Turn data into rich insights using this powerful tool that allows businesses to look at the past and present in order to plan for future trends. Using Power BI you can visually explore data and collaborate on shared dashboards and interactive reports. To learn more about how Power BI can benefit your business, contact our team today!
Traditionally, Microsoft Excel has been the ‘go-to’ reporting tool for businesses around the world, however, Power BI offers businesses even more powerful analytics and reporting features. Power Bi offers businesses faster experimentations with visualisations, statistical functions and calculations across broad datasets, and the ability to derive answers through the rapid recombination of fields. There are a variety of ways that Power BI supersedes Excel, below we will explain how utilising Power BI can benefit your business.
1.Access and Store Large Amounts of Data
Power BI has impressive compression abilities for Microsoft Excel and text/.csv files, which allows you to access, analyse and visualise large quantities of data that Excel cannot open. Many computers may struggle to open a file larger than 300 megabytes, making analysis and reporting through Excel challenging. Thus adding several smaller .csv files to data, like sales data for neighbouring regions, will be incredibly difficult to combine with your previous dataset and analysis.
Large datasets don’t have to be reduced in size and aggregated to show a more encompassing analysis. All granular details and summarisations can exist in one file together and be accessed through drill downs.
Users also have the opportunity to modify and prepare data:
- Transformations and edits including changing formats, deleting rows, adding columns and transposing data.
- Adding relationships within different tables.
- Adding new datasets easily as additional useful data is uncovered.
When using Power BI, the painful repetition of data preparation is reduced or eliminated as the software will remember the data preparation steps and automatically repeat them during data refreshes.
2.Spot Trends Easily
Analyzing trends with Power BI is extremely easy. With built-in time intelligence features, it only takes seconds to view vast amounts of data. Data can be viewed by various dimensions and attributes, including date-time dimensions.
3.Intuitive UX Features
Users can easily make data on Power BI visually appealing, even if users have limited creativity or UX skills. Power BI’s drag-and-drop functionality, easy resizing, and copying and pasting makes those who are accustomed to Office 365 feel at ease when using Power BI.
Incorporate your brand into reports through utilising colour schemes with Power BI themes. Your marketing team can now create Power BI branding themes, in the form of a .json file, and Power BI users simply have to import this theme during the development of a report. From this theme, users can create graphs and charts that follow the business’ ‘theme’.
Once you have constructed your Power BI analysis, you will need to publish and disseminate your dashboards and reports. In Excel this would generally involve emailing a large file to your team or uploading it to a shared device or SharePoint portal. Through utilising Power BI, this process has been completely revolutionised. Through using Power BI you can upload or update data to Power BI and automate the refreshing of underlying data, to make this data available to your team, simply publish this data.
Power BI can revolutionise how you share information with your team. Power BI is easily configured and allows users to track metrics, understand insights and visualise data. Creating reports on Power BI allows your business to understand the past and present while also understanding potential future trends. Contact our team today to learn more about how adopting Power BI can benefit your business!