Not enjoying Data Analyst Job
I have been a data analyst for 8 months now and I have to second guess all my analysis and dashboards. The data I get is “corrupt”.
For example in 2023, our data was categorized into 3 tiers (1,2,3). In 2024 they changed this to (a,b,c,d). Guess what? In 2025 they are changing them again. Unfortunately it is impossible to have some logic convert all of these tiers . It largely requires a manual read of all the data . There are around 1.2 million rows of data.
This is one example of my departments data integrity issues. What can I do to start fresh with my data analysis ? A data quality dashboard? The only problem with this is it wouldn’t be fully automated. How can I ensure all the data is correct when I run reports ?