The Data Analyst Course: Complete Data Analyst Bootcamp 2023

سرفصل های دوره

Data Science involves: Statistics, Excel, Linear Algebra, Power BI, Machine Learning, SQL

1. Introduction to Data Analytics

1.1 Course Content - Became a Data Analyst.pdf

1. Course Content - Became a Data Analyst

2.1 Common Mistakes in Data Analytics.html

2. How not to Learn Data Analytics Tools

2. Structured Query Language (SQL)

1. Introduction to SQL - SQL Syntax and Download MySQL

2. RDBMS - Data Integrity, Database Normalization

3. Data Definition Language (DDL)

4. Data Manipulation language (DML)

5. Data Control Languages (DCL) and Domain Constraints

6. Filtering Data and SET Operators in SQL

7. Conditional Expressions in SQL

8. Grouping Data

9. Joining Multiple Tables (JOINS)

10. SQL RANK Functions

11. SQL Triggers and Stored Procedures

12. Data Analytics on Movie Reviews in SQL

3. Statistical Analysis

1.1 Business Statistics.pptx

1. Introduction to statistics and Measures of central tendencies

2.1 tutorial_stats_pel.zip

2. Central Limit Theorem

3. Distributions and Correlations

4.1 data_cleaning_insights.zip

4.2 data.csv

4. PDF & CDF and Hypothesis Testing

5.1 basics_of_time_series_forecasting.zip

5.2 Time_Series_AirPassengers.csv

5. Time Series Forecasting

6. Probability Theory and Statistical Analysis

7.1 uk_road_accident_analytics.zip

7. Capstone Project - UK Road Accident Analysis (Part - 1)

8.1 uk_road_accident_timeseries_forecasting.zip

8. Capstone Project - UK Road Accident (Part -2)

4. Microsoft Excel

1. Introduction to Excel Workbook

2. Hands on Excel Cells and Ranges

3. Basic Formulae - Logical Operators

4. Excel - Lookup and Reference Formulae

5. Excel - Logical Formulae

6. Text and Statistical Formulae

7. Excel - Date & Time Formulae

8. Excel - Sorting & Filtering

9. Dynamic Charts With Examples

10. Derive Insights with Pivot Tables

5. Microsoft Power BI (Business Intelligence Tool)

1. Installation Power BI Desktop and Applications of Power BI

2. Understand the Concepts of Maps using Power BI

3. Power BI - Tables and Matrix

4. Different Types of Power BI Slicers

5. Introduction to Power Query

6. Hands on with Power Query Operations

7. Manipulations with Power Query Operations

8. Build a Sales Dashboard

9. Capstone Project - Sales and Production Analysis

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training