Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Master Data Analysis Essentials: SQL, Python & Tableau
Rating: 4.0 out of 5(1 rating)
9 students

Master Data Analysis Essentials: SQL, Python & Tableau

Learn the tools and techniques to analyze data, uncover insights, and create stunning visualizations
Created byPurwadhika Digital Technology
Last updated 1/2025
English

What you'll learn

  • Extract data efficiently from relational databases using SQL queries
  • Apply Python libraries such as Pandas and NumPy to clean, manipulate, and analyze datasets
  • Design and present compelling visualizations and dashboards using Tableau to communicate data-driven insights effectively
  • Combine SQL, Python, and Tableau to execute end-to-end data analysis workflows
  • Utilize key statistical techniques to summarize and interpret data insights

Course content

5 sections • 72 lectures • 15h 12m total length

  • Introduction to Databases2:31
  • CREATE Table Statement10:46
  • SELECT Table Statement2:40
  • LIMIT, DISTINCT, COUNT, AVG, SUM9:29
  • INSERT Statement5:33
  • WHERE Statement2:22
  • UPDATE and DELETE Statements6:18
  • Using String Patterns and Ranges8:21
  • Sorting Result3:04
  • Grouping Result7:30
  • Built-in Database Functions12:00
  • Date and Time Built-in Functions6:21
  • Subqueries and Nested Selects5:57
  • Working with Multiple Tables6:17
  • Relational Model Constraints1:46
  • Join Table9:18
  • Access Databases Using Python6:49
  • MySQL Exercise4:19
  • SQL Exercise Solution8:51
  • Common Table Expression (CTE) in MYSQL9:14
  • Window Function in MySQL28:23
  • Advanced MySQL Exercise2:23
  • Advanced MySQL Exercise Solution16:17

Requirements

  • Familiarity with using operating systems, file management, and basic software tools
  • A basic understanding of databases and their structure is helpful but not mandatory
  • Basic knowledge of Python programming, including variables, loops and functions, is recommended.
  • Comfort with basic algebra and an understanding of mathematical concepts like averages and percentages
  • No prior experience with Tableau is required, as the module will cover introductory data visualization skills

Description

Unlock the world of data analysis with our comprehensive course, designed for beginners and professionals eager to gain in-demand skills. Thiss course takes you on an exciting journey through the essential tools and techniques used in the data-driven world today.


You will start with SQL, learning how to extract meaningful data from databases using efficient queries. No prior experience? No problem! We'll guide you step by step to help you understand the fundamentals of working with data.


Next, you'll dive into Python for Data Analysis, one of the most versatile programming languages for data manipulation and analysis. Using libraries like Pands and Numpy, you will learn how to clean, organize, and analyze datasets to uncover insights that matter.


Understanding the story behind the numbers is crucial. That's why we cover Statistics, equipping you with the knowledge to interpret data trends and make informed decisions confidently.


Finally, transform raw data into captivating visuals using Tableau, a powerful visualization tool. You'll design interactive dashboards to showcase your findings in a way anyone can understand.


By the end of this course, you'll be equipped to turn raw data into actionable insights and advance your career in the growing field of data analysis.


Ready to begin? Let's dive in!

Who this course is for:

  • Aspiring data analysts, Individuals looking to start a career in data analsis and want to learn tools like SQL, Python, and Tableau
  • Professionals who want to leverage data insights for decision-making and communicate them effectively through visualization
  • Students or recent graduates from any discipline who want to acquire practical data skills to enhance their employability
  • Career changers, those transitioning to a data-driven role or considering a career switch to analytics
  • Entrepreneurs and small business ownwers, individuals who want to use data analysis to improve their business performance and operations
  • Learners with a curious mindset, anyone interested in exploring the basics of data analysis and visualization, even without prior experience

Report abuse