Testing out DALL-E 2

I was recently granted access to DALL-E 2, the impressive new AI system that can generate images from text prompts.

I don't have anything technical to say about it, I just wanted to share some of the incredible images it has produced. If you'd like to know more about it here are some links;

Anytime you enter a text prompt and click generate you are presented with six versions of your request, see below for a close up of a pizza.

Here is another example of the six different images Dalle-2 generates for each request you submit.

You can specify the style of the image, or it will make an assumption about which style might be more appropriate. For the hippos above, I did not specify that they should be a cartoon, but Dall-e made assumed that a cartoon style would be the best approach. Similarly for a man walking in the street in Khayelitsha, South Africa it chose a very photo realistic approach.

I've chosen some of the nicest images generated so far to include below. Enjoy!

Images I generated from text prompts using Dall-E 2

A watercolor painting of Toronto generated by Dall-E 2
A watercolor painting of Toronto
The space Shuttle floating in the sky above Cape Town, South Africa, polaroid generated by Dall-E 2
The space Shuttle floating in the sky above Cape Town, South Africa, polaroid
An aircraft carrier on the lake, in front of the Toronto skyline, digital art generated by Dalle-2
An aircraft carrier on the lake, in front of the Toronto skyline, digital art
A raccoon fortune teller, digital art generated by Dall-e-2
A raccoon fortune teller, digital art
An astronaut walking on mars, watercolour painting generated by dalle 2.0
An astronaut walking on Mars, watercolour painting
An alien spaceship hovering over Table Mountain digital art generated by Dalle 2
An alien spaceship hovering over Table Mountain digital art
raccoon with the toronto skyline in background disney animation generated by Dalle2
A raccoon with the Toronto skyline in background, Disney animation
A Matisse painting of a blue jay and a cardinal
A spaceship hovering above Toronto skyline, digital art
A possum, a skunk, a raccoon and a blue jay having a picnic together, album cover art
The statue of Liberty fighting with Godzilla with the New York skyline in the background

How to make a simple Crytpocurrency Price report in Google Data Studio

How to make a simple Cryptocurrency Price report in Google Data Studio

If you own some cryptocurrencies across multiple exchanges or platforms, you might want a report that shows various cryptocurrency prices in one report. In this article I'll show you how to build a simple report using Google Sheets and Google Data Studio that allows you to see the latest prices and value of the various Cryptocurrencies you own.

Read more


How to build a simple Bitcoin and Ethereum dashboard in Google Data Studio

How to build a simple Bitcoin and Ethereum dashboard in Google Data Studio

In this post I'll show you how to make a simple dashboard that lets you monitor the price of two of the most popular Cryptocurrencies; Bitcoin and Ethereum.

All you need is;

Read more


How to combine string fields in Google Data Studio

How to combine string fields in Google Data Studio

Have you ever needed to combine string fields in Google Data Studio? I tried to do it the other day and it was more difficult than expected.

In this post I'll show a method that solves how to combine different string fields into one field. This method is from Harry Bryars whom you can follow on Twitter or Medium. He was kind enough to show me this method!

Looking at the hypothetical Data Set

So in this hypothetical data set we have a list of tourist names in Column A and then the country they visited in each year, listed as five seperate columns. You'll notice that many cells are blank as some tourists did not travel to countries in some of the years. or in some cases no countries.

The First attempt at Combining the strings

So the first attempt at combining the strings seems like an obvious solution.

Use the CONCAT function to combine all the strings together, as shown below.

Here is the actual CONACT formula if you want to try it yourself.

CONCAT(Country 2015,", ", Country 2016,", ", Country 2017,", ", Country 2018,", ", Country 2019)

And below is what the formula displays in our Data Studio report. You'll notice that if all the fields (columns) contain a country then the formula works as intended and combines the countries into a list.

However if one of the columns has no county listed and is null then the formula doesn't work.

Second attempt at combining the strings

This is the second version for the formula from Harry Bryars that worked!

So it uses multiple CASE statements to insert a "_" when the column value is null, and otherwise lists the country.

Below is how the formula show look.

Here is the actual formula if you'd like to try replicate this with your own data source.

CONCAT
(CASE WHEN Country 2015 IS NULL THEN "_" ELSE Country 2015 END,", ", 
CASE WHEN Country 2016 IS NULL THEN "_" ELSE Country 2016 END,", ", 
CASE WHEN Country 2017 IS NULL THEN "_" ELSE Country 2017 END,", ", 
CASE WHEN Country 2018 IS NULL THEN "_" ELSE Country 2018 END,", ",
CASE WHEN Country 2019 IS NULL THEN "_" ELSE Country 2019 END,", "
)

Below in the final column you can see that we have the formula working close to how we would like it to.

Below is the actual Google Data Studio report if you'd like to take a look.



My Other Blog posts

If you enjoyed this post then you might like my other blog posts.


How to map Growth in Google Analytics sessions by Country in Data Studio

Google Data Studio has always had the ability to add in a comparison column to tables, but not to map out a change in values on a map. Ideally I would want to be able to see which countries have seen the highest rates of growth over a period of time. This is a method that worked for me and hopefully it will be useful for you too!

Read more


Comparing Cape Town and Toronto - Copy

Comparing Cape Town and Toronto

In this post I'll compare and contrast some things comparing Cape Town, South Africa with Toronto, Canada!

🇿🇦 🇨🇦

Read more


How to use DATE_DIFF in Google Data Studio to work out Sessions per Day

How to use DATE_DIFF in Google Data Studio to work out Sessions per Day

So one thing I've wanted to do for a while is to determine how many sessions each blog post has had since they were published. Since the URLs of my blog posts contain the date they were published, I tried to work this out using regex and some other methods. It got a bit messy and wasn't very accurate.

Read more


Change Bubble Size and Colour in a Google Data Studio Map using Parameters

Change Bubble Size and Colour in a Google Data Studio Map using Parameters

In this post I'll show how you can change Bubble Size and Colour in a Google Map in a Data Studio report. This method using two parameters to let you switch between which metrics are displayed on the map.

Read more


How to combine data from two BigQuery public datasets using SQL

How to combine data from two BigQuery public datasets using SQL

So in this blog post I'll show how you can combine data from two BigQuery public datasets using SQL and to visualize the data in Data Studio.

Read more


Mapping Canadian Provinces and US States in Google Data Studio

Mapping Canadian Provinces and US States in Google Data Studio

So something I've been interested in doing for a while is mapping Canadian provinces and US states in Google Data Studio. New features added to Google Data Studio have allowed me to do that and I'll give you a quick overview of how you can build something similar in Data Studio.

Read more