Data Science With SQL
and TableauCornell Certificate Program

Data drives many real-world endeavors, which means that storing and accessing the data is foundational to success. Relational databases are an industry-standard data storage mechanism for maintaining data integrity while allowing flexible data retrieval.

You will begin this course by examining the basic table structures that form a relational database. Using the relational database format, you will define connections between your data fields and determine how those can be expressed. You will then practice normalizing a relational database to ensure data integrity and reduce redundancy. As this course concludes, you will use a relational database system called OmniDB along with structured query language (SQL) to retrieve specific information from the database.

Relational databases are workhorses which form the backbone for much of the information we find at our fingertips on the internet. In this course, you will learn to create and modify databases using OmniDB and structured query language (SQL) to import data, create tables, and modify fields. You will also practice cleaning data to maintain your database and ensure that it provides accurate information. As the course progresses, you will identify questions you want answered and practice translating those questions into SQL. You will also examine different forms of outputting data from a database, including outputting to a program or text file and outputting CSV text.

You are required to have completed the following course or have equivalent experience before taking this course:

• Querying Relational Databases

In today's world, data fills every corner — from business to science to our daily lives. Yet large swathes of data aren't practical or parseable for humans when presented in their native formats; we rely on faster and more intuitive ways of digesting complex data. One of these methods is data visualization, or the graphical representation of data in the form of charts, graphs, and diagrams. In this course, you will encounter myriad ways to visualize data and provide your audience with a clear understanding of the data's contents.

You will explore the fundamental principles of data visualization through the lens of data types, audience analysis, and communication effectiveness. You'll categorize data and select compelling visualization methods while considering your intended audience and message objectives. You'll also gain insight into the strategic implementation of data visualization, including determining when visualization enhances communication and when alternative approaches might be more effective.

Raw data rarely arrives in the perfect format for analysis and visualization. Before analysts can visualize meaningful insights from their data in Tableau, they must first transform their data into a structured, reliable foundation.

In this course, you will prepare and load data into Tableau to construct your first data visualizations. You'll begin by exploring Tableau's interface and reviewing the requirements for analysis-ready data. To organize your data and workspace, you'll double-check data elements for proper formatting, connect multiple datasets, and identify and resolve common data preparation issues.

You will further develop these foundational skills by constructing basic plot and chart visualizations then build on these visuals by computing additional custom values from your data, called calculated fields, to represent key business metrics. By practicing these techniques on a fictional financial dataset, you'll gain the skills to construct strong visualizations that communicate clear business insights to your audiences.

System requirements:

To complete this course, you will need to install Tableau Desktop Public on your local device. While this software is free, you'll need to create an online Tableau Public account to download the Tableau Desktop Public package. You‘ll also need administrative privileges to install this software on your device.

Refer to Tableau's System Requirements for up-to-date information on supported devices to check your device compatibility.

You are required to have completed the following course or have equivalent experience before taking this course:

• Exploring Data Visualization Techniques

As an analyst, it's not always enough to create a visualization; sometimes, you need to weave together many elements to give your audience the whole picture. Whether it's creating an important presentation to persuade your clients or crafting a vital dashboard that enables decision making in real time, creating insightful and compelling data stories is essential to effective data visualization.

In this course, you will explore the art of combining visualizations into powerful dashboards and compelling data stories. Beginning with dashboard fundamentals, you'll identify essential components and evaluate their effectiveness for different audiences. You'll then create interactive dashboards incorporating filters, actions, and navigation elements to enhance user experience. You'll also apply styling techniques, including color schemes, spacing, and show/hide features, to improve dashboard quality and impact. Finally, you'll develop data stories that effectively communicate insights and guide audiences through complex analytical narratives.

System requirements:

To complete this course, you will need to install Tableau Desktop Public on your local device. While this software is free, you'll need to create an online Tableau Public account to download the Tableau Desktop Public package. You‘ll also need administrative privileges to install this software on your device.

Refer to Tableau's System Requirements for up-to-date information on supported devices to check your device compatibility.

You are required to have completed the following courses or have equivalent experience before taking this course:

• Exploring Data Visualization Techniques
• Creating Professional Data Visualizations
• Creating Map-Based Visualizations
• Developing Advanced Visual Analytics