#145–146PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #145This time our task is to summarise sales from three stores, but there are strings attached. They shoul...

Puzzles no. 359–363PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #359Just like in this dragon sometimes numbers are a sum of many consecutive elements. And todays task is to discover which sequence of numbers are valid ...

The Art of Data ExplorationIn the world of data analysis, every dataset is a trove of untold secrets waiting to be unearthed. These data-driven revelations can hold the key to informed decision-making, scientific discoveries, and a deeper understanding...

#143–144PuzzlesAuthor: ExcelBIFrom this week all files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Suprisingly this week we have no time-related puzzles, they are rather transformations of tables.Puzzle #143In this puzzle we have some kind of log. Employees are ...

Puzzles no. 354–358PuzzlesAuthor: ExcelBIFrom this week all files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #354This puzzle comes up on Christmas (Dec, 25th), so it was not really suprisin...

n the world of programming, where complexity often intertwines with the need for efficiency, there exists a practice as ancient as it is modern: memoization. This concept, akin to the meticulous art of typesetting in the days of yore, stands as a testa...

# 141–142Puzzles:PQ_141: content filePQ_142: content fileLast time I noted that usually PQ Puzzles are focused on times and dates. And… it confirms this week. Lets count it.PQ_141Rolling averages and other rolling calculations are very useful concepts ...

Puzzles no. 349–353PuzzlesAuthor: ExcelBIPuzzles:#349: content file#350: content file#351: content file#352: content file#353: content fileLet dig in those numbers.Puzzle #349In this puzzle we have to translate “normal” (Arabic) numbers into Roman nume...

S(00)7 — Agent with License for OOPIn the realm of data science and statistical programming, R stands out for its rich set of features and libraries. Just like the iconic James Bond, also known as Agent 007, who never fails to amaze with his suave skil...

# 139–140Puzzles:PQ_139: content filePQ_140: content fileI noticed that usually Power Query puzzles are about time. Does it really a case in PQ that time related calculations are hard or tricky?PQ_139In this puzzle we have to extract informations about...

Puzzles no. 339–343PuzzlesAuthor: ExcelBIPuzzles:#344: content file#345: content file#346: content file#347: content file#348: content fileLet dig in those numbers.Puzzle #344I am sure that you have heard about palindrome, but did you know katadromes? ...

The Art of Testable CodeIn the intricate world of programming, particularly in the field of data science, the ability to write testable code stands as a hallmark of a skilled developer. Testable code is the backbone of reliable and maintainable softwar...

# 137–138Puzzles:PQ_137: content filePQ_138: content filePQ_137Our goal today is to find out some data properties in table, but unfortunatelly they are weirdly nested in cells. It doesn’t look scary because we already know that many structured are nest...

Puzzles no. 339–343PuzzlesAuthor: ExcelBIPuzzles:#339: content file#340: content file#341: content file#342: content file#343: content fileLets dive into solutions!Short disclaimer: This weeks riddles were well designed and I found out that very good b...

Anticipating the UnanticipatedIn the dynamic world of data science and programming, one of the most valuable skills is the ability to anticipate and handle unexpected scenarios. When working with data, the unexpected comes in various forms: unusual dat...

# 135–136Puzzles:PQ_135: content filePQ_136: content filePQ_135Lets imagine that we have binning machines in our sport centre. We can set how many balls need to be grouped in one bin/bucket/chest/whatever. We have 10 balls and machine is placing it in ...

Puzzles no. 334–338PuzzlesAuthor: ExcelBIPuzzles:# 334: content file# 335: content file# 336: content file# 337: content file# 338: content fileLets dive into solutions!Puzzle 334We are given pairs of numbers and we have to find if they are amicable. B...

The Importance of Error HandlingIn the multifaceted world of R programming, particularly when navigating the intricate paths of data analysis, robust error handling is not merely a precaution; it’s an essential pillar of reliable and trustworthy code development. Picture this: you’re deep into a complex data analysis task, ...

# 133–134This weekend brought us two stories, two puzzles which have to things in common: they are pretty hard and difficulties were both linked to time dimension.Puzzles:PQ_133: content filePQ_134: content filePQ_133In first puzzle we have data about ...

Week 47 — Puzzles no. 329–333PuzzlesAuthor: ExcelBIPuzzles:# 329: content file# 330: content file# 331: content file# 332: content file# 333: content fileLets dive into solutions!Puzzle 329In this puzzle we were asked to generate first 50 elements of I...