Desktop POWER BI – September – I1209
Programme Aim
This 1 Day course covers the essential skills needed to begin using the Power BI Desktop to produce Visual Reports and learn how to bring data into the Power Query Editor to transform into Power BI. This hands-on interactive course is focused on real-world techniques utilising the amazing capabilities of Power BI. The course covers the core elements needed to get an understanding of what Microsoft Power BI can do.
What will you Learn
How to get your data into Power BI, how to link it together and how to construct a dynamic visual representation of it.
How is it Delivered
Tutor-Led online Virtual classroom.
How Long is the Course
This course is 1 day in duration.
Learning Objectives
After completing this course, you will be able to:
- How to connect to a range of Data Sources
- The Art of creating Data Models to base the interactive dashboards and reports
- How to manipulate Data and run Reports
Who Should Attend
Experienced Excel users (you should be familiar with pivot tables and vlookups) who are curious about Power BI and how they could use it to visualise and present their data.
Prerequisites
Attendees must be familiar with working with large data sets, either in Excel or other database programmes (SQL, Access etc.)
Course Outline
Module 1: Getting Started with Power BI Desktop
- Explore the Power BI Application
- Import Data from Excel
- Importing Data from Online Services
- Refresh Data from a Data Source
- Creating the Data Model
- Linking Tables and Data
Module 2: Manipulating Data
- Organize and Format Tables
- Creating DAX Formulas
- Create Calculated Columns/Measures
- Sort and Filter PowerPivot Data
- Create and Manage Table Relationships
Module 3: Creating Simple Reports
- Introduction to Power Apps
- How to build a canvas app
- How to build a model-driven app
Module 4: Using Power Query
- Importing Data direct from the Internet
- Removing unwanted data from the import
- Appending data to tables or data sets
- Shaping Data to analyse
- Merging and Appending Queries
- Saving and Loading Queries
Module 5: Working with Power View
- What is Power View?
- Using the Power View Window
- Adding Data to a Report Page
- Applying Filters/Slicers
- Adding extra Report Pages
Module 6: Using Power View Features
- Working with the Mapping Function
- Changing Data into Charts
- Applying a TimeLine to the data
Module 7: Using Power View Features
- Publishing to Power BI Online
- Creating an Online Dashboard
- Sharing Reports Internally/Externally
- Publishing a report to SharePoint
