Posts on Dashboards & Data Warehousing
Visualising Skills Funding Agency Learner and Qualifications Data with Microsoft Power BI
There's a lot of Skills Funding Agency data freely available of the web - much of it derived from the individualised learner record (ILR).
Microsoft Power BI is a good tool for making sense of what can be quite complex data. It's straightforward to build simple interactive visualisations that highlight patterns in the data and make it easier to spot trends. And sharing Power BI dashboards is also easy - at the moment Microsoft lets you share dashboards via a public url for free.
Data warehousing and analytics - bringing data to life at Together Housing
Musgrave Analytics and SkillsLogic have been working together to develop a state of the art performance management framework for Together Housing Group. The end result is a set of dashboards that gives all staff across the Together Housing Group a consistent view of the the numbers that are used to track performance.
Microsoft Power BI Tutorial - A simple timesheet dashboard Part 2, calculated columns and measures
Extending my simple timesheeting dashboard so that I could report on staff utilisation by month was a good way to start to use measures in Power BI Desktop. What I wanted to get to was a chart that showed the percentage of each person's time being spent on chargeable work each month.
Microsoft Power BI Tutorial - A simple timesheet dashboard Part 1
Power BI is Microsoft's powerful new data analytics and visualisation solution. Power BI comes in two parts - a cloud based service that makes it easy to share dashboards and Power BI Desktop, a free desktop application for building more sophisticated interactive reports and dashboards. Power BI is low cost - there's a completely free version and the Pro version costs $9.99 per user per month.
Calculating medians in PostgreSQL with percentile_cont
SkillsLogic is developing a big reporting and data dashboard solution and as part of that we need to calculate a lot of medians.
Remember from school, the median of a list of numbers is found by sorting the values from lowest to highest and then picking the middle one. If there’s no middle then the median is typically defined to be the mean of the two middle values.
SkillsLogic and Musgrave Analytics to Develop Workforce Data System for the FE Sector
Sheffield software development company SkillsLogic and Musgrave Analytics are to develop ground-breaking new software that from September 2015 will be used to collect workforce information from the Further Education sector.
Visualising Data
Johan Oldekop gave a good talk about visualising data with infographics at the Showroom here in Sheffield yesterday evening. Johan’s from Sheffield University’s Institute for International Development and his event was part of the 11th Annual ESRC Festival of Social Science.
-
Categories
-
EQUAL - Bespoke E-Learning Platform
Read about how we developed a bespoke learning management system for The Skills Network
-
E-Learning Design - Social Care
Read about the work we're doing for the National Association for Providers of Activities for Older People
-
Software Development - clickLearner
Read about how we developed a new video based e-learning solution for a Sheffield company.