{"id":460,"date":"2025-05-05T16:48:17","date_gmt":"2025-05-05T16:48:17","guid":{"rendered":"http:\/\/portfolio-data.local\/?p=460"},"modified":"2025-05-06T14:11:17","modified_gmt":"2025-05-06T14:11:17","slug":"creation-dune-base-de-donnees-immobiliere","status":"publish","type":"post","link":"https:\/\/riverphot.com\/data\/creation-dune-base-de-donnees-immobiliere\/","title":{"rendered":"Cr\u00e9ation d&rsquo;une base de donn\u00e9es relationnelle pour l&rsquo;analyse des contrats immobiliers"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"460\" class=\"elementor elementor-460\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f77165d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f77165d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7b4eb3b\" data-id=\"7b4eb3b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-408b8b9 elementor-widget elementor-widget-heading\" data-id=\"408b8b9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Cr\u00e9ation d'une base de donn\u00e9es relationnelle <br>pour l'analyse des contrats immobiliers<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-29ce138 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"29ce138\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"\/wp-content\/uploads\/2025\/05\/DataImmo.pdf\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-share-square\"><\/i>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Voir le rapport<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-169afe2 elementor-widget elementor-widget-heading\" data-id=\"169afe2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Objectif du projet<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-68d1c9f elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"68d1c9f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a1c35db elementor-widget elementor-widget-text-editor\" data-id=\"a1c35db\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Concevoir une base de donn\u00e9es relationnelle normalis\u00e9e pour centraliser les informations immobili\u00e8res (ventes, localisation, d\u00e9mographie) et r\u00e9diger des requ\u00eates SQL afin d\u2019analyser le march\u00e9 et mieux accompagner les clients des agences Laplace Immo.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-96569eb elementor-widget elementor-widget-heading\" data-id=\"96569eb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Approche m\u00e9thodologique<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f5eacb8 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"f5eacb8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0f7c36d elementor-widget elementor-widget-text-editor\" data-id=\"0f7c36d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Le projet a d\u00e9but\u00e9 par une analyse approfondie de plusieurs sources de donn\u00e9es (DVF, INSEE, r\u00e9f\u00e9rentiel g\u00e9ographique) pour identifier les colonnes pertinentes, respecter la r\u00e9glementation RGPD, et documenter les variables \u00e0 conserver via un dictionnaire structur\u00e9.<\/p>\n<p>Un travail de mod\u00e9lisation a ensuite \u00e9t\u00e9 r\u00e9alis\u00e9 pour mettre \u00e0 jour le sch\u00e9ma relationnel et garantir une structuration en 3e forme normale, avec une gestion rigoureuse des cl\u00e9s primaires et \u00e9trang\u00e8res.<\/p>\n<p>La base de donn\u00e9es a \u00e9t\u00e9 cr\u00e9\u00e9e dans un SGBD, les fichiers CSV nettoy\u00e9s et pr\u00e9par\u00e9s, puis import\u00e9s dans les tables con\u00e7ues.<\/p>\n<p>Enfin, plusieurs requ\u00eates SQL complexes ont \u00e9t\u00e9 d\u00e9velopp\u00e9es pour r\u00e9pondre \u00e0 des besoins m\u00e9tier sp\u00e9cifiques : \u00e9volution des ventes par zone g\u00e9ographique, tendances des prix, volumes par type de bien, et analyses crois\u00e9es avec la d\u00e9mographie locale.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-949e42d elementor-widget elementor-widget-heading\" data-id=\"949e42d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comp\u00e9tences et outils mobilis\u00e9s<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0f1a552 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"0f1a552\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a9133a elementor-widget elementor-widget-text-editor\" data-id=\"4a9133a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>Base de donn\u00e9es : cr\u00e9ation de tables, gestion des cl\u00e9s, jointures complexes, agr\u00e9gations<\/li>\n<li>Nettoyage et pr\u00e9paration de fichiers CSV<\/li>\n<li>Conception de dictionnaire de donn\u00e9es (type, r\u00e8gles de gestion, RGPD)<\/li>\n<li>Mod\u00e9lisation relationnelle (3NF)<\/li>\n<li>Documentation technique et vulgarisation<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e5039b1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e5039b1\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9da382e\" data-id=\"9da382e\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d4de335 elementor-widget elementor-widget-heading\" data-id=\"d4de335\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">\ud83d\udcbb Environnement technique et biblioth\u00e8ques\u200b<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e575715 liste-tag elementor-widget elementor-widget-text-editor\" data-id=\"e575715\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<span>SQL<\/span>\n<span>Excel<\/span>\n<span>Power query<\/span>\n<span>SQL Lite<\/span>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8a93fd7 elementor-widget elementor-widget-heading\" data-id=\"8a93fd7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">\ud83e\udde0 M\u00e9thodes et techniques appliqu\u00e9es<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4be6784 liste-tag-skills elementor-widget elementor-widget-text-editor\" data-id=\"4be6784\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<span>Mod\u00e9lisation relationnelle<\/span>\n<span>Normalisation 3NF<\/span>\n<span>Dictionnaire de donn\u00e9es<\/span>\n<span>Requ\u00eates SQL<\/span>\n<span>Agr\u00e9gation<\/span>\n<span>Jointures<\/span>\n<span>Analyse descriptive<\/span>\n<span>RGPD<\/span>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Cr\u00e9ation d\u2019une base de donn\u00e9es relationnelle et r\u00e9daction de requ\u00eates SQL avanc\u00e9es pour analyser les ventes immobili\u00e8res, dans le cadre du projet strat\u00e9gique DATAImmo.<\/p>\n","protected":false},"author":1,"featured_media":562,"comment_status":"closed","ping_status":"","sticky":false,"template":"elementor_canvas","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[46,33,30,45],"class_list":["post-460","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-portfolio","tag-architecture-de-base-de-donnees","tag-excel","tag-rgpd","tag-sql"],"_links":{"self":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts\/460","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/comments?post=460"}],"version-history":[{"count":12,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts\/460\/revisions"}],"predecessor-version":[{"id":523,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/posts\/460\/revisions\/523"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/media\/562"}],"wp:attachment":[{"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/media?parent=460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/categories?post=460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/riverphot.com\/data\/wp-json\/wp\/v2\/tags?post=460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}