This course will walk you through fundamental data concepts, with practical exercises, in order to build you from an absolute beginner to a skilled user, in both analysis and visualisation, working through the examples together to give you live practice.
The course starts with ‘Core SQL’, where you will gain an in-depth understanding of the core functions in SQL. You will learn creating databases, to the most frequently used queries, to advanced filtering, to bucketing results.
Next you’ll learn the more advanced SQL functions and concepts in the ‘Intermediate SQL’ section of the course. This includes data conversion, data cleansing, running totals, views, variables, stored procedures, and more.
The final section of this course covers Microsoft’s intuitive ‘Power BI’ data visualisation tool. Power BI is Microsoft self-service business analytics and data visualization tool that delivers deep insights to enable fast, informed decisions.
During this training, you will learn the fundamental skills to know how to use Power BI to build highly interactive visualization and dashboards form end to end; getting the data from various sources, data preparation, data cleansing, data modelling and relationships, adding measures and calculations, visualization, explore data and get insights and eventually purplish and share dashboards.