SQL for Data Analysis cover

SQL for Data Analysis

Advanced Techniques for Transforming Data into Insights 80 GSM

by Cathy Tanimura

Price৳ 290
Price৳ 290

Have a question? Ask on WhatsApp or Message on Messenger

Call 01963 822422 / 01817 506044 for help with your order

SQL for Data Analysis by Cathy Tanimura is a comprehensive guide to writing advanced SQL queries for analytical modeling and business reporting. Extracting meaningful insights from relational databases requires techniques beyond simple SELECT statements and basic joins. Tanimura demonstrates how to solve real analytical problems using window functions, cohort breakdowns, and time series transformations.

What you will learn

  • Transform raw transactional tables into clean datasets using window functions and CTEs
  • Conduct cohort analysis and retention calculations to measure user behavior over time
  • Build sales and marketing conversion funnels across multi-step user journeys
  • Calculate rolling averages, period-over-period growth, and time series aggregations
  • Analyze A/B test experiments and evaluate statistical significance directly inside SQL
  • Detect anomalous records and data outliers using distribution metrics

Who this is for

Data analysts, business intelligence developers, and data scientists who want to perform sophisticated analytics directly in the database. Basic knowledge of SQL syntax is assumed.