Publications by Numbers around us

R Solution for Excel Puzzles

14.10.2024

Puzzles no. 559–563PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #559Sometimes we need to make work on columns. It technically just like working on lists, and look what we need to do with the lists today. It is called running maximum. We usually have som...

3475 sym R (4273 sym/15 pcs) 34 img

R You Ready? Git Your Code Under Control!

10.10.2024

Hey there, ready to get your R code under control? Whether you’re working on your own or in a small team, managing your code can sometimes feel like juggling too many things at once. But don’t worry — there’s an easy way to stay on top of everything. That’s where Git comes in.Think of Git like a trusty sidekick for your coding advent...

24991 sym R (147 sym/8 pcs) 12 img

PowerQuery Puzzle solved with R

08.10.2024

#223–224PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #223As usual on weekends we are mainly doing table transformations. Sometimes it need simple manouvers and sometimes very complicated almost magical tricks. And today we have exactly that situation. Fi...

1624 sym R (1218 sym/6 pcs) 16 img

R Solution for Excel Puzzles

07.10.2024

Puzzles no. 554–558PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #554Another interesting number called after Indian mathematician. We need to find first 50 Kaprekar numbers of any order. What does it mean? We need to find numbers which square cut in any ...

2900 sym R (3408 sym/15 pcs) 34 img

Choosing the Right Chart: A Personal Guide to Better Data Visualization

03.10.2024

Why Choosing the Right Visualization MattersI’ve been visualizing data for quite a few years now, and if there’s one thing I’ve learned, it’s that choosing the right chart can make or break your message. I’ve spent countless hours reading, learning, and experimenting — immersing myself in works by data visualization experts like Lel...

12776 sym 18 img

PowerQuery Puzzle solved with R

01.10.2024

#221–222PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #221We already had task to provide indices for some structured project, and here we go again. Once again I found out that perfect concept to use for such puzzles is factorization. Using it properly mak...

1581 sym R (1310 sym/6 pcs) 16 img

R Solution for Excel Puzzles

30.09.2024

Puzzles no. 549–553PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #549We do not discriminate any people and technology in solving those tasks, but today is day of discrimination. We woke up this morning and said: we don’t like O letter, letter O is BANN...

3380 sym R (3470 sym/15 pcs) 32 img

PowerQuery Puzzle solved with R

30.09.2024

#219–220PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #219Somebody make request for equipment for new employees. But we have little mess here, if two devices with the same OS is needed it looks, like D1, D2 — OS1, and if we have two devices of the s...

1546 sym R (1266 sym/6 pcs) 16 img

Blueprint for SUCCESS: The Architecture of Structured Reports

26.09.2024

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 fully align with the official IBCS® standards. I greatly appreciate the insights and framework p...

25443 sym 4 img

R Solution for Excel Puzzles

23.09.2024

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 from random strings and then add them up. It shouldn’t be hard. What do you think?Loading lib...

3232 sym R (4992 sym/16 pcs) 32 img