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

Focused View

Start-Tech Academy

30:44:28

69 View

1. Introduction

1. Introduction.mp4

04:28

2. Installation and getting started

1. Installing PostgreSQL and pgAdmin in your PC.mp4

10:44

2. This is a milestone!.mp4

03:31

3. If pgAdmin is not opening....html

4. Course Resources.html

3. Case Study Demo

1. Case Study Part 1 - Business problems.mp4

04:21

2. Case Study Part 2 - How SQL is Used.mp4

06:17

4. Fundamental SQL statements

1. CREATE.mp4

11:40

2. INSERT.mp4

09:07

3. Import data from File.mp4

04:59

4. SELECT statement.mp4

03:40

5. SELECT DISTINCT.mp4

06:05

6. WHERE.mp4

04:02

7. Logical Operators.mp4

06:03

8. UPDATE.mp4

05:24

9. DELETE.mp4

04:11

10. ALTER - Part 1.mp4

06:49

11. ALTER - Part 2.mp4

10:31

5. Restore and Back-up

1. Restore and Back-up.mp4

07:37

2. Debugging restoration issues.mp4

08:26

3. Creating DB using CSV files.mp4

05:40

4.1 Customer.csv

4.2 Product.csv

4.3 Sales.csv

4. Debugging summary and Code for CSV files.html

6. Selection commands Filtering

1. IN.mp4

04:18

2. BETWEEN.mp4

05:40

3. LIKE.mp4

08:52

7. Selection commands Ordering

1. Side Lecture Commenting in SQL.mp4

01:21

2. ORDER BY.mp4

07:42

3. LIMIT.mp4

03:38

8. Alias

1. AS.mp4

03:33

9. Aggregate Commands

1. COUNT.mp4

05:07

2. SUM.mp4

03:24

3. AVERAGE.mp4

02:53

4. MIN And MAX.mp4

04:18

10. Group By Commands

1. GROUP BY.mp4

11:42

2. HAVING.mp4

05:04

11. Conditional Statement

1. CASE WHEN.mp4

05:17

12. JOINS

1. Introduction to Joins.mp4

02:54

2. Concepts of Joining and Combining Data.mp4

11:58

3. Preparing the data.mp4

02:00

4. Inner Join.mp4

08:04

5. Left Join.mp4

07:30

6. Right Join.mp4

06:27

7. Full Outer Join.mp4

04:59

8. Cross Join.mp4

04:21

9. Intersect and Intersect ALL.mp4

07:06

10. Except.mp4

02:53

11. Union.mp4

03:09

13. Subqueries

1. Subquery in WHERE clause.mp4

04:55

2. Subquery in FROM clause.mp4

05:23

3. Subquery in SELECT clause.mp4

04:02

14. Views and Indexes

1. VIEWS.mp4

07:14

2. INDEX.mp4

06:25

15. String Functions

1. LENGTH.mp4

03:22

2. UPPER LOWER.mp4

02:10

3. REPLACE.mp4

04:13

4. TRIM, LTRIM, RTRIM.mp4

06:56

5. CONCATENATION.mp4

02:56

6. SUBSTRING.mp4

06:01

7. LIST AGGREGATION.mp4

04:54

16. Mathematical Functions

1. CEIL And FLOOR.mp4

03:20

2. RANDOM.mp4

05:04

3. SETSEED.mp4

04:11

4. ROUND.mp4

02:27

5. POWER.mp4

02:18

17. Date-Time Functions

1. CURRENT DATE And TIME.mp4

04:25

2. AGE.mp4

03:50

3. EXTRACT.mp4

08:16

18. PATTERN (STRING) MATCHING

1. PATTERN MATCHING BASICS.mp4

07:33

2. ADVANCE PATTERN MATCHING - Part 1.mp4

08:29

3. ADVANCE PATTERN MATCHING - Part 2.mp4

06:49

19. Window Functions

1. Introduction to Window functions.mp4

09:57

2. Introduction to Row number.mp4

06:04

3. Implementing Row number in SQL.mp4

19:19

4. RANK and DENSERANK.mp4

07:19

5. NTILE function.mp4

07:20

6. AVERAGE function.mp4

08:22

7. COUNT.mp4

03:55

8. SUM TOTAL.mp4

11:14

9. RUNNING TOTAL.mp4

06:58

10. LAG and LEAD.mp4

08:17

20. COALESCE function

1. COALESCE function.mp4

05:57

21. Data Type conversion functions

1. Converting Numbers Date to String.mp4

10:46

2. Converting String to Numbers Date.mp4

05:49

22. User Access Control Functions

1. User Access Control - Part 1.mp4

07:50

2. User Access Control - Part 2.mp4

05:22

23. Nail that Interview!

1. Tablespace.mp4

05:37

2. PRIMARY KEY And FOREIGN KEY.mp4

05:02

3. ACID compliance.mp4

05:32

4. Truncate.mp4

03:54

24. Looker Studio

1. Introduction.mp4

02:37

2. Why Data Studio.mp4

09:53

25. Terminologies And Theoretical concepts for Data Studio

1. Data Studio Home Screen And Dataset vs Data Source.mp4

04:12

2. Structure of Input data.mp4

01:05

3. Dimensions vs Measures (new definition).mp4

05:42

26. Practical part begins here

1. Opening Data Studio and preparing data.mp4

09:08

2. Adding a data source.mp4

06:15

3. Managing added data source.mp4

11:36

27. Charts to highlight numbers

1. Data Table.mp4

10:08

2. Styling tab for data table.mp4

14:00

3. Scorecards.mp4

07:51

28. Charts for comparing categories Bar charts and stacked charts

1. Simple Bar and Column chart.mp4

07:39

2. Stacked Column chart.mp4

05:22

29. Charting maps of a country, continent or a region - Geomaps

1. GeoMap.mp4

03:23

30. Charts to highlight trends Time series, Line and Area charts

1. Time Series.mp4

08:08

2. Update to Time Series chart.mp4

05:23

3. Line Chart and Combo Chart.mp4

04:50

31. Highlight contribution to total Pie chart And Donut Chart

1. Pie Chart and Donut Chart.mp4

05:46

2. Stacked Area Charts.mp4

07:28

3.1 Areachart updated.csv

3. Updated data for area charts.html

32. Relationship between two or more variables Scatterplots

1. Scatter Plots and Bubble charts.mp4

10:27

33. Aggregating on two dimensions Pivot tables

1. Pivot tables for cross tabulation.mp4

06:34

34. All about a single Metric Bullet Chart

1. Bullet Chart.mp4

04:11

35. Chart for highlighting heirarchy TreeMap

1. TreeMaps.mp4

04:47

36. Branding a Report

1. Branding a Report Brand Logo and Company Details.mp4

05:31

2. Brand colors for report branding.mp4

04:39

37. Giving the power to filter Data to viewers

1. Filter controls for viewers.mp4

09:05

38. Add Videos, Feedback form etc. to your Report

1. URL Embed to include external content.mp4

05:08

39. Sometimes data is in multiple tables

1. Blending data from multiple tables.mp4

09:41

2. Different types of Joins while blending data.mp4

12:18

40. Sharing and collaborating on Data Studio report

1. Downloading report as PDF and Page Management.mp4

03:17

2. Sharing report and Data Credentials.mp4

10:05

3. Sharing report using a link.mp4

02:46

4. Scheduling emails.mp4

03:42

5. Embeding report on Website.mp4

02:36

41. Charting Best Practices

1. Highlighting chart message.mp4

03:25

2. Eliminating Distractions from the Graph.mp4

06:54

3. Avoiding clutter.mp4

05:35

4. Avoiding the Spaghetti plot.mp4

05:27

42. Machine Learning in Python

1. Introduction.mp4

01:45

43. Setting up Python and Jupyter notebook

1. Installing Python and Anaconda.mp4

03:04

2. Opening Jupyter Notebook.mp4

09:04

3. Introduction to Jupyter.mp4

13:27

4. Arithmetic operators in Python Python Basics.mp4

04:28

5. Strings in Python Python Basics.mp4

19:07

6. Lists, Tuples and Directories Python Basics.mp4

18:40

7. Working with Numpy Library of Python.mp4

11:52

8. Working with Pandas Library of Python.mp4

09:15

9. Working with Seaborn Library of Python.mp4

08:57

44. Basics of statistics

1. Types of Data.mp4

04:04

2. Types of Statistics.mp4

02:45

3. Describing data Graphically.mp4

11:37

4. Measures of Centers.mp4

07:05

5. Measures of Dispersion.mp4

04:37

45. Introduction to Machine Learning

1. Introduction to Machine Learning.mp4

16:03

2. Building a Machine Learning Model.mp4

08:42

46. Data Preprocessing

1. Gathering Business Knowledge.mp4

02:53

2. Data Exploration.mp4

03:19

3. The Dataset and the Data Dictionary.mp4

06:36

4. Importing Data in Python.mp4

06:04

5. Univariate analysis and EDD.mp4

03:31

6. EDD in Python.mp4

12:11

7. Outlier Treatment.mp4

04:15

8. Outlier Treatment in Python.mp4

14:18

9. Missing Value Imputation.mp4

03:36

10. Missing Value Imputation in Python.mp4

04:57

11. Seasonality in Data.mp4

03:35

12. Bi-variate analysis and Variable transformation.mp4

16:14

13. Variable transformation and deletion in Python.mp4

09:21

14. Non-usable variables.mp4

04:44

15. Dummy variable creation Handling qualitative data.mp4

04:46

16. Dummy variable creation in Python.mp4

05:45

17. Correlation Analysis.mp4

09:42

18. Correlation Analysis in Python.mp4

07:07

47. Linear Regression

1. The Problem Statement.mp4

01:22

2. Basic Equations and Ordinary Least Squares (OLS) method.mp4

07:46

3. Assessing accuracy of predicted coefficients.mp4

14:40

4. Assessing Model Accuracy RSE and R squared.mp4

07:19

5. Simple Linear Regression in Python.mp4

14:07

6. Multiple Linear Regression.mp4

04:58

7. The F - statistic.mp4

08:22

8. Interpreting results of Categorical variables.mp4

05:04

9. Multiple Linear Regression in Python.mp4

14:13

10. Test-train split.mp4

09:32

11. Bias Variance trade-off.mp4

06:01

12. Test train split in Python.mp4

10:17

13. Regression models other than OLS.mp4

04:18

14. Subset selection techniques.mp4

11:34

15. Shrinkage methods Ridge and Lasso.mp4

07:14

16. Ridge regression and Lasso in Python.mp4

23:51

17. Heteroscedasticity.mp4

02:30

48. Introduction to the classification Models

1. Three classification models and Data set.mp4

05:31

2. Importing the data into Python.mp4

01:36

3. The problem statements.mp4

01:28

4. Why cant we use Linear Regression.mp4

04:32

49. Logistic Regression

1. Logistic Regression.mp4

07:54

2. Training a Simple Logistic Model in Python.mp4

12:25

3. Result of Simple Logistic Regression.mp4

05:11

4. Logistic with multiple predictors.mp4

02:22

5. Training multiple predictor Logistic model in Python.mp4

06:04

6. Confusion Matrix.mp4

03:47

7. Creating Confusion Matrix in Python.mp4

09:56

8. Evaluating performance of model.mp4

07:41

9. Evaluating model performance in Python.mp4

02:22

50. Linear Discriminant Analysis (LDA)

1. Linear Discriminant Analysis.mp4

09:39

2. LDA in Python.mp4

02:30

51. K-Nearest Neighbors classifier

1. Test-Train Split.mp4

09:32

2. Test-Train Split in Python.mp4

10:19

3. K-Nearest Neighbors classifier.mp4

08:41

4. K-Nearest Neighbors in Python Part 1.mp4

05:51

5. K-Nearest Neighbors in Python Part 2.mp4

07:00

52. Comparing results from 3 models

1. Understanding the results of classification models.mp4

06:06

2. Summary of the three models.mp4

04:32

53. Simple Decision Trees

1. Introduction to Decision trees.mp4

03:39

2. Basics of Decision Trees.mp4

10:10

3. Understanding a Regression Tree.mp4

10:17

4. The stopping criteria for controlling tree growth.mp4

03:15

5. Importing the Data set into Python.mp4

02:53

6. Missing value treatment in Python.mp4

02:18

7. Dummy Variable Creation in Python.mp4

04:03

8. Dependent- Independent Data split in Python.mp4

03:36

9. Test-Train split in Python.mp4

05:15

10. Creating Decision tree in Python.mp4

03:47

11. Evaluating model performance in Python.mp4

04:10

12. Plotting decision tree in Python.mp4

04:59

13. Pruning a tree.mp4

04:16

14. Pruning a tree in Python.mp4

10:37

54. Simple Classification Tree

1. Classification tree.mp4

06:06

2. The Data set for Classification problem.mp4

01:38

3. Classification tree in Python Preprocessing.mp4

08:25

4. Classification tree in Python Training.mp4

13:13

5. Advantages and Disadvantages of Decision Trees.mp4

01:34

55. Ensemble technique 1 - Bagging

1. Ensemble technique 1 - Bagging.mp4

06:39

2. Ensemble technique 1 - Bagging in Python.mp4

11:05

56. Ensemble technique 2 - Random Forests

1. Ensemble technique 2 - Random Forests.mp4

03:56

2. Ensemble technique 2 - Random Forests in Python.mp4

06:06

3. Using Grid Search in Python.mp4

12:14

57. Ensemble technique 3 Boosting

1. Boosting.mp4

07:11

2. Ensemble technique 3a - Boosting in Python.mp4

05:08

3. Ensemble technique 3b - AdaBoost in Python.mp4

04:00

4. Ensemble technique 3c - XGBoost in Python.mp4

11:07

58. Alteryx

1. The Problem Statement.mp4

07:53

59. Case study and Alteryx Installation

1. Installing Alteryx.mp4

03:47

2. Alteryx Interface.mp4

10:15

60. DATA EXTRACTION Extracting tabular data

1. Manually entering data into Alteryx.mp4

09:23

2. Importing Data from a CSV (Comma Separated Values) file.mp4

04:31

3. Importing Data from a TXT (text) file.mp4

04:08

4. Importing Data from an Excel file.mp4

03:31

5. Importing Data from a ZIP file.mp4

03:05

6. Importing Data from multiple files in a folder.mp4

08:14

61. DATA EXTRACTION Extracting non-tabular data

1. Probable Issue with Extraction from XML.html

2.1 ProductXMLFull.csv

2.2 productxmlfull.zip

2.3 productxmlfull2.zip

2. Extracting from XML.mp4

03:30

62. Extracting from an SQL table

1. Plan for importing sales Data.mp4

02:59

2. Installing PostgreSQL and pgAdmin in your PC.mp4

10:44

3. Creating Sales table in SQL.mp4

09:01

4. Extracting from an SQL table.mp4

07:54

63. Storing and Retrieving Data Cloud storage

1. Storing Data on AWS S3.mp4

05:19

2. Importing data from AWS S3.mp4

04:27

64. Merging Data Streams

1. Union tool - Merging Customer Data.mp4

06:57

65. Data Cleansing and improving data quality

1. Find and Replace Tool.mp4

05:50

2. Data Cleaning Tool.mp4

05:48

3. Autofield and Select Tool - For controlling Field order and data type.mp4

10:38

66. Merging Sales and Product data

1. Select and Unique Tools- For Removing duplicates from product data.mp4

05:29

2. Date Parse - Changing Date format.mp4

05:57

3. Select and union - Merging Sales data.mp4

08:17

67. Sampling Data

1. Select Records Tool.mp4

05:15

2. Sample Tool.mp4

04:12

3. Random Percent Sample Tool.mp4

05:01

4. Train-Validation-Test Split sampling.mp4

05:52

68. Data Preparation

1. Multifield binning and Tile Tool - To create customer age categories.mp4

09:33

2. Formula Tool - Conditional Formula for giving category titles.mp4

06:05

3. Sort tool - Sorting customer Data based on ID.mp4

03:07

4. Formula Tool - Sales order date And ship date.mp4

05:03

5. Multifield Formula tool - Converting multiple currency fields.mp4

06:59

6. Filtering and Sorting - Positive number of days.mp4

05:27

7. Text to Columns - Splitting Product ID into 3 columns.mp4

05:49

69. Outputting Cleaned Data

1. Outputting Clean Customer And Product Data.mp4

04:40

70. Merging tables to create a datamart

1. The Joining Tool - Adding customer and Product data to Sales table.mp4

17:25

2. Extracting more info from the Date values.mp4

05:38

71. Performing Analytics Transformation on Datamart

1. The Summarize tool.mp4

04:54

2. Running Total Tool.mp4

06:47

3. Crosstab tool for creating Pivot tables.mp4

05:09

4. Transpose Tool - the opposite of Cross Tab tool.mp4

05:49

5. The Count tool.mp4

02:13

72. Creating a report in Alteryx

1. Introduction to Reporting.mp4

03:08

2. Interactive Chart tool - Bar chart to show region-wise sales.mp4

08:44

3. Interactive Chart tool - Line chart to show Sales trend.mp4

11:57

4. Table Tool - Formatting the Pivot table.mp4

07:00

5. Text Tool - Adding static text to a report.mp4

04:08

6. Visual Layout tool - Arranging charts, text and tables in a report.mp4

07:03

7. Header tool - Adding header in a report.mp4

02:45

8. Footer tool - Adding footer to a report.mp4

02:22

9. Rendering tool - rendering report as a PDF, HTML or PNG.mp4

05:16

10. Email Tool - Sending email with Alteryx.mp4

10:46

11. Image tool - Adding image to a report.mp4

02:32

12. Layout tool - Arranging charts, text or tables in a report.mp4

04:57

73. Scheduling a workflow in Alteryx

1. Schedule and Automate Alteryx workflow.mp4

08:26

74. Congratulations And about your certificate

1. Alternative to Alteryx.html

2. The final milestone!.mp4

01:33

3. Bonus Lecture.html

Description

[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.

Who is this for?

Recent graduates or job seekers who want to break into the field of data science and acquire a comprehensive skillset.

Small business owners who want to learn how to effectively analyze data and create reports to inform their business decisions.

Analysts who want to enhance their skills in data management and visualization using SQL, Looker Studio, and Alteryx

What You Need to Know?

A PC with internet connection. Installation instructions for all tools used are covered in the course.

More details

Description
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!
Who this course is for:
Recent graduates or job seekers who want to break into the field of data science and acquire a comprehensive skillset.
Small business owners who want to learn how to effectively analyze data and create reports to inform their business decisions.
Analysts who want to enhance their skills in data management and visualization using SQL, Looker Studio, and Alteryx

User Reviews

Rating

average 0

Total votes0

Focused display

Start-Tech Academy is a technology-based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners. Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey. Founded by Abhishek Bansal and Pukhraj Parikh. Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.