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?