About this Event
It starts with an overview of the UI, followed by importing data into Power BI. It then focuses on the process of cleaning data, then the creation of visualisations, including charts and tables, to build an interactive end user dashboard used to analyse data.
This webinar will be hosted by one of our trainers, Alan Gilbert.
What’s in it for you?
This session will help you:
- The aim of this course is to provide an introduction to understanding the Power BI analysis process and equip you with the necessary skills to start applying your learning straight away.
Agenda
(10.00 – 10.45)
1 GETTING STARTED
- The Power BI Desktop ecosystem
- The four Power BI views
2 IMPORTING FILES
- The process of importing files
- Importing an Excel file
- Managing imported file connections
3 CLEAN DATA IN POWER QUERY
- The process of cleaning data
- How Applied Steps work
- Managing data types
- Using Filters and Fill to clean data
4 INSERTING DASHBOARD VISUALISATIONS
- Things to keep in mind
- Inserting maps and charts
- Formatting visualisations
- Insert a table and a card
- Filtering reports with slicers
Free registration
This webinar, one of a series, is completely free of charge – just make sure you book well in advance to get the ‘joining instructions’ and to be sure of a place. Click 'Add to calendar' above before you click the green ‘Register’ button, above. The session will be held on Zoom, so remember to look out for the secure password we will email you an hour before the session begins.
Sessions in the series
6 December 2024: Assertiveness
Please don’t forget to attend – the session will not be recorded.
TRAINER
This webinar, one of a series, is completely free of charge – just make sure you book well in advance to get the ‘joining instructions’ and to be sure of a place. Click 'Add to calendar' above before you click the green ‘Register’ button, above. The session will be held on Zoom, so remember to look out for the secure password we will email you an hour before the session begins.
Alan became a professional IT trainer in 1995 when, on completion of an NVQ accreditation in IT, the organisation providing the course invited him to join their team as a trainer and, subsequently, City & Guilds Assessor.
He later founded his own independent training consultancy, back in 2013, and has trained thousands of people since then. He has experience of delivering training on a range of specialist programs, such as Excel VBA, PowerPivot, Publisher, Sway and Visio, although his main focus is on the core Microsoft Office packages.
PARTICIPANT FEEDBACK
• ‘Fantastic. Well-paced and easy to follow.’
• ‘Very useful and informative if you are looking to improve Excel understanding.’
• ‘Great experience.’
• ‘Great course to learn the advanced formulas of Excel.’
• ‘Very in-depth introduction to some of the more complicated, unexplored Microsoft excel tools.’
• ‘If you use pivot tables, or look up searches in databases in Excel, you will find this course very helpful. Also for a basic understanding of macros and good handouts and exercises for personal reference and further training.’
• ‘Very patient and knowledgeable.’
• ‘Very personable, relatable, patient and able to present complicated processes in an understandable way.’
• ‘Friendly and good at checking people are up to speed.’
• ‘Good mix of examples of different scenarios in your work and where to use them.’
• ‘Very informative and interesting regarding Excel's capabilities.’
• ‘Very good and explained and answered all questions.’
• ‘The trainer is very knowledgeable and informative.’
• ‘Makes sure everyone understands. Adapts his training to the slowest pace for the room.
• ‘The trainer was very thorough in his explanations.’
• ‘Explains everything well.’
• ‘Excellent teacher and very intelligent.’
• ‘Alan explains things very clearly and addresses issues on questions before they are visible. Thank you very much!’
• ‘Very knowledgeable would love to have him again if there is another course, thank you.’
Event Venue
Online
GBP 0.00