Developing A Modern Business Intelligence System Training in Norway

  • Learn via: Classroom / Virtual Classroom / Online
  • Duration: 4 Days
  • Level: Fundamentals
  • Price: From €5,791+VAT
We can host this training at your preferred location. Contact us!

Business Intelligence (BI) systems are the heart of any company’s analytical capability. This course introduces the delegate to all the necessary terminology, architectures, approaches, skills, techniques, and infrastructure necessary to design and implement a successful BI system. The course focuses on the generic skills that are necessary to create an effective BI system and will teach you the skills that underpin good BI development no matter which software platform you use.

A BI system has the potential to revolutionise your business. It can turn the mass of data that sits in your operational systems (Finance, HR, Sales etc.) into high quality, well-defined information. This information allows you to move from a ‘gut-feel’ approach of decision making to a proper, evidence-based approach. A well-designed BI system collects the appropriate data from your operational systems and move it into a data warehouse. There it is restructured and organised for analytical purposes and often deployed to data marts. The approach, methodology and design techniques required to build a BI system differ significantly from those required to build operational systems and include ETL (Extract, Transform and Load), dimensional modelling and OLAP (On-Line Analytical Processing).

Target Audience

This course is made up of a mix of theory and vendor-neutral practicals that allow delegates to apply the principles they have learnt. It is ideal for developers, software engineers, database administrators, data analysts, system analysts or application designers who will be involved in designing, building or maintaining a BI system. Please note delegates who have previously attended CSWARDE2 - Effective Data Warehouse Construction should not attend this course.

Basic understanding of IT and how business systems use IT; this would be gained by at least a year's experience in IT or business systems development.
Some exposure to Relational Databases and Database Modelling. Database modelling skills can be acquired on QA's Database Analysis and Design course.
Systems/Application programming experience would also be an advantage.

Please note:

Delegates who have previously attended:

'CSWARDE2 - Effective Data Warehouse Construction'

and/or

'QADM - Dimension Modelling'

- Should not attend this course due to duplication of content.

At the end of this course you will be able to:

  • Make a business case, assemble a project team, and lay the infrastructure necessary for the BI system construction to begin
  • Design, implement, utilise, maintain, and administer the BI system
  • Understand dimensional modelling
  • Talk to users and create a logical model from their analytical requirements
  • Turn those logical models into a star schema
  • Extract data from one or more operational systems
  • Transform, condition, and cleanse the data
  • Load the data into the data warehouse using a variety of mechanisms
  • Query, drill-down, and report the data
  • Understand the role of technologies such as OLAP and data mining
  • Assess your organisation's readiness to embark on a BI project

Introduction

Data overview, Historical background; What is a BI System and why do we need it? OLTP versus OLAP; Benefits to the business; Benefits to IT; Reasons for failure; The processes of building and running BI systems

BI Architectures

Centralised Data Warehouse; Independent or Federated Data Marts; Hybrid approach; Standards

The Project

Top down vs. bottom up development; Ownership & funding; Methodology; Scoping and requirements gathering

Requirement Analysis

Review of modelling terminology and techniques; How a Warehouse is different; Logical and physical modelling; 3NF vs. denormalisation, Questions to ask in determining requirements; Sun modelling

Dimensional Modelling Basics

The dimensional model; The fact table; The dimension tables; Modelling Attributes in the Dimensions; Steps in design

Dimensional Modelling Further Considerations

Conformed Dimensions; Synonym Dimensions; Mini Dimensions; Snowflaking; Slowly changing dimension types 0-4; Junk dimensions; Degenerate dimensions; Aggregations; The importance of Surrogate Keys

Data Extraction

Extraction method; The meaning of the data, The Data Quality Assessment Process

Data Transformation

The case for data quality; Transformation; Cleansing; Conditioning; Specific data type issues; Transformation methods

Data Loading

How to identify what has changed; Snapshot vs. detail data; Full Refresh vs. Delta Capture; Load methodology; Load techniques

Querying the Data

Canned queries; Report writers; ROLAP and OLAP tools; Data visualisation; Drilldown analysis; End user training; Performance

Data Mining and Exploration

Data mining methodology; Data mining algorithms; Interpreting the output; Formulating a strategy

Operating and Maintaining the System

Processes and procedures; Change control; User and privilege administration; Service level agreements; Archive and recovery



Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Norway facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
26 november 2024
Oslo, Bergen, Trondheim
4 Days
Classroom / Virtual Classroom
03 januar 2025
Oslo, Bergen, Trondheim
4 Days
Classroom / Virtual Classroom
07 januar 2025
Oslo, Bergen, Trondheim
4 Days
Classroom / Virtual Classroom
26 november 2024
Oslo, Bergen, Trondheim
4 Days
Classroom / Virtual Classroom
14 januar 2025
Oslo, Bergen, Trondheim
4 Days
Classroom / Virtual Classroom
21 januar 2025
Oslo, Bergen, Trondheim
4 Days
Classroom / Virtual Classroom
03 januar 2025
Oslo, Bergen, Trondheim
4 Days
Classroom / Virtual Classroom
07 januar 2025
Oslo, Bergen, Trondheim
4 Days
Developing A Modern Business Intelligence System Training Course in Norway

The Nordic country Norway, is in Northern Europe. Known for its stunning natural beauty, including fjords, mountains, and forests, Norway is also famous for its high standard of living and strong social welfare system. Norway's capital and largest city is Oslo. Tromsø, Bergen, Trondheim and Stavanger are the other tourist attracting cities of Norway.

Norway is a constitutional monarchy with King Harald V as the head of state. The country has a population of 5,425,270 as of January 2022. Norway is a relatively small country and has a relatively low population density, with much of its land area covered by forests, mountains, and fjords. Despite its small size, Norway is known for its rich cultural heritage, strong economy, and stunning natural beauty, which attracts millions of visitors every year. This Nordic country is also known for its winter sports, such as skiing and snowboarding, and is a popular destination for outdoor enthusiasts.

Norway has a long history of invention and is home to numerous more top-tier tech firms and research facilities, such as; Kongsberg Gruppen, Telenor, Atea, Evry and Gjensidige Forsikring.

Due to the country's high latitude, there are large seasonal variations in daylight. From late May to late July, the sun never completely descends beneath the horizon. Which attracts many tourists around the world to see the "Land of the Midnight Sun". Tourists mainly visit Sognefjord, Norway's Largest Fjord, Pulpit Rock, one of the most photographed sites in Norway and of course the capital; Oslo.

Oslo is considered the business center of Norway. It is the country's largest city and the capital of Norway. The city is home to many of Norway's largest and most important companies, as well as several international organizations and research institutions. Additionally, the city is a popular tourist destination, known for its scenic location on the Oslo Fjord, its many museums and cultural attractions, and its vibrant nightlife and dining scene. Some of the most popular museums in Oslo are The Norwegian Museum of Cultural History, The Nobel Peace Center, The National Museum of Art, Architecture, and Design, The Munch Museum and The Vigeland Museum.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.