Introduction to Power BI – Virtual Classroom
Back to Training- Date: 18 Feb - 11 Mar 2025
- Duration: 4 X half day sessions
- Time: 9:30 am to 1:00 pm
- Location: online
Introduction to Power BI Desktop
4 X half-day session via MS Teams
9:30am - 1pm
- Tuesday February 18th
- Thursday February 27th
- Tuesday March 4th
- Tuesday March 11th
Cost: €495 Member / €645 Non Member (per person)
ICBE Business Excellence Skillnet funding applied
This course is designed to Introduce participants to the Power BI Desktop, covering the essential skills you need to create and save interactive Visual reports.
Who should attend this course? Aimed at people who work with data (Excel spreadsheets & VLOOKUP’s etc.), who need an introduction to Power BI from beginner level.
Key areas include: connecting to Data, introducing the Data Model and how to shape your data, how to build relationships, use Many to One Relationships, apply common DAX formula and functions and finally visualise your data with interactive reports, all within the Power BI Desktop.
By the end of this course, delegates should be able to create visually pleasing and informative Reports using the Power BI Desktop. You will learn how to load raw data into the Power Query and transform the same data into a Visual Report in Power BI.
This course will cover a selection of Visuals such as composition, comparison and correlation, along with Cards, Slicers and Tables. You will also learn how to run Data Cleansing and apply common DAX formula covering some basic calculations and functions.
Pre-requisites
- A working knowledge of Excel and common Functions
- Knowledge of Relational Database concepts would be advantageous (if you can understand the logic behind VLOOKUP Formula, you will easily understand how a relationship works between 2 separate tables in a database with a common key/column).
- No prior knowledge of creating charts is required
- An understanding of the need to process your information visually
- An understanding of the use of large datasets
| Course Content | |
|
What is Power BI?
Importing Data Sources
Transform and Shaping data · Introduction to the Power Query Editor · Data Types, Header Rows and Replace Values · Remove Columns and Rows · Splitting Columns · Transforming Data – Number, Date and Text Specific Tools · Adding Columns · Applied Steps Introduction to the Data Model & Relating Tables · Introduction to the Data Model · Create and Edit a Relationship · Many to One Relationships
|
Introduction to DAX · Introduction to DAX Syntax · Add a Calculated Column to a Dataset · Using Count and Distinct Count Functions · Create a Measure to be used in the Values Field of your Visuals
Visualizing Data in a Report · Create a Report in Power BI · Use Visuals such as Column, Bar, Line and Area Charts, Funnel, Cards, Tables and Matrix · Customising Formats · Using Slicers · Editing Interactions between Visuals · Filters · Drill – Through Filters
Publish Report to Power BI Service · Overview on Publishing a Report to the Power BI Service · Add Tiles to a Dashboard · Q&A Question Box |
