Power BI Desktop, Excel and Query Editor

Course Outline

This one-day course is an introduction to the Microsoft power tools found within Excel and Power BI and is for those who need to analyse, process and connect to with data in order to produce reports, interactive dashboards and visualisations at all levels within an organisation. It is assumed that attendees on the course are already working with data, are familiar with charts and PivotTable concepts.

Course Content

Excel : Get and Transform Data (PowerQuery)

  • Create Pivot Tables from related tables using a data model within Excel
  • Connect to a variety of data sources from Excel using queries to extract, transform and load data (Power Query)
  • Merge and Append multiple data sets
  • Manage relationships between data sources
  • Transform data using Calculated columns

Power BI Desktop

  • Connect to a variety of data sources using Query Editor
  • Create Visualisations (Charts, Tables, Gauges, Maps)
  • Introduction to basic DAX language to create calculated columns and measures
  • Create Charts with Interactivity
  • Filter data with various tools
  • Drill down and use Hierarchies
  • Apply advanced formatting and visualisations with conditional formatting, matrices, cards, gauges and KPIs

Full Course Content

Please visit the link https://docs.microsoft.com/en-us/power-bi/desktop-what-is-desktop for a greater understanding

Show the next months in

Location Dates Time Price exc. VAT   Status
Contact Nina or Graham on 01243 216278 or email courses@growtrain.co.uk to book this course
Share This