Advanced Applied SQL for Business Intelligence and Analytics
Advanced Applied SQL for Business Intelligence and Analytics, available at $34.99, has an average rating of 3.95, with 21 lectures, based on 55 reviews, and has 212 subscribers.
You will learn about Put SQL to work for Business Intelligence Develop your SQL skills to advance your career Master advanced topics such as materialized views, common table expressions, advanced data grouping, and more! Bring data into Excel, Tableau or other business software for further analysis and visualization Uncover key insights about your customers, suppliers, and business performance Use your database to make crucial business decisions and grow the bottom line Avoid common mistakes that cost you credibility and time. This course is ideal for individuals who are The course is for analysts and developers. It is particularly useful for The course is for analysts and developers.
Enroll now: Advanced Applied SQL for Business Intelligence and Analytics
Summary
Title: Advanced Applied SQL for Business Intelligence and Analytics
Price: $34.99
Average Rating: 3.95
Number of Lectures: 21
Number of Published Lectures: 21
Number of Curriculum Items: 21
Number of Published Curriculum Objects: 21
Original Price: $109.99
Quality Status: approved
Status: Live
What You Will Learn
- Put SQL to work for Business Intelligence
- Develop your SQL skills to advance your career
- Master advanced topics such as materialized views, common table expressions, advanced data grouping, and more!
- Bring data into Excel, Tableau or other business software for further analysis and visualization
- Uncover key insights about your customers, suppliers, and business performance
- Use your database to make crucial business decisions and grow the bottom line
- Avoid common mistakes that cost you credibility and time.
Who Should Attend
- The course is for analysts and developers.
Target Audiences
- The course is for analysts and developers.
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 localhost 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!
About the Author
Jeffrey James has been working in the analytics and data space since 2006. With roots in digital marketing and web analytics, he’s applied analytical techniques to problems including customer value analysis, financial forecasting, machine learning, and process automation. He’s made his share of mistakes on the way to mastery and understands the mindset of a beginner/learner.
Course Curriculum
Chapter 1: Installing Postgres and Our Initial Dataset
Lecture 1: The Course Overview
Lecture 2: Installation on Windows and Mac Via Postgres App
Lecture 3: Installing pgAdmin
Lecture 4: Downloading and Restoring the DVD Rental Database
Chapter 2: SQL in the Real World and Customer Value Analysis
Lecture 1: Finding First Orders
Lecture 2: The Window Function ROW_NUMBER() and Using a CTE to Find First Orders
Lecture 3: Analyzing New Versus Repeat Buyer Behavior
Lecture 4: Customer Value Analysis/LTV Case Study Part One
Lecture 5: Customer Value Analysis/LTV Case Study Part Two
Chapter 3: Time between Events and Mastering Window Functions
Lecture 1: The LAG Function
Lecture 2: Time between Customer Orders
Lecture 3: Analyzing Our Time Since Behavioral Data
Lecture 4: NTILE Window Function
Chapter 4: Freeform Analysis of the DVD Rental Database
Lecture 1: First Orders
Lecture 2: Does First Rating Rented from Predict Lifetime Value?
Lecture 3: Top Five Highest Grossing Actors
Lecture 4: Films by Most Gross Revenue Per Actor
Chapter 5: Additional Advanced Analysis of the Database
Lecture 1: Cross Shopping
Lecture 2: Computing LTV Summary Metrics Using Correlate Subqueries
Lecture 3: CPA and Profitability Analysis Project – Part One
Lecture 4: CPA and Profitability Analysis Project – Part Two
Instructors
-
Packt Publishing
Tech Knowledge in Motion
Rating Distribution
- 1 stars: 4 votes
- 2 stars: 4 votes
- 3 stars: 10 votes
- 4 stars: 13 votes
- 5 stars: 24 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple