~Get Your Files Here !

  1. Introduction

   1. Introduction.mp4

   2 pie chart.pbix

   Grocery Price - Copy.xlsx

   billing.xls

   query.pbix

  10. Create Data visualization Charts

   1. bar chart.srt

   2. Line chart.srt

  2. Getting Started with Power Query

   1. Row deletion and Column SPLIT.srt

   2. Replace Column Values.srt

   3. Column MERGE.srt

  3. Updating Data values

   1. Adding SUFFIX and PREFIX.srt

   2. UPPERCASE and Lowercase.srt

  4. Text Extraction

   1. Add and Transform Column- Extract function.srt

   2. Extract text based on delimiter.srt

  5. Index and Conditional Columns

   1. Adding Conditional and Index column.srt

   2. query editor options.srt

   3. Sorting.srt

  6. Date and Time Functions

   1. Date functions in Power Query.srt

   2. Date and Time function- age and more.srt

   3. Time function.srt

  7. Creating Visualization charts

   1. bar chart.srt

   2. Line chart.srt

   3. Ring chart.srt

   4. Treemap- Inter-Related charts in a dashboard.srt

  8. Creating Slicers and advanced charts

   1. Table and Matrix.srt

   2. Drill Down Table and Matrix.srt

   3. Slicer- Basics.srt

   4. Slicers- Date Slicer.srt

   5. View Data and Export in CSV.srt

   6. Simple Map and modes.srt

  9. Removing Null values using python script

   1. Python script to replace null values.srt

   2. Append Query- Join tables to bring back lost date data.srt