This training will allow participants to understand what Business Intelligence is, and how it is implemented through tools such as SAP Business Objects, Qlikview. For educational purposes, the training ends with a practical case of business intelligence implementation under Microsoft Excel. At the end of this training you will be able to:

• Understand the objectives of Business Intelligence
• Understand the implementation of Business Intelligence through SAP Business Objects ® Qlikview ®
• Understand the main components of Business Intelligence and be able to identify them in a professional environment

1. BUSINESS INTELLIGENCE OVERVIEW

2. BUSINESS INTELLIGENCE WITH SAP BUSINESS OBJECTS

3. BUSINESS INTELLIGENCE WITH QLIKVIEW

4. PEDAGOGICAL IMPLEMENTATION OF BUSINESS INTELLIGENCE IN MICROSOFT EXCEL

This training will enable you to implement a simple Business Intelligence solution with Power BI Desktop tools. At the end of this training, you will also be able to create quality data connections, models, reports and visualizations.

• Be able to implement a Business Intelligence solution
  simple with Power BI Desktop tools
• Create quality data connections, templates, reports and visualizations
• Learn how to format and combine data from different sources

1. INTRODUCTION TO BUSINESS INTELLIGENCE

2. TAKING CHARGE OF THE ENVIRONMENT

3. DATA CONNECTION AND MODELING

4. QUERY EDITING AND DATA TRANSFORMATION

5. CREATE VISUALIZATIONS

6. ADVANCED TECHNIQUES AND DAX FORMULAS

• Establish the fundamentals of programming
• Understand the most common uses in VBA-Excel
• Acquire the ability to progress self-taught in Excel-VBA

1. UTILITY OF EXCEL-VBA

• Excel-VBA, for what?
• Use cases in marketing
• Use cases in management control
• Use cases in the financial sector

2. EXCEL-VBA OVERVIEW

• Introducing VBA
• Principles of language and programming and automation
• Creating and running macros
• Description of the environment: the project, the sheets, the modules, the libraries.

3. CREATING AND USING OBJECTS

• Creation and use of buttons
• Using input data fields
• Calling external objects
• Demonstration of the use of forms
• Automatic creation of sheets and workbooks

4. RECURRING ROUTINES AND ALGORITHMS
5. CONNECTING TO EXTERNAL SOURCES
6. GOOD PRACTICES
7. VBA SELF LEARNING PRINCIPLES AND TIPS

This course will make you able to create simple or complex Web Intelligence documents by achieving the following objectives.

• Understand the concepts of Business Intelligence and Business Objects Web Intelligence
• Create simple or complex Web Intelligence documents, composed of one or more reports, combining one or more data sources

1. INTRODUCTION TO SAP BUSINESS OBJECTS

2. BI LAUNCH PAD ENVIRONMENT

3. DOCUMENT STRUCTURE AND ERGONOMICS

4. CREATING AND USING REPORTS

5. DIAGRAM MANAGEMENT
6. DATA ANALYSIS
7. GOOD PRACTICES
8. DOCUMENT SHARING

This course will make you able to understand a VBA program and automate all or parts of a treatment for a VSE/SME. At the end of this course you will also be able to automate the creation of graphs and pivot tables related to business activities.

• CUnderstand what VBA is and its utility for Excel
• Become familiar with the Excel VBA environment and be able to read a program
• Master recurrent algorithmic routines
• Be able to automate formatting tasks
• Be able to automate the creation of charts and Pivot Tables.

1. UTILITY OF EXCEL-VBA

• Excel-VBA, for what?
• Use cases in marketing
• Use cases in management control
• Use cases in the financial sector

2. EXCEL-VBA OVERVIEW

• Introducing VBA
• Principles of language and programming and automation
• Creating and running macros
• Description of the environment: the project, the sheets, the modules, the libraries.

3. CREATING AND USING OBJECTS

• Creation and use of buttons
• Using input data fields
• Calling external objects
• Demonstration of the use of forms
• Automatic creation of sheets and workbooks

4. RECURRING ROUTINES AND ALGORITHMS
5. CONNECTING TO EXTERNAL SOURCES

6. CREATION AND AUTOMATION OF CHARTS AND PIVOT TABLES
7. IMPLEMENTATION OF PERIODIC COMMERCIAL MONITORING
8. IMPLEMENTATION OF AN AUTOMATIC COMPARISON TOOL BETWEEN TWO PERIODS
9. SELF-LEARNING PRINCIPLES AND GOOD PRACTICES

• Understand what data governance is
• Be able to choose the right data governance model for your business
• Be able to ensure reliable data from integration to restitution
• Know the roles of data governance

1. DATA GOVERNANCE: DEFINITION AND NEED
2. CHOOSING A DATA GOVERNANCE MODEL
3. PROVIDE RELIABLE DATA
4. DATA GOVERNANCE RECOMMENDATIONS
5. ROLES IN DATA GOVERNANCE
6. EXAMPLES OF SUCCESSFUL DATA GOVERNANCE
7. TOWARDS DATA INTELLIGENCE, FROM INTEGRATION TO RESTITUTION

• Understand what data quality is
• Know the tools of data quality
• Implement a continuous improvement approach to data quality

1. WHAT IS DATA QUALITY
2. DATA QUALITY, DATA GOVERNANCE AND DATA MANAGEMENT
3. DATA QUALITY TOOLS
4. BISSONGENIOUS DATA QUALITY IMPROVEMENT METHODOLOGY
5. STUDY CASE
6. ARTIFICIAL INTELLIGENCE AND DATA QUALITY

• Understanding the need for a data warehouse
• Know the components and management of a data warehouse
• Be able to launch and manage a data warehouse project
• Be able to conduct a requirements gathering document
• Be able to make a dimensional modeling

1. Reminder of BI objectives and associated concepts
2. The need for data warehouse
3. Data warehouse components and management
4. Starting and Managing a Data Warehouse Project
5. Data warehouse and datamarts
6. The requirements gathering document
7. Conducting workshops
8. Relational Modeling for Businesses
9. Dimensional modelling

• Master the architecture and role of the universe designer
• Create the structure and objects of a universe
• Implement the functions and the optimal organization of a universe: value lists, aggregate tables, joins...

1. INTRODUCTION TO SAP BUSINESS OBJECTIS BI 4
2. CREATING A UNIVERSE: THE PROJECT...
3. CREATING A UNIVERSE: CONNECTIONS
4. CREATING A UNIVERSE: THE DATA FOUNDATION
5. CREATING A UNIVERSE: THE MANAGEMENT LAYER
6. COMPLEMENTARY FUNCTIONS AND OPTIMIZATION