For working professionals
For fresh graduates
- Study abroad
More
- Post Graduate Certificate in Data Science & AI (Executive)
- Gen AI Foundations Certificate Program from Microsoft
- Gen AI Mastery Certificate for Data Analysis
- Gen AI Mastery Certificate for Software Development
- Gen AI Mastery Certificate for Managerial Excellence
- Gen AI Mastery Certificate for Content Creation
- Post Graduate Certificate in Product Management from Duke CE
- Human Resource Analytics Course from IIM-K
- Global Master Certificate in Integrated Supply Chain Management
- Gen AI Foundations Certificate Program from Microsoft
- CSM® Certification Training
- CSPO® Certification Training
- PMP® Certification Training
- SAFe® 6.0 Product Owner Product Manager (POPM) Certification
- Post Graduate Certificate in Product Management from Duke CE
- Professional Certificate Program in Cloud Computing and DevOps
- Python Programming Course
- Executive Post Graduate Programme in Software Dev. - Full Stack
- AWS Solutions Architect Training
- AWS Cloud Practitioner Essentials
- AWS Technical Essentials
- The U & AI GenAI Certificate Program from Microsoft
Free Certificate
Case Study using Tableau, Python and SQL
Analyze a real-world case study using Python, SQL, and Tableau to solve a business churn problem. Learn data extraction, visualization, and insights generation—perfect for analysts, data scientists, and business professionals!
10 hours of learning
SQL
ChatGPT
Tableau
-065d895a9ea2483a988dc39812b0f267.webp&w=3840&q=75)
KEY HIGHLIGHTS
What You Will Learn
Intro to Case Study
Get introduced to the problem statement and learn how to combine Python, SQL, and Tableau to solve a customer churn problem.
Topics Covered:
- Churn and Lifetime Value – Understand customer churn and how to calculate customer lifetime value (LTV).
- SQLite – Learn about this lightweight database management system and its applications.
- SQlite on Python – Explore how to integrate SQlite with Python for data storage and management.
- Pandas with SQlite – Use the Pandas library to manipulate and analyze data stored in SQlite.
Analyzing Churn and LTV
Understand how the Pandas library can be used to perform complex data analysis in Python.
Topics Covered:
- Creating a churn database – Build a structured database to track customer churn data.
- ERD Creation and RDBMS Validation – Design an Entity-Relationship Diagram (ERD) to visualize database structure and validate it in a relational database management system (RDBMS).
- Data Exploration – Analyze and clean raw data to extract meaningful insights.
- Analysis of Lifetime Value – Use statistical methods to assess customer LTV for business decisions.
Business Logic on Python
Learn how to use Python to write business logic that enhances company decision-making.
Topics Covered:
- Introduction – Get familiar with implementing business logic in Python.
- Sorting – Organize and structure data for better analysis.
- Tagging – Categorize data based on predefined business rules.
- Summary – Generate key insights and reports for business strategy.
Creating a Tableau Story
Create multiple visualizations using Tableau and present findings through a compelling data story.
Topics Covered:
- Understanding Customer Services – Analyze customer service interactions and their impact.
- Contract and Payment Patterns – Identify trends in contract types and payment methods.
- Creating a Dashboard – Develop interactive dashboards to visualize key business metrics.
- Creating a Tableau Story – Combine insights into a narrative to present to senior management.
Python Case Study Certification Online
Earn and Share Your Certificate
Official & Verifiable
Receive a signed and verifiable e-certificate from upGrad upon successfully completing the course.
Share Your Achievement
Post your certificate on LinkedIn or add it your resume! You can even share it on Instagram or Twitter.
Stand Out to Recruiters
Use your certificate to enhance your professional credibility and stand out among your peers!
upGrad Learner Support
Talk to our experts. We are available 7 days a week, 9 AM to 12 AM (midnight)
Indian Nationals
1800 210 2020
Foreign Nationals
+918045604032