Puzzles no. 499–413PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #499Interesting numbers are pretty often in scope of our puzzles. Today we have Lynch-Bell Numb...

#199–200PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #199Data mining, maybe it is too big word for challenge we face today, but we need to dig up some informat...

Puzzles no. 494–498PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #494Sometimes we are exploring new types of numbers, that although they are integers, they have...

Hey there! In our fast-paced business world, clear and consistent communication is more crucial than ever. We all know how misunderstandings and ambiguities can throw a wrench into our plans, leading to inefficiencies and missed opportunities. That’s w...

#195–196PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #197Today we have some warehouse management issue. We were provided with log of products stocked in three ...

Puzzles no. 489–493PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #489Today we get some kind of schedule of appointments, we have time intervals of various lengt...

Have you ever sat through a meeting, staring at a slide filled with jargon and complex charts, and found yourself utterly lost? Or perhaps you’ve read a report that was so vague you had no idea what the key takeaways were. Miscommunication in business ...

#195–196PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #195Is it told that analysts spend big chunk of their time on cleaning data. And sometimes it is indeed a ...

Puzzles no. 484–488PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #484I think we all know what Pythageorean Theorem is. Or at least I hope so… And today we need ...

Why Standardization MattersHey there! Thanks for joining me on this exciting journey into the world of International Business Communication Standards (IBCS). Before we dive into the nitty-gritty of the SUCCESS acronym, let’s take a step back and chat about why standardization in business reporting is such a game-changer. If ...

#193–194PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #193Summary again? Yes, but this time not as usual. We have sales and bonus per salesperson per quarter, a...

Puzzles no. 479–483PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #479Today we have pretty weird sequence to generate — Recaman’s sequence. It doesn’t make any s...

Embracing the Tidyverse Style GuideHey there, fellow R coder! When it comes to writing code in R, making it functional is just the beginning. Trust me, I’ve been there — debugging code at 2 AM, wondering what I was thinking when I wrote that line. This...

#191–192PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #191Usually on Power Query Challenges we are getting some table transformations, but not this time. We have some pretty hardcore text manipulation here. What we have to do? ...

Puzzles no. 474–478PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #478Waves of digits in style of Kanagawa wave, created by Dall-e3Today we get some numbers and ...

Joins Are No Mystery Anymore: Hands-On Tutorial — Part 3Welcome back to the final installment of our series, “Joins Are No Mystery Anymore: Hands-On Tutorial.” In the previous weeks, we covered the foundational and advanced join techniques, including I...

#189–190PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #189We have sequential report of some weird acceptance process. Unfortunatelly we don’t know the rules, and we are suppose to only clean report to more digestible form. ...

Puzzles no. 469–473PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #469This task is suprisingly easy and interesting at once. We have sequence of letters separate...

Joins Are No Mystery Anymore: Hands-On Tutorial — Part 2Welcome back to the second part of our series, “Joins Are No Mystery Anymore: Hands-On Tutorial.” In the first part, we explored the foundational types of joins, including Inner Join, Left Join, R...

#187–188PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #187There are two ways of showing data and it really depends on what is the purpose of certain presentatio...