Has any of you used JIRA as an analysis documentation tool? My team has decided that apart from managing the regular sprint planning, we're also going to be keeping track of changes made to Tableau datasources in JIRA. This also meant that all additional calculations that had been added to a datasource on top of … Continue reading How do I quickly add extra characters to a cell?
When I was working as a Reporting Analyst, I was responsible for generating the monthly EMEA Delivery Management scorecards, whose results would get discussed in a day-long meetings between all senior management members One of the major issues with these scorecards when I inherited them was that there was no consistent way of regularly feeding … Continue reading How Can I Quickly Zap the Formulas in a cell range?
Do you remember the 7 most common data integrity problems? 4 of them needed business expertise and 3 of them were immediately solvable. If you only have Excel in your toolkit, here's a quick way in which you can address them in a relatively painless way: (2) same person, different spellings (e.g. TENEVA ANGELINA in … Continue reading How do I quickly re-map values with VBA?
25th May is approaching fast and so is GDPR. For those of you who are not yet aware - GDPR is a EU-wide regulation on the handling of privacy data A potential implication for all data analysts is that they may have to take extra precautions as to who can access the data they provide … Continue reading How Can I validate if a user is authorized to view certain data or not?