Blog Posts

Why Move Data from Excel to a Relational Database?

excel vs database, database vs spreadsheet advantages and disadvantages, database vs spreadsheet comparison table, difference between excel and database, why is a database more versatile than a spreadsheet, compare and contrast databases and spreadsheets, why is excel not a database, is excel a database, access vs excel

Excel allows business professionals to unlock the potential of their data – to a point. But when it comes to storing and manipulating large amounts of data, Excel can cause some problems. Excel has many good points. It’s often used by specialists to work with data related to their particular field. But it can come with problems, such as sluggish performance and difficult team collaboration. Even worse, Excel is vulnerable to the most dreaded problem of all: the accidental deletion of

Continue Reading

How not to show data on a π chart

Today’s March 14th, also known as PI Day. Mathematicians rejoice! π is a constant — the ratio of a circle’s circumference to its diameter — and it’s used in many different formulas. Baking and eating pies is super popular on this day — ’cause, you know, people just love their homophones. Today’s not Anna’s day, though. See, Anna hates math, and she’s terrible at making pies. And the one thing that’s worse than her cooked pies are her pie charts

Continue Reading

Data Visualization for Your Business: Does it Really Matter?

Our world is bursting with data—the new digital age has dynamically inflated the volumes of data collected by businesses worldwide. By 2020, about 1.7 megabytes of new information will be created every second for every person on the planet. According to Forbes, The White House has already invested more than $200 million in big data projects. Can you imagine that? Seriously! Yet all the data that’s being generated by people, machines, online devices, and other sources doesn’t provide decision-makers with

Continue Reading

Here’s Why You Should Learn SQL

We asked our users why they decided to learn SQL. The results are clear. At Vertabelo Academy, we help people with no computer science background to understand the core concepts of databases and data science. For example, we teach users how to extract the most important data from a database to build simple reports and how to understand key statistical metrics in data analysis. We love to provide easy-to-understand examples that thoroughly depict complex technical concepts. Why? Because we’re good

Continue Reading

Learning to Think in SQL

Learning to think in SQL will help you understand what SQL queries do, how to create and change them, and how to create reports from the data you obtain. One of the greatest skills you can have in SQL programming is this the ability to change an existing SQL query so you get the results you need. When you are first starting out, you likely will not create SQL queries from scratch but rather reuse what others have written. Thus,

Continue Reading

My Very First Script

Valentine’s Day is over but I’m still in the mood. We recently published a story from a Vertabelo Academy user who found her love thanks to SQL. On a similar note, I asked my colleagues to bring back old memories of writing their very first scripts. And yes, love is involved. Here at Vertabelo Academy, we’ve got some real OG programmers and data scientists making great content. They fell in love with data way before it was cool—and easy. So

Continue Reading