SQL & Power BI Data Analyst: MS SQL | SSRS | SSAS | Power BI

Focused View

Skill Tree

9:11:06

13 View

1. SQL Server Setup

1. Introduction.mp4

00:20

2. What is SQL Server.mp4

02:57

3. What is SQL.mp4

03:38

4. SQL Server Editions.mp4

04:45

5. Download SQL Server.mp4

04:31

6. Install SQL Server.mp4

09:43

7. Install SSMS.mp4

05:48

8. Connect SSMS to SQL Server.mp4

07:46

9. Install sample database.mp4

06:28

10. Create database.mp4

00:32

2. Install Business Intelligence Templates

1. What is Visual Studio.mp4

04:32

2. Installing Visual Studio.mp4

08:15

3. Installing SSDT.mp4

04:09

4. Installing SSDT Templates.mp4

06:21

3. SQL data exploration & analysis

1. Data Preparation.mp4

08:36

2. Importing datasets into database.mp4

07:31

3. How many continents do we have data for.mp4

04:52

4. What is possibility of dying from COVID.mp4

06:38

5. What percentage of the population is infected with COVID.mp4

05:00

6. What countries has highest COVID infection per population.mp4

05:40

7. What countries has highest death from COVID.mp4

04:58

8. What continent has highest deaths from COVID.mp4

02:50

9. What are the global COVID cases and death.mp4

03:23

10. What number of people have been vaccinated against COVID.mp4

10:13

11. Analyse data with SQL CTE.mp4

05:43

12. Using temporary tables for data exploration.mp4

06:17

13. Using views for data exploration.mp4

03:45

4. Create 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 report.mp4

02:32

5. Define a dataset for report.mp4

04:51

6. Add a table to report.mp4

03:33

7. Format the report.mp4

04:43

8. Grouping 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

5. Create Models and Analyse data with SSAS

1. What is SSAS.mp4

00:25

2. Installing SSAS.mp4

08:07

3. Connecting to SSAS.mp4

01:27

4. Create a tabular model project.mp4

02:30

5. Explore tabular model authoring.mp4

04:16

6. Create a connection to data source.mp4

02:42

7. Transform and import data.mp4

07:10

8. Mark as date 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. Create key performance indicators.mp4

05:00

16. Create perspectives.mp4

02:07

17. Create hierarchies part 1.mp4

03:19

18. Create hierarchies part 2.mp4

05:31

19. What are partitions.mp4

01:51

20. Creating partitions.mp4

10:10

21. Creating roles.mp4

07:06

22. Analyse in excel.mp4

03:35

23. Deploy your model.mp4

03:11

24. Analyse Model.mp4

06:46

6. Power BI Setup

1. What is Power BI.mp4

05:47

2. What is Power BI Desktop.mp4

03:40

3. Install Power BI Desktop.mp4

02:55

4. Explore Power BI interface.mp4

05:02

5. Microsoft 365 setup.mp4

03:43

6. Exploring Microsoft 365.mp4

04:04

7. Add users to Microsoft 365.mp4

02:54

7. Power BI Overview

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

03:56

8. Data Analysis & Transformation with Power BI

1. Connect to data source.mp4

05:07

2. Clean and transform data part 1.mp4

07:12

3. Clean and transform data part 2.mp4

09:45

4. Combine data sources.mp4

07:59

5. Creating visuals Part 1.mp4

06:09

6. Creating visuals Part 2.mp4

05:23

7. Publishing report to Power BI Service.mp4

04:47

9. Consume data from databases with Power BI

1. Connect Power BI to SQL Server.mp4

07:15

2. What is PostgreSQL.mp4

01:41

3. Install PostgreSQL.mp4

10:46

4. Connect to PostgreSQL.mp4

09:35

5. Install sample database into PostgreSQL.mp4

11:49

6. Connect Power BI to PostgreSQL Part 1.mp4

03:28

7. Connect Power BI to PostgreSQL Part 2.mp4

05:00

10. Data Analysis & Transformation with Power BI

1. Importing Microsoft Access Database File.mp4

12:58

2. Change locale settings.mp4

01:47

3. Connect to data source.mp4

07:09

4. Power Query Editor and queries.mp4

06:49

5. Create and manage query groups.mp4

04:35

6. Rename queries.mp4

04:54

7. Splitting columns.mp4

07:06

8. Changing data types.mp4

05:47

9. Removing & reordering columns.mp4

06:54

10. Duplicating and adding columns.mp4

03:31

11. Creating conditional columns.mp4

06:18

12. Connecting to files in folder.mp4

07:17

13. Appending queries.mp4

06:58

14. Merge queries.mp4

05:35

15. Query dependency view.mp4

04:32

16. Transform less structure data.mp4

09:10

17. Create tables.mp4

03:47

18. Query Parameters.mp4

09:28

Description

Perform Data Analyst Tasks using SQL and Power BI

What You'll Learn?

Perform data exploration and analysis with SQL
Write SQL Queries to explore and analyse data
Write SQL CTE queries to extract and query data
Write SQL temporary table queries to extract and query data
Connect to multiple data sources with Power BI
Clean and transform data with Power BI
Create visualizations with Power BI
Create Dashboards with Power BI
Create Reports with SQL Server Reporting Services - SSRS
Create and analyse tabular data models with SQL Server Analysis Services - SSAS

Who is this for?

Beginner data analyst

Beginner data scientist

What You Need to Know?

Basic knowledge of Excel advised

Basic knowledge of database concepts advised

Basic knowledge of SQL advised

More details

Description
Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.
Data analysts are in high demand across all sectors, such as finance, consulting, manufacturing, pharmaceuticals, government and education.
The ability to pay attention to detail, communicate well and be highly organised are essential skills for data analysts. They not only need to understand the data, but be able to provide insight and analysis through clear visual, written and verbal communication.
You can work across a range of areas, including: Types of data analyst

data assurance
business intelligence
data quality
Finance
higher education
marketing
sales.

Some responsibilities of a data analyst includes:

Developing records management processes and policies
identify areas to increase efficiency and automation of processes
set up and maintain automated data processes
identify, evaluate and implement external services and tools to support data validation and cleansing
produce and track key performance indicators
develop and support reporting processes
monitor and audit data quality
liaise with internal and external clients to fully understand data content
gather, understand and document detailed business requirements using appropriate tools and techniques
design and carry out surveys and analyse survey data
manipulate, analyse and interpret complex data sets relating to the employer's business
prepare reports for internal and external audiences using business analytics reporting tools
create data dashboards, graphs and visualisations
provide sector and competitor benchmarking
mine and analyse large datasets, draw valid inferences and present them successfully to management using a reporting tool

In this course we will perform some task of an SQL and Power BI Data Analyst .Â We will connect to a variety of data sources, performÂ data transformation ,cleaning andÂ exploration . We will create dashboards to visual dataÂ . We will also create reports using SQL Server Reporting Services (SSRS)Â and also create then analyse tabular data model using SQL Server Analysis Services (SSAS).

Who this course is for:
Beginner data analyst
Beginner data scientist

User Reviews

Rating

average 0

Total votes0

Focused display

We are experienced company that provides quality video based training .Our courses are easy to follow and understand and will take you froman absolute beginner with no technical skills to being efficient and confident with various technical skill like SQL and databases.We have worked with companies of various sizes and provided consultancy services at various levels.Thank you for learning with us and we hope your experience will be pleasant.

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.