The Journey to OOP in RIn the world of programming, embarking on the path of Object-Oriented Programming (OOP) is akin to boarding a high-speed train towards more structured, efficient, and maintainable code. As we continue our series, our next stop is...

Excel BI’s Weekend PQ Puzzles SolutionsUntil this time I didn’t really look on PowerQuery Puzzles of ExcelBI, which he publishes every weekend. But after making some posts about Excel Puzzles, I realized that PQ ones are equally if not more interesting...

Week 46 — Puzzles no. 323–328First time after few weeks I decided to slightly change my way of publishing this format of content. I used to publish daily, then every 2 or 3 days, but I realized that summary of all puzzles weekly will be my way.Host of ...

The Need for Speed in RIn the realm of data science, where the landscape is ever-changing and data volumes are incessantly swelling, speed and efficiency in processing aren’t mere conveniences — they’re indispensable. As we unveil the second chapter of our series, we turn the spotlight onto a crucial ...

Excel BI’s Excel Challenge #322— solved in RDefining the Puzzle:Let’s talk about money. We have list of employees, and their salaries. We have to find who’s salaries are closest to average of this list.Find the top 3 employees whose salary is nearest t...

Excel BI’s Excel Challenge #321 — solved in RDefining the Puzzle:Soccer came back to play. According to matches rusult we have to find which matches has biggest difference in goals scored. In task we see question for 3 matches, but in solution we see 4...

Slide, Scan, Sum — Find the largestExcel BI’s Excel Challenge #320 — solved in RDefining the Puzzle:Current puzzle seems not hard, need few minutes to solve. Our host gave us sequence of numbers, both positive and negative and ask to find largest sum i...

Setting the Scene with Data QualityIn the multifaceted realm of data science, ‘quality’ isn’t just a desirable attribute, it’s the bedrock upon which all subsequent analysis is built. Think of it as the foundation of a house. Without a solid base, no matter how grand your designs or ...

Excel BI’s Excel Challenge #319 — solved in RDefining the Puzzle:We need to find which from given numbers are “more powerful” than others which means as follow:List all Powerful numbers.A powerful is number is that number which is perfectly divisible b...

Excel BI’s Excel Challenge #318 — solved in RDefining the Puzzle:Now we are asked to find sum of small series which value and number depends on input number itself. Sounds weird but it was suprisingly easy and nice.Find the Sum of the Series — 1*2*3 + ...

Excel BI’s Excel Challenge #317 — solved in RDefining the Puzzle:Today we are move single letters from starts to end of words. But with some exceptions.Swap the first and last letter of each words in given names. But if either first or last letter or b...

Excel BI’s Excel Challenge #316 — solved in RDefining the Puzzle:Probably everyone of us have heard of Fibonacci Numbers. It is a sequence that property is that next number is a sum of two previous. But this time ExcelBI asked us to generate… first 20 ...

Excel BI’s Excel Challenge #315 — solved in RDefining the Puzzle:Unlike title suggests, today our task is not to manipulate planets, but to remove from our target texts all characters that are in the Solar System planets and Sun.Remove the English lett...

Excel BI’s Excel Challenge #314 — solved in RDefining the Puzzle:This puzzle is searching Atbash Palindrome.ATBASH Palindrome — In ATBASH cipher, we replace a with z, b with y, c with x…..y with b, z with a.Find those texts which are palindrome after d...

Excel BI’s Excel Challenge #313 — solved in RDefining the Puzzle:Today we need to transform table into its cummulative (someway) version. Every column have to include content of column lagged by 2.Generate the result table.Here, Tn = T(n-2) & Tn wh...

Excel BI’s Excel Challenge #312 — solved in RDefining the Puzzle:In current puzzle we need to check if digits of our numbers has some magic properties. Seems easy, but it is not usually the case, when ExcelBI prepare riddle.List all Sumproduct numbers ...

Excel BI’s Excel Challenge #311 — solved in RDefining the Puzzle:In puzzles and riddles from ExcelBI we usually play with numbers or words, why not both at once. Lets dive into the newest one.We need to sort digits in numbers written by numerals :-)Sor...

Excel BI’s Excel Challenge #310 — solved in RDefining the Puzzle:It was early Monday morning when hunt for Fridays come up. Of course new riddle about Fridays 13th.Task was really short yet challenging: Find the next 3 Friday the 13th dates for dates g...

Excel BI’s Excel Challenge #309 — solved in RDefining the Puzzle:The newest puzzle by ExcelBI is going from words to books. I need to construct script which convert ISBN10 into ISBN13 number. Those number are used to identify books internationall. How ...

In the diverse universe of data analysis, one often finds themselves in the role of an intrepid treasure hunter. Picture the gold rush era, with miners sifting through endless sands and dirt, eyes alight with the thrill of discovery, and hands eager to unearth the gleaming rewards of their relentless ...