johnmackintosh.net 23. 5. 2024Metallica tour history with R and PowerBI – johnmackintosh.net 15. 3. 2024Resolving errors connecting PowerBI to Linux version of MS SQL Server – johnmackintosh.net 6. 2. 2024new programming with data.table – johnmackintosh.net 3. 2. 2024more .I in data.table – johnmackintosh.net 3. 1. 2024.I in data.table – johnmackintosh.net 22. 12. 2023non-equi joins in data.table – johnmackintosh.net 22. 12. 2023Newsletter news – johnmackintosh.net 7. 12. 2023That’s a (W)RAP! – johnmackintosh.net 8. 10. 2023checks and {tiny}testing - a quick primer – johnmackintosh.net 17. 8. 2023Create your first Excel LAMBDA function – johnmackintosh.net 21. 5. 2023Achieve your target – johnmackintosh.net 19. 2. 2023Pivoting in tidyr and data.table – johnmackintosh.net 5. 2. 2023Fixing my broken VSCode setup for R – johnmackintosh.net 27. 1. 2023Making headlines – johnmackintosh.net 15. 12. 2022On target – johnmackintosh.net 28. 9. 2022Word Up – johnmackintosh.net 23. 9. 2022Cover Up – johnmackintosh.net 7. 9. 2022(h)appy with lapp(l)y – johnmackintosh.net 14. 6. 2022Exploring your database with shiny – johnmackintosh.net 28. 4. 2022Purrr Sql – johnmackintosh.net 7. 4. 2022Dynamic schema, table and column names in SQL Server queries as a gateway to functional programming with R – johnmackintosh.net 14. 3. 2022Dual axis charts - how to make them and why they can be useful – johnmackintosh.net 8. 3. 2022Getting to know Julia – johnmackintosh.net 8. 2. 2022Separate SQL – johnmackintosh.net 3. 2. 2022Inverness street maps – johnmackintosh.net 3. 2. 2022What song lyric sentiment analysis doesn’t tell you – johnmackintosh.net 26. 1. 2022UK Energy company acquisitions - a great use case for Sankey plots – johnmackintosh.net 6. 1. 2022Enjoying the process of making tables in R using {reactable} and {reactablefmtr} – johnmackintosh.net 5. 1. 2022I invented something better than wordclouds. True or False? – johnmackintosh.net 28. 11. 2021I got my first package onto CRAN, and YOU CAN TOO – johnmackintosh.net 23. 11. 2021Shooting Stars – johnmackintosh.net 20. 11. 2021cusumcharter available on CRAN – johnmackintosh.net 5. 11. 2021Scheduling Rmarkdown files on Windows - your foolproof guide – johnmackintosh.net 21. 10. 2021Pass parameter to SQL Server DATEADD function using R – johnmackintosh.net 13. 10. 2021Scheduled Refresh - a surprisingly simple fix – johnmackintosh.net 13. 10. 2021PreppinData - accepting the challenge with R and PowerBI – johnmackintosh.net 6. 10. 2021fwf without the faff – johnmackintosh.net 5. 10. 2021Join the cult – johnmackintosh.net 17. 9. 2021Calculating hotel occupancy with R – johnmackintosh.net 13. 8. 2021Well Well Well my Excel – johnmackintosh.net 9. 8. 2021Cutting down code in dplyr and data.table – johnmackintosh.net 28. 3. 2021Introducing popthemes – johnmackintosh.net 28. 3. 2021Some data.table tips – johnmackintosh.net 18. 3. 2021Scheduled Refresh - a surprisingly simple fix – johnmackintosh.net 4. 2. 2021PreppinData - accepting the challenge with R and PowerBI – johnmackintosh.net 23. 12. 2020demystifying the coalesce function – johnmackintosh.net 29. 11. 2020collapse might rock your world – johnmackintosh.net 29. 11. 2020Defending the indefensible – johnmackintosh.net 26. 11. 2020NHS-R Community Conference 2020 – johnmackintosh.net 28. 10. 2020Getting started with network plots – johnmackintosh.net 7. 10. 2020The day after – johnmackintosh.net
23. 5. 2024Metallica tour history with R and PowerBI – johnmackintosh.net 15. 3. 2024Resolving errors connecting PowerBI to Linux version of MS SQL Server – johnmackintosh.net 6. 2. 2024new programming with data.table – johnmackintosh.net 3. 2. 2024more .I in data.table – johnmackintosh.net 3. 1. 2024.I in data.table – johnmackintosh.net 22. 12. 2023non-equi joins in data.table – johnmackintosh.net 22. 12. 2023Newsletter news – johnmackintosh.net 7. 12. 2023That’s a (W)RAP! – johnmackintosh.net 8. 10. 2023checks and {tiny}testing - a quick primer – johnmackintosh.net 17. 8. 2023Create your first Excel LAMBDA function – johnmackintosh.net 21. 5. 2023Achieve your target – johnmackintosh.net 19. 2. 2023Pivoting in tidyr and data.table – johnmackintosh.net 5. 2. 2023Fixing my broken VSCode setup for R – johnmackintosh.net 27. 1. 2023Making headlines – johnmackintosh.net 15. 12. 2022On target – johnmackintosh.net 28. 9. 2022Word Up – johnmackintosh.net 23. 9. 2022Cover Up – johnmackintosh.net 7. 9. 2022(h)appy with lapp(l)y – johnmackintosh.net 14. 6. 2022Exploring your database with shiny – johnmackintosh.net 28. 4. 2022Purrr Sql – johnmackintosh.net 7. 4. 2022Dynamic schema, table and column names in SQL Server queries as a gateway to functional programming with R – johnmackintosh.net 14. 3. 2022Dual axis charts - how to make them and why they can be useful – johnmackintosh.net 8. 3. 2022Getting to know Julia – johnmackintosh.net 8. 2. 2022Separate SQL – johnmackintosh.net 3. 2. 2022Inverness street maps – johnmackintosh.net 3. 2. 2022What song lyric sentiment analysis doesn’t tell you – johnmackintosh.net 26. 1. 2022UK Energy company acquisitions - a great use case for Sankey plots – johnmackintosh.net 6. 1. 2022Enjoying the process of making tables in R using {reactable} and {reactablefmtr} – johnmackintosh.net 5. 1. 2022I invented something better than wordclouds. True or False? – johnmackintosh.net 28. 11. 2021I got my first package onto CRAN, and YOU CAN TOO – johnmackintosh.net 23. 11. 2021Shooting Stars – johnmackintosh.net 20. 11. 2021cusumcharter available on CRAN – johnmackintosh.net 5. 11. 2021Scheduling Rmarkdown files on Windows - your foolproof guide – johnmackintosh.net 21. 10. 2021Pass parameter to SQL Server DATEADD function using R – johnmackintosh.net 13. 10. 2021Scheduled Refresh - a surprisingly simple fix – johnmackintosh.net 13. 10. 2021PreppinData - accepting the challenge with R and PowerBI – johnmackintosh.net 6. 10. 2021fwf without the faff – johnmackintosh.net 5. 10. 2021Join the cult – johnmackintosh.net 17. 9. 2021Calculating hotel occupancy with R – johnmackintosh.net 13. 8. 2021Well Well Well my Excel – johnmackintosh.net 9. 8. 2021Cutting down code in dplyr and data.table – johnmackintosh.net 28. 3. 2021Introducing popthemes – johnmackintosh.net 28. 3. 2021Some data.table tips – johnmackintosh.net 18. 3. 2021Scheduled Refresh - a surprisingly simple fix – johnmackintosh.net 4. 2. 2021PreppinData - accepting the challenge with R and PowerBI – johnmackintosh.net 23. 12. 2020demystifying the coalesce function – johnmackintosh.net 29. 11. 2020collapse might rock your world – johnmackintosh.net 29. 11. 2020Defending the indefensible – johnmackintosh.net 26. 11. 2020NHS-R Community Conference 2020 – johnmackintosh.net 28. 10. 2020Getting started with network plots – johnmackintosh.net 7. 10. 2020The day after – johnmackintosh.net