The very first step – accessing data. For spreadsheets, this is a simple thing to do – just open the file. You'll write your first SQL queries in this lesson, and be introduced to BI Software fundamentals.
Accessing data in a spreadsheet is native to the software itself. Because data is stored and visible directly in a spreadsheet file, accessing the data is as simple as opening the file. We'll introduce the Remove Duplicates feature in Google Sheets.
Database and SQL
Write your first SQL query! In this lesson you'll learn how to pull data from a database. You'll also learn how to view de-duplicated data. The SQL operators introduced in this lesson include:
- SELECT DISTINCT
This lesson will introduce basic BI Software fundamentals, as well as a basic rundown of how to navigate through Looker.