Introduction To Power BI Desktop


Training in this course covers the essential skills in Power BI: Extracting; Transforming and Loading Data into the Data Model and then Visualising it with a rich sets of Graphics; Charts and Dashboards. These can then be shared with colleagues or others with the Power BI service, and in many other ways.

Course code





1 day – Virtual delivery via MS Teams




Location: Online
Delivery Via MS Teams – 28 Jun 2024 09:00

Entry Requirements

Attendees should previously have knowledge of Excel with some familiarity with Excel Pivot Tables and Excel Functions like SUMIFS and VLOOKUP. People with Database, Programming, or other BI experience will be qualified for the course even if they don’t have direct Excel experience

Course Content

What is Microsoft Power BI

· Understanding the Power BI environment

· Installing Power BI Desktop

Understanding Data Sources in Power BI Desktop

· Importing a variety of data sources into Power BI Desktop

· Connecting to Excel Workbooks, Access Databases, CSV Files and other data locations.

Exploring Power BI Desktop

· Working with the Fields and Visualisation Panes

· Using Report View to create visualisations

· Using Data View to sort and Format data

Creating a Data Model in Power BI desktop

· Understanding the Data Model

· Using Relationship View

· Creating Many-to-One relationships

· Refreshing Data

Visualisations Workshop using Power BI Desktop

· Adding visualisation to the Report Canvas

· Understanding and controlling interactions between visualisations

· Using Drill Down and Drill Through on visualisations

· Creating and using Hierarchies

Introduction to DAX in Power BI Desktop

· Exploring the importance of custom calculation within the Data Model

· Creating Calculated Columns & Measures

· Understanding Evaluation Context

· Using CountRows and DistinctCount Functions

Using Queries in Power BI Desktop

· Understanding the role of Queries in data import

· Understanding Extract, Transform & Load (ETL)

· Data transformations

· Applied Steps

· Creating and using Query Parameters

Publishing to Power BI Service

· Publish your Report to

· Creating Dashboards

Using Power Pivot Data Model in Power BI Service

· Creating visualisations in Power BI Service using Power Pivot data

Sharing your Dashboards & Content Packs

· How to share your interactive Power BI Dashboards with people both inside and outside your organisation.

· Sharing using Power BI, Web, PowerPoint and other

Additional funding information

No One Left Behind Training Allowance
Dumfries and Galloway Local Employability partnership (Funded by the Scottish Government) are proud to be working in partnership with DG College to offer eligible individuals funding to learn new, work-related skills and training.

You can use the money to build the skills you need for a job or get some training to take your career to the next level.

And because it’s not a loan, you don’t have to pay it back.

Check if you are eligible then follow the registration process.

Are you eligible?

You must meet all of the following criteria

  • 16 years of age or older
  • Resident in Dumfries and Galloway
  • Have the right to work and live in the UK.
  • Unemployed and looking to get back into work OR in employment and claiming an income-based benefit (i.e Universal Credit)

AND at least one of the following characteristics: (hyperlink to the definitions)

  • Parents with a child under the age of 19 (still registered in full time education)
  • Armed Forces Veteran
  • Asylum Seeker
  • Care Experienced
  • Caring responsibilities
  • Childcare needs
  • Criminal Convictions
  • Homeless or affected by housing inclusion.
  • Long Term health condition/ illness
  • No Limited work experience.
  • Refugee
  • Substance related conditions
  • Lack of Transport

If you meet the criteria, you could receive the full cost of your course fee.

Apply for your No One Left Behind Grant

To access support with the fees you must register with DG Works. Just follow the link or use the QR code. If you are already registered, please contact your Employment Key Worker for next steps.

Once you have completed the registration form and your eligibility has been checked someone from DG Works (part of Dumfries and Galloway Council) will contact you to ask you to provide the following evidence:

  • Reside in Scotland (e.g. evidence address)
  • Working Age (e.g. birth certificate)
  • Right to Live & Work in the UK (e.g. evidence of benefits)

If you have any questions please contact 01387 260035 or email

Course Contact Details

If you would like more information or to reserve a place on a course, please get in touch.

Telephone: 01387 734199

Booking Terms & Conditions | Dumfries & Galloway College (

Other Courses at DGC

Cyber Security NPA @ SCQF Level 5

Dumfries and Galloway College Birds Eye View with criffel in the background

If you want to have the opportunity to develop skills and knowledge for further study for entry into a career into the vast world of Cyber, then this is the course for you! The course provides you with the foundation knowledge and skills in Cyber Security. You will develop skills relevant to the use of Data Security, Digital Forensics and...

Digital Leadership & Management

Dumfries and Galloway College Birds Eye View with criffel in the background

Digital tools are progressing at an unprecedented rate both in our personal and business lives, and it is easy to find ourselves behind the times and using dated methods that no longer achieve the best results. This is particularly true for managers and leaders, who need to adopt new processes and procedures from a technical aspect, but a...

Cyber Security HND @ SCQF Level 8

Computing and IT - cyber security

This course is for students who have completed HNC Cyber Security and who want to progress to a degree in a Computing discipline or into employment in computing-related disciplines. This course is equivalent to the second year of degree study, and we offer this course as a standalone HND or as part of a three-year programme which will al...