SQL & Power BI: Your Data Analytics & Visualisation Journey
Learn the core fundamental concepts of data analysis
4.50 (1615 reviews)
7 969
students
11 hours
content
Oct 2024
last update
$79.99
regular price
What you will learn
Core SQL - the SQL interface, navigation, importing data for analysis
Core SQL - retrieving, filtering, and aggregating data using the SELECT, FROM, WHERE, IN, LIKE, GROUP BY, HAVING statements
Core SQL - the INTO statement for creating new tables and using the CASE statement to compute new columns based on conditions
Core SQL - joining tables together using various JOIN statements to enrich data analysis
Intermediate SQL - dealing with NULLs, converting data types, and data cleansing using the ISNULL, COALESCE, CAST, CONVERT, and REPLACE statements
Intermediate SQL - using window functions such as ROW_NUMBER, RANK, PARTITION, and learning running totals to increase the functionality of datasets
Intermediate SQL - understanding the importance of subquerying, views, and variables in SQL data analysis as well as the importance of stored procedures
Power BI - understand the importance, concepts and power of data visualisation
Power BI - learning how to directly import data from SQL and relate tables in the back-end of Power BI
Power BI - creating meaningful dashboards using Power BI visualisation objects for in-depth data insights
The skills to analyse different types of data sets!
Quizzes to test your knowledge as you progress through the course
Screenshots
Related Topics
2177912
udemy ID
26/01/2019
course created date
08/02/2020
course indexed date
Bot
course submited by