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

Focused View

Tech Academy

10:59:23

207 View

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

00:20

2. What is a Data Analyst.html

3. What is Python.mp4

05:16

4. What is Jupyter Notebook.mp4

01:20

5. Installing Jupyter Notebook Server.mp4

06:45

6. Running Jupyter Notebook Server.mp4

08:44

7. Common Jupyter Notebook Commands.mp4

07:28

8. Jupyter Notebook Components.mp4

04:26

9. Jupyter Notebook Dashboard.mp4

04:20

10. Jupyter Notebook User Interface.mp4

05:44

11. Creating a new Notebook.mp4

06:45

3. Data Analysis & Visualization with Python

1. Kaggle Datasets.mp4

03:06

2.1 us_baby_names.zip

2. Tabular Data.mp4

08:00

3. Exploring Pandas Data Frame.mp4

02:20

4. Manipulating a Pandas Data Frame.mp4

12:57

5. What is Data Cleaning.mp4

03:28

6.1 crime_boston.zip

6. Performing Data Cleaning.mp4

22:42

7.1 listings.zip

7. What is data visualization.mp4

02:35

8. Visualizing qualitative data.mp4

12:00

9. Visualizing quantitative data.mp4

13:49

4. SQL Server Setup

1. What is SQL Server.mp4

02:57

2. SQL Server Installation Requirements.mp4

04:21

3. SQL Server Editions.mp4

04:45

4. Download SQL Server.mp4

04:31

5. Install SQL Server.mp4

09:43

6. Install SQL Server Management Studio (SSMS ).mp4

05:48

7. Connect SSMS to SQL Server.mp4

02:16

8. Please Note.html

9. Restore sample data warehouse database.mp4

05:49

10. Restore sample database.mp4

06:28

5. Visual Studio Setup

1. What is Visual Studio.mp4

04:32

2. Visual studio installation requirements.mp4

04:27

3. Install Visual studio.mp4

06:46

4. Visual studio workloads.mp4

03:59

5. Install SQL Server Data Tools (SSDT).mp4

04:09

6. Install SSDT Templates.mp4

06:21

6. Data Analysis with ETL & SSIS

1. What is ETL.mp4

05:41

2. What is SSIS.mp4

03:25

3. ETL Illustration.mp4

00:53

4. Create a new SSIS Project.mp4

02:13

5. SSIS Designer.mp4

02:18

6. Add and configure a Flat File Connection Manager.mp4

06:26

7. Remapping Column Data Types.mp4

11:12

8. Add and configure OLE DB connection manager.mp4

03:39

9. Add a Data Flow task to the package.mp4

05:02

10. Add and configure the flat file source.mp4

04:28

11. Add and configure the lookup transformations.mp4

11:29

12. Add and configure Lookup for DateKey Transformation.mp4

09:28

13. Add and configure OLEDB Destination.mp4

07:53

14. Run and test Package.mp4

02:02

7. Create Analytic Reports with SSRS

1. What is SSRS.mp4

00:30

2. Create a report server project.mp4

02:05

3. Create a report definition file.mp4

01:56

4. Configure a data source for the report.mp4

02:32

5. Define a dataset for the report.mp4

04:51

6. Add a table to the report.mp4

03:33

7. Format report.mp4

04:43

8. Group data in report.mp4

03:50

9. Adding totals to the report.mp4

04:38

10. Previewing report.mp4

00:54

11. Exporting report.mp4

00:49

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

1. What is SSAS.mp4

00:25

2. Installing SSAS.mp4

08:07

3. Connecting SSAS.mp4

01:27

4. Create a tabular model.mp4

02:30

5. Explore tabular model authoring.mp4

04:16

6. Creating connection to data source.mp4

02:42

7. Transform and import data.mp4

07:10

8. Mark as a data table.mp4

01:34

9. Create table relationships.mp4

06:26

10. Create calculated columns- part 1.mp4

07:55

11. Create calculated columns- part 2.mp4

03:24

12. Creating measures - Part 1.mp4

05:47

13. Creating measures - Part 2.mp4

03:44

14. Creating measures - Part 3.mp4

03:13

15. Creating KPIs.mp4

05:00

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

1. What is SQL.mp4

02:29

2. What is Microsoft SQL (T-SQL ).mp4

10:27

3. Analysing data with Analytic Functions.mp4

04:45

4. Basic Analytic Function Syntax.mp4

04:19

5. Analysing data with LEAD Function.mp4

07:49

6. Restore sample data warehouse database.html

7. Analysing data with LAG Function.mp4

06:35

8. Analysing data with LAST_VALUE Function.mp4

05:01

9. Analysing data with FIRST_VALUE Function.mp4

04:45

10. Analysing data with PERCENT_RANK Function.mp4

04:43

11. Analysing data with CAST Function.mp4

07:04

12. Analysing data with ROUND Function.html

13. Analysing data with CONVERT Function.mp4

04:04

14. Analysing data with SUBSTRING Function.mp4

05:17

15. Analysing data with CASE Expression.mp4

08:56

10. Power BI Setup

1. What is Microsoft 365.html

2. Microsoft 365 Setup.mp4

03:43

3. Getting started with Microsoft 365.mp4

04:04

4. What is Power BI.mp4

05:47

5. What is Power BI Desktop.mp4

03:40

6. Installing Power BI Desktop.mp4

02:55

7. Exploring Power BI Desktop.mp4

05:02

11. Data Analysis & Visualization with Power BI

1. Power BI Overview - Part 1.mp4

04:24

2. Power BI Overview - Part 2.mp4

04:05

3. Power BI Overview - Part 3.mp4

04:49

4. Components of Power BI.mp4

02:57

5. Building blocks of Power BI.mp4

09:31

6. Power BI Service.mp4

04:28

7. Connect to web data.mp4

05:07

8. Clean & transform data - Part 1.mp4

07:12

9. Clean & transform data - Part 2.mp4

09:45

10. Combine data sources.mp4

07:59

11. Data visualization - part 1.mp4

06:09

12. Data visualization - part 2.mp4

05:23

13. Publishing reports to Power BI Service.mp4

04:47

14. Analyse and visualize SQL Server data.mp4

07:15

15. Connect to Microsoft Access Database.mp4

12:51

16. Creating and Managing Relationships in Power BI Desktop.mp4

11:53

17. Power Query Editor and Queries.mp4

06:49

18. Creating and managing query groups.mp4

04:35

19. Renaming queries.mp4

04:54

20. Splitting columns.mp4

07:06

21. Changing data types.mp4

05:47

22. Remove and re-order columns.mp4

06:54

23. Duplicate and add columns.mp4

03:31

24. Create conditional columns.mp4

06:18

25. Connect to files in a folder.mp4

07:17

26. Append queries.mp4

06:58

27. Merge queries.mp4

05:35

28. Query dependency view.mp4

04:32

Description

What You'll Learn?

Analyse Data with Python
Visualise Data with Python
Clean Data with Python
Create an ETL Process
Create SSIS Package to Extract, Transform and Load Data
Create reports with SSRS
Create a Tabular Model with SSAS
Create Key Performance Indicators - KPI's
Create calculated columns
Creating measures
Analyse data with SSAS
Analyse data with Microsoft SQL (T-SQL)
Connect to multiple data sources with Power BI
Analyse data with Power BI
Visualise data with Power BI
Analyse and visualise data on SQL Server Database with Power BI

Who is this for?

Beginner Data Analyst

Beginner Data Scientist

Beginner Business Intelligence Analyst

More details

Description
Data is everywhere. Everything you do online and in your daily life generates dataâ€”and itâ€™s a valuable business resource. In fact, 94% of companies say data and analytics are essential to their growth. As we move toward greater digitization, there is an ever-increasing demand for professionals who can turn information into actionable insights.
A data analyst is a person whose job is to gather and interpret data in order to solve a specific problem. The role includes plenty of time spent with data but entails communicating findings too.
Hereâ€™s what many data analysts do on a day-to-day basis:

Gather data: Analysts often collect data themselves. This could include conducting surveys, tracking visitor characteristics on a company website, or buying datasets from data collection specialists.
Clean data: Raw data might contain duplicates, errors, or outliers. Cleaning the data means maintaining the quality of data in a spreadsheet or through a programming language so that your interpretations wonâ€™t be wrong or skewed.
Model data: This entails creating and designing the structures of a database. You might choose what types of data to store and collect, establish how data categories are related to each other, and work through how the data actually appears.
Interpret data: Interpreting data will involve finding patterns or trends in data that could answer the question at hand.
Present: Communicating the results of your findings will be a key part of your job. You do this by putting together visualizations like charts and graphs, writing reports, and presenting information to interested parties

During the process of data analysis, analysts often use a wide variety of tools to make their work more accurate and efficient. Some of the most common tools in the data analytics industry include:

Microsoft Excel
Google Sheets
SQL
Tableau
R or Python
SSAS
SSRS
SSIS
ETL
Microsoft Power BI
Jupyter Notebooks

Who this course is for:
Beginner Data Analyst
Beginner Data Scientist
Beginner Business Intelligence Analyst

User Reviews

Rating

average 0

Total votes0

Focused display

Tech Academy is a UK based e-learning provider that offers a range of high quality elearning solutions that teach real life technical skills that are essential and relevant in today's commercial environment. Our instructors have a wealth of experience in their respective courses and currently provide consultancy services to fortune 100 companies. Our courses are presented in HD and are clear and concise to enable retention and provide intuitive learning experience for absolute beginners.

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.