Okay, we have a
This presentation is the property of its rightful owner.
Sponsored Links
1 / 85

Okay, we have a PowerPoint PPT Presentation


  • 140 Views
  • Uploaded on
  • Presentation posted in: General

Okay, we have a. Okay, we have a. Now what?. Suppose I need these two values. Every week on new data. Don’t paste!. Make repeatable analyses (without clicking) Easily add data. Structured query language. Structured query language. Developed at IBM. Structured query language.

Download Presentation

Okay, we have a

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Okay we have a

Okay, we have a


Okay we have a

Okay, we have a

Now what?


Okay we have a

Suppose I need these two values

Every week on new data


Okay we have a

Don’t paste!


Okay we have a

  • Make repeatable analyses(without clicking)

  • Easily add data


Okay we have a

Structured query language


Okay we have a

Structured query language

  • Developed at IBM


Okay we have a

Structured query language

  • Developed at IBM

  • Usually NOT considered a programming language


Okay we have a

Structured query language

  • Developed at IBM

  • Usually NOT considered a programming language

  • But a “domain specific language”


Okay we have a

Structured query language

  • Developed at IBM

  • Usually NOT considered a programming language

  • But a “domain specific language”

  • Aimed at analyzing and manipulating DATA


Okay we have a

Suppose I need these two values

Every week on new data


Okay we have a

Where is like ‘filter’ in Excel


Okay we have a

But we need temperature?


Okay we have a

In Excel, we did a lookup


Okay we have a

Temperature is here


Okay we have a

To fix a bit (move rows up)


Okay we have a

This results in Carthesian product


Okay we have a

This is called a ‘JOIN’


Okay we have a

Very similar to VLOOKUP


Okay we have a

We have a temperature field now


Okay we have a

We have

the filter


Okay we have a

We still need to show: Machine & temperature


Okay we have a

Benefit over Excel:

We can have multiple such queries


Okay we have a

Benefit over Excel:

We can have multiple such queries


Okay we have a

We have the

right data


Okay we have a

We have the

right data

But! We need ‘pivot like’ summary on average


Okay we have a

AVG of what?

Of everything?

Per machine?


Okay we have a

AVG of what?

Of everything?

Per machine?


Okay we have a

Almost there!


Okay we have a

Almost there!


Okay we have a

Suppose I need these two values

Every week on new data


Okay we have a

Remember lecture 1?


Okay we have a

  • Make repeatable analyses(without clicking)

  • Easily add data


Okay we have a

Can’t pick

field names now


Okay we have a

We made an easily repeatable analysis!


  • Login