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
Смотрите видео IRCTC /Railways Data Analysis - Power BI - Part 1, JSON file Transformation онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Learn On ! ! !... 12 Январь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 311 раз и оно понравилось 12 людям.