Identifying outliers An outlier is a data point in your dataset that is out of place or doesn’t fit well with other data. For example, we might collect data about our daily revenue and see that each day we consistently have $1,000 in total sales. If we then have a day where our daily revenue […]
Configuring automatic page refresh Reports are often only as valuable as the data they display. The frequency in which data is updated in the report can be critical to the value the report provides. When the most up-to-date data is required, it’s best to consider using the automatic page refresh feature of Power BI. When […]
Applying slicing and filtering The ability to focus your report to show exactly what you want to see is one of the biggest advantages of using a modern reporting platform. Filtering allows you to remove data so you can focus on the data that is needed for a particular scenario. Filtering can be applied directly […]
Designing reports for mobile devices Power BI embraces the mobile-first world that is quickly approaching, if it is not already here. Many report users will prefer interacting with reports on their mobile phones or tablets. Power BI works with all modern browsers, so this is not a problem. The problem is, especially for phones and […]
Introducing Power BI dashboards Dashboards in Power BI are where users of the business intelligence solution can go to see all the important information without having to switch between multiple reports. A dashboard is a type of content that is created and used from a Power BI workspace. Dashboards are only created with the Power […]
Exploring slicers and filters Slicers allow Power BI users to apply filters dynamically to data shown in visuals. This is helpful when you have an entire dataset that can be divided or segmented to show different characteristics of the data. For example, our sales database contains both store sales and customer addresses and the associated […]
Pinning tiles Content on a dashboard is referred to as a tile. Tiles can be visuals from a report in the workspace, web content, images, text, video, or real-time streaming data. After creating a blank dashboard, it is possible to add any of these content types from the Edit menu by clicking Add a tile, […]
Creating a dashboard To create a dashboard, first log into the Power BI service at https://www.powerbi.com. This requires a work or school account with Microsoft to use Power BI. The Power BI service is where workspaces are hosted and where Power BI apps are created, shared, and hosted as well. Once logged into the Power […]
The Analytics pane Power BI Desktop includes the ability to add lines to a visual using the Analytics pane. Lines are useful to make it easier to see things such as trends, average, min, max, and other functions used in statistical analysis. The type of lines that can be added depends on the visual used. […]
Optimizing dashboards Dashboards are a useful way to tell a story using data and visuals in Power BI but if they are not optimized to the screen they are being presented on or if the dashboard takes a long time to load, they lose their effectiveness. In this section, we’ll see how we can optimize […]