iTrain Scotland IT Training Edinburgh image
 

Microsoft Power BI

iTrain Scotland IT Training Edinburgh image

Home > Courses > Microsoft courses > Microsoft Power BI

Microsoft Power BI

Power BI is a suite of business analytics tools that deliver insights throughout your organisation. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organisation to consume on the web and across mobile devices. Everyone can create personalised dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in.

This course is designed for new or existing basic users of Power BI.  An introductory knowledge of Microsoft Excel is also required.

 

Delegates will learn what Power BI is and when it is useful to use this tool, how to import and link to data sources, manipulate the data, create dashboard visualisations and export the results.  Delegates will also learn shortcuts and tips about how to use Power BI in the most efficient way.

 

Introduction to Power BI Desktop

  • What is Power BI Desktop
  • Power BI Desktop Environment

Importing and Connecting to data sources

  • Difference between Importing and Connecting
  • Databases
  • Excel
  • Text file
  • Entering Data
  • Relationships

Querying and Shaping Data

  • Filtering
  • Sorting
  • Understanding applied steps
  • Manipulating columns
  • Data Types
  • Parameters
  • Custom columns
  • Introduction to DAX Functions

Visualisations

  • Charts
  • Tables
  • Maps
  • Matrices
  • Slicers

Report Elements and Output options

  • Formatting the report
  • Adding graphics, shapes and text boxes
  • Report Filters
  • Export as csv
Prices below are for scheduled courses held in our Edinburgh Training Centre. Major discounts available for onsite or private courses: click General Enquiry button below to enquire about private courses.
Group discount
1 place £ 350 n/a
2 places £ 700 n/a
3 places £ 1050 £ 975
4 places £ 1400 £ 1125
5 places £ 1750 £ 1275
6 places £ 2100 £ 1425
7 places £ 2450 £ 1575
8 places £ 2800 £ 1725