Course Duration
4 Days
Database and Business Intelligence
Authorized Training
IT
Course cost:
£4,590.00
IT Certification Overview
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.
Newto Training Reviews
What Our Happy Alumni Say About Us
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
Prerequisites
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.
Learning Objectives
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
Developing A Modern Business Intelligence System Course Content
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
Upcoming Dates
Dates and locations are available on request. Please contact us for the latest schedule.
Advance Your Career with Developing A Modern Business Intelligence System
Gain the skills you need to succeed. Enrol in Developing A Modern Business Intelligence System with Newto Training today.