SQL & Power BI: Your Data Analytics & Visualisation Journey

Learn the core fundamental concepts of data analysis

Created by: Data Civilisation
Technology-based analytics company

What Will I 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

Requirements

• None - we will walk you through from an absolute beginner level! No prior knowledge of SQL or PowerBI required
• An inquisitive mind and motivation to learn about data!
• No need to even have SQL Server downloaded in advance, as we'll show you how to get it installed for free!
• Note that SSMS (SQL Server Management Studio) cannot be installed on Mac OS. To install it on your Mac, the "Parallels Desktop" software is required, or the dual-boot to Windows method
• Why not check the reviews & curriculum to see what's in it for you?

Target audience

• For those who are new and curious about SQL & Power BI
• Students who are willing to put in a couple of hours to learn about analytics
• Students who want to add data skills to their tool-belt
• Beginner SQL
• Beginner Power BI
• For those who are interested in Data Analytics and a gateway into Data Science