Puzzles no. 544–548PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #544Wake up Cinderellas, we have some cleaning to do. To be exact we need to pick up numbers fr...

Disclaimer:While my work in this series draws inspiration from the IBCS® standards, I am not a certified IBCS® analyst or consultant. The visualizations and interpretations presented here are my personal attempts to apply these principles and may not f...

#217–218PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #217Turn around, transpose, pivot it all means almost the same. Like table asked us to spin itself around....

Puzzles no. 539–543PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #539Many companies have to diversify their source of resources, to optimize prices etc. So they usually have their orders somehow mixed between vendors. In this case ...

Attention: Article looks long at word count, but remember that contains pretty long chunks of code.Disclaimer:While my work in this series draws inspiration from the IBCS® standards, I am not a certified IBCS® analyst or consultant. The visualizations and interpretations presented here are my personal attempts to apply ...

#215–216PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #215Today we have to do something that I really don’t like to do: constructing tables with esthetical stru...

Puzzles no. 534–538PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #534Palindromes and other symetric numbers are pretty common them of our challenges, but this t...

The IBCS ‘Check’ PrincipleIn the complex world of business intelligence (BI), the ability to present data accurately and transparently is critical. Whether crafting a dashboard for executive decision-making or generating a report for operational analys...

#213–214PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #213Two warehouses gave us some summary, but products there are sometimes in packages, sometimes in batche...

Puzzles no. 529–533PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #529Today we need to look for some numbers and sum it up. So what is the problem? We have numbe...

In today’s data-driven world, the ability to present information clearly and efficiently is essential across various fields, from business to academia. As the volume of data continues to grow, the importance of well-structured and easily interpretable reports becomes increasingly critical. This series on adapting the International Business Communication Standards (...

#211–212PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #211Sometimes there is more than one team under your “jurisdiction” and you need to summarise data coming ...

Puzzles no. 524–528PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #524Today we get bunch of numbers with masked digits. Our task is to check if from those masked...

Concise Tutorial for R Database InterfacesIn the Land of Databases, where the Data lies…In the vast and intricate world of data, much like the realms of Middle-earth, there lies a powerful force — SQL, the language of databases. SQL (Structured Query Language) has long been the One Language to query ...

#209–210PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #209Today we have task related to project management. We have project that consists of processes that consists of tasks. Each task has owner and duration. We need to ...

Puzzles no. 519–523PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #519Today we need to find very complex number. No not complex in mathematical sense, but have v...

Lessons from Will Hunting and McGayverIn the world of data science, data cleaning is often seen as one of the most time-consuming and least glamorous tasks. Yet, it’s also one of the most critical. Without clean data, even the most sophisticated algorithms and models can produce misleading results. This ...

#207–208PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #207Sometimes we have task that are somehow related to real life, not just mind-bending puzzles. And today...

Puzzles no. 514–518PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #514Today we are searching for treasure. Exactly what we need is to find highest 2x2 submatrix ...

#201–206PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #201We need to find out which customer had opportunity to buy specific product (and maybe bought). We rece...