website analysis

[Torbenan]

Hi

I trying to build a report on intranet usage,  which should show the number of page views by sites.

In the data below, I would like the to count the number of page views by site:

http://contoso.sharepoint.com/sites/intranet/ has 52 page views

http://contoso.sharepoint.com/sites/intranet/hr/ has 12 page views

http://contoso.sharepoint.com/sites/intranet/hr/handbook has 8 page views

http://contoso.sharepoint.com/sites/intranet/sales/ has 12 paes views

http://contoso.sharepoint.com/sites/intranet/hr/sales/team1/ has 4 pages views 

etc..

Can this be done in PowerBi? How?

The data, I've got looks like this. I've got one line per pages view in a Azure SQL DB.

http://contoso.sharepoint.com/sites/intranet/default.aspx
http://contoso.sharepoint.com/sites/intranet/default.aspx
http://contoso.sharepoint.com/sites/intranet/default.aspx
http://contoso.sharepoint.com/sites/intranet/default.aspx
http://contoso.sharepoint.com/sites/intranet/default.aspx
http://contoso.sharepoint.com/sites/intranet/hr/holiday.aspx
http://contoso.sharepoint.com/sites/intranet/hr/holiday.aspx
http://contoso.sharepoint.com/sites/intranet/hr/benifits.aspx
http://contoso.sharepoint.com/sites/intranet/hr/default.aspx
http://contoso.sharepoint.com/sites/intranet/hr/handbook/
http://contoso.sharepoint.com/sites/intranet/hr/handbook/.aspx
http://contoso.sharepoint.com/sites/intranet/hr/handbook/.aspx
http://contoso.sharepoint.com/sites/intranet/hr/handbook/.aspx
http://contoso.sharepoint.com/sites/intranet/hr/handbook/default.aspx.aspx
http://contoso.sharepoint.com/sites/intranet/hr/handbook/.aspx
http://contoso.sharepoint.com/sites/intranet/hr/handbook/.aspx
http://contoso.sharepoint.com/sites/intranet/hr/handbook/default.aspx.aspx
http://contoso.sharepoint.com/sites/intranet/sales/.aspx
http://contoso.sharepoint.com/sites/intranet/sales/.aspx
http://contoso.sharepoint.com/sites/intranet/sales/team1/.aspx
http://contoso.sharepoint.com/sites/intranet/sales/team1/page2.aspx
http://contoso.sharepoint.com/sites/intranet/sales/team1/default.aspx
http://contoso.sharepoint.com/sites/intranet/sales/team1/page2.aspx
http://contoso.sharepoint.com/sites/intranet/sales/team2/.aspx
http://contoso.sharepoint.com/sites/intranet/sales/team2/page3.aspx
http://contoso.sharepoint.com/sites/intranet/sales/team2/pages4.aspx
http://contoso.sharepoint.com/sites/intranet/sales/team2/.aspx
http://contoso.sharepoint.com/sites/intranet/sales/team2/default.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productA/page2.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/default.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/page3.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/pages4.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/default.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/page2.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productA/default.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productA/page3.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productA/pages4.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productA/default.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productA/page2.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/default.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/page3.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/pages4.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/page1.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/default.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/default.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/page2.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/default.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/page3.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/pages4.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/page1.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/default.aspx
http://contoso.sharepoint.com/sites/intranet/prodcution/productB/page2.aspx

[v-yulgu-msft · Accepted solution]

Hi @Torbenan,

You should first import above data into Power BI desktop.

Then, to count page views per site, you can "Group by" data rows.

Regards,

Yuliana Gu