Business Intelligence Analyst Interview Project — what you can expect (OLTP, Python ETL & OLAP)

Some years ago, as I neared the end of the computer science accreditation I was lucky enough to interview for a BI Analyst position with a leading social media management company based in my home city of Vancouver, Canada — I’m sure you can figure out ‘WHOOO’.

The interview was for an intermediate Business Intelligence Analyst and, not having any experience but a keen interest in the topic I thought, “Hey, why not!?” I went in with the right attitude and was happy to…