Description
In this course, you will :
- Learn how to use E:R diagrams and data exploration techniques to gain a solid understanding of the data and answer business-related questions more effectively.
- You will plan and build a complex query step by step, which will require you to combine tables in multiple ways and create different types of fields.
- Learn how to deal with this jumbled data by resolving data type issues, cleaning up jumbled strings, dealing with nulls, and removing duplication.
- Learn how to create more complex fields using window functions and layered calculations.
- Get hands-on experience creating two advanced calculations in particular: the percentage of a total calculation and the performance index calculation.
Syllabus :
- Exploring the Olympics Dataset
- Creating Reports
- Cleaning & Validation
- Complex Calculations