Python, SQL, Tableau for Data Science Professional Certificate

advanced-data-science-techniques-with-aws-integration

foundations-in-aws-and-machine-learning-with-generative-ai

lesson-1-course-overview
1 welcome-to-advanced-data-science-techniques
2 course-syllabus-roadmap_instructions
3 course-resources-datasets-notebooks_instructions
4 day-in-the-life-an-interview-with-an-expert
5 insightlysoft-introduction_instructions
6 video-transcript-access_instructions

lesson-2-introduction-to-machine-learning-with-aws
7 understanding-the-ml-process_instructions
8 machine-learning-process-from-start-to-finish
9 how-cloud-tools-help-with-ml_instructions

lesson-3-aws-fundamentals-and-security
10 aws-essentials-for-data-science
11 mapping-aws-services-across-the-data-science-workflow_instructions
12 aws-components-security-best-practices_instructions

lesson-4-working-with-s3-glue-and-athena
13 leveraging-aws-athena-glue-and-s3-for-data-queries_instructions
14 setting-up-s3-glue-and-athena-for-data-analysis

lesson-5-sagemaker-ai-fundamentals-environment-setup
15 setting-up-sagemaker-unified-studio_instructions
16 overview-of-related-aws-tools-ec2-rds_instructions
17 navigating-the-sagemaker-interface

data-preparation-and-supervised-learning

lesson-1-data-preparation-for-machine-learning
18 data-preparation-fundamentals-for-ml_instructions
19 preparing-your-data-for-ml

lesson-2-regression-analysis
20 connecting-technical-metrics-to-business-impact_instructions
21 regression-techniques-in-python

lesson-3-classification-techniques
22 introduction-to-classification-models_instructions
23 building-classification-models
24 connecting-classification-metrics-to-business-outcomes_instructions

time-series-analysis-and-unsupervised-learning

lesson-1-time-series-analysis
25 time-series-concepts-and-arima-modeling_instructions
26 time-series-analysis-in-python
27 advanced-machine-learning-models-prophet-and-others_instructions

lesson-2-unsupervised-learning-methods
28 evaluating-unsupervised-learning-clustering-and-dimensionality-reduction_instructions
29 clustering-and-pca-techniques

model-enhancement-and-optimization

lesson-1-advanced-feature-engineering-with-ai
30 ai-generated-feature-suggestions_instructions
31 enhancing-your-features-with-ai
32 feature-selection

lesson-2-model-evaluation-and-conceptual-hyperparameter-tuning
33 overview-of-evaluation-metrics-and-tuning-concepts_instructions
34 evaluating-and-tuning-your-models

model-deployment-and-capstone-project

lesson-1-model-deployment
35 model-deployment-basics-with-sagemaker-ai_instructions
36 basic-model-deployment-in-sagemaker-ai

lesson-2-capstone-introduction-and-project-setup
37 expert-interview-on-end-to-end-cloud-ml-projects
38 understanding-your-capstone-project-journey_instructions
39 introducing-your-capstone-project-dataset_instructions

lesson-3-capstone-project-integrating-advanced-techniques-aws
40 course-wrap-up_instructions

building-a-real-world-data-science-solution

planning-and-data-collection

lesson-1-course-introduction-and-overview
41 welcome-to-building-a-real-world-data-science-solution
42 course-syllabus-roadmap_instructions
43 companies-and-datasets-overview_instructions
44 video-transcript-access_instructions

lesson-2-understanding-the-business-problem-and-success-metrics
45 understanding-ticketwises-ticket-routing-business-problem_instructions
46 defining-a-data-science-problem
47 best-practices-in-problem-definition-and-success-metrics_instructions

lesson-3-aws-s3-setup-and-data-management
48 setting-up-s3-glue-and-athena-for-data-analysis
49 introduction-to-amazon-sagemaker-ai-overview-and-getting-started_instructions
50 aws-s3-integration-with-python_instructions

exploratory-data-analysis-eda-and-preprocessing

lesson-1-exploratory-data-analysis
51 exploratory-data-analysis-techniques_instructions
52 first-look-smart-eda-for-hr-data

lesson-2-data-preprocessing-and-cleaning
53 data-cleaning-transformation-techniques

model-development-and-evaluation

lesson-1-feature-engineering-and-feature-selection
54 enhancing-your-features-with-ai
55 feature-selection
56 ai-generated-feature-suggestions_instructions

lesson-2-model-building-and-evaluation
57 model-recap-and-technique-overview_instructions
58 building-classification-models
59 regression-techniques-in-python
60 time-series-analysis-in-python
61 clustering-and-pca-techniques

pipeline-construction-and-deployment

lesson-1-pipeline-construction-and-deployment
62 step-by-step-pipeline-guide_instructions
63 automating-your-data-pipeline

lesson-2-model-deployment-with-aws-sagemaker-ai
64 sagemaker-case-study_instructions
65 model-deployment-basics-with-sagemaker-ai_instructions
66 real-time-model-deployment-in-sagemaker-ai

lesson-3-data-visualization-and-reporting
67 designing-interactive-dashboards
68 narrative-visualization-techniques_instructions
69 crafting-data-stories-with-bi-tools

lesson-4-technical-documentation-and-reporting
70 day-in-the-life-an-interview-with-an-expert
71 documenting-your-data-science-solution
72 best-practices-in-solution-documentation_instructions

solution-integration-and-delivery

lesson-1-mapping-your-toolkit-knowledge-to-real-world-applications
73 your-data-science-toolkit-in-action
74 mapping-your-data-science-toolkit-to-business-solutions_instructions

lesson-3-course-completion-and-future-journey
75 course-wrap-up-building-real-world-data-science-solutions_instructions
76 congratulations-on-completing-your-certificate

data-visualization-with-tableau-and-microsoft-excel

introduction-to-data-visualization-bi-tools

lesson-1-welcome-course-overview
77 welcome-to-data-visualization-with-bi-tools
78 course-syllabus-roadmap_instructions
79 introduction-to-business-intelligence-modern-bi-tools_instructions
80 day-in-the-life-an-interview-with-an-expert
81 global-finance-corp-introduction_instructions
82 video-transcript-access_instructions

lesson-2-introduction-to-tableau-and-excel
83 bi-tools-at-a-glance_instructions
84 setting-up-tableau_instructions
85 getting-started-with-tableau-public

lesson-3-connecting-to-data-sources
86 understanding-data-sources-in-tableau_instructions
87 connecting-to-databases-and-online-services-in-tableau-desktop_instructions
88 connecting-tableau-to-data-sources
89 troubleshooting-data-connections-in-tableau_instructions

lesson-4-data-preparation-and-transformation
90 data-cleaning-essentials-from-messy-to-analysis-ready-data_instructions
91 data-cleaning-transformation-techniques

lesson-5-tableau-challenge-uncovering-insights-in-action
92 from-raw-data-to-first-insights-a-social-media-analysis-challenge_instructions

creating-calculations-custom-metrics-and-building-visualizations

lesson-1-getting-started-with-tabelau-calculations
93 foundations-of-calculations-in-tableau-from-basic-math-to-table-calculations_instructions
94 mastering-calculations-in-tableau

lesson-2-advanced-calculations-lod-expressions-calculated-fields
95 mastering-level-of-detail-lod-expressions-beyond-basic-calculations_instructions
96 advanced-calculation-techniques-in-tableau

lesson-3-building-basic-visualizations
97 choosing-the-right-visualization-a-guide-to-basic-chart-types_instructions
98 building-your-first-visualizations

lesson-4-specialized-visualizations-and-advanced-formatting
99 specialized-visualizations-in-tableau_instructions
100 advanced-charting-techniques

creating-interactive-dashboards-and-data-stories

lesson-1-dashboard-design-and-interactivity
101 dashboard-design-principles-creating-interactive-user-experiences_instructions
102 designing-interactive-dashboards

lesson-2-data-stories-and-narrative-visualizations
103 narrative-visualization-techniques_instructions
104 leveraging-automated-insights-in-tableau_instructions
105 crafting-data-stories-with-bi-tools

lesson-3-implementing-real-time-visualizations
106 setting-up-live-data-connections_instructions
107 real-time-dashboard-techniques_instructions

lesson-4-performance-optimization-publishing
108 best-practices-for-dashboard-performance-and-publishing_instructions
109 optimizing-and-sharing-your-dashboards

exploring-other-tools-excel-for-data-analysis-and-visualization

lesson-1-essential-excel-fundamentals
110 why-excel
111 excel-in-modern-data-science_instructions
112 setting-up-excel-for-data-analysis_instructions
113 getting-started-with-excel-online

lesson-2-excel-functions-visualization-and-ai-tools
114 data-visualization-fundamentals-for-excel-dashboards_instructions
115 excel-functions-ai-tools-for-data-analysis
116 building-your-first-excel-dashboard
117 advanced-excel-capabilities-in-enterprise-settings_instructions

data-visualization-capstone

lesson-1-capstone-introduction-and-project-setup
118 the-future-of-data-visualization
119 introducing-your-capstone-project-dataset_instructions
120 capstone-project-overview_instructions

lesson-2-capstone-implementation-assessment
121 course-wrap-up_instructions

python-for-data-science-and-version-control-with-github

introduction-to-python-and-environment-setup

lesson-1-welcome-and-course-overview
122 welcome-to-python-for-data-science
123 course-syllabus-roadmap_instructions
124 day-in-the-life-an-interview-with-an-expert
125 engagemetrics-introduction_instructions
126 video-transcript-access_instructions

lesson-2-python-fundamentals-jupyter-notebook-setup
127 introduction-to-jupyter-notebook-with-python-overview-and-resources_instructions
128 python-basics_instructions
129 hello-python_instructions
130 getting-started-with-jupyter-notebooks
131 case-study-data-environments-in-industry_instructions

lesson-3-github-for-data-science-projects
132 version-control-best-practices_instructions
133 familiarize-with-git-and-github_instructions
134 git-basics-for-data-scientists_instructions

data-loading-and-manipulation

lesson-1-data-loading-techniques
135 data-import-essentials-csv-excel-and-apis

lesson-2-data-manipulation-with-pandas
136 transforming-hr-data-with-pandas

lesson-3-handling-categorical-and-date-time-data
137 python-data-transformation-essentials

lesson-4-numerical-operations-with-numpy
138 numpy-speed-boost-from-loops-to-lightning-fast-arrays

data-exploration-and-visualization

lesson-1-exploratory-data-analysis-eda
139 exploratory-data-analysis-techniques_instructions
140 first-look-smart-eda-for-hr-data

lesson-2-data-visualization-with-matplotlib-and-seaborn
141 choosing-the-right-visualization-a-guide-to-basic-chart-types_instructions
142 professional-visualizations-from-basic-to-beautiful

lesson-3-interactive-visualizations-with-plotly
143 interactive-dashboards-with-plotly-bringing-data-to-life

advanced-data-analysis-techniques

lesson-1-statistical-analysis-in-python
144 statistical-methods-in-python_instructions
145 statistical-analysis-in-hr-from-hypothesis-to-insights

lesson-2-a-b-testing-with-python
146 a-b-testing-in-action-training-methods-analysis_instructions
147 a-b-testing-in-action-analyzing-department-performance

lesson-3-automation-documentation-and-reporting
148 automating-your-data-science-workflow

github-integration

lesson-1-version-control-and-notebook-management-with-github
149 versioning-your-notebooks-with-github

lesson-2-documentation-with-generative-ai
150 automated-documentation-techniques_instructions
151 leveraging-ai-for-better-documentation

lesson-3-managing-experimentation-branching-strategies-in-data-science
152 branching-strategies-for-data-science-projects

data-science-workflow-capstone

lesson-1-capstone-introduction-project-setup
153 industry-expert-interview-on-data-science-workflows
154 introducing-trendwave-media-your-capstone-project-dataset_instructions
155 capstone-project-overview_instructions

lesson-2-capstone-implementation-assessment
156 course-wrap-up_instructions

sql-for-data-science-and-version-control-with-github

introduction-to-sql-and-environment-setup

lesson-1-welcome-course-overview
157 welcome-to-sql-for-data-science
158 course-syllabus-roadmap_instructions
159 day-in-the-life-an-interview-with-an-expert
160 bookcycle-introduction_instructions
161 lab-video-transcripts_instructions

lesson-2-sql-fundamentals-development-environment
162 introduction-to-jupyter-notebook-with-sql-overview-and-resources_instructions
163 sql-basics_instructions
164 hello-sql_instructions
165 case-study-data-environments-in-industry_instructions

lesson-4-introduction-to-git-basics-for-sql
166 version-control-best-practices_instructions
167 familiarize-with-git-and-github_instructions
168 git-basics-for-data-scientists_instructions

data-querying-aggregation-joins

lesson-4-conceptual-check-challenge
169 module-recap-study-guide_instructions

advanced-query-techniques

lesson-2-common-table-expressions-ctes-and-window-functions
170 exploring-advanced-query-patterns_instructions

lesson-4-advanced-query-techniques-challenge
171 advanced-sql-techniques-a-comprehensive-review_instructions

data-preparation-management-performance-optimization

lesson-3-creating-and-managing-database-schema
172 designing-a-database-schema_instructions
173 optimizing-sql-beyond-the-basics_instructions

data-analysis-capstone

lesson-1-capstone-introduction-project-setup
174 insights-from-a-data-scientist
175 introducing-techmart-your-capstone-project-dataset_instructions
176 building-your-data-analyst-report_instructions

lesson-2-capstone-implementation-assessment
177 course-wrap-up_instructions