Conversion Rate Optimization with SQL, Tableau & A/B testing

Analyze signup and login flows using the 365 data science case study, comparing manual and social sign-up options, error handling, and conversion factors for online businesses.

Explore key terms like visitors, registered users, and customers, and analyze signup success rate and signup conversion rate to evaluate onboarding and optimize online signup processes against industry benchmarks.

Streamline signup and login flows with a simple, fast process and minimal fields, adding social, passwordless, or phone-based options to boost conversions and AB testing dashboards.

Create a simple, fast signup experience and visualize it in a three-page Tableau dashboard, analyzing signup flow, devices, signup types, and errors with filters for time range and outcomes.

Explore how to collect, access, and import data for a Tableau dashboard, including SQL and non-SQL databases, APIs, web scraping, and surveys.

Use MySQL and MySQL Workbench to prepare signup flow data from visitors, students, actions, and sessions for dashboards in Tableau, by joining tables and exporting csv for analysis.

Lead students through constructing SQL queries in MySQL Workbench to measure signup conversion rate, using visitors, students, and purchases with common table expressions and monthly calculations.

Analyze SQL-based signup methods by counting clicks for Google, Facebook, LinkedIn, and email signups and classifying attempts as successful, failed, or successful retries using actions and error messages.

Categorize sign-up attempts by device type using session operating systems. Build case expressions for mobile vs desktop, join relevant tables, and analyze signup types and errors to improve conversion rate.

Learn to combine sql and Tableau to visualize signup conversion rates by importing MySQL Workbench data into Tableau Public and creating CSV exports for insightful dashboards and stories.

Build a Tableau dashboard from sql to visualize monthly website traffic and sign-up conversion rates, using calculated fields for visitors to registered and free conversions, dual-axis visuals, and time-frame filters.

Explore how devices and operating systems influence the sign-up experience on the 3.65 platform, comparing mobile versus desktop and examining Android and iOS trends.

Create Tableau bar charts comparing mobile and desktop signup attempts, showing success, retry, and failure rates, to identify optimization opportunities for each device.

Explore how sign-up attempts vary by operating system and visualize rankings with a bar chart, grouping Android, iOS, macOS, Windows, and others while analyzing failure rates by signup type.

Build a Tableau dashboard with vertical sign-up charts and horizontal error charts on sheets, analyze failure and success rates by sign-up option, and use device filters to optimize conversions.

Create a Tableau story by merging worksheets into dashboards, organizing three story points that cover sign up conversion rate, devices, operating systems, sign up types, and login errors.

Learn to build a professional Tableau dashboard that swaps between visitors to registered and visitors to free conversion rate graphs using a string parameter, calculated field, and filter shelf.

Use parameters to swap between two sign-up conversion rate types in a Tableau dashboard and organize graphs with containers for flexible layouts.

Build a polished Tableau dashboard by adding preferred sign-up devices and operating systems charts alongside monthly visitors and conversion rates, configuring filters, layouts, and captions to illuminate signup choices.

Create a dashboard with signup types and error messages to analyze 4365 registrations across email, Google, Facebook, and LinkedIn, using shared filters and colors.

Format and refine Tableau visuals by applying design improvements, customizing colors with palettes and HTML codes, and aligning objects to create a professional, cohesive dashboard and story.

Learn to enhance Tableau stories with formatting, color schemes, titles, and fonts to improve readability and consistency across dashboards, guiding actionable insights into signup flow.

Analyze a story-based Tableau dashboard to identify signup flow issues, define business objectives, and generate actionable insights that drive revenue via optimization opportunities.

Examine the current state of affairs in the 365 data science sign up flow, detailing email and social sign ups (Facebook, LinkedIn, Google) and conversion rates across mobile and desktop.

Analyze sign up types on the story point two dashboard, revealing Google leads with over 54,000 visitors and email follows with about 24,000, while mobile and screen layout influence choices.

Assess sign-up type performance by comparing fail rates across Google, email, Facebook, and LinkedIn, reveal mobile challenges, and propose aligning email signup with Google's success to optimize conversions.

Analyze login types and success rates from sessions data, compare email and Google logins, identify device-specific issues, and propose actionable improvements to the login flow.

Identify a clear business objective and monitor it with data-driven analysis of visitor-to-free and free-to-paid conversions to boost signups and paid subscriptions.

Develop a clear, testable hypothesis from the business objective to optimize the signup flow. Highlight social signup options to raise visitor to free conversion and boost subscriptions through opportunity sizing.

Size opportunities by establishing a baseline, defining a hypothesis, and estimating impact with benchmarks. Demonstrates a signup flow optimization yielding a 10% lift from 3% to 3.3% and revenue implications.

Identify data-driven insights to improve the sign up experience and boost the visitor-to-registered conversion rate. Highlight social sign up options, simplify email signup, and plan A/B tests to validate improvements.

Explore the fundamentals of A/B testing by designing split tests with a control (A) and a variation (B), setting KPIs, and evaluating impact on conversion rate and revenue.

Compare original and modified signup screens through an a/b test, applying null and alternative hypotheses, a 0.05 significance level, and p-values to draw 95% confidence conclusions from over 300,000 visitors.

Set up and interpret an A/B test by defining minimum detectable effect and statistical power, balancing sample size, significance, and confidence level to reliably detect true conversions.

Execute an A/B test on the sign-up screen, monitor critical metrics and novelty effects, avoid peaking, and analyze results to decide on full-scale implementation.

Reveal how MySQL data and a Tableau dashboard identified a signup layout hurdle that hampered conversions, and how an AB test validated a signup redesign emphasizing social media options.

Advance the sign up flow with A/B test insights and monitor the visitor-to-registered conversion rate using MySQL and Tableau. Explore sign up options, like Apple or email, to improve conversions.