Welcome to the Mushroom KingdomIn the vast and varied landscape of data analysis, navigating through complex datasets and transformation processes can often feel like an adventure through unknown lands. For those who embark on this journey using R, there’s a powerful tool at their disposal, reminiscent of the magical ...

#171–172PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #173One of contestants said: Why should we break such a nice table? Because indeed it is what we have to d...

Puzzles no. 429–433PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #429We all (I assume) know the Pythagorean theorem, thanks to which we can calculate sides of t...

IntroductionIn the world of scientific research and academic writing, the clarity, precision, and aesthetics of your documents can significantly impact their reception and comprehension. LaTeX, a powerful typesetting system, has long been revered for its ability to create beautifully formatted documents, especially those requiring complex mathematical expressions and detailed layouts. ...

#171–172PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #171Power Query puzzles are very often focused on transformation of tables in very different ways. And we ...

Puzzles no. 424–428PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #424We are playing with numbers very often, and sometimes is just playing for playing. Like tod...

In the era of data-driven decision making, the ability of businesses to communicate complex information effectively has never been more critical. Yet, as companies navigate through vast oceans of data, the challenge of not just analyzing but also presenting this data in a coherent, consistent, and compelling manner is a ...

#169–170PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #169In todays challenge we have certain pattern to extract from given texts. As you may notice I really li...

Puzzles no. 419–423PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #419What do you think hearing reversely divisible? My first thougth was… hey, palindromes are p...

In the vast and ever-expanding universe of data, the ability to not just see but truly understand the stories hidden within numbers becomes paramount. This journey of comprehension isn’t unlike the iconic moment from The Matrix, where Neo, standing amidst the endless possibilities of the digital realm, declares his ...

#167–168PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #167Today we have little bit messed up table with very important information. This table has information a...

Puzzles no. 424–418PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #414I wonder if you know that big ships has identification number just like cars. This number i...

In the boundless expanse of the data universe, the quest for the ultimate tool to navigate the complexities of information has led us to Quarto, the newest starship in our fleet. This vessel is not just an upgrade to our previous crafts but a revolutionary leap forward, designed for the ...

#165–166PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #165Today we get table with data which we suppose to transform into shape of Excel Pivot Tables (aka Cross...

Puzzles no. 409–413PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #409This puzzle is like splitting rock. Sometimes tables in Excel and other documents have merg...

Launching the Starship: An Introduction to QuartoIn the cosmic expanse of data science tools, a new starship has been unveiled — Quarto. Crafted from the essence of RMarkdown, Quarto is engineered to explore further, integrating more seamlessly with the universe of languages and tools used in data science, and providing a ...

#163–164PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #163Some puzzle we receive are based on recognizing and checking certain patterns. I remember checking IPv...

Puzzles no. 404–408PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #404Can analyst make something that looks good? Of course… Can analyst draw with numbers? Once ...

Welcome to the next chapter in our exploration through the Enchanted Forest of Data, where the path becomes less trodden and the magic, more profound. As we delve deeper into the arcane arts of RMarkdown, we uncover tools and spells capable of transforming the complex into the captivating, the overwhelming ...

#161–162PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #161This week comes with some of hardest challenges I faced on ExcelBI series. It was looking pretty straightforward, but later I realised what is going on. One of ...