General Concepts Dimensional Data Modeling Fact & Dimension Types of Dimension Tables Slowly Changing Dimension (SCD) Other Topics Types of Analytics File Formats Types of Partitioning ETL vs ELT Data Analytics Tools Apache Hadoop Apache Hive Apache Sqoop Apache Kafka Apache Spark Databricks Data Visualization Excel Power BI