Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Data Science Skillpath: SQL, ML, Looker Studio & Alteryx

via Udemy

Overview

[4-in-1 Bundle] Covers SQL, Data viz using Google's Looker Studio, Machine Learning using Python and ETL using Alteryx

What you'll learn:
  • Master SQL and perform advanced queries on relational databases.
  • Develop expertise in data visualization using Google's Looker Studio and create interactive dashboards.
  • Explore machine learning algorithms and apply them to real-world data problems.
  • Master Python libraries such as NumPy, Pandas, and Scikit-learn for data analysis and modeling.
  • Understand the ETL process and learn how to use Alteryx for data preparation and cleansing.
  • Learn how to build and evaluate regression and classification models
  • Develop skills in data storytelling and communicate insights effectively.

If you're a data professional looking to level up your skills and stay ahead of the curve, this is the course for you. Do you want to be able to analyze and manipulate data with ease, create stunning visualizations, build powerful machine learning models, and streamline data workflows? Then join us on this journey and become a data science rockstar.

In this course, you will:

  • Develop expertise in SQL, the most important language for working with relational databases

  • Master data visualization using Looker Studio, a powerful platform for creating beautiful and interactive dashboards

  • Learn how to build machine learning models using Python, a versatile and widely-used programming language

  • Explore the world of ETL (Extract, Transform, Load) and data integration using Alteryx, a popular tool for automating data workflows

Why learn about data science? It's one of the most in-demand skills in today's job market, with companies in all industries looking for professionals who can extract insights from data and make data-driven decisions. In this course, you'll gain a deep understanding of the data science process and the tools and techniques used by top data scientists.

Throughout the course, you'll complete a variety of hands-on activities, including SQL queries, data cleaning and preparation, building and evaluating machine learning models, and creating stunning visualizations using Looker Studio. By the end of the course, you'll have a portfolio of projects that demonstrate your data science skills and a newfound confidence in your ability to work with data.

What makes us qualified to teach you?

The course is taught by Abhishek (MBA - FMS Delhi, B. Tech - IIT Roorkee) and Pukhraj (MBA - IIM Ahmedabad, B. Tech - IIT Roorkee). As managers in the Global Analytics Consulting firm, we have helped businesses solve their business problems using Analytics and we have used our experience to include the practical aspects of business analytics in this course. We have in-hand experience in Business Analysis.

We are also the creators of some of the most popular online courses - with over 1,200,000 enrollments and thousands of 5-star reviews like these ones:

This is very good, i love the fact the all explanation given can be understood by a layman - Joshua

Thank you Author for this wonderful course. You are the best and this course is worth any price. - Daisy

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet, or anything related to any topic, you can always post a question in the course or send us a direct message.

Don't miss out on this opportunity to become a data science expert. Enroll now and start your journey towards becoming a skilled data scientist today!

Syllabus

  • Introduction
  • Installation and getting started
  • Fundamental SQL statements
  • Restore and Back-up
  • Selection commands: Filtering
  • Selection commands: Ordering
  • Alias
  • Aggregate Commands
  • Group By Commands
  • Conditional Statement
  • JOINS
  • Subqueries
  • Fun way to practice SQL
  • Views and Indexes
  • String Functions
  • Mathematical Functions
  • Date-Time Functions
  • PATTERN (STRING) MATCHING
  • Window Functions
  • COALESCE function
  • Data Type conversion functions
  • User Access Control Functions
  • Nail that Interview!
  • Looker Studio
  • Terminologies & Theoretical concepts for Data Studio
  • Practical part begins here
  • Charts to highlight numbers
  • Charts for comparing categories : Bar charts and stacked charts
  • Charting maps of a country, continent or a region - Geomaps
  • Charts to highlight trends : Time series, Line and Area charts
  • Highlight contribution to total: Pie chart & Donut Chart
  • Relationship between two or more variables: Scatterplots
  • Aggregating on two dimensions: Pivot tables
  • All about a single Metric: Bullet Chart
  • Chart for highlighting heirarchy: TreeMap
  • Branding a Report
  • Giving the power to filter Data to viewers
  • Add Videos, Feedback form etc. to your Report
  • Sometimes data is in multiple tables
  • Sharing and collaborating on Data Studio report
  • Charting Best Practices
  • Machine Learning in Python
  • Setting up Python and Jupyter notebook
  • Integrating ChatGPT with Python
  • Basics of statistics
  • Introduction to Machine Learning
  • Data Preprocessing
  • Linear Regression
  • Introduction to the classification Models
  • Logistic Regression

Taught by

Start-Tech Academy, Abhishek Bansal and Pukhraj Parikh

Reviews

4.6 rating at Udemy based on 108 ratings

Start your review of Data Science Skillpath: SQL, ML, Looker Studio & Alteryx

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.