PowerQuery Puzzle solved with R

July 2, 2024 | Numbers around us

#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 ...
[Read more...]

A wrapper for the Climate Data Operators in R

July 1, 2024 | Code R

Today I’m extremely happy because I’ve finally been able to fulfil a dream of mine. And yes, by the end of this blogpost you might be worried about me for having such a weird, niche and, frankly, dumb dream, but I swear I’m fine! My dream was ...
[Read more...]

R Solution for Excel Puzzles

July 1, 2024 | Numbers around us

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 ...
[Read more...]

How to avoid empty line charts

June 29, 2024 | Albert Rapp

Have you ever tried to create a line chart with ggplot only to find that the chart remains blank and a warning showing up that each group consists out of one observation? That’s a common struggle and I used to attempt a lot of trial and error to...
[Read more...]

Introduction to Standardization in Business Reporting

June 27, 2024 | Numbers around us

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 ...
[Read more...]
1 37 38 39 40 41 2,160