Data Analyst Assignment - Real 'Take Home' Interview Task | Power Query

This video will show you a typical take-home interview assignment and replicate a normal day in the life of a data analyst. There is an actual take-home assignment that was provided by a large VPN provider. This is a great way to hone your skills and show what you can do as an analyst.

Here are the analyst steps

0:49 Problem Statement
1:30 Dataset Exploration
3:50 Power Query
7:01 Data Type
8:40 Merge and Join
14:25 Pivot Table
17:55 Grouping
21:30 Visualizing
23:40 Insights and Communication

Get the e-commerce dataset here:

Get the holiday table here:

#interview
#dataanlyst

[ahiafor_]

I actually practiced this with Python Pandas and it was fun.

Thanks very much 🙏🏿

[keifer]

Idk whats going on but your videos seem to always drop right when I need them haha keep em coming!

[ingluissantana]

This kind of videos is what I was waiting for!!!

[jay_with_the_real]

So awesome!! Great project run through. SUBSCRIBED.

Missed calculating the Revenue column at first, might want to add a note to calculate that before referencing it?

Thanks!

[DishaSatyanarayan]

Is it really necessary to remove the 'hours' column? Why?
Great analysis explanation, thanks!

[asddd]

Hello, Thanks for the project. I'm a little bit concerned by the fact that most of the Revenues come from the UK yet we are analyzing US holidays?

[johannpauldalingay]

I downloaded the raw Ecommerce Dataset and the revenue column is missing 😁😁