Mario O.
Before 365:
Data Scientist | InSites Consulting
After 365:
ML/Data Science Engineer | NEWTON
See all reviews
Online Course
top-rated
free
Sign-Up Flow Optimization Analysis with SQL and Tableau
with
Ivan Manov
Gain first-hand data analyst experience: Use SQL and Tableau to tackle real-world business challenges
1170 students already have enrolled
Skill level:
Intermediate
Duration:
4 hours
-
Lessons (4 hours)
-
Practice exams (20 minutes)
-
Projects (8 hours)
- Lessons (4 hours)
- Practice exams (20 minutes)
- Projects (8 hours)
CPE credits:
6.5
CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of
professionals must earn to maintain their licenses and stay current with regulations and best
practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's
official website: www.nasbaregistry.org
CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of
professionals must earn to maintain their licenses and stay current with regulations and best
practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's
official website: www.nasbaregistry.org
Accredited:
certificate
What You Learn
- Improve your SQL and Tableau skills by working with real business data.
- Interpret sign-up flow data to improve lead acquisition strategies.
- Create professional, well-formatted charts and dashboards in Tableau.
- Identify challenges, analyse trends, and propose data-driven solutions.
- Validate analysis findings through robust A/B testing procedures.
Topics & tools
data analysisdata visualizationhypothesis testinga/b testingtableau storybusiness objectivesign-up form optimizationsign-up page redesignSQLconversion rates optimizationuser registration processbusiness decision-makingdashboard reportingbusiness skillstableau
Your instructor
AI & Data Science Course Creator | Sound Engineer
Track record
Bringing real-world expertise from leading global companies
Academic background
Master's degree, Sound Engineering
Media and recognition
- Author of Speech Recognition with Python on 365DS & Udemy
- Speaker at Power Platform Bootcamp 2025 on Audio AI
- Sound Engineer for TV/Film incl. The Bachelor & award-winners
Course OVERVIEW
Description
CPE Credits: 6.5
Field of Study: Information Technology
Delivery Method: QAS Self Study
Delivery Method: QAS Self Study
The sign-up flow optimization analysis course uncovers potential issues that websites may encounter with their registration process. You’ll put theory to practice in a use case employing actual data from 365's website visitors, examining their interactions with the current sign-up screen. Essentially, we aim to point out specific issues that require further investigation. To address these challenges, we employ powerful tools like SQL and Tableau and conduct an in-depth optimization analysis. By creating insightful visualizations, we reveal critical obstacles hindering the smooth sign-up flow and identify actionable solutions.
After organizing those observations into a customized analysis report, we validate the findings by implementing robust A/B testing. Еquipped with data-driven insights, we then make informed decisions on whether specific recommendations should be employed to enhance user experience.
Are you looking to improve your website’s performance and conversion rates? Join the thousands of professionals who have taken 365’s program and are now using their new skills to advance their careers. Sign up now and master the art of optimization analysis.
Prerequisites
- Any SQL environment (such as SQLite, MySQL Workbench, or an online SQL editor).
- Tableau Desktop or Tableau Public
- Python (version 3.8 or later), pandas library, and a code editor or IDE (e.g., Jupyter Notebook, Spyder, or VS Code)
Advanced preparation
Curriculum
43 lessons
40 exercises
1 project
2 exams
- 2. Case Study24 MinUncover the theoretical framework guiding our ongoing research and learn the core principles of a streamlined website registration process. We define the key aspects in a sign-up flow optimization analysis with SQL and Tableau and draw a rough sketch of the dashboard we’ll be making.
- 3. SQL: Data Retrieving41 MinLearn how to use MySQL Workbench to collect and extract the necessary data for creating visualizations. You have the opportunity to build the relevant MySQL queries from scratch.Types of Data Access FreeGetting to know the Database FreeExercise FreeSQL Query 1: Sign-Up Conversion Rate FreeNote FreeExercise FreeSQL Query 2: Sign-Up Types and Errors - Part 1 FreeSQL Query 2: Sign-Up Types and Errors - Part 2 FreeExercise FreeSQL Query 3: Login Types and Errors - Homework Free
- 4. Tableau: Dashboard Sheets42 MinThis section of the sign-up flow optimization analysis course demonstrates how to import the data we’ve collected with MySQL into Tableau. You acquire the skills necessary to build essential visualizations that represent the issues 365’s visitors encounter during their sign-up and login processes. You use filters, parameters, and sheet swapping to enhance bar and line charts and display informative statistics.SQL and Tableau FreeExercise FreeSign-Up Conversion Rate FreeDevice and Operating System Distribution FreePreferred Devices Horizontal Bar Chart FreeExercise FreePreferred Operating Systems Horizontal Bar Chart FreeSign-Up Types and Errors Bar Charts FreeExercise FreeLogin Types and Errors Bar Charts Free
- 5. Creating the Tableau Story34 MinIn this part of the sign-up flow optimization analysis course, you build a Tableau story leveraging the visualizations we’ve made. We will organize and format the story as an interactive tool for interpreting and exploring the data effectively.Creating Dashboards: Getting Familiar with the Canvas FreeSign-Up Conversion Rates: Sheet Swapping with Parameters FreeExercise FreeSign-Up Conversion Rates: Containers FreePreferred Sign-up Devices and Operating Systems FreeSign-Up Types and Errors FreeExercise FreeLogin Types and Errors FreeFormatting the Tableau Story - Part 1 FreeFormatting the Tableau Story - Part 2 FreeExercise Free
- 6. Analysis Report63 MinBased on the gathered information, you conduct a comprehensive data analysis with the help of the Tableau story. You also learn how to perform a sign-up flow optimization analysis and construct a hypothesis about possible improvements. And you formulate business objectives and opportunity sizing and search for ways to achieve the goals with appropriate actionable solutions. Lastly, we organize our observations and findings into a customized template for presenting to an audienceDashboard Application for an Analysis Report FreeCurrent State of Affairs: Observing Story Point 1 - Conversion Rate FreeCurrent State of Affairs: Observing Story Point 2 - Sign-Up Types and Preferences FreeExercise FreeCurrent State of Affairs: Observing Story Point 2 - Sign-Up Types Success and Fail Rates FreeCurrent State of Affairs: Observing Story Point 3 - Login Types FreeBusiness Objective FreeExercise FreeHypothesis and Opportunity Sizing - Part 1 FreeHypothesis and Opportunity Sizing - Part 2 FreeActionable Insights Based on the Analysis FreeExercise Free
- 7. A/B Testing32 MinGain a fundamental understanding of statistics and apply the experimental approach known as A/B testing. We use this method to test our hypothesis on the website sign-up flow optimization and learn how to make data-driven decisions.
- 8. Discussion and Further Analysis of a Website Sign-Up Flow8 MinThe section summarizes the obtained knowledge and discusses potential webpage improvements. Additionally, you can explore best practices for optimizing sign-up flow and other possible actions that aren’t central to the current study but could be tackled in future projects of a similar nature.
- 9. Course project and exam540 Min
Free preview
1.1 What Does the Course Cover?
5 min
1.2 Motivation
5 min
2.1 Understanding the 365's Sign-Up Process
6 min
2.2 Basic Terminology
7 min
2.4 Defining the Key Aspects of the Sign-Up Process
6 min
2.6 Sketching the Story
5 min
96%
of our students recommend
365 Data Science.
94%
of AI and data science graduates
successfully change
or advance their careers.
$29,000
average salary increase
after moving to an AI and data science career
ACCREDITED certificates
Craft a resume and LinkedIn profile you’re proud of—featuring certificates recognized by leading global
institutions.
Earn CPE-accredited credentials that showcase your dedication, growth, and essential skills—the qualities
employers value most.
How it WORKS
Student REVIEWS
