Advaiya Solutions Inc. - Internet Use and Activities

Key metrics on extent of internet use in Great Britain, overall and by gender and age group. Summaries include percentage of households with internet access, devices used to access, types of internet activities including financial and learning activities and online purchases by goods categories.

The UK Office for National Statistics conducted a survey on internet use in Great Britain by Adults (aged 16+) in 2016 and compiled the summaries in an Excel file. All the summaries are in the form of tables and present a challenge in terms of user consumption because of a lack of visual representation of the results of the survey.

A subset of the survey data was cleaned and transformed in the Excel file and imported to Power BI. Report pages were built to highlight key metrics and trends regarding internet use in Great Britain. These can be used by businesses to understand the customer segments and for targeting.

• A map shows the regions with bubble sizes representing the percentage of households with internet access in 2016. A bar chart next to the map shows the percentages in 2006, 2011 and 2016 for the regions. Although city names are used in the map, the cities represent the broader Great Britain regions.

• Among those adults who accessed internet in the last 3 months, percent of people using each of the device types to access internet is plotted. The breakdown by gender and age group is also provided. A background image is added to make the report page more appealing.

• Internet activity trends are plotted from 2007 to 2016 showing how the percentage of people using internet for different activities have changed.

• Percentage of people using internet for different kinds of financial and learning activities in 2016 are shown along with different background images for financial and learning charts for easy identification of the purpose of the charts.

• Percentage of people making online purchases by goods categories is shown along with a breakdown by age group.