APS signifie Avant Projet Sommaire.
Toulouse, Occitanie, France
Mission chez Safran Helicopter Engines consiste :
• Expertise via la Création, Modification de Rapport PoWer Bi (toutes sources
de données telles que (Excel, txt, csv WebServices, SQL, Sharepoint…) et la
documentation associée,
• Ouverture de l’entrepot SQL à la BI Self service au travers de vues SQL,et
vues matérialisées. Toute ou verture de dataset(mise à disposition de vues)
devra etre renseignée dans le data catalogue Safran Helicopter Engines
•Support et Assistance au référent Power BI pour assurer la continuité de la
communauté BI, des POWER BI SCHOOL.
•Support et Assistance aux utilisateurs dans le développement de Rapports
Power BI au travers des plateaux Uses Cases,
•Assistance dans la rédaction de documentation autour du déploiement de la
BI Agile.
•Création Modification de flux SSIS et la documentation associée
Toulouse, Occitanie, France
Projet airfrance joint revenu,gestion de data warehouse airfrance et KLM
Les projets BI AFKLM contiennent les éléments classiques d’un projet BI
à savoir une base de données, un outil ETL d’alimentation, des scripts
de chargement regroupés en chaînes de chargement, un ordonnanceur
organisant ces chaînes, et différents outils de restitution des données pour les
utilisateurs finaux.
-To form a transversal Business Intelligence Unit
–To develop and produce standard management reports
–To centralize and improve Innovation Power
–To steer Forecasting and Budgeting processes
–To facilitate convergence of MI processes & Tools
–To improve efficiency of data production and Reporting
–To organize Joint Quality control on Data
QlikView SalesAllinOne*
–Dynamic analysis tool with some report functionalities–Through selections
all shown info is updated–Level of detail: detailed sales portfolio information–
Target group: (outdoor) sales employees–Main Information: trade/corporate
contracted info, MIDT, FWB, (BSP)
AMS/RP Tools
–Dynamic analysis tool; no reporting functionalities–Through selections
all shown info is updated–Level of detail: detailed network (subline/flights)
analysis–Target group: to support operational process of revenue mngnt–Main
Information: Delorean (forward booking), Monet (Revenues)
Business Object
– BoXi: –To build queries and reports. Not dynamic analysis tool–Selections
are defined in query–Level of detail: very detailed information –Target group:
building queries/reports by expert BI users, refresh of reports by non experts–
Main Information: everything we have available, from booking till loadfactor
Toulouse, Midi-Pyrénées, France
projet APS 'airbus product data management services' pour Airbus
APS is, as its name suggests, a piece of software responsible for the
management of all the changes than can happen in the life of an A/C (aircraft).
Each A/C will have changes during its lifecycle. It can happen during its
manufacturing, or later in its life, even after being delivered to the client. APS
is here to keep track of all those changes. That’s the main purpose of APS, but
actually, since it stores all the changes that happened to each A/C produced
by Airbus, APS also proposes complementary modules that use this data to
offer more services. So, APS is used by Airbus, during all the phases in the
lifecycle of their aircrafts.
In order to manage this data, APS first needs to gather it. The data is spread in
different applications which can be running in all the different countries where
Airbus is implemented (those countries are called the NatCos). So APS is also
here to aggregate the data from all those sources and to deliver some other
data that he processed to those sites too.
Région de Lyon, France
-Création d'une interface ETL avec Oracle Primavera et les fichiers natifs des
projets
-Automatisation de l'extraction et de la structuration des données via talend
afin de les charger dans la Database Oracle
-Réalisation d'une fonction d'aide à la décision en offrant une vue d'ensemble
de l'activité traitée(reporting,tableau de bord, rapport ....)