From the course: Introduction to Career Skills in Data Analytics
Join today to access over 25,100 courses taught by industry experts.
Transforming data in Power BI
From the course: Introduction to Career Skills in Data Analytics
Transforming data in Power BI
- [Instructor] Power BI offers two core functions for the data analyst: Transforming the data, as well as presenting the data. We want to analyze the sales of our products to note our top 10 products. We will eventually visualize this data for an executive meeting or a future dashboard. The opening screen of Power BI desktop is a blank page ready for visualization. This happens after you've connected to your data. If you notice in my Field pane on the far right, I've connected to the tables I need to analyze the top products. It's the Order Details and the Products. We'll do the transformations on Product and Order tables in Power Query. I'll get to show you the Group By function, so I can total the orders. As well as the Query function, where I merge the orders and the products together using the Merge Queries option. Because I've connected to my data, I can just go to the Transform option and begin my data cleanup.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.