Further Microsoft Power BI (two-day)
This course is designed to help you advance your Power BI skills. We expand on the basics, showing you new transformation techniques to shape your data and explore ways to generate fully automated reporting systems.
Course Summary
Course Information for Students
Who is this course for?
Bring together other software like SharePoint, Excel and Power Automate into your Power BI environment and start to understand how you already have all the tools at your fingertips. You just need to harness them.
Entry Requirements
N/A
What will you learn?
Transforming Data
- Import data from different sources into Power Query
- Connect SharePoint sites to data models
- Practise advanced data transformation techniques via Power Query
- Learn how to merge and append queries
- Pivot and unpivot data
- Group data
- Add calculated columns in Power Query
Data Models and Relationships
- Create a data model
- Understand the star schema
- Build different types of cardinalities between data sets
- Explore the importance of relationships to reports and visualisations
Shaping Data
- Work with more complex DAX in Power BI
- Understand the difference between calculated columns and measures
- Create calculated columns and measures to data models
Creating Reports
- Explore different types of visualisation
- Build meaningful reports from data sets
- Format the appearance of reports
Power BI Navigation and Security
- Understand the behaviour of slicers within reports and dashboards
- Explore Multi-level Security
- Apply and share roles to reports and dashboards
Working with the Online Service
- Assign security roles to colleagues
- Build dashboards from published reports
- Share dashboards and review roles
- Create automatic refresh schedules
Day 2 entails working on Power BI data projects using your own data and systems.
How will you learn?
You will learn on-site.
What will you need to bring with you?
How will you be assessed?
Where next?
Who do you contact for more information?
For more information, contact dcgprofessional@dcg.ac.uk
Course Information for Employers
Information for Employers
Career Information
DCG Success Stories
Discover how our students have achieved success. Their hard work and dedication to learning has enabled them to succeed in rewarding careers or progress onto higher education.
We encourage progress and aspirational outcomes by guiding people onto learning pathways that lead to positive destinations. Our students have gone on to achieve great things since leaving the College. We would like to share some of their inspiring success stories with you.
Find out what funding could be available to you:
Thinking about returning to education or developing new skills? Use our funding calculator below to get an estimate of the financial support you may be eligible for based on where you live.
Whether you’re looking to retrain, progress in your career, or try something new, funding could make your next step more accessible than you think.
Simply enter your postcode into the calculator to see an estimate of the funding that may be available in your area. This is based on regional funding allocations and typical eligibility criteria for adult learners.
Important:
The results shown are a guide only and are not a guarantee of funding.
Funding availability can vary depending on:
- Your personal circumstances (such as age, employment status, and prior qualifications)
- The course you choose
- Government and local funding rules at the time of enrolment
If you’re considering adult learning, there’s never been a better time to explore your options.
Our courses are designed to fit around your life, with flexible study options and expert support every step of the way.
Find out more about the courses available. Adult Courses
If you have any questions about funding, eligibility, or courses, our team is here to help. Contact Us
Course Information Last Updated On: February 17, 2026 4:37 pm
