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

preview_player
Показать описание
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.
Рекомендации по теме
Комментарии
Автор

Great vide! If the number of pages is not constant - is it possible to automate? And it's readable from page

amlevin
Автор

Thanks for sharing... Have a question.. what if the webpage has load more button and not different pages?? Like Google Trends

aashasangole
Автор

how to do this if site needs user & pasword please help

AngelRivera-sgue