Written by GoodData Author |
How do natural disasters influence GDP and birth rate? Is the number of UFO sightings related at all to alcohol consumption in the U.S? Is there a correlation between natural disasters and UFO sightings or GDP? Do aliens always travel around the universe in flying saucers?
You’re probably wondering what all these random questions have to do with GoodData, a super stellar platform designed to solve all your data analytics needs. From our work as Support Representatives, Denis and I have seen our lot of interesting, insightful reports and dashboards spanning business topics such as Sales, Marketing, and Customer Support. However, at times it can be hard to get excited about numbers when they aren’t exactly addressing sexy or enticing subjects. That’s why when Denis and I were presented with the opportunity to work together and create our own project, we decided to go outside the box and connect seemingly unrelated but equally fascinating topics.
This idea first originated when we were choosing data sources. I essentially made a long list of 6 or 7 sources which I found thrilling and easy to work with. Rather than choosing one or two amongst them, Denis and I began to see patterns that would allow each data source to build upon and add more complexity to the next. Before getting too overzealous, we mapped out exactly what we were looking to learn from each source and from the project overall. What resulted was the questions you see above. In order to fully understand the processes, Denis and I will discuss our individual experiences.
I liked Nicole's idea very much and thought about how cool would it be to tie it all together and have a detailed look at the data. I was especially interested in observing the correlation between UFO sightings and other events around the world. But first things first – we needed to model and load the data.
Once I examined the data sets, a few problematic areas were identified. I needed to clean up the data and do a few transformations in order to load it onto the platform.
After completing the cleanup, it wasn't difficult to connect everything and load the data. I used a separate data set that contained just the countries' names and codes to easily reference all the data sets and enable reporting across all of them. Here's the final data model:
All in all, this was an exciting project to work on and as it usually happens I was able to learn a few interesting tricks.
Stay tuned for a more technical deep dive of Denis’s work.
Once Denis had defeated all our Cloud Connect obstacles, it was time for me to start building out the UI. I quickly discovered that first planning the flow and content of each dashboard tab was far more efficient than rapidly trying to make as many reports as possible. Knowing that the individual disasters were at the core of our project, I made sure that each new factor I introduced, such as birth rates or alcohol consumption, was able to connect back to the disasters dataset. What resulted was a series of interesting graphs and trends that shed some light on how natural disasters affect the world around us.
Part 2 of this blog series coming soon: Dashboards, Insights & Analysis from this GoodData Project.
Written by GoodData Author |