This course is designed for those new to Power BI who want to know what it is used for and how to get started with it or those who have used it before but want to make sure they have the foundations firmly understood. In this course you will find out what Power BI is and start working with it to produce interactive graphics that can be published and shared with others.
Topics
Introduction to Power BI Desktop
• What is Power BI Desktop
• Power BI Desktop Environment
Introduction to data sources
• Difference between Importing and Connecting
• Connecting to data in Excel, text files and csv files
• Creating relationships between tables
Introduction to Querying and Shaping Data
• Data Types
• Filtering
• Sorting
• Understanding applied steps
• Renaming Columns
• Manipulating columns
Introduction to Visualisations
• Create a basic Chart
• Create a basic Table
• Create a Map
• Create a Matrix
• How to use Slicers
Report Elements and Output options
• Formatting the report
• Adding graphics, shapes and text boxes
• Report Filters
• Publishing
The course is Fully Funded (no charge) for eligible participants. To be eligible, participants must be employed and live in the North of Tyne area (Northumberland, Newcastle or North Tyneside) or work for an organisation in the North of Tyne area.
If you’d like to check your eligibility, please contact the Digital Skills team at digitalskills@sunderland.ac.uk
Venue tbc
Prerequisites: This course is designed for new or existing basic users of Power BI. The attendees must have a good knowledge of using a computer
Lara Mellor
Microsoft Office Desktops Apps Trainer