Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Business Intelligence for Manager & Business Analyst

Name: Business Intelligence for Manager & Business Analyst
Rating: 4.4 (19 reviews)

Understand the basics and express a need in BI with a little french touch !

Created byClément Fiocre | Data | API | Business Intelligence | Low Code

Last updated 5/2026

English

What you'll learn

Express your requirements in a Business Intelligence project
Identify the information involved in a Business Intelligence project
Scope and design a BI Dashboard
Identify and name the components of a BI project
Understand the fundamental concepts of Business Intelligence
Contribute to discussions in a Business Intelligence project

Course content

6 sections • 47 lectures • 3h 35m total length

Introduction1:54
Before your inscription: Description of a BI project4:29
Description of our point of view on what a Business Intelligence project is in order to avoid any misunderstanding. This training covers the notions of data flow and data pipeline. but it only flies over them.

Facts3:31
In this session, we address the most structuring concept of a BI project, namely the facts. We will start with an extremely simple example and then move on to more business examples.
Fact exercices
Dimensions4:10
In this part, we will discuss another structuring concept in Business Intelligence, namely dimensions. We will start again from the example of the pen and then we will take other more business-oriented examples.
Introduction to indicators1:53
In this part we will introduce the concept of indicator. However, we will miss other Business Intelligence concepts before we can define this concept.
Indicators are discussed as essential units of work in BI projects.
Meshes1:50
In this part, we will discuss a concept that structures the construction of an indicator, i.e. the Meshes
Measures4:29
In this section we will discuss a structuring but optional concept for constructing an indicator, namely Measures.
Indicators3:06
In this section we will conclude on indicators, the most important concept in BI.
Aggregation5:25
See how aggregation merges core business application data with BI indicators, summing monthly sales and applying various operations to produce insightful indicators.
Vocabulary reinforcement
Information qualification
Aggregated data or not ?
Concrete example4:07
In this video, we will simulate an analysis made by a manager or a business analyst using the basic concepts in Business Intelligence that we discussed before.

Session introduction0:52
In this part we introduce the section that consists in expressing a need in Business Intelligence.
Simplified business need expression8:29
In this section we will break down some indicators. This example is not a complete BI requirement expression example. We will enrich the process later.
Expressing a Business need in BI
Exercise result6:28
In this part, we will correct the exercises proposed in the previous part.
Dashboards & Graph3:41
In this part we will discuss the notion of Dashboard, the deliverable of a Business Intelligence project.
We will also discuss an essential BI notion, the graphic forms.
Complex Fact5:33
In this part, we will discuss a controversial concept that is the complex fact. This notion does not come from the world of Business Intelligence and should be used with caution.
Complex fact or not?
Introduction to the template3:53
In this section we will discuss the requirements template, which is actually one of the processes of data governance. We will then see that we are dealing with the data catalog (or data dictionary) and meta data management
The Data Catalog8:08
In this part, we will build a collaborative data catalog (or data dictionary) using AirTable.

Session introduction1:41
This part introduces the functional components necessary to build a BI project
Data Sources & 360 view5:38
In this section we will discuss the data sources of a Business Intelligence project and we will review the notion of 360° Vision.
We will also briefly discuss the positioning of MDM (Master Data Management) in the constitution of the 360° vision
Data Sources & 360 view
The Data Pipeline5:47
In this part we will discuss the notion of Data Pipeline and its position in a BI project.
We will also have the opportunity to talk about the notion of ETL.
The Data Pipeline
Datawharehouse Data Modeling trends8:14
In this part, we will explore three trends of data modeling in a data warehouse:
- The snowflake model
- The star model
- The Data Vault
Datawharehouse Data Modeling trends
The Data Warehouse Concept6:33
In this part we will explore the technical architecture of a Data Warehouse, major concept in a Business Intelligence architecture
The Cube5:00
In this notion, we will approach the concept of cube, it contains the data representing the indicators of the project in Business Intelligence.
Data Warehouse

Introduction1:20
Presentation of the process and data4:37
In this section, we will present the process and data involved in the case study that we will use in the Pentaho Data Integration and Power BI demonstration
Tools Presentation (Power BI, Pentaho Data Integration - PDI, MySQL)4:54
In this section, we will present :
- Pentaho Data Integration
- Power BI
- MySQL
These are the tools we will use to implement the case study
Architecture Presentation1:46
In this section, we will present the architecture to support the case study. This will allow us to define the role of MySQL, Pentaho Data Integration and Power BI
Presentation of source data3:16
In this part, we will introduce the Excel files that we will use as source application. We will use Pentaho Data Integration to load them
Construction of the landing database3:43
In this part we will build the landing database, we will use Pentaho Data Integration to load it later.
Loading files into the landing database9:51
In this part, we will model the landing database loading flows with Pentaho Data Integration.
Building the Data Warehouse1:24
In this part we will build the Data Warehouse database, we will use Pentaho Data Integration to load it afterwards.
Loading the Data Warehouse5:52
In this part, we will retrieve the data from the landing database and load it into the data warehouse using Pentaho Data Integration
Loading Power BI2:53
In this section, we will use Power BI to retrieve data from the data warehouse.
Data enrichment with DAX3:33
In this part, we will use DAX, the programming language of Power BI, to enrich the data.
Building Dashboards6:58
Dans cette partie, nous allons contruire des dashboards dans Power BI.

Introduction2:22
Introduction to Architecture Aspect4:24
Identify Data Sources (1/3)3:09
Identify data sources in the information system to feed dashboards when data isn’t in the data warehouse, mapping dimensions and facts from core business, support, external, and master data.
Identify Data Sources (2/3)9:18
Identify Data Sources (3/3)1:56
Identify Facts Data7:18
Identify Dimensions Data6:51
Identify dimension data sources across referential architectures: collaboration, consolidation, and absence of reference, and weigh risks, master data, and the role of a data pipeline for reliable business intelligence.
Identify IT Projects5:44
Identify Business Projects (1/2)1:56
Identify business projects by reengineering company processes to feed data for the data warehouse and dashboards. Acknowledge that without data, investments in bi and dashboards fail, making business workshops essential.
Identify Business Projects (2/2)5:14
Identify Data Recovery Projects5:04
Identify the processes impacted by a business intelligence project and the missing data required, whether dimensions or facts, and plan data recovery strategies from sources like suppliers, countries, and factories.
Architecture Aspect Conclusion7:11

Requirements

No experience in Business Intelligence
No experience in programming

Description

Express Your BI Needs with Precision and Confidence!

Join the professionals who leverage Business Intelligence projects to better serve their teams and organizations. Our training shows you how to effectively articulate your business requirements for successful and relevant BI projects. With a clear teaching approach and concrete examples, you will learn to clarify and communicate your BI needs, ensuring that the proposed solutions are perfectly aligned with your organization’s strategic goals. Transform your role within your company by becoming the essential bridge between technology and business needs.

What You Will Learn

Understanding the Fundamentals of Business Intelligence: Discover the basic principles of BI, data types, and key metrics that guide strategic decisions in companies.

Articulating Your Business Needs: Learn to identify and clearly articulate your needs for a BI project, ensuring that the developed solutions precisely meet your team’s requirements.

Collaborating with IT Teams: Gain the skills to work effectively with technical teams, using a common language that facilitates understanding and project implementation.

Creating and Interpreting BI Dashboards: Master the tools needed to create and interpret dashboards that effectively visualize data, allowing for simplified performance tracking and analysis.

Data-Based Decision Making: Enhance your ability to make strategic decisions based on real and predictive data analysis, thereby improving business outcomes.

Project Management and Roadmap Development: New! Learn to develop a macro project roadmap, incorporating lessons from BI to prioritize, orchestrate, and budget various tasks. This section will equip you to effectively manage project scoping phases, coordinate IT and business activities, and ensure successful execution.

Why This Training Is Unique ?

This training is specifically designed for non-technical individuals in management and analysis roles. With a mix of theory and practice, including real case studies and simulations, you will be prepared to make a significant contribution to Business Intelligence projects without requiring deep technical expertise.

Your Instructor: Clément Fiocre: Benefit from the expertise of Clément Fiocre, a data architect and certified trainer with over 20 years of experience in managing corporate information assets. Clément will guide you through each step of the training, ensuring clear understanding and practical skills.

Effectively Contribute to Your Company’s Business Intelligence Projects

Enhance your ability to actively participate in Business Intelligence projects with this training. You will learn to clarify and communicate business needs, allowing you to collaborate effectively with technical teams and align technological solutions with your company’s strategic objectives. This knowledge will help you support well-informed decisions and improve the efficiency of BI initiatives, strengthening your role in strategic discussions without requiring extensive technical expertise.

Ready to Become a Key Player in BI Projects? Register Now!

Take advantage of our special offer to access this comprehensive Business Intelligence training for only €12.99, an exceptionally low price! This offer is temporary and designed to make learning accessible to everyone without compromising quality. Don’t miss this chance to develop BI skills, recognized and demanded in the industry, at a minimal cost. Get ahead in your career: click below and start today to transform your ability to influence the strategic projects of your company.

Who this course is for:

Team Manager
Business Analyst
Product Owner

Business Intelligence for Manager & Business Analyst

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 6min

Fundamental concepts of Business Intelligence8 lectures • 29min

Expressing a BI business need7 lectures • 37min

Business Intelligence project components6 lectures • 33min

Demonstration with Power BI and Pentaho Data Integration12 lectures • 50min

Identify IT & Business Projects12 lectures • 1hr

Requirements

Description

Who this course is for: