Business Intelligence for Manager & Business Analyst
- Descrição
- Currículo
- FAQ
- Revisões
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.
-
3
FactsIn 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.
-
4
Fact exercices -
5
Dimensions
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.
-
6
Introduction to indicators
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.
-
7
Meshes
In this part, we will discuss a concept that structures the construction of an indicator, i.e. the Meshes
-
8
Measures
In this section we will discuss a structuring but optional concept for constructing an indicator, namely Measures.
-
9
Indicators
In this section we will conclude on indicators, the most important concept in BI.
-
10
Aggregation
-
11
Vocabulary reinforcement
This exercise will allow you to reinforce your knowledge of basic Business Intelligence vocabulary.
-
12
Information qualification
This exercise will test your understanding of basic BI concepts
-
13
Aggregated data or not ?
-
14
Concrete example
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.
-
15
Session introduction
In this part we introduce the section that consists in expressing a need in Business Intelligence.
-
16
Simplified business need expression
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.
-
17
Expressing a Business need in BI -
18
Exercise result
In this part, we will correct the exercises proposed in the previous part.
-
19
Dashboards & Graph
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.
-
20
Complex Fact
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.
-
21
Complex fact or not?
This exercise will allow you to strengthen your knowledge of complex facts
-
22
Introduction to the template
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
-
23
The Data Catalog
In this part, we will build a collaborative data catalog (or data dictionary) using AirTable.
-
24
Session introduction
This part introduces the functional components necessary to build a BI project
-
25
Data Sources & 360 view
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
-
26
Data Sources & 360 view
This exercise will allow you to test your understanding of basic BI components
-
27
The Data Pipeline
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.
-
28
The Data Pipeline
This exercise will allow you to test your understanding of basic BI components
-
29
Datawharehouse Data Modeling trends
In this part, we will explore three trends of data modeling in a data warehouse:
- The snowflake model
- The star model
- The Data Vault
-
30
Datawharehouse Data Modeling trends
This exercise will allow you to test your understanding of basic BI components
-
31
The Data Warehouse Concept
In this part we will explore the technical architecture of a Data Warehouse, major concept in a Business Intelligence architecture
-
32
The Cube
In this notion, we will approach the concept of cube, it contains the data representing the indicators of the project in Business Intelligence.
-
33
Data Warehouse
This exercise will allow you to test your understanding of basic BI components
-
34
Introduction
-
35
Presentation of the process and data
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
-
36
Tools Presentation (Power BI, Pentaho Data Integration - PDI, MySQL)
In this section, we will present :
- Pentaho Data Integration
- Power BI
- MySQL
These are the tools we will use to implement the case study
-
37
Architecture Presentation
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
-
38
Presentation of source data
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
-
39
Construction of the landing database
In this part we will build the landing database, we will use Pentaho Data Integration to load it later.
-
40
Loading files into the landing database
In this part, we will model the landing database loading flows with Pentaho Data Integration.
-
41
Building the Data Warehouse
In this part we will build the Data Warehouse database, we will use Pentaho Data Integration to load it afterwards.
-
42
Loading the Data Warehouse
In this part, we will retrieve the data from the landing database and load it into the data warehouse using Pentaho Data Integration
-
43
Loading Power BI
In this section, we will use Power BI to retrieve data from the data warehouse.
-
44
Data enrichment with DAX
In this part, we will use DAX, the programming language of Power BI, to enrich the data.
-
45
Building Dashboards
Dans cette partie, nous allons contruire des dashboards dans Power BI.
