filmov
tv
How to import and clean messy data with Power Query #powerbitutorial #powerquerytutorial
Показать описание
In this video, you will learn how to import and clean messy data from a text (.txt) file.
Topics Covered:
00:00 Introduction
00:58 Review and identify the challenge at hand
06:30 Connect .txt file using Get Data
08:00 Launch Power Query to Transform Data
09:56 Remove the unwanted header rows
11:33 Promote top row as headers
11:55 Remove blank rows
13:22 Remove the repeated column headers
14:25 Remove the unwanted blank columns
16:50 Change data types manually
17:37 USING LOCALES - Change data type for [Price Each] and [Order Date] columns
19:37 Split Order Date column into separate [Order Date] and [Order Time] columns
21:14 Split [Purchase Address] column to get [City], [State Code] and [Post Code]
25:12 Check the Data Quality and Data Distribution across columns
26:26 Insert [Index] column
30:20 Close & Apply changes to commit the transformations
31:07 Save changes and create the .pbix file
32:31 Recap of the key learning points
33:37 What's next...
Thanks for watching. If you have any comments regarding the topics covered in this video, then pease leave a comment.
#powerquery #powerquerytutorial #powerbitutorial #biwithgurpreet
Topics Covered:
00:00 Introduction
00:58 Review and identify the challenge at hand
06:30 Connect .txt file using Get Data
08:00 Launch Power Query to Transform Data
09:56 Remove the unwanted header rows
11:33 Promote top row as headers
11:55 Remove blank rows
13:22 Remove the repeated column headers
14:25 Remove the unwanted blank columns
16:50 Change data types manually
17:37 USING LOCALES - Change data type for [Price Each] and [Order Date] columns
19:37 Split Order Date column into separate [Order Date] and [Order Time] columns
21:14 Split [Purchase Address] column to get [City], [State Code] and [Post Code]
25:12 Check the Data Quality and Data Distribution across columns
26:26 Insert [Index] column
30:20 Close & Apply changes to commit the transformations
31:07 Save changes and create the .pbix file
32:31 Recap of the key learning points
33:37 What's next...
Thanks for watching. If you have any comments regarding the topics covered in this video, then pease leave a comment.
#powerquery #powerquerytutorial #powerbitutorial #biwithgurpreet
0:20:38
How To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP Data
0:10:12
Import and Clean pdf Bank Statement in Excel
0:06:06
Data Import: Prepare your Data for Import | Salesforce
0:09:19
A cleaner, better and faster way to bulk import files in Power BI: Csv.Document and Excel.Worbook
0:06:03
Import and Clean Bank Activity
0:04:32
Repair Geometry and Import Meshes (OBJ, FBX, ...) - Blender Tutorial
0:03:07
How to quickly Import Excel data into SPSS. Super Easy SPSS Tutorial in 3 minutes!!!
0:11:38
Excel - Power Query Import And Clean Fixed Width Text Files - Episode 2539
0:11:44
Best Deals on Used Cars in Lagos at Favour autos
0:43:00
Organize, Clean, and Import Chart of Accounts into QuickBooks Desktop
0:11:28
Properly Convert PDF to Excel
0:06:49
How to Import Data from Web to Excel
0:09:02
How Power Query Will Change the Way You Use Excel
0:05:16
Import Data into R Studio
0:09:28
How to import data from Microsoft Excel into Microsoft SQL Server
0:07:29
How to Import PDF Files into Excel with Power Query
0:07:18
05 - Import Data from TEXT Files in Excel using Power Query
0:13:51
Import and Cleanup CAD Files in SketchUp
0:06:31
How to import data from Excel files to R | R Programming
0:26:40
E-DAB 06: The Magic of Power Query to Import, Transform & Load Data
0:04:02
How to import Excel data to STATA easily and regress
0:05:04
How to IMPORT Excel file (CSV) to MySQL Workbench.
0:09:41
Import and Clean PDF Data with Power BI
0:12:23
Import CSV Files As Pandas DataFrame With Few Data Cleaning Options
Комментарии