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

SQL & Power BI Data Analyst: MS SQL | SSRS | SSAS | Power BI, available at $49.99, has an average rating of 4.7, with 107 lectures, based on 23 reviews, and has 144 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner data analyst or Beginner data scientist It is particularly useful for Beginner data analyst or Beginner data scientist.

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

Summary

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

Price: $49.99

Average Rating: 4.7

Number of Lectures: 107

Number of Published Lectures: 107

Number of Curriculum Items: 107

Number of Published Curriculum Objects: 107

Original Price: $84.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

Beginner data analyst
Beginner data scientist

Target Audiences

Beginner data analyst
Beginner data scientist

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

Course Curriculum

Chapter 1: SQL Server Setup

Lecture 1: Introduction

Lecture 2: What is SQL Server

Lecture 3: What is SQL

Lecture 4: SQL Server Editions

Lecture 5: Download SQL Server

Lecture 6: Install SQL Server

Lecture 7: Install SSMS

Lecture 8: Connect SSMS to SQL Server

Lecture 9: Install sample database

Lecture 10: Create database

Chapter 2: Install Business Intelligence Templates

Lecture 1: What is Visual Studio

Lecture 2: Installing Visual Studio

Lecture 3: Installing SSDT

Lecture 4: Installing SSDT Templates

Chapter 3: SQL data exploration & analysis

Lecture 1: Data Preparation

Lecture 2: Importing datasets into database

Lecture 3: How many continents do we have data for

Lecture 4: What is possibility of dying from COVID

Lecture 5: What percentage of the population is infected with COVID

Lecture 6: What countries has highest COVID infection per population

Lecture 7: What countries has highest death from COVID

Lecture 8: What continent has highest deaths from COVID

Lecture 9: What are the global COVID cases and death

Lecture 10: What number of people have been vaccinated against COVID

Lecture 11: Analyse data with SQL CTE

Lecture 12: Using temporary tables for data exploration

Lecture 13: Using views for data exploration

Chapter 4: Create reports with SSRS

Lecture 1: What is SSRS

Lecture 2: Create a report server project

Lecture 3: Create a report definition file

Lecture 4: Configure a data source for report

Lecture 5: Define a dataset for report

Lecture 6: Add a table to report

Lecture 7: Format the report

Lecture 8: Grouping data in report

Lecture 9: Adding totals to the report

Lecture 10: Previewing report

Lecture 11: Exporting report

Chapter 5: Create Models and Analyse data with SSAS

Lecture 1: What is SSAS

Lecture 2: Installing SSAS

Lecture 3: Connecting to SSAS

Lecture 4: Create a tabular model project

Lecture 5: Explore tabular model authoring

Lecture 6: Create a connection to data source

Lecture 7: Transform and import data

Lecture 8: Mark as date table

Lecture 9: Create table relationships

Lecture 10: Create calculated columns : part 1

Lecture 11: Create calculated columns : part 2

Lecture 12: Creating measures : Part 1

Lecture 13: Creating measures : Part 2

Lecture 14: Creating measures : Part 3

Lecture 15: Create key performance indicators

Lecture 16: Create perspectives

Lecture 17: Create hierarchies: part 1

Lecture 18: Create hierarchies: part 2

Lecture 19: What are partitions

Lecture 20: Creating partitions

Lecture 21: Creating roles

Lecture 22: Analyse in excel

Lecture 23: Deploy your model

Lecture 24: Analyse Model

Chapter 6: Power BI Setup

Lecture 1: What is Power BI

Lecture 2: What is Power BI Desktop

Lecture 3: Install Power BI Desktop

Lecture 4: Explore Power BI interface

Lecture 5: Microsoft 365 setup

Lecture 6: Exploring Microsoft 365

Lecture 7: Add users to Microsoft 365

Chapter 7: Power BI Overview

Lecture 1: Power BI Overview : Part 1

Lecture 2: Power BI Overview : Part 2

Lecture 3: Power BI Overview : Part 3

Lecture 4: Components of Power BI

Lecture 5: Building blocks of Power BI

Lecture 6: Power BI Apps

Chapter 8: Data Analysis & Transformation with Power BI

Lecture 1: Connect to data source

Lecture 2: Clean and transform data : part 1

Lecture 3: Clean and transform data : part 2

Lecture 4: Combine data sources

Lecture 5: Creating visuals : Part 1

Lecture 6: Creating visuals : Part 2

Lecture 7: Publishing report to Power BI Service

Chapter 9: Consume data from databases with Power BI

Lecture 1: Connect Power BI to SQL Server

Lecture 2: What is PostgreSQL

Lecture 3: Install PostgreSQL

Lecture 4: Connect to PostgreSQL

Lecture 5: Install sample database into PostgreSQL

Lecture 6: Connect Power BI to PostgreSQL : Part 1

Lecture 7: Connect Power BI to PostgreSQL : Part 2

Chapter 10: Data Analysis & Transformation with Power BI

Lecture 1: Importing Microsoft Access Database File

Instructors

Skill Tree
Skill based learning

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 3 votes
4 stars: 6 votes
5 stars: 13 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu