Perform Data Analyst Tasks using SQL and Power BI
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.
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.
Course Content
- SQL Server Setup –> 10 lectures • 46min.
- Install Business Intelligence Templates –> 4 lectures • 23min.
- SQL data exploration & analysis –> 13 lectures • 1hr 15min.
- Create reports with SSRS –> 11 lectures • 30min.
- Create Models and Analyse data with SSAS –> 24 lectures • 1hr 47min.
- Power BI Setup –> 7 lectures • 28min.
- Power BI Overview –> 6 lectures • 30min.
- Data Analysis & Transformation with Power BI –> 7 lectures • 46min.
- Consume data from databases with Power BI –> 7 lectures • 50min.
- Data Analysis & Transformation with Power BI –> 18 lectures • 1hr 55min.
Requirements
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).