Publications by Numbers around us
R Solution for Excel Puzzles
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 some interesting properties. Today is the time for Tech Numbers. They always have even number...
3189 sym R (3180 sym/15 pcs) 34 img
Unify: How to Eliminate Ambiguity and Achieve Consistent Business Communication
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 where the International Business Communication Standards (IBCS) come in with their super handy SU...
25353 sym 4 img
R Solution for Excel Puzzles
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 length and names placed on crossing of interval and weekday. Of course designing tables beforehand ...
2796 sym R (3006 sym/15 pcs) 34 img
PowerQuery Puzzle solved with R
#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 stores in three months. You would say, Nice, but we don’t have any stock levels in there just...
1668 sym R (887 sym/6 pcs) 16 img
Say What You Mean: Mastering Clarity in Business Communication
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 can lead to costly mistakes, poor decision-making, and missed opportunities. This is why clarity...
23260 sym 12 img
PowerQuery Puzzle solved with R
#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 mess. We have list of orders made by people, with products, prices and amounts written “how t...
1731 sym R (1296 sym/6 pcs) 16 img
R Solution for Excel Puzzles
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 to use properties of right triangle to solve our challenge. We need to find groups of 3 numb...
2715 sym R (4079 sym/15 pcs) 34 img
Introduction to Standardization in Business Reporting
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 you’ve ever felt ove...
17465 sym 4 img
PowerQuery Puzzle solved with R
#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, and as result we also need total per each of those partitions and cummulative summary down the t...
1975 sym R (1401 sym/6 pcs) 16 img
R Solution for Excel Puzzles
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 sense in real life, it is just mathematical concept linked to recursion. Nonetheless ...
3472 sym R (4168 sym/17 pcs) 34 img