2017 was a busy year running BI projects and big (messy) data, and it’s consolidated a better focus going forward – on data analytics rather than just systems. After all, nobody simply needs a database system anymore – we need solutions and business improvements. Although they need to be built on sound and structured database systems, we can take that as a given (although careful your analytics consultant has such database experience!). PowerBI analytics become awkward if the underlying database is poor, not to mention the quality of the data.
Still End-to-End Solutions
Tickbox Systems will always provide end-to-end data solutions from initial analysis through development, programming, integration, maintenance and support. But we’ve decommissioned our last hosted SharePoint servers as we see clients more confident to use Microsoft’s own Office 365, and we’ve stopped promoting licence sales as there is no margin for advisory consultancy and we prefer to point our clients to the best way to save money via EU-linked distributors and resellers. That leaves our focus on SQL Server database development and data analytics for Business Intelligence.
From Models and Statistics to PowerBI (and other) Analytics
Personally, I’ve committed to that focus by undertaking an MSc in Data Analytics – one which is highly practical with selectable commercial datasets and flexible modules (ie. not just PhD preparation). Although I’ve been working with analysis tools, data warehousing and management reporting for many years, this course has already proved invaluable – drilling into mathematical models and statistics but practically implemented in new R (and SAS) programming. R is the preferred tool, exposing a huge wealth of statistical packages and techniques with many opportunities – all integrateable with PowerBI and SQL Server. Such a project has a screenshot above – analysis of Air Pollutants and Ozone, but the techniques apply across many business uses (ask me for examples). And that is where I want to steer the company and our services, which I hope will be of use to you, the client.
Have a great 2018!