IntroductionIn the world of data analysis and statistical computing, R stands out as a powerful and versatile language. Its ability to handle complex data operations with ease makes it a favorite among data scientists, statisticians, and researchers. A...

#231–232PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #231Both puzzles this weekend are somehow related to logistics. In first one we need to complete data for ...

Puzzles no. 574–578PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #574We have some weird military drill on numbers today. Like some seargent shouting “Every firs...

Why Interactive Tables MatterWhen people think of tables, they often picture static rows and columns, a no-frills way to present data. But interactive tables are a whole different story! These tables let users engage with the data directly, exploring it in ways that feel almost hands-on. Adding features like sorting, ...

#229–230PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #229When somebody is working on a project for more than a month it doesn’t really matter for him individua...

Puzzles no. 569–573PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #569Today we have some random strings thate need to process in certain way. We have to count ev...

You’ve probably been there — mention to someone that you work with data, and they say, “Oh, so you just make tables?” Tables, right? How hard could it be? It’s just rows and columns. But we know better, don’t we? Tables aren’t just a random dumping gro...

#227–228PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #227We are given two tables one with employees data, and second with conditional assignment of salary. The...

Puzzles no. 564–568PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #564Have you ever thought about sorting only part of given data, not even changing position whe...

Have you ever looked at a headline or a graph and thought, “Well, the numbers don’t lie, right?” It’s tempting to trust the stats we see around us — whether it’s a political poll, a study about coffee’s health benefits, or a chart showing the rise of ...

#225–226PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #225Sometimes we have nice tables with so called tidy data, where each observation mean one row. But this ...

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 l...

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. ...

#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...

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 Kapr...

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, an...

#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...

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 ...

#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 wi...

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...