Locations: Online
Course Description: Learning Objectives:
-Students will gain a mastery of basic information theory (i.e. Cardinality Principles) and the Entity Relationship Diagram (ERD) where they’ll learn how to create their own ERDs that are connected via Primary and Foreign Keys for Dimension Driven Data Models
- Students will learn how to use Lucid Chart and Dbdiagram.io platforms to create Data Models adhering to the ERD principles that have been taught
- Students will gain a mastery of core data cleansing competencies where they’ll master Regular Expressions, Linear Interpolation and Base Data Manipulation Methodologies to slice and replace irregular/dirty data in small to medium sized datasets
- Students will be introduced to a refresher on Python where we’ll build upon Boolean Logic / Regex / Cleansing Libraries for Data Prep. purposes
- Students will gain a mastery of Descriptive and Inferential Statistics inclusive of the underlying theoretical principles that span across Standard Linear Principles, Basic and Advanced Regression Techniques
- Students will learn the differences between Continuous / Non Continuous Time Series Manipulation as well as a base introduction to Visualisation with Seaborn
- Students will gain a mastery of SQLite, PostgreSQL and Snowflake where they’ll be comfortable with building out and populating a database from the ground-up using a Fact-Dimension Data Model
- Students will learn how to make use of the Deepnote + Python + PostgreSQL / Snowflake Pipeline to create insightful analyses representative of an organisational workflow
- Students will gain a mastery of Seaborn, Tableau and Power BI where they’ll be comfortable connecting and performing ETL jobs in preparation for using views as references for their visual storyboarding
- Students will learn how to create compelling stories for the different audience groups they’ll encounter whether this is technical or non-technical stakeholder groupings
- Students will select a specific Job Path of interest for their RPP and create an End-to-End Platform Workflow that showcases their Data Modelling, ETL, Python Competencies and Visual Excellence (i.e. Power BI / Tableau / Seaborn) that will be presented to their Guide
Comprehensive costs $5,500 if the student pays up front, $6,000 if they pay monthly which works out to be 10 payments or $600. $6,425 on the Extended payment plan which is $200 up front then $75 a week for 83 weeks.
Subjects:
PostgreSQL, JSON, Python, Data Analytics, SQL, Excel