global social media investigation
power bi taster
This short exercise will introduce you to the World According to Power BI… you have been provided with a dataset of 100,000 rows of data, with details of social media usage in daily screentime hours. It has a breakdown of age groups and also their interests.
We want to find out the most popular social media platform by age group, and what these age groups are interested in.
here's one i made earlier
The embedded Power BI below is what we’ll be creating together.
It works best viewed in full screen mode, which you can activate using the toggle in the bottom right hand corner.
There are 4 dashboards which can be accessed using the Page Navigator
You will learn the basics of Power BI and create various charts such as
- Pie Charts
- Stacked Column Charts
- Bar Charts
- Cards
- Map Visuals
You will learn how to make these dashboards interactive for your viewers using Slicers and how to add-in custom visuals.
We will also cover format options and how to apply custom formats.
starter files
Power BI for Managers
Starter files for Global Social Media Usage tutorial
Download the starter file and save to your OneDrive.
PBI Social Starter File – 13.08.25
This is the image file that we use in the tutorial. Download it and save to your OneDrive
The Power BI Taster Session has been pre-recorded into 4 short YouTube tutorials, which can be found below. You will need the PBI starter file above and also the image file.
Video Tutorials - power bi taster session
Power BI Taster Session
Video #1 - 3 mins 19 seconds
Power BI Taster Session
Video #2 - 8 mins 48 seconds
Power BI Taster Session
Video #3 - 6 mins 59 seconds
Power BI Taster Session
Video #4 - 7 mins 44 seconds
Want to go further?
Video Tutorials - Introduction to Power BI
The 5 pre-recorded tutorials below are a full micro-credential – Introduction to Power BI, which we first produced for our Professional Development Award in Data Science at SCQF Level 7.
Having worked through the tutorials, you’ll find a short 5 question Form at the end, which once you complete, will automatically send you out a Completion Certificate
Introduction to PBI
Video #1
Introduction to PBI
Video #2
Introduction to PBI
Video #3
Introduction to PBI
Video #4
Introduction to PBI
Video #5
Certificated free courses
Introduction to Power BI - Colleges Completion Rates
Introduction to Power BI - Colleges Completion Rates
The first of our Introduction to Power BI - updated for Autumn 2024 - based on a dataset of college completion rates in Scotland. Suitable for Power BI beginners with a good grounding in Excel
- Free
- Creative Commons
- Certificated
Excel Power Query - The Chase
Excel Power Query - The Chase
Introduction to data transformation using Excel Power Query - based on 4 years of statistics from ITV's The Chase
- Free
- Creative Commons
- Certificated
excel zero to excel hero #1
Excel Zero to Excel Hero #1
Suitable for Excel beginners with no prior knowledge required
- Free
- Creative Commons
- Certificated
Starter files for youtube tutorials
The various starter files for our YouTube tutorials can be found here
Introduction to Power BI College Completion Rates starter file
Intro to PBI Completion Rates starter file
Starter file for Excel Power Query – The Chase
The Chase Stats – starter file
Starter file for Excel Zero to Excel Hero #1
Sqa Certified courses from scqf level 3 to scqf level 8
short courses from 2 hours to 8 hours in a range of microsoft applications
Turning Data Education in Scotland upside down
Offering a flexible alternative to the traditional fixed in-person classes
Skills Development Award Winners - CDN 2022
Data Education in Colleges are proud to have been shortlisted for 6 awards - both in Scotland and UK-wide - and won the College Development Network's Skills Development Award in 2022