Posts on Dashboards & Data Warehousing

Visualising Skills Funding Agency Learner and Qualifications Data with Microsoft Power BI

06 May 16 Mike Education & Training  / Dashboards & Data Warehousing

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

28 Apr 16 Mike Dashboards & Data Warehousing

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

08 Apr 16 Mike Dashboards & Data Warehousing

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

07 Mar 16 Mike Dashboards & Data Warehousing

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

29 Jan 16 Dan Dashboards & Data Warehousing  / Bespoke Software

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

14 May 15 Mike Bespoke Software  / Dashboards & Data Warehousing

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

08 Nov 13 Mike Dashboards & Data Warehousing

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.

Contact Us

SkillsLogic Ltd,
Cooper Buildings,
Sheffield Technology Park,
Arundel Street,
Sheffield,
S1 2NS

+44 (0)114 383 0093
info@skillslogic.com


Follow us on Twitter: