royce wells

Hey, I’m Royce

I’m an American expat currently living in Lomé, Togo.

I work as strategist at CI&T focused on analytics and data architecture. I also manage an investment fund focused on West Africa businesses.

If you’re interested in talking or working together, you can reach me over email or on Twitter.

SQL basics for Tableau and Redshift

Wednesday, September 15, 2021 · 7 min read

There is something about not reading a manual or taking a walk through the basic documentation when learning a piece of software that is rewarding yet very painful. True to form, I jumped into creating a Tableau dashboard without much prior knowledge of Tableau or SQL. Here are some things I wish I would have known when starting the work.

Read On →

How to Install dapptools on an M1 Mac

Saturday, August 7, 2021 · 3 min read

I ran in to some issues trying to install dapptools on my M1 MacBook Air. The project helpfully explains that you have to run dapptools and the installer under Rosetta 2. But it took me a few tries to get it right and there wasn’t a clear explanation of the complete steps, so recording those here.

Read On →

Speculation, Innovation and a Gold Rush

Tuesday, July 27, 2021 · 5 min read

In the 1850s, San Francisco’s Daily Herald reported that “No day so gloomy has been witnessed in San Francisco since that disasterous fire of the 4th of May, 1851. Every bank was said to have suspended, and rumors of mercantile failures-most of them false, we are glad to say-came thick and heavy in the afternoon.” From Hard Money to Branch Banking: California Banking in the Gold-Rush Economy

It was the culmination of years of credit speculation and growth driven by the California Gold Rush. Growing up in California, the gold rush takes on a bit of mythical grandeur in the history of the state. Less talked about was that the gold rush was financed with tons of speculation. Then in the aftermath of a short lived boom the nascent financial system quickly collapsed. The companies and financial infrastructure that were left became the foundation of San Francisco as the finance hub of the American West.

Read On →

El Salvador's Bitcoin Experiment

Thursday, June 10, 2021 · 3 min read

Yesterday El Salvador passed a law that makes Bitcoin legal tender in the country. Here’s a brief overview of some potential consequences.

Read On →

More Emergent Features on Twitter

Wednesday, May 5, 2021 · 5 min read

Twitter continues to evolve it’s product with emergent features, this time taking on direct payments to creators.

Read On →