SQL & Power BI: Your Data Analytics & Visualisation Journey
Learn the core fundamental concepts of data analysis
4.50 (1631 reviews)
8 080
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
Course Gallery
Loading charts...
Related Topics
2177912
udemy ID
26/01/2019
course created date
08/02/2020
course indexed date
Bot
course submited by