Time: 45 minutes
Level: Intermediate
I learned how to use power query.
Excel challenge.xlsx (109.4 KB)
Time to Complete: 30 Minutes
Difficulty: Intermediate
Solution:
PowerandPivot.xlsx (115.2 KB)
Time to complete: 45 minutes
Rating of Difficulty: Intermediate
This was my first time using Power Query and I think most of the problems I had was using a Mac so some buttons functions were harder to find.
SamHerb_Challenge215_Powering_Up_PowerQuery.xlsx (1.3 MB)
Time to complete: 30 min
rating of difficulty: intermediate
challenge215powerquery.xlsx (107.0 KB)
Was totally new at this so it took me longer than expected.
Time: 60 min
Level: intermediate
Power up.xlsx (110.7 KB)
Time: 40
Rating: Intermediate
Relatively easy to follow with the hints and instructions, but something very new to me.
dataanalyticspractice1.xlsx (109.9 KB)
Time to Complete: 15 Minutes
Difficulty: Beginner/intermediate
I had never used Power Query before, but the instructions were easy to follow. Good review of simple pivot tables as well.
PowerQuerySolution.xlsx (143.5 KB)
Time: 30 mins
Rating: Moderate
I have never used power query or pivot tables before so it was a good chance to learn.
Power.xlsx (103.8 KB)
Time to Complete: 20 minutes
I was unfamiliar with PowerQuery, but it was cool to learn!
techhub 215.xlsx (116.5 KB)
Time to Complete 40 minutes
Level Intermediate
This is a great challenge to introduce power
Poweringup.xlsx (177.2 KB)
query and pivot tables.
Time to complete: 15 minutes
Difficulty: easy
Notes: I have not done pivot tables for a while, so it was exciting to relearn. I also loved learning about the power query, though I don’t necessarily understand it very well.
challenge1.xlsx (140.3 KB)
time to complete: 15 minutes
Challenge Level: Beginner
Solution:
Challenge_407_COLES_25.xlsx (127.1 KB)
Awesome introduction into power query with helpful instructions for me having never done it before!
Time to complete: 45 min
Difficultly: moderate
Challenge215Excel.xlsx (115.7 KB)
Time to complete: 30 minutes
Difficulty: intermediate
Never used power query before, now I see that it is a useful tool.
Book2 challenge 215.xlsx
This was my first time using PowerBI, and I learned a lot! It was a fun challenge, and the instructions were clearly outlined.
PowerBIChallenge.xlsx (110.6 KB)
30 minutes
intermediate
PowerQuery.xlsx (116.6 KB)
Time to complete: 30 mins
Difficulty: Intermediate
Hadn’t ever used power query before so it was a good introduction.
Challenge215 Power Query.xlsx (110.0 KB)
Time to Complete: 1 hour
Difficulty: Intermediate
Comments: I had some weird technical issues, but without the step by step helps and guidance, it would’ve taken me a while.
Power Query Solution Colby Field.xlsx (122.0 KB)
Time: 30 min
Challenge: Intermediate
Great challenge. I needed the hints to help me.
Powering Up Power Query Challenge.xlsx (50.9 KB)
Time to complete: 60 minutes
Rating of difficulty: Intermediate
hw.xlsx (109.1 KB)