Accelerator Week 8 - Final Problem Set - tb.pbix (20.7 MB)
Here is my submission. Good practice - seems I spent a lot of time playing around with this before finding my way to the end. Thanks,
Tim
2 Likes
Hi There,
This round was very interesting. I cannot say it was hard for me as I already worked on similar transformations. I just had to find a time to do it and It was more like a welcome and helpful revise.
I took the time to apply what I have learned in previous rounds, and from the different resources I got on eDNA, like setting a parameter for the location of the source file, organize the queries in folders or loading to the model only the necessary queries. The dates table was already there I just had to adjust the starting date
The easiest problem to solve was the #4.
For problem #3, it was like when you have the word on the tip of your tongue, but it doesn’t want to come out until the moment I remembered that I had made a video in 2018 to solve the same problem. If you are interested, here is the link (the video is in French) Lignes décalées, cas 02. Répartir les Produits, Quantités et Prix de Vente (Méthode 01) - YouTube
Thank you for the time you are taking to set up all these resources.
Please find below my solution for the Week 8
Have a nice week
2 Likes
Welcome @stevens and don’t worry I always feel like that
Not sure that my results are elegant but they seem to work
2 Likes
Brian,
Happy New Year! This Accelerator was great. The stack data problem was spot on. I can see myself using modulo and integer divide often.
Accelerator Week 8 - Boehnke Final.pbix (20.7 MB)
Thanks,
Brad B
1 Like
Hi @BrianJ
Many thanks for another learning opportunity. There were some cool take aways for me; like
- Using Modulo and Integer divide
- Fill Down
- How to fix the “Too many elements in the enumeration to complete…” pivot error in Power Query
1 Like
Accelerator Participants,
Happy belated New Year! I’m back after a much-needed holiday break. Great to see so many people enjoying this round’s problem set, and lots of different solution approaches.
Registration in for the live solution event with @sam.mckay and me at 5 PM ET this Wednesday 1/12 is available here:
Hope to see you there!
- Brian
1 Like
Hello Brian:
Here is my submission for Accelerator 8, as it stands now.
Until a couple of hours ago, I was feeling great about this exercise with one exception, which was problem 1. I knew I’d have an issue assigning the highest payer to each month along with the average salary. I didn’t want to lift anyone else’s code. I thought I could work on it as time permitted. I was fine with that. I’ll explain the rest in the section devoted to each problem.
Problem 1 - (Time to complete - 45 minutes, with the exceptions noted below)
Aside from linking average salary and highest payer, I thought everything was fine. I created the matrix and checked several of the dollar values at random. It looked great until I tried to sort the Education Level by the Education Sort. There was an error stating that there wasn’t a one to one match between columns. Further research indicates that I must’ve butchered a step in the data shaping, so I’ll try to fix the issue and resubmit tomorrow.
Problem 2 - Double Headers (Time to complete - 15 minutes)
I used the tutorials you suggested and found another tutorial from “Data Training IO”
Problem 3 - Stacked Data (Time to complete - 20 minutes)
I used the tutorials you suggested.
Problem 4 - Horizontal Pairs (Time to complete - 2 hours)
I stumbled around on this problem, but Melissa de Korte’s “Unpivot Multiple Column Pairs In Power Query” (using M Code List.Zip). About 15 minutes later, I’d finished the problem.
I did additional research and analysis on Melissa’s M Code after completing the problem.
So, here’s my submission. I’ll try to correct the errors in Problem 1 prior to tomorrow’s review session.
Regards,
John Giles
Accelerator Week 8 - JohnG.pbix (20.7 MB)
1 Like
Folks,
My apologies for the last-minute change, but we’re going to have to bump the Accelerator Live Solution Event to the same time next Wednesday 1/19. Looks like I picked up a case of Omicron at a family wedding this weekend. Hopefully, not a huge deal but I’m not going to be in shape to teach the course tonight.
Thanks to all who have submitted solutions thus far – definitely an interesting range of approaches taken. Looking forward to discussing this next week.
– Brian
Hoping you feel better, soon.
1 Like
Hoping it is not grave I wish you a speedy and good recovery
Accelerator Participants,
Bad news and good news. First, the bad. Unfortunately, due to schedule conflicts, I am going to need to push off our live solution event for round #8 another week, until 5pm ET on January 26, 2022.
The good news is that this delay is in service of some fantastic context, partnerships, and initiatives we wil be rolling out in 2022 that we’re really excited about.
I promise we will be back at it next Wednesday night, and that we will finish strong in the last 2 remaining sessions for this Accelerator cycle.
Thanks for your patience and flexibility.
- Brian
1 Like
Hello Brian:
I hope you’re feeling better.
Here’s my second submission for Accelerator.
I resolved an error with Problem 1.
The resolution?
I needed to perform the Modulo step to assign the “Education Sort” prior to “expanding” the column that was created for Highest Payer via Merge.
I’ve played around with the formatting of the Compensation and Highest Payer, to no avail. Let’s see how others handled it during the review session.
Regards,
John Giles
Accelerator Week 8 - JohnG.pbix (20.7 MB)
Hi Brian:
Will we receive a link to tonight’s session?
Thanks.
John Giles
John,
Apologies. Per message above, I had to bump tonight’s session one more week ahead due to schedule conflict. Will post revised signup link for that session later today.
- Brian
Thanks, Brian. Sorry I missed the message.
John Giles
Hi @BrianJ
Submission attached.
Took a while to get my head around the pivot column error when there’s no reference column.
All,
Here’s the registration link for the live Solution Event for Accelerator #8 this Wednesday 1/26/22 at 5pm ET.
Hope to see you there!
- Brian