Publications by Numbers around us
Keep It Simple: Extracting Value from the Noise of Data Overload
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...
19793 sym 4 img
PowerQuery Puzzle solved with R
#217–218PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #217Turn around, transpose, pivot it all means almost the same. Like table asked us to spin itself around. Let get back to math maybe. We have table containing rate (maybe daily rate) for each person a...
1738 sym R (1171 sym/6 pcs) 16 img
R Solution for Excel Puzzles
Puzzles no. 539–543PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #539Many companies have to diversify their source of resources, to optimize prices etc. So they usually have their orders somehow mixed between vendors. In this case we need to assume that ...
2854 sym R (3389 sym/15 pcs) 34 img
Express to Impress: Leveraging IBCS Standards for Powerful Data Presentations
Attention: Article looks long at word count, but remember that contains pretty long chunks of code.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 n...
29767 sym R (10936 sym/15 pcs) 34 img
PowerQuery Puzzle solved with R
#215–216PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #215Today we have to do something that I really don’t like to do: constructing tables with esthetical structure, when esthethic is primarly for person reading and not having any knowledge bringing pu...
1670 sym R (1535 sym/6 pcs) 16 img
R Solution for Excel Puzzles
Puzzles no. 534–538PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #534Palindromes and other symetric numbers are pretty common them of our challenges, but this twist we have today, is pretty unique and hard in the same moment. First time we have to find n...
3184 sym R (3335 sym/16 pcs) 36 img
Guarding Against Misleading Data
The IBCS ‘Check’ PrincipleIn the complex world of business intelligence (BI), the ability to present data accurately and transparently is critical. Whether crafting a dashboard for executive decision-making or generating a report for operational analysis, the clarity and honesty of data visualization can make or break the effectiveness of the m...
26511 sym R (11326 sym/18 pcs) 38 img
PowerQuery Puzzle solved with R
#213–214PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #213Two warehouses gave us some summary, but products there are sometimes in packages, sometimes in batches. So we need to find out how many products and groups are in both warehouses. So we need to me...
1480 sym R (1001 sym/6 pcs) 16 img
R Solution for Excel Puzzles
Puzzles no. 529–533PuzzlesAuthor: ExcelBIAll files (xlsx with puzzle and R with solution) for each and every puzzle are available on my Github. Enjoy.Puzzle #529Today we need to look for some numbers and sum it up. So what is the problem? We have numbers without signs, but also some with minuses and pluses both before number and after it. So we...
2753 sym R (4619 sym/15 pcs) 34 img
Condense: Enhancing Reporting Efficiency through IBCS Standards
In today’s data-driven world, the ability to present information clearly and efficiently is essential across various fields, from business to academia. As the volume of data continues to grow, the importance of well-structured and easily interpretable reports becomes increasingly critical. This series on adapting the International Business Commun...
22439 sym R (10983 sym/8 pcs) 20 img