Course: Microsoft Power BI: Advanced Data Analysis and Visualisation

Format and Configure Visualisations Power BI Desktop gives you a variety of options for customising how your selected visualisations look, such as the colours and format of the text that …

Data Visualisation Power BI Desktop offers a range of out-of-the-box visualisation options that are available directly from the Visualisations pane. It is important that you choose an effective visualisation to …

Introduction Power BI visuals are attractive charts and graphics that you can use to revitalise your data. Visuals allow you to share data insights more effectively and increase comprehension, retention, …

You can take any report or dataset in Power BI and using the Analyze in Excel function, send that data to Excel to apply any of the tools in Excel …

You’ve explored how you can use data in Excel workbooks to drive the reports and dashboards that you build in Power BI, but you can also pin content from your …

When you connect an Excel workbook stored in OneDrive for Business, Power BI will retain the connection so that any changes to the workbook get automatically picked up by Power …

Power Pivot is used to pull in data from different data sources or to manage multiple tables in an Excel workbook, and Power BI will understand that and translate that …

The simplest way of using Excel with the Power BI service is to upload a standard Excel spreadsheet into Power BI and start using the data to create reports straight …

Work With Time Intelligence All data analysts will have to deal with time. Dates are important, so we highly recommend that you create or import a dates table. This approach …

Create Semi-Additive Measures In situations where you don’t want the standard evaluation behaviour in Power BI, you can use the CALCULATE and/or USERELATIONSHIP functions. However, more circumstances exist where you …

Use Relationships Effectively Another DAX function that allows you to override the default behaviour is USERELATIONSHIP. The screenshot shows an established relationship between the Date and OrderDate columns, as shown …

Use the Calculate Function The CALCULATE function is your method of creating a DAX measure that will override certain portions of the context that are being used to express the …