Business Intelligence and Data Warehousing

Section outline

• Select section General

  Collapse Expand

  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 2025

    

    COURSE OUTLINE 2025 File
  • Select activity VIRTUAL ONLINE CLASS

    

    VIRTUAL ONLINE CLASS External tool
• Select section Topic 1 - Introduction to Business Intelligence & Data Warehousing

  Collapse Expand

  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

  Collapse Expand

  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)

  Collapse Expand

  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

  Collapse Expand

  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

  Collapse Expand

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

  Collapse Expand

  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

  Collapse Expand

  Topic 7 - Emerging Trends & Future Directions

  • Select activity Emerging Trends and Future Directions

    

    Emerging Trends and Future Directions File
• Select section Coursework Test 1 2024/2025

  Collapse Expand

  Coursework Test 1 2024/2025

  • Select activity Coursework Test 1

    

    Coursework Test 1 Quiz

    Opened: Saturday, 22 February 2025, 5:30 PM

    Closed: Saturday, 22 February 2025, 6:50 PM

    MAKERERE UNIVERSITY BUSINESS SCHOOL

    COURSEWORK TEST ONE FOR THE

    DEGREE OF BACHELOR OF BUSINESS COMPUTING (BBC)

    OF MAKERERE UNIVERSITY, ACADEMIC YEAR 2024/ 2025

    COURSE NAME:       Business Intelligence and Data warehousing  

    COURSE CODE:       BUC2225       YEAR OF STUDY:     Two             SEMESTER:   Two

    DATE:             Saturday 22^nd February 2025                                      TIME:  5.30-6.30pm

    INSTRUCTIONS:

    [1].  Attempt ALL Questions.

    [2].  Choose the MOST correct answer. 

• Select section DATASET FILES — PRACTICAL SESSIONS

  Collapse Expand

  DATASET FILES — PRACTICAL SESSIONS

  • Select activity UgandaRideTransport Dataset

    

    UgandaRideTransport Dataset File
  • Select activity MulagoClinicNetwork Dataset

    

    MulagoClinicNetwork Dataset File
  • Select activity GreenHarvestAgriculture Dataset

    

    GreenHarvestAgriculture Dataset File
  • Select activity Mukwano Industries Dataset

    

    Mukwano Industries Dataset File

    Download the file and carryout BI operations on it.

  • Select activity Northwind Dataset

    

    Northwind Dataset File

    Download the file and perform BI operations on it using PowerBI.

  • Select activity Supermarket Dataset

    

    Supermarket Dataset File

    Download the file and perform BI operations on it using PowerBI.

  • Select activity Date Query

    

    Date Query File
  • Select activity Project Submission

    

    Project Submission Assignment

    Opened: Thursday, 17 April 2025, 12:00 AM

    Due: Saturday, 19 April 2025, 12:00 AM