Course programme
Power BI - Power Query Editor in Kannada 27 lectures 04:39:54 Chapter 01 - Introduction preview Power Query Editor, how to transform data, how to data model, how to add new columns, how to group the data, split columns, and many more options Chapter 02 - Get Data This Video explains about How to connect to various data sets and import data to Power BIData Sources Explained in this Video are - MS Excel - Txt/CSV - MS Access - By Folders - Webpages Chapter 03 - Transform Data This chapter explains about - How to go to Power Query Editor? - How to get data in Power Query Editor? Chapter 04 - Manage Columns This Video explains about - Manage Columns - Transform & Add Columns - Lower Case - Upper Case - Capitalize each word - Trim - Clean - Add Prefix - Add Suffix - Length Chapter 05 - Reduce Rows This video explains about - Keep Top Rows - Keep Bottom Rows - Keep Range of Rows - Keep Duplicates - Keep Errors - Remove Top Rows - Remove Bottom Rows - Remove Blank Rows - Remove Alternative Rows - Remove Duplicates - Remove Errors Chapter 06 - Format Text Columns This video explains about Power Query Editor - Format Text Columns in Kannada- Lowercase - Uppercase - Capitalize each word - Trim - Clean - Add Prefix - Add Suffix - Length - Merge Columns - First Characters - Last Characters - Range - Text Before Delimiters - Text After Delimiters - Text Between Delimiters Chapter 07 - Format Date Columns This video explains about - Format Date Columns - Day - Month - Year - Quarter - Week Chapter 08 - Format Number Columns This Video explains about Power Query Editor Format Number Columns in Kannada - Add - Multiply - Subtract - Divide - Divide (Integer) - Modulo - Percentage - Percent of - Absolute Value - Power - Square - Cube - Square Root - Round Up - Round Down - Round - Is Even - Is Odd - Sign Chapter 09 - Group By This video explains about - Group by - Group by Single Column - Aggregating by Single Column - Group by Multiple Column - Aggregating by Multiple Column Chapter 10 - Fill Up and Down This video explains about - How to fill the data for the blank cells above - How to fill the data for the blank cells below Chapter 11 - Split Columns This video explains about - Split By Delimiter - Split By Number of Characters - Split By Positions - Split By LowerCase to UpperCase - Split By UpperCase to LowerCase - Split By Digit to NonDigit - Split By NonDigit to Digit Chapter 12 - Append Query This video explains about - Append Queries - Append Queries New Chapter 13 - Merge Queries This video explains about Merge Queries Merge Queries as New Left Outer Right Outer Full Outer Inner Left Anti Right Anti Chapter 14 - Combine Files This video explains about - How to get multiple files (Excel, Text) from a folder - Combine the files to append data into a single table Chapter 15 - Pivot Columns This video explains about - How to get Pivot Columns from a table with single column and multiple column Chapter 16 - Unpivot Columns This video explains about - How to Unpivot Columns from a table - How to Unpivot Selected Columns from a table - How to Unpivot Other Columns from a table Chapter 17 - Column From Examples This video explains about - How to use Column from Examples for Text, Numbers, Dates - How to combine multiple columns using examples - How to Calculate values using examples Chapter 18 - Custom Column This video explains about - How to Create Custom Column - How to use Text, Number, Date functions to create custom column Chapter 19 - Index Column This video explains about - How to Create Index Column From 0, From 1, Custom Index - How to use Index Column and Modulo combination to filter unwanted rows Chapter 20 - Conditional Column This video explains about - How to create Conditional Columns for Text Columns, Data Columns, Numbers Columns - How to use Conditional Columns to remove unwanted rows Chapter 21 - Replace Columns This video explains about - How to Replace Values by Text, Word, Null - How to Replace Errors Chapter 22 - Count Rows This video explains about - How to count the total number of rows in a table - How to convert the Count Rows data into table Chapter 23 - Reverse Rows This video explains about - How to Reverse the Rows in the table Chapter 24 – Transpose This video explains about - How to Transpose table with Single Column, Multiple Columns - How to Use Headers as First Row Chapter 25 - Move Columns This video explains about - How to move columns Left, Right, To Beginning, To End - How to move columns by dragging Chapter 26 - Rename Columns This video explains about - How to Rename the columns by Right Click, Double Click, using Transform Tab Chapter 27 - Data Preview This video explains about - How to check the Column Quality - How to check the Column Profiling - How to check the Column Distribution Power BI - Power Query Editor in Kannada odel, how to add new columns, how to group the data, split columns, and many more options Chapter 01 - Introduction preview Power Query Editor, how to transform data, how to data model, how to add new columns, how to group the data, split columns, and many more options Chapter 01 - Introduction preview Power Query Editor, how to transform data, how to data model, how to add new columns, how to group the data, split columns, and many more options Chapter 01 - Introduction preview Power Query Editor, how to transform data, how to data model, how to add new columns, how to group the data, split columns, and many more options Power Query Editor, how to transform data, how to data model, how to add new columns, how to group the data, split columns, and many more options Power Query Editor, how to transform data, how to data model, how to add new columns, how to group the data, split columns, and many more options Chapter 02 - Get Data This Video explains about How to connect to various data sets and import data to Power BIData Sources Explained in this Video are - MS Excel - Txt/CSV - MS Access - By Folders - Webpages Chapter 02 - Get Data This Video explains about How to connect to various data sets and import data to Power BIData Sources Explained in this Video are - MS Excel - Txt/CSV - MS Access - By Folders - Webpages Chapter 02 - Get Data This Video explains about How to connect to various data sets and import data to Power BIData Sources Explained in this Video are - MS Excel - Txt/CSV - MS Access - By Folders - Webpages Chapter 02 - Get Data This Video explains about How to connect to various data sets and import data to Power BIData Sources Explained in this Video are - MS Excel - Txt/CSV - MS Access - By Folders - Webpages This Video explains about How to connect to various data sets and import data to Power BIData Sources Explained in this Video are - MS Excel - Txt/CSV - MS Access - By Folders - Webpages This Video explains about How to connect to various data sets and import data to Power BIData Sources Explained in this Video are - MS Excel - Txt/CSV - MS Access - By Folders - Webpages Chapter 03 - Transform Data This chapter explains about - How to go to Power Query Editor? - How to get data in Power Query Editor? Chapter 03 - Transform Data This chapter explains about - How to go to Power Query Editor? - How to get data in Power Query Editor? Chapter 03 - Transform Data This chapter explains about - How to go to Power Query Editor? - How to get data in Power Query Editor? Chapter 03 - Transform Data This chapter explains about - How to go to Power Query Editor? - How to get data in Power Query Editor?This chapter explains about - How to go to Power Query Editor? - How to get data in Power Query Editor?This chapter explains about - How to go to Power Query Editor? - How to get data in Power Query Editor? Chapter 04 - Manage Columns This Video explains about - Manage Columns - Transform & Add Columns - Lower Case - Upper Case - Capitalize each word - Trim - Clean - Add Prefix - Add Suffix - Length Chapter 04 - Manage Columns This Video explains about - Manage Columns - Transform & Add Columns - Lower Case - Upper Case - Capitalize each word - Trim - Clean - Add Prefix - Add Suffix - Length Chapter 04 - Manage Columns This Video explains about - Manage Columns - Transform & Add Columns - Lower Case - Upper Case - Capitalize each word - Trim - Clean - Add Prefix - Add Suffix - Length Chapter 04 - Manage Columns This Video explains about - Manage Columns - Transform & Add Columns - Lower Case - Upper Case - Capitalize each word - Trim - Clean - Add Prefix - Add Suffix - Length This Video explains about - Manage Columns - Transform & Add Columns - Lower Case - Upper Case - Capitalize each word - Trim - Clean - Add Prefix - Add Suffix - Length This Video explains about - Manage Columns - Transform & Add Columns - Lower Case - Upper Case - Capitalize each word - Trim - Clean - Add Prefix - Add Suffix - Length Chapter 05 - Reduce Rows This video explains about - Keep Top Rows - Keep Bottom Rows - Keep Range of Rows - Keep Duplicates - Keep Errors - Remove Top Rows - Remove Bottom Rows - Remove Blank Rows - Remove Alternative Rows - Remove Duplicates - Remove Errors Chapter 05 - Reduce Rows This video explains about - Keep Top Rows - Keep Bottom Rows - Keep Range of Rows - Keep Duplicates - Keep Errors - Remove Top Rows - Remove Bottom Rows - Remove Blank Rows - Remove Alternative Rows - Remove Duplicates - Remove Errors Chapter 05 - Reduce Rows This video explains about - Keep Top Rows - Keep Bottom Rows - Keep Range of Rows - Keep Duplicates - Keep Errors - Remove Top Rows - Remove Bottom Rows - Remove Blank Rows - Remove Alternative Rows - Remove Duplicates - Remove Errors Chapter 05 - Reduce Rows This video explains about - Keep Top Rows - Keep Bottom Rows - Keep Range of Rows - Keep Duplicates - Keep Errors - Remove Top Rows - Remove Bottom Rows - Remove Blank Rows - Remove Alternative Rows - Remove Duplicates - Remove Errors This video explains about - Keep Top Rows - Keep Bottom Rows - Keep Range of Rows - Keep Duplicates - Keep Errors - Remove Top Rows - Remove Bottom Rows - Remove Blank Rows - Remove Alternative Rows - Remove Duplicates - Remove Errors This video explains about - Keep Top Rows - Keep Bottom Rows - Keep Range of Rows - Keep Duplicates - Keep Errors - Remove Top Rows - Remove Bottom Rows - Remove Blank Rows - Remove Alternative Rows - Remove Duplicates - Remove Errors Chapter 06 - Format Text Columns This video explains about Power Query Editor - Format Text Columns in Kannada- Lowercase - Uppercase - Capitalize each word - Trim - Clean - Add Prefix - Add Suffix - Length - Merge Columns - First Characters - Last Characters - Range - Text Before Delimiters - Text After Delimiters - Text Between Delimiters Chapter 06 - Format Text Columns This video explains about Power Query Editor - Format Text Columns in Kannada- Lowercase - Uppercase - Capitalize each word - Trim - Clean - Add Prefix - Add Suffix - Length - Merge Columns - First Characters - Last Characters - Range - Text Before Delimiters - Text After Delimiters - Text Between Delimiters Chapter 06 - Format Text Columns This video explains about Power Query Editor - Format Text Columns in Kannada- Lowercase - Uppercase - Capitalize each word - Trim - Clean - Add Prefix - Add Suffix - Length - Merge Columns - First Characters - Last Characters - Range - Text Before Delimiters - Text After Delimiters - Text Between Delimiters Chapter 06 - Format Text Columns This video explains about Power Query Editor - Format Text Columns in Kannada- Lowercase - Uppercase - Capitalize each word - Trim - Clean - Add Prefix - Add Suffix - Length - Merge Columns - First Characters - Last Characters - Range - Text Before Delimiters - Text After Delimiters - Text Between Delimiters This video explains about Power Query Editor - Format Text Columns in...