Interesting projects
We hate business jargon and sometimes it's much better to "show-not-tell".
Here are a few cool things which might help spark your imagination.
Some will be relevant to you, some less so, but we hope they give you a sense of how you could progress your own Business by upskilling your Team and making the most of available technology - a lot of which comes at no extra cost.
This is not exhaustive - SQL, Python, data modelling, machine learning....these are all tools that could help you get more from your business, and Clarity can give you advice and support.​
​
Typical data problems and solutions
01
Power BI
Power BI is a powerful visualization tool that goes beyond simple drag and drop. The DAX language enables more sophisticated calculations beyond simple Sum/Count/Average, to understand customer profiles and buying behaviours, assess profitability.
Power BI enables you to make content dynamic, so you don't need to try and cram everything in together.
Design is a skill, but once you learn some tricks, the tools are very powerful.
Cost to build: FREE (via Power BI desktop), but there are costs if you scale further.
​
(Credits to Coupler.io for the example PBI report)
02
Power Query
This is the "hidden" gem that comes FREE within Excel.
How often does your Team just use Excel to repetitively update bad data, map to some other tables and generally undertake data cleansing every period just to get "good data"?
Power Query can automate that with ease via the user interface, but even more powers are unlocked via the M language which underpins the UI. Parsing content, adding complex business logic, aggregations, joining across content - all achievable with a little guidance.
Cost: FREE (with Microsoft Excel)
03
Excel
Wait, I know Excel already? Well yes, and no.
In Excel 2016, Microsoft created a whole series of "dynamic array" functions which give a lot of power and enable things like financial modelling to be more responsive to columns or rows that might shift. A common example - you have a subtotal or total on a particular row, and every time you add data, you have to insert rows and change the formula. That issue disappears with the new functions.
Simple to learn and it will change the way you think about your files.
Cost: FREE (with Microsoft Excel)
​
​(Credits to https://www.myonlinetraininghub.com/excel-dynamic-arrays)
04
Music Note Learning App
This is not really our normal domain, but it was born out of a need to teach Steve's young twins how to improve their ability to read music.
Of course, they did not thank him for it, but he likes to think it helped them!
Coded in Python, with help from AI, and deployed via Streamlit Community.
Give it a try !
Cost to build: FREE