Customer Service or Enrol: 0800 282 353 or +44 1372 364610
You Will Learn How To
Design, implement and refine a business intelligence (BI) solution
Apply a multitier BI process that turns outcomes into actions
Extract and transform data from an operational database to a data warehouse
Exploit business analytics and performance measurement tools
Organise a Business Intelligence Consistency Center (BICC)
Integrate BI into your daily business decisions
Course Benefits Setting up a business intelligence programme takes more than just installing the technology. A successful BI programme involves a set of concepts and methods designed to improve the business decision-making process by putting targeted information into the hands of those who need it most. This course provides a multitier process to design and implement an effective BI solution that maximises your organisation's business opportunities.
Who Should Attend Anyone interested in implementing a BI programme in their organisation, including programme and project managers, business and statistical analysts, and marketing directors. Prior BI experience is not needed.
An interactive and evolving case study immerses you in a challenging environment where you explore the concepts and methods behind a business intelligence implementation. Activities include:
Applying a multitier BI process
Analysing successful systems to identify what works
Building a simple BI system
Combining simple systems to create a complex BI solution
Creating an information flow diagram and business rules
Organising a Business Intelligence Competency Center (BICC)
Incorporating BI tools to evaluate the quality of data
Mapping operational data to a data warehouse
Course Content
Defining Business Intelligence (BI)
Components of a BI solution
Mapping the business intelligence process
Identifying the business needs for BI
New BI taxonomy
BI-specific management issues
Driving business agility and efficiency
Building a BI Framework Applying BI to solve business problems
Assessing the business problem
Identifying major components of a BI process
Focusing on pertinent information using the BI process
Stating desired outcome for a given situation
Overcoming common BI challenges
Building from the simple to the complex
Starting BI with simple processes
Combining processes to solve complex problems
Scaling the BI process to fit your organisational needs
Enabling repeatable and successful BI processes
Discovering BI possibilities
Listing the major components of a BI system
Comparing and contrasting the attributes of an existing BI system using a BI matrix checklist
Reviewing successful systems
Selecting capabilities for your organisation
Identifying critical and variable attributes of a BI system
Connecting BI processes
Realising the desired outcome from a specific organisational situation
Targeting the process to achieve the desired outcome
Deriving actions and decisions from the Outcome Tier
Designing and Planning BI Processes Transitioning from the Knowledge Tier to the Information Tier
Architecting the information flow model
Identifying information flow stages
Applying the knowledge framework
Migrating from the Information Tier to the Data Tier
Articulating the business rules
Profiling the data
Classifying the data domains
Extracting and transforming data from the operational database to the data warehouse
Comparing and contrasting operational databases and data warehouses
Migrating data to the data warehouse
Testing Extract Transform and Load (ETL) tools
Implementing and Fine Tuning the BI Solution Evaluating business analytic tools
Selecting criteria for business analytics
Exploring online analytic processing (OLAP) tools
Slicing and dicing your data using multidimensional analysis
Defining the characteristics of a data mine
Reviewing data mining tools
Leveraging performance measurement tools
Extracting information using dashboards
Assessing the current state of your business with key performance indicators (KPIs)
Communicating to stakeholders through scorecards
Organising a Business Intelligence Consistency Center (BICC)
Promoting expertise within your organisation
Creating a BICC functional checklist
Defining the roles of the BICC
Organising the BICC
Putting BI to Work for You
Applying the BI process across the organisation
Making predictive analytics work for your bottom line
Blending BI process into daily management activities
RealityPlus is a trademark of Learning Tree International.