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

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

Requirements
Basic knowledge of Excel advised
Basic knowledge of database concepts advised
Basic knowledge of SQL advised

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