Advanced applied SQL for business intelligence and analytics

"This example-driven course provides thoughtful and interactive commentary throughout. We understand the common mistakes and misconceptions you might make and help you navigate tricky SQL concepts. Window Functions are used in detail throughout the course to solve problems dealing with finding...

Full description

Bibliographic Details
Main Author: James, Jeffrey
Format: eBook
Language:English
Published: [Place of publication not identified] Packt 2018
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
Description
Summary:"This example-driven course provides thoughtful and interactive commentary throughout. We understand the common mistakes and misconceptions you might make and help you navigate tricky SQL concepts. Window Functions are used in detail throughout the course to solve problems dealing with finding the first order or the Nth instance of an event, computing the timing between events, and new and repeat purchase behaviors among customers. You'll run through the workflow from SQL to a local host connection in Tableau and also analysis, all of which you'll need in your professional life. Concepts such as CASE statements, common table expressions, and subqueries will be explained via case studies. You'll generate web analytics acquisition source data using Python and then create tables to store your information. By the end of the course, you will have gone through all the examples and coded them out, and you'll be ready to confidently tackle non-trivial problems. Supercharge your data productivity today with this course and get 100x your time investment back in the next year or two!"--Resource description page
Item Description:Title from title screen (viewed March 20, 2018). - Date of publication from resource description page
Physical Description:1 streaming video file (2 hr., 49 min., 46 sec.)