About this course
This is a beginner’s course and aims to give the new Power BI user a thorough grounding in the basics of working with spreadsheet data from Excel to create visualisations, charts and reports in Microsoft Power BI.
Business Intelligence software tools help you to clearly visualise and analyse reports for your business organisation.
Review the course outline below to see what is covered.
Why Study Online?
- ZERO travel and flexible course delivery; complete this course online from home or at work.
- Study according to your schedule with 24/7 access to online course content.
- Fully equipped virtual classrooms. Attend real-time virtual classes with a certified trainer.
- Participate in interactive learning experiences.
- Feel supported through your studies with our dedicated Student Support Days to provide one on one guidance.
Rather study Face-to-Face?
Check out our Microsoft Power BI Level 1 face to face Newcastle course for classroom delivery.
Prerequisites
This course requires at least an Intermediate – Level 2 knowledge of Microsoft Excel with at least several months’ experience in using Excel at this level prior to attending Power BI Level 1.
Is Power BI the same as Excel?
Power BI does not edit, add or change data like Excel does. It allows the creation of powerful dashboards and visually appealing graphical visualisations of existing data provided by Excel and other programs. It also leverages powerful tools to tidy up and fully normalise data from Excel into “Fact” and “Dimension” tables to allow much more efficient manipulation of the data.
Course structure and content
The following topics are covered in Level 1:
- Introduction
- Using Data from Excel
- Power Bi Desktop
- Data Normalisation
- Visualisations
- From Visualisations to Reports
- More Visualisations
- Using Visual Interactions
- Working with Filters
- Spatial Visuals
- Q&A and Analysis
- Custom Visuals
- Publish to Power BI Service
- Create Dashboards
- Working with dashboards
- Refreshing Data
- Share reports and dashboards
- Getting help
- Working with Formats in a Visualisation
- Power BI Mobile
- Data Samples
View the attached document below for further information.