Automation and the use of technological tools have resulted in the accumulation of vast volumes of data by modern business organisations. Data warehouses have been set up as repositories to store this data and improved techniques now result in the speedy collection and integration of such data. OLAP technology has resulted in the faster generation of reports and more flexible analysis based on the data repositories. This unit will explore the concepts of data warehousing and OLAP, covering the data processing technological requirements for data warehousing and OLAP and will provide hands on experience on designing data warehousing and OLAP systems.
Minimum total expected workload to achieve the learning outcomes for this unit is 144 hours per semester typically comprising a mixture of scheduled online and face to face learning activities and independent study. Independent study may include associated reading and preparation for scheduled teaching activities.
Design multi-dimensional databases and data warehouses;
Implement online analytical processing (OLAP) queries;
Use fact and dimensional modelling;
Create business intelligence reports using data warehouses and OLAP.
Explain the roles of data warehousing architecture and the concepts of granularity in data warehousing;
Company
About UsMetaverse ClassroomNews & BlogJR CareersBecome a MentorOur MentorsContact UsJR Store J3.ClubResources
Job ReferralsEvents1-on-1 TutoringIndustry WhitepapersOnline LearningInterview CenterShare Interview ExperienceInternshipMembershipImmigration Services
Australia ImmigrationSkilled Visa 189/190/491Employer Sponsored 482/186/494Business Visa 188/888UK ImmigrationUS ImmigrationCanada ImmigrationEnterprise
P3 Career IncubatorEnterprise (EN)Corporate TrainingInternship PartnershipRecruitment PartnershipApply for PartnershipTop Categories
Web Full-Stack BootcampDevOps BootcampData Engineering BootcampData Analysis BootcampCoding for BeginnersBusiness Analyst InternshipAlgorithm BootcampCareer Services
BA & PM InternshipData Science InternshipData Analysis InternshipMarketing InternshipResume ReviewInterview CoachingVIP Mentor GuidanceAddresses
Level 10b, 144 Edward Street, Brisbane CBD(Headquarter)Level 2, 171 La Trobe St, Melbourne VIC 3000四川省成都市武侯区桂溪街道天府大道中段500号D5东方希望天祥广场B座45A13号Business Hub, 155 Waymouth St, Adelaide SA 5000Disclaimer
JR Academy acknowledges Traditional Owners of Country throughout Australia and recognises the continuing connection to lands, waters and communities. We pay our respect to Aboriginal and Torres Strait Islander cultures; and to Elders past and present. Aboriginal and Torres Strait Islander peoples should be aware that this website may contain images or names of people who have since passed away.
All content on the JR Academy website, including course materials, logos, and information provided, is protected under Australian intellectual property laws. Unauthorized use, sale, distribution, reproduction, or modification is strictly prohibited. Violations may result in legal action. By accessing our website, you agree to respect our intellectual property. JR Academy Pty Ltd reserves all rights, including patents, trademarks, and copyrights. Any infringement will be subject to legal prosecution. View Terms of Service
© 2017-2026 JR Academy Pty Ltd. All rights reserved.
ABN 26621887572
