Author Archives: Lee Hawthorn

About Lee Hawthorn

Business Intelligence Consultant

Data Analytics modelling, why tune by hand?

When we’re carrying out analysis once we’ve got clean transformed data we have to create a model. There are many types of models that can be used depending on the type of analysis or prediction being made.  For instance, predicting … Continue reading

Posted in Analytics, R | Leave a comment

Collecting requirements from users for a BI project

When holding a workshop to collect requirements for a BI project you can take two broad approaches. When customers know what they want it’s easier to talk dimensions and facts i.e. £ sales by customer, product, brand, time.  Or £ … Continue reading

Posted in Business Analysis | Leave a comment

Business Analysis for BI projects

BI projects have complex elements such as dimensional modelling, modelling facts, hierarchies, calculations etc.. This makes it essential that Business Analysis is applied on all projects.  It’s during the BA phase that requirements are picked up.  As a BI professional it’s … Continue reading

Posted in Business Analysis | Leave a comment

Cleaning data with t-SQL

When creating BI models and looking into the guts of the ERP system we see data artifacts from user behavior or sometimes poor design which requires us to get out our cleaning gear. It goes without saying the best course … Continue reading

Posted in Data Quality | Tagged | Leave a comment

Consuming R through API endpoints with Domino Data Lab

This is a follow-up to the post about deploying R models using web services. Within 1 hour I was able to take an existing R function and publish to the Domino Data Lab web service AND write a simple Python … Continue reading

Posted in Analytics, Deployment, R | Tagged , | Leave a comment