Data Analyst-Python/ETL/SSIS/SSRS/SSAS/Microsoft SQL/PowerBI

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

1. Chapter 1

1. What is SSIS.html

2. What is T-SQL.html

3. What is SQL.html

4. What is SQL Server.html

5. Introduction.html

6. What is a Data Analyst.html

2. Python & Jupyter Notebook Setup

1. Introduction

2. What is a Data Analyst.html

3. What is Python

4. What is Jupyter Notebook

5. Installing Jupyter Notebook Server

6. Running Jupyter Notebook Server

7. Common Jupyter Notebook Commands

8. Jupyter Notebook Components

9. Jupyter Notebook Dashboard

10. Jupyter Notebook User Interface

11. Creating a new Notebook

3. Data Analysis & Visualization with Python

1. Kaggle Datasets

2.1 us_baby_names.zip

2. Tabular Data

3. Exploring Pandas Data Frame

4. Manipulating a Pandas Data Frame

5. What is Data Cleaning

6.1 crime_boston.zip

6. Performing Data Cleaning

7.1 listings.zip

7. What is data visualization

8. Visualizing qualitative data

9. Visualizing quantitative data

4. SQL Server Setup

1. What is SQL Server

2. SQL Server Installation Requirements

3. SQL Server Editions

4. Download SQL Server

5. Install SQL Server

6. Install SQL Server Management Studio (SSMS )

7. Connect SSMS to SQL Server

8. Please Note.html

9. Restore sample data warehouse database

10. Restore sample database

5. Visual Studio Setup

1. What is Visual Studio

2. Visual studio installation requirements

3. Install Visual studio

4. Visual studio workloads

5. Install SQL Server Data Tools (SSDT)

6. Install SSDT Templates

6. Data Analysis with ETL & SSIS

1. What is ETL

2. What is SSIS

3. ETL Illustration

4. Create a new SSIS Project

5. SSIS Designer

6. Add and configure a Flat File Connection Manager

7. Remapping Column Data Types

8. Add and configure OLE DB connection manager

9. Add a Data Flow task to the package

10. Add and configure the flat file source

11. Add and configure the lookup transformations

12. Add and configure Lookup for DateKey Transformation

13. Add and configure OLEDB Destination

14. Run and test Package

7. Create Analytic Reports with SSRS

1. What is SSRS

2. Create a report server project

3. Create a report definition file

4. Configure a data source for the report

5. Define a dataset for the report

6. Add a table to the report

7. Format report

8. Group data in report

9. Adding totals to the report

10. Previewing report

11. Exporting report

8. Data Analysis with SQL Server Analysis Server (SSAS)

1. What is SSAS

2. Installing SSAS

3. Connecting SSAS

4. Create a tabular model

5. Explore tabular model authoring

6. Creating connection to data source

7. Transform and import data

8. Mark as a data table

9. Create table relationships

10. Create calculated columns- part 1

11. Create calculated columns- part 2

12. Creating measures - Part 1

13. Creating measures - Part 2

14. Creating measures - Part 3

15. Creating KPIs

9. Data Analysis with Microsoft SQL(T-SQL)

1. What is SQL

2. What is Microsoft SQL (T-SQL )

3. Analysing data with Analytic Functions

4. Basic Analytic Function Syntax

5. Analysing data with LEAD Function

6. Restore sample data warehouse database.html

7. Analysing data with LAG Function

8. Analysing data with LAST_VALUE Function

9. Analysing data with FIRST_VALUE Function

10. Analysing data with PERCENT_RANK Function

11. Analysing data with CAST Function

12. Analysing data with ROUND Function.html

13. Analysing data with CONVERT Function

14. Analysing data with SUBSTRING Function

15. Analysing data with CASE Expression

10. Power BI Setup

1. What is Microsoft 365.html

2. Microsoft 365 Setup

3. Getting started with Microsoft 365

4. What is Power BI

5. What is Power BI Desktop

6. Installing Power BI Desktop

7. Exploring Power BI Desktop

11. Data Analysis & Visualization with Power BI

1. Power BI Overview - Part 1

2. Power BI Overview - Part 2

3. Power BI Overview - Part 3

4. Components of Power BI

5. Building blocks of Power BI

6. Power BI Service

7. Connect to web data

8. Clean & transform data - Part 1

9. Clean & transform data - Part 2

10. Combine data sources

11. Data visualization - part 1

12. Data visualization - part 2

13. Publishing reports to Power BI Service

14. Analyse and visualize SQL Server data

15. Connect to Microsoft Access Database

16. Creating and Managing Relationships in Power BI Desktop

17. Power Query Editor and Queries

18. Creating and managing query groups

19. Renaming queries

20. Splitting columns

21. Changing data types

22. Remove and re-order columns

23. Duplicate and add columns

24. Create conditional columns

25. Connect to files in a folder

26. Append queries

27. Merge queries

28. Query dependency view

139,000 تومان

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

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

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

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