From the course: Introduction to Career Skills in Data Analytics
Join today to access over 25,100 courses taught by industry experts.
Tips on preparing the data in Excel
From the course: Introduction to Career Skills in Data Analytics
Tips on preparing the data in Excel
- [Instructor] In the life of every data analyst, you reach a point where it's time to prepare the data. This is the part where we clean and transform our data to meet the requirements, and if you haven't heard, we do this a lot. You've profiled your data, you've reviewed all the business rules, and now it's time to dig in and actually get started. I want to work with my sales order data to prepare it for a template to import it into a new system. I typically start with a new blank workbook and I'll use Power Query to connect to my data, and then I'll do my data transformations there. I'll go to my data tab, I'll choose get data, and I'll choose from file. There are several connections here, but because my data is an export that's stored in an Excel workbook, I can choose from file and from workbook. Okay, I'll navigate to my data for template, I'll double click it, and this is what is establishing the connection…
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.