Business Intelligence and Data Warehousing

Section outline

• Select section General

  General

  Collapse all Expand all

  • Select activity Announcements

    

    Announcements Forum

    Welcome Message

    Welcome to the Business Intelligence and Data Warehousing course! We're excited to embark on a journey exploring the dynamic world of data-driven decision-making. In this course, we will dive into the essentials of Business Intelligence (BI) and Data Warehousing, equipping you with valuable skills for the modern business landscape.

    Throughout the semester, we will cover a range of topics, from understanding the historical evolution and significance of BI to hands-on experiences with tools like Talend, Tableau, and Power BI. Our aim is to provide you with a comprehensive understanding of data principles, ETL processes, and the strategic use of BI tools.

    As you progress, you'll have the opportunity to design and implement functional data warehouses, execute seamless ETL processes, and create engaging reports and dashboards. The course will also explore emerging trends such as cloud-based BI, Big Data, and the role of Artificial Intelligence.

    Active participation is key, and we encourage you to engage in discussions, hands-on activities, and real-world case studies. Feel free to explore the resources provided and ask questions as we navigate the exciting field of Business Intelligence and Data Warehousing together.

    We look forward to a rewarding and knowledge-packed semester!

    Enjoy the course!

  • Select activity COURSE OUTLINE 2024

    

    COURSE OUTLINE 2024 File
• Select section Topic 1 - Introduction to Business Intelligence & Data Warehousing

  Topic 1 - Introduction to Business Intelligence & Data Warehousing

  • Select activity Introduction to Business Intelligence & Data Warehousing

    

    Introduction to Business Intelligence & Data Warehousing File
• Select section Topic 2 - Data Modelling and Database Design

  Topic 2 - Data Modelling and Database Design

  • Select activity Data Modelling and Database Design

    

    Data Modelling and Database Design File
  • Select activity Topic 2 Assignment

    

    Topic 2 Assignment

    Opened: Wednesday, 14 February 2024, 12:00 AM

    Due: Wednesday, 21 February 2024, 12:00 AM

    INSTRUCTIONS
    

    • This is a group assignment for database modeling.
    • You need to submit both a soft copy and a hard copy of your work.
    • For the soft copy, scan your paper into a pdf document and upload it using this link by February 20, 2024.
    • For the hard copy, hand it in to the course leaders by February 20, 2024.
    • You can use software tools to create ERDs if you want, but it is not required.
    • ONLY THE GROUP LEADER SHOULD SUBMIT THE WORK.

    
    

    
    

• Select section Topic 3 - Extract, Transform, Load (ETL)

  Topic 3 - Extract, Transform, Load (ETL)

  • Select activity ETL

    

    ETL File
  • Select activity ETL Practical Session

    

    ETL Practical Session File
• Select section Topic 4 - Data Warehouse Implementation

  Topic 4 - Data Warehouse Implementation

  • Select activity Data Warehouse Implementation

    

    Data Warehouse Implementation File
  • Select activity DW Implementation - Practical Session

    

    DW Implementation - Practical Session File
• Select section Topic 5 - Data Visualizations

  Topic 5 - Data Visualizations
• Select section Topic 6 - Data Quality and Governance

  Topic 6 - Data Quality and Governance

  • Select activity Data Quality and Governance

    

    Data Quality and Governance File
• Select section Topic 7 - Emerging Trends & Future Directions

  Topic 7 - Emerging Trends & Future Directions

  • Select activity Emerging Trends and Future Directions

    

    Emerging Trends and Future Directions File