Power BI Topic 3: Data Transformation
Duration: 90 Minutes
Target Audience:
Aimed at experienced Microsoft Excel users who wish to use the Power BI interface to create their own reports and dashboards.
Course Objectives:
Power BI is a Microsoft product that allows for the creation of powerful, interactive visualizations using business intelligence. This session will introduce participants to the numerous ways Power BI facilitates the transformation of data.
Participants should have attended the Power BI Level 1: Introduction to Power BI, Power BI Level 2: Building Reports webinars prior to attending this session.
Course Outline:
Course Introduction
Introduction to Desktop Data Transformation
Connecting to a Database
Carrying Out Basic Transformations
Managing Query Groups
Splitting Columns
Concatenating Columns
Changing Data Types
Working with Dates
Removing Columns and Reordering Columns
Creating Conditional Columns
Connecting to Files in a Folder
Merging Queries
Using the Query Dependency View
Transforming Less Structured Data
Creating New Tables by Entering Data
Setting Query Parameters
Discussion and Question Time
Please contact us today if you have any questions about our Microsoft Courses. We offer both classroom and virtual training options. Contact us at +353 1 279 0020 or Email us at sales@olas.ie
