Most of the sharing is done by old people, not young people. People over 65 shared fake news at a rate seven times higher than young people 18–29. This factor held across controls for education, party affiliation and ideology, sex, race, or income.
… initial sources that we set-up in the data warehouse was to have the read-only replica of the production database saved under a schema named prod (more on our naming convention later). Since Amazon offers a database syncing service that allows us to output data from a schema to another schema of a different database, this was a simple change for us. The fact that our data analyst could now run long queries without impacting customer experience on Glossier.com was a big win in and of itself.
As this was not scalable, we gradually migrated towards a tool called Looker in 2016. This platform allows us to easily query our databases without most of the Excel hassle that you may be familiar with. Looker acts as a presenter layer on top of your data and abstracts SQL, allowing you to define your own objects and query them fairly easily. It also offers the possibility to visualize your data without having to know much about how everything works behind the scenes, thus allowing multiple departments to fetch their own set of answers.