Back to articles list October 12, 2018 - 5 minutes read How SQL supports data-driven organization Aldo Zelen Aldo is a data architect with a passion for the cloud. From leading a team of data professionals to coding a data warehouse in the cloud, Aldo has experience with the whole lifecycle of data-intensive projects. Aldo spends his free time forecasting geopolitical events in forecasting tournaments. Tags: data-driven organization get started learn sql SQL basics Typical business users make decisions based on gut feelings, but this can't get them so far. In this article, we'll look at how learning to write basic SQL queries helps your company become a data-driven organization. Businesses face many decisions. Do we increase our advertising budget in one region or the other? Are certain products selling quickly enough? What we should do if they aren't? Most of these decisions are driven by intuition, but organizations that make the most business impact use data-driven decision-making. To start, let's first look at the types of data that organizations collect and use. Types of data used by organizations Organizations have data lying in various data silos. The number and flavor of these silos depend on your organization's area of specialization. Example 1: If you're working for a small web retailer, then your only data source is likely your website's database, with a multitude of spreadsheets that various employees produce to handle their day-to-day work. Example 2: If you're working for a large enterprise company like an insurance company, you will have many heterogeneous data from different departments—accounting, sales, HR, and others. All of this data needs to be centralized. Example 3: Perhaps you're working for a company that is a mixture of these two—one that has classical processes but a strong web presence. Here, your data may or may not be centralized. Decision-makers may opt to implement data-driven processes only in some departments. Tying the data together Organizing all this data is a major endeavor that usually results in a centralized data store. Data stores are a repository of the organizational data specifically built for reporting and analytical purposes. They come in two forms: operational data stores and data warehouses. The difference lies in data historization: Operational data stores house unified data of the company at a point in time; data is usually collected in near-real time, and typical users are operational CRM teams. Data warehouses, on the other hand, house data that is historized and collected in batches, during a fixed time slot of the day. Organizations that are on the path to becoming more data driven tie their data together in a data store. This process is known as data integration. When looking at data-driven decisions in huge enterprises, a business intelligence maturity model is compared against a benchmark to see where the organization stands in relation to how its current business processes fulfill its desired functions. The more an organization is mature, the more its processes are supporting complex and challenging business goals. Data-driven organization is by definition highly mature. Here's an example of a business intelligence maturity model from Gartner. If you're low on the maturity scale, don't fret. Small businesses can still make good data-driven decisions. It's not the size of the data that matters—it's how you use it. How to identify important data Data with the most relevant business value is naturally the most important data. So If your organization places more emphasis on growth, then marketing data is the most important. On the other hand, if you are highly regulated, then perhaps the most important data is plain old accounting data. Now that you've identified the sources of data you will use to make informed decisions, what do you do next? You can certainly dump your data into spreadsheets and use various functions there, but this approach is often inefficient and inflexible. A more professional and popular approach is to write SQL queries. How does SQL help make data-driven decisions? What would a typical setup look like for your decision analysis if you have one data silo? First, you should identify all the data entities in your relational database (or databases). Entities in databases are represented with tables, so you need to find the tables that hold the data you need. Here are just a few examples of business data that can be represented as tables in a relational database: Customer information Store locations Website sales Business expenses By querying this data, you can answer relevant business questions—and perhaps uncover new questions that need answering. Use of SQL in marketing: a real-world example Look at a simple example of how to use SQL in marketing. Let's say you're working for a marketing department and need a good metric to calculate the churn of your advertising, audience, and funnel. The information of your churn, when compared with your industry's churn, will guide your decision-making. For example, are you experiencing slowdowns at some stage of the funnel? First, you need to identify your reach. To calculate reach, some advertising channels will show us exact numbers (e.g., the number of views on YouTube), but some will not. For example, if we are not the owners of the website, we cannot know how many views a certain blog post has. This is where our gut feeling can come in. By using a heuristic—i.e., a rule of thumb—we can define a fixed number to approximate our reach in a certain channel. Let's say our gut feeling tells us that the whole blog channel has a reach of 1000 views per post. We'd define this reach in SQL like so: SELECT CASE WHEN channel = 'blog' THEN 1000 ELSE reach END modified_reach FROM media_reach; With a well-defined reach, you can now expand your analysis to answer other question: In what countries do we have the most reach? SELECT country.name,SUM(CASE WHEN channel = 'blog' THEN 1000 ELSE reach END) sum_modified_reach FROM media_reach JOIN country ON (media_reach.country_id = country.id) GROUP BY country.name ORDER BY 2 desc; Of course, this is just a single example of how SQL can help you answer business questions. SQL is a powerful language with plenty of possibilities. If you don't know SQL yet, it's just about time. Where to go from here Data stores and business goals Business maturity and maturity models SQL's importance in data-driven decision-making What do you think? Is data-crunching necessary, or can decision-making be purely analytical? Let me know in the comments! Tags: data-driven organization get started learn sql SQL basics You may also like Key Insights for Mastering SQL Queries Using Tinder Data Example We’ll take a look at key insights that will help you understand the nuances of mastering SQL queries. If you’ve never used SQL, you’re in the right place. Read more Why Learn SQL Over the Summer For the love of SQL, we decided to motivate you (yes, you) to learn SQL over the summer. Here's why! Read more Forget About Excel, High Five With SQL Find out how easy it is to learn SQL, why it can make you work better, and how LearnSQL.com makes the learning process fun. Read more Career Change: From Accountant to Database Designer Personal insight into career change, learning SQL, becoming a database designer, and how your life choices can help you accomplish all that and more. Read more How Long Does It Take to Learn SQL? Top Tips for SQL Proficiency How long does it take to Learn SQL? We break it down so you know exactly how long you’ll need to achieve SQL proficiency. Read more What Programming Language Should You Learn? Guide to what programming language should you learn first when starting learning to code Read more Should I Learn SQL as a Data Analyst? Are you a data analyst wondering if you should learn SQL? You should, and here's how! Read more How to Start Writing SQL Reports Learn how to write SQL reports. Reporting in SQL will benefit you professionally, regardless of your role or industry. Read more How Will Learning SQL Improve My Daily Work? Do you think that learning SQL is only for people in IT? Not true! A knowledge of SQL is good for most professions. Read more You Want to Learn SQL? You've Come to the Right Place! If you want to learn SQL basics or enhance your SQL skills, check out LearnSQL.com for a wide range of SQL courses and tracks. Read more Practical Ways to Improve the Performance of SQL Queries Knowing how to improve SQL query performance is an important skill, especially when working with with large databases. In this article, you'll learn how to write more efficient SQL queries to get results faster. Read more Subscribe to our newsletter Join our weekly newsletter to be notified about the latest posts.