Understand what is a case study and what are the steps included in data analysis process  .
Learn how to perform basic data check by finding - unique Ids, duplicate rows and NULL values.
Practice how to create calculated fields .

Journey into data

Alteryx capabilities

Importing data and modifying data type

Finding and replacing NULL values

Count unique id's and find duplicate rows

Find average steps

Possible next steps

Journey Into Data

This chapter covers date field conversion, dataset integration through joins, average calculations, and the determination of activity/sitting thresholds and BMI categories to enable comprehensive user analysis.

Diving into data

Understanding join types

Date conversion and dataset integration

Calculate Body Mass Index (BMI)

Finding lifestyle index

Finding sitting thresholds

Diving Further Into Data

Explore date transformations, activity level comparisons, and inference-based recommendations using Alteryx tools like Union, Sort, Transpose, and Crosstab in fitness-tracking data analysis.

Delving deeper into data

Find sedentary minutes percentage

Find sleep pattern based on weekday

Find patterns in weekday step counts

Weekly activity analysis & categorization

Options

Insights-Driven Recommendations

Generic Recommendations

Recommendations

Congratulations

Wrapping Up

Exercises and Datasets

The fitness product industry is intensely competitive, and success depends on developing effective marketing strategies and products that align with customers' fitness routines and lifestyles. In this Alteryx case study, you will analyze real-world fitness tracker data to identify app usage patterns, assess customers'  fitness levels, and understand their schedules. As you analyze the data, you'll provide feedback to Bellabeat, a fitness product company, on potential product improvements and marketing strategies. You will use your Alteryx skills to prepare, transform, and blend data to derive actionable insights. By consolidating your findings into a single, comprehensive table, you'll effectively communicate insights to the Bellabeat team, demonstrating the practical application of your Alteryx skills. Whether you're a data enthusiast, aspiring analyst, or seasoned professional looking to enhance your Alteryx proficiency, this course provides the perfect opportunity to apply your skills to a real-world dataset.

<h2>Introduction to Fitness Data Analysis</h2>
<p>In the rapidly evolving fitness product industry, the ability to analyze and interpret real-world data is invaluable. This case study leverages Alteryx to delve into fitness tracker data, scrutinize app usage patterns, and evaluate users' fitness levels. You will extract meaningful insights that reflect customers' daily routines and preferences, which are crucial for developing targeted marketing strategies and innovative products for Bellabeat, a leader in the fitness product space.</p>

<h2>Developing Insights with Alteryx</h2>
<p>Throughout this case study, you will utilize your Alteryx skills to prepare, transform, and join various datasets to uncover hidden patterns and trends. This hands-on experience enhances your proficiency with Alteryx and teaches you to construct a comprehensive table consolidating all key findings. This structured approach ensures that your insights are clear and actionable, aiding Bellabeat make data-driven decisions to refine its product offerings and market positioning.</p>

<h2>Application and Impact</h2>
<p>By the end of this case study, your analysis will culminate in a detailed feedback report to Bellabeat’s management team, highlighting potential areas for product enhancement and innovative marketing tactics. Whether you are just starting out in data analytics or are looking to hone existing skills, this case study provides a realistic scenario to apply Alteryx.</p>


Data Transformation in Alteryx

Advance your Alteryx skills with real fitness data to develop targeted marketing strategies and innovative products!

Case Study: Analyzing Fitness Data in Alteryx

45.75% didn't meet the 150-minute MVPA goal. Bellabeat can use active minutes as a health metric by sending reminders to meet the weekly target

Bellabeat should highlight how its products support fitness goals to effectively target the audience, as only 7 users have a very active lifestyle

Sedentary minute percentage is 79.98%. Bellabeat can recommend customized exercise plans to attract customers and enhance marketing strategy

Consider promoting Bellabeat products with exclusive discounts on Wednesdays, Thursdays, and Fridays when average total steps decrease

Gather feedback from users to understand their preferences and experiences with Bellabeat products

Review pricing strategy to ensure competitiveness and value proposition in the market.

Monitor conversations and sentiment on social media platforms related to Bellabeat products, pricing, and perceived value.

Recommendations

Case Study: Analyzing Fitness Data in Alteryx

Interaktive Übung