filmov
tv
Web Scraping from Multiple Web Pages using Power Query | Automate your Data | @MicrosoftPowerBI

Показать описание
In this tutorial, you will get to know how to automatically scrape the data from the internet (Multiple Web Pages) using Power Query (which is available in Excel and Power BI). We will use the function to invoke and fetch the relevant data.
Analysing the Cricket Records. Who is the highest run scorer for India for the given time frame?
Sachin Tendulkar or Virat Kohli?
0:40 Dataset taken on ESPNCRICINFO website
01:50 Get Data from the web to Power BI
02:30 Select the relevant Table from NAVIGATOR
03:00 POWER QUERY Basics
03:55 ADVANCED EDITOR - (Create a function for the loop)
05:30 INVOKE CUSTOM FUNCTION
06:00 Handling ERRORs
07:25 Expand the Table to get all the records
08:20 SAVE & CLOSE the changes made in the POWER QUERY
10:30 Change the DATA TYPE to clean the data
DATA TYPE ::: (TEXT to WHOLE NUMBER)
11:10 DATA VISUALISATION (BAR Chart for the batsmen (Descending Order)
Understanding PIVOT in Excel (Excel Training for Data Analyst)
What IF analysis (Excel Training for Data Analyst)
Conditional Formatting for Storytelling (Excel Training for Data Analyst)
Excel Basics for Salesmen
Sales Forecasting in Excel (Excel Training for Salesmen & Data Analyst)
#dataanalytics #datascience #powerbi #excel
For a Data Analyst, it is essential to know the web scraping technique with or without python.
Analysing the Cricket Records. Who is the highest run scorer for India for the given time frame?
Sachin Tendulkar or Virat Kohli?
0:40 Dataset taken on ESPNCRICINFO website
01:50 Get Data from the web to Power BI
02:30 Select the relevant Table from NAVIGATOR
03:00 POWER QUERY Basics
03:55 ADVANCED EDITOR - (Create a function for the loop)
05:30 INVOKE CUSTOM FUNCTION
06:00 Handling ERRORs
07:25 Expand the Table to get all the records
08:20 SAVE & CLOSE the changes made in the POWER QUERY
10:30 Change the DATA TYPE to clean the data
DATA TYPE ::: (TEXT to WHOLE NUMBER)
11:10 DATA VISUALISATION (BAR Chart for the batsmen (Descending Order)
Understanding PIVOT in Excel (Excel Training for Data Analyst)
What IF analysis (Excel Training for Data Analyst)
Conditional Formatting for Storytelling (Excel Training for Data Analyst)
Excel Basics for Salesmen
Sales Forecasting in Excel (Excel Training for Salesmen & Data Analyst)
#dataanalytics #datascience #powerbi #excel
For a Data Analyst, it is essential to know the web scraping technique with or without python.
Комментарии