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?
Let's face it - few analysts are lucky enough to work with clean data, obtainable from a single database. I certainly wasn't among the lucky few when I was working as a Reporting Analyst, which meant that before I was even able to produce a standard Excel report, required on an ongoing basis, I had … Continue reading How Do I Quickly Update User Paths?
Can you give me a list of all the product information that we hold for these products? As a Business Analyst, that is a fairy simple question to answer - just a matter of a couple of joins and a where-clause. What could make it annoying and unnecessarily time-consuming, however, is the necessity to use … Continue reading How Do I Quickly Enclose String in Quotes?
I want to remove all the hyperlinks in my spreadsheet That's super easy - just right click on the column with the hyperlinks and click "Remove Hyperlinks". A problem arises when you want to add them quickly back in, as there is, unfortunately, no option of doing so, other than right-clicking on a link after … Continue reading How Do I Add/Remove links with VBA?