Photo by the writer
You and your company are “run by data,” OK? Of course, that means using the most complex technology by managing data. Having a database in the area and asks it about a SQL looks less requirement in that country.
But what if there is a case when the simple spreadsheet is a carefully questioning question? Here are a few real circumstances.
Photo by the writer
1. Your data is small and / or one-off
Examples of such data include:
- CSV from seller
- Financial model with a few hundred lines
- Simple Budget Status
- Tracker Task
Photo by the writer
It would be almost Balarre to load such information in the database and then make a few questions. Passes. Open to Excel or Google sheets, and you can set fast, plan, and do Statistics and Reforms. It will probably still set the tables, directions, and schemas database.
2. You need quick setup and zero
If you do not have a related database, setup requires:
- Running data, location or cloud
- Tables specified with datatypes
- Right Permissions
With Sheets? None of this. Or installation is needed, it is very quick. But you may not need to install anything, as your machine comes with the installed Spreadsheet program, or you can easily use the cloud version.
Photo by the writer
You simply click the file and move – especially when you need to see what's in it or run a few quick statistics.
3. You need to work together
Details can manage worker, but requires setbacks, describes the roles, and SQL information.
For example, interaction in Google sheets is very easy:
- Share a link with your participants
- Add comments
- Track File Changes
Photo by the writer
If your participants are outside the data team (eg, finance, financial, functionality), the chances do not use SQL – Sheets, that doesn't matter.
4. You want to see the data senses and introduce data
The SQL belongs to the questions and data analysis, but it is not good in introduction to findings. Usually, you can send the result of your questions elsewhere. Surprisingly, the spreadsheets were trying to avoid avoiding.
If I can imagine and present the data important and you can easily analyze the spreadsheet, and select it by SQL. Spreadsheet for calculating tools and presentation.
Photo by the writer
Usually, you can select SPREADSHET on top of SQL if you need:
- Presentation charts
- Pivot tables are managers
- Model status model
5. Your work is visible and dirty
Such examples of such work are building models, intellectual forms, and consideration. That's where I used spreadsheets.
Photo by the writer
You can use them in:
- Collect Conditions -> Copy the sheet, drop a few cells, and see results
- Examining -> Write two formulas, and compare them, remove the weak; No migration of the required schema required
- Quickly fast models
- AD-Hoc Definence -> Colored Comments, Leaving Comments, Highlighting Data
- Formula Itetation -> Easily modify = sum (A1: A52) to = Average (A1: A52); No need to rewrite questions or verify syntax
6. Your audience don't talk SQL
Company leaders, project management, and external clients are more likely to open the spreadsheet than the database.
Photo by the writer
With sprespospies, they find something to learn, do, and share without learning the programs language that they do not intend to read.
7. You look at the cost and access
Keeping the contact details of the production sites may cost costs; Consider the cloud storage, Compute, and administrative resources.
Photo by the writer
Spreadsheet are free or almost free. If your dataset and analysis is a spreadsheet to easily, and select SQL prevales more.
8. You need a quick data access
Databases are not designed for simple texting. You will have to list a query or import data from, guess what, spreadsheets.
Photo by the writer
Typing data directly to the spreadsheet is easy if you want, for example, in:
- Record the Notes of the Assembly
- A number of the leading sales
- Track to Dos or Dealles
Store
The best way, of course, to combine the spreadsheets with SQL. The latter is designed for heavy data processing, conversion, and analysis, especially when including repeated tasks; Then it pays to establish a logical question and you simply restart when needed. If you just start or need to kiss, this SQL Cheat sheet is the best source of basic ideas to apply.
SPREADSHET are better if you are looking for a stigma, a quick understanding of information, easy analysis, fast data recognition, and share.
Nate Rosid He is a data scientist and product plan. He is a person who is an educated educator, and the Founder of Stratascratch, a stage that helps data scientists prepare their conversations with the highest discussion of the chat. Nate writes the latest stylies in the work market, offers chat advice, sharing data science projects, and covered everything SQL.
