IRCTC /Railways Data Analysis - Power BI - Part 1, JSON file Transformation
In this series of video, we will learn how to export data from JSON file and use minimum applied steps, also combine multiple steps to increase power BI/ Power Query engine performance. Best practices for running Power BI engine better.
Followings are the topics will cover in this video: -
IRCTC data analysis
Railway data analysis,
Indian Railways data anlaysis
JSON Data export
JSON data transformation
get data from JSON file
parse json file
How to import json file data
Daily trains list
Weekly trains list
time table of trains
How to pivot data
How to unpivot data
unpivot other columns
Unpivot only selected columns
how to change column headers to column value
how to change column value to coulumn headers
Extract value from a string
Extract data from a column
Column from example
easiest way to extract value from a column
Atlernate way for if then else statment
Alternate way for split column
Extract value without splitting a column
Automatically generate value from a column
Inserted Text after Delimiter
How to converted to table
Expanded column
Change Type of the column
How to make minimum applied steps
How to combine multiple steps into one to run the power bi engine fast
How to improve power query engine performance
Split DateTime column
How Splitting DateTime column helps power BI performance
Create Railway trains time table
How to rename multiple column at ones
How to combine multiple change types in one step
Watch video IRCTC /Railways Data Analysis - Power BI - Part 1, JSON file Transformation online without registration, duration hours minute second in high quality. This video was added by user Learn On ! ! !... 12 January 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 311 once and liked it 12 people.