If you are building dashboards in and and tool like Tableau, Power BI you will be tempted to query the Google Analytics API directly using some built-in connector. This might seem really nice for a while, until you discover sampling, the distinct count challenge, retroactive changes to goals.
In this series I will try to show this issue by example. The first issue is counting the Users metric correct.
I have built a dashboard to show you the problem.