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 have a sit down with a few key players “WHOO”, to my surprise allowed me to complete a small project, their thinking being similar to mine, “Hey, why not!?”

Unfortunately, I did not get the job — but as I said this wasn’t so much that intention, I got some good real-world interview experience prior to my graduation and learned what I might expect with respect to interview-type take-home projects.

Funny enough I completed the project over that Christmas break and, some 7 years later over the Christmas holidays, I decided to revisit the project and rework the areas that (surely) needed improvement.

I have uploaded my PDF report to GitHub including recommendations and an explanation of the task at hand, I did not update this report and was happy to find it was clear and had some good insight (for a student).