MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries
Download Excel START File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-LocaleStart.xlsx
Download Zipped Folder with Text Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/TextFiles012.zip
Download Excel FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-LocaleFinished.xlsx
Download Power BI Desktop FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-LocaleFinished.pbix
Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-Locale.pdf
Comprehensive video about using Locale Settings so that Power Query interprets Dates and Numbers from different parts of the world correctly. In this Video learn about how to use the “Using Locale…” Feature and Regional Settings to import Text Files from Different Countries so that Dates and Numbers in Different Formats can be interpreted correct, and the multiple Text Files and be Appended into a single table. Also see how to change the Locale settings on individual columns.
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Topics:
1. (00:15) Introduction
2. (00:25) Text Files from Different Countries have Different Date and Number Formats
3. (02:40) Change Regional Settings in Power Query and Power BI Desktop
4. (04:28) Using Locale… Feature on Single Columns to interpret Dates and Numbers Correctly
5. (06:50) Convert ISO Dates to Proper Dates in Power Query
6. (08:04) Power BI Desktop: Import Multiple Text Files with Different Date and Number Formats From Folder and Append. See 1) Create Table in Power BI Desktop, 2) Build Custom Function 3) Import Text Files From Folder and Append
7. (20:30) Summary
Assigned Homework:
Download pdf file with homework description: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-Homework-Start.docx
Zipped Text Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-TextFilesForHomework.zip
Example of Finished Homework in Excel: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-HomeworkFinishedExample.xlsx
Видео MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries канала ExcelIsFun
Download Zipped Folder with Text Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/TextFiles012.zip
Download Excel FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-LocaleFinished.xlsx
Download Power BI Desktop FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-LocaleFinished.pbix
Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-Locale.pdf
Comprehensive video about using Locale Settings so that Power Query interprets Dates and Numbers from different parts of the world correctly. In this Video learn about how to use the “Using Locale…” Feature and Regional Settings to import Text Files from Different Countries so that Dates and Numbers in Different Formats can be interpreted correct, and the multiple Text Files and be Appended into a single table. Also see how to change the Locale settings on individual columns.
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Topics:
1. (00:15) Introduction
2. (00:25) Text Files from Different Countries have Different Date and Number Formats
3. (02:40) Change Regional Settings in Power Query and Power BI Desktop
4. (04:28) Using Locale… Feature on Single Columns to interpret Dates and Numbers Correctly
5. (06:50) Convert ISO Dates to Proper Dates in Power Query
6. (08:04) Power BI Desktop: Import Multiple Text Files with Different Date and Number Formats From Folder and Append. See 1) Create Table in Power BI Desktop, 2) Build Custom Function 3) Import Text Files From Folder and Append
7. (20:30) Summary
Assigned Homework:
Download pdf file with homework description: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-MSPTDA-Homework-Start.docx
Zipped Text Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-TextFilesForHomework.zip
Example of Finished Homework in Excel: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/012-HomeworkFinishedExample.xlsx
Видео MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report7 Interesting Power Query Tricks14 - Combine CSV Files (or Text Files) in a Folder Using Power QueryAppend Vs Merge: What is the difference? | Power Query EditorMSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to ExcelHow To Break Out Large Tables Into Multiple Tables And Build A Model - Power BI TipsRelated and RelatedTable in DAXCount of Unique Values DistinctCount in Power BI Through Power Query Group By Transformation05 - Import Data from TEXT Files in Excel using Power QueryHow Power Query Will Change the Way You Use ExcelGet more info with Power Query tracing in Power BI DesktopWhat is SQL? [in 4 minutes for beginners]Unstack Uneven Rows into Separate ColumnsMSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples)Excel Magic Trick 1408: DAX Measure: Moving 12 Month Average on Daily Sales (DAX Formatter too)MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, MoreMSPTDA 33: Data Modeling for Slowly Changing Dimensions with Power Query & PivotTablePower BI - Splitting a column