{"id":1968,"date":"2026-01-26T19:49:50","date_gmt":"2026-01-26T19:49:50","guid":{"rendered":"https:\/\/ranaghazzi.com\/?p=1968"},"modified":"2026-04-11T01:55:21","modified_gmt":"2026-04-11T01:55:21","slug":"it-survey-part-2","status":"publish","type":"post","link":"https:\/\/ranaghazzi.com\/?p=1968","title":{"rendered":"Survey Analysis Medallion Pipeline"},"content":{"rendered":"<p><style>\n    .light-font-container, .light-font-container p, .light-font-container h2, .light-font-container li {<br \/>\n        font-weight: #FFFFFF !important;<br \/>\n    }<br \/>\n<\/style>\n<\/p>\n<div class=\"light-font-container\" style=\"background-color: #2b85d9; padding: 40px; border-radius: 15px;\">\n<h1 class=\"light-font-container\" style=\"background-color: rgba(43, 134, 217, 0.63); padding: 40px; border-radius: 15px; text-align: center;\">Survey Analysis Medallion Pipeline<\/h1>\n\n\n<div style=\"height:21px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading has-contrast-color has-text-color has-background has-link-color has-large-font-size wp-elements-58e75ad4fa534e94847ac85d993faf7f\" id=\"block-11bdef61-7168-49e8-8e43-6760caaf6544\" style=\"background-color:#2b86d9a1\"><strong>Tools:&nbsp;Jupiter Notebook | PostgreSQL | Python: Pandas | NumPy | Matplotlib | Seaborn | SciPy<\/strong><\/h3>\n\n\n\n<div style=\"height:19px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button is-style-outline is-style-outline--1\"><a class=\"wp-block-button__link has-contrast-color has-text-color has-background has-link-color has-large-font-size has-custom-font-size wp-element-button\" href=\"https:\/\/github.com\/Ranoush75\/Survey-Analysis-Medallion-ETL.git\" style=\"background-color:#a7f161\"><strong>Github<\/strong><\/a><\/div>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:1px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Project Overview<\/strong><\/h2>\n\n\n\n<div style=\"height:0px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-contrast-color has-text-color has-background has-link-color has-large-font-size wp-elements-221b77fb3e6deaace4195caeb3b7310b\" style=\"background-color:#2b86d9a1\">This project implements a multi-layer ETL pipeline for analyzing survey data using the Medallion Architecture pattern. The pipeline extracts raw survey data, performs data quality checks, applies transformations, and prepares, clean and normalized data  using Python and PostgreSQL for analysis.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Dataset:<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"has-contrast-color has-text-color has-background has-link-color has-large-font-size wp-elements-a6f40201556e423c1ce10e32ebfc8f6f\" style=\"background-color:#2b86d9a1\">Our data set is a survey works among IT professional , collected and published in the link below.<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-background has-link-color has-large-font-size wp-elements-5a784a33f4eb93419daf0700b7b3a4f9\" style=\"background-color:#2b86d9a1\">\u201chttps:\/\/api.example.com\/data\u201d<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-background has-link-color has-large-font-size wp-elements-9497a0f387289085805fb3f74e16ebdc\" style=\"background-color:#2b86d9a1\">It has 11551 records and 84 columns. (11552, 85)<\/p>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Architecture<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-group has-background has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#2b86d9a1\">\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-170805954a34ccc3d90eebcf14c66fd6\">The project follows the <strong>**Medallion Architecture**<\/strong> pattern:<\/p>\n\n\n\n<ul class=\"wp-block-list has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-fed1ae9ae8346dd3a64577308e33b1cf\">\n<li><strong>Bronze Layer<\/strong>:  Raw data ingestion from APIs and databases<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-d264c4931567da3356ad1f3a2c8358c1\">\n<li><strong>Silver Layer<\/strong>: Data cleaning, normalization, and transformation<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-65e8122cb635db6daf05228284031781\">\n<li><strong>Gold Layer<\/strong>: (Future) Aggregated, business-ready analytics<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div style=\"height:22px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div style=\"height:0px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Pipeline Components<\/strong><\/h2>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Bronze Layer<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-17bb6e64cef8b9b20f0fcda0d8eaa287\">The Bronze layer handles:<\/p>\n\n\n\n<div class=\"wp-block-group has-background has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#2b86d9a1\">\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-0996309b903162d39aa6d1e55ed3da88\">&#8211; Data extraction from external APIs<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-ade3b677973ae35bfc60cd09834493d6\">&#8211; Connection to PostgreSQL database<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-14b45f531b8ac403a439baa9b1df5a08\">&#8211; Loading raw survey data<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-f890777e115445875c66396adf29d9c8\">&#8211; Initial column filtering and selection<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-077d92e8deb41e49fb758a5592eed9cf\">&#8211; Raw data storage for future reference<\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Key Features:<\/strong><\/h2>\n\n\n\n<div style=\"height:0px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group has-background has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#2b86d9a1\">\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-3b3d49c3decec318c451c41ef59fe94d\">&#8211; API data ingestion<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-67a7f935f9e3da6baafc4873fa585721\">&#8211; Database connectivity with PostgreSQL<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-e68c6131f5587a4034c4f4bb1fbe7a7c\">&#8211; Column management and initial filtering<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-abfbe62f348475a74cb2dccf6f338d3b\">&#8211; Raw data preservation<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Silver Layer<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-group has-background has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#2b86d9a1\">\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-fd884f9d10b46e5c713a45248a48e436\">The Silver layer performs:<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-146bbac16e84332712f8324dfe5e460a\">&#8211; Data quality checks (duplicates, missing values)<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-f04ae461ad08503825db9ecaee3a052c\">&#8211; Data cleaning and imputation<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-21aa91cdb3ce614b81a038575ae19142\">&#8211; Currency and payment frequency normalization<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-3bde3f0fcfd198874838136699263d51\">&#8211; Data type standardization<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-e346795ca3ee2f6b5d211ebfffc22095\">&#8211; Statistical analysis preparation<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-21d59a67c8b70b1ecfe7a4240d7b7f6d\">&#8211; Chi-square tests for categorical variables<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Key Operations:<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-group has-background has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#2b86d9a1\">\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-dc47aee24834b8fe7249475c1445312b\">&#8211; Duplicate detection and removal<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-8bf0aad07fd5b1456bce8979d8c8e29f\">&#8211; Missing value identification and imputation<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-043ed564d7375057bcc624f9c79c8b75\">&#8211; Earnings normalization across currencies<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-e13e7bdcf7658aa398d9f4b89797ba17\">&#8211; Payment frequency standardization to annual income<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-774e098c17ff900ea493b5cd1b3b5cc0\">&#8211; Data validation and quality reporting<\/p>\n<\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading has-contrast-color has-text-color has-link-color wp-elements-7b26f321538d5ff67b9d2ba7423185ef\"><strong>Running the Pipeline<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-group has-background has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#2b86d9a1\">\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-3fbad4572a913d1c8d198ba38e67b015\">1. <strong>Bronze Layer<\/strong> Run [Bronze_layer 1.38.59 PM.ipynb](Bronze_layer%201.38.59%20PM.ipynb)<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-2af97183e851b7b42b012cbb969b1bdc\">&#8211; Extracts raw data from sources<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-976f3fe7df230c137daf8e6c6640764b\">&#8211; Loads into PostgreSQL<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-group has-background has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#2b86d9a1\">\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-fc12559c660a755d7f906b550c96847e\">2. <strong>Silver Layer<\/strong>: Run [Silver_layer 1.38.59 PM.ipynb](Silver_layer%201.38.59%20PM.ipynb)<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-1696f374e9d50ab2fabe4b5e5c996175\">&#8211; Cleans and transforms data<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-cbe22f19b15b40b96eb7a4eb29db08f2\">&#8211; Normalizes earnings and currencies<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-45fedc870294176553d90f92b742f638\">&#8211; Performs quality checks<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading has-contrast-color has-text-color has-link-color has-x-large-font-size wp-elements-534920a52e542014c6878cc45bd89fe0\"><strong>Data Transformation DetailsEarnings Normalization<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-group has-background has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#2b86d9a1\">\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-53e83ab615df6cd0d37ca521cdd4593f\">&#8211; Converts various payment frequencies to annual income<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-3a85cbb261be4cc85bc73d98a7d74a70\">&#8211; Standardizes multiple currencies to USD<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-99e87b67e6b91f52cd807b298cdfc05a\">&#8211; Uses current exchange rates for accurate conversion<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Data Quality Checks<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group has-background has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#2b86d9a1\">\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-911823a33e7b6e3d2021d10840a57e3a\">&#8211; Duplicate record detection<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-9921090377e03082c87737560b0532d9\">&#8211; Missing value analysis<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-43b7ac7630e216ed4db3cf590b1706ed\">&#8211; Data type validation<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-a635651234402530e24fa0b6c9fbb5a9\">&#8211; Statistical distribution analysis<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading has-background\" style=\"background-color:#2b86d9a1\"><strong>Security Notes<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-group has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group has-background has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#2b86d9a1\">\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-2f7954aefb1c6206b7e2b8e08f2c13da\">&#8211; Database credentials are stored separately (not in version control)<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-91a17b940d95a76971804291d0401369\">&#8211; API keys and sensitive data are managed in external configuration files<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-97f0a5375fba25f950738c89ed039a99\">&#8211; Follow the principle of least privilege for database access<\/p>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Future Enhancements<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-group has-background has-global-padding is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#2b86d9a1\">\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-9333eb5b2ee6f54317741fd060e333b3\">&#8211; [ ] Implement Gold layer for business analytics<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-76f2c0dd6c9bd686553b0cd7b5dc0681\">&#8211; [ ] Add automated data validation rules<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-d52469a4b0d4d1e31f0bf61060814124\">&#8211; [ ] Create data quality dashboard<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-407e822dd61b5cfa68a3511d29062447\">&#8211; [ ] Implement incremental data loading<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-a08b17688b9640f26ed87f5d96952e67\">&#8211; [ ] Add comprehensive error handling<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-66e165b41ab36b55460ecd06bbe2e5e4\">&#8211; [ ] Create automated testing suite<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-736a4ab7772ec798ec0aec3280f27279\">&#8211; [ ] Add CI\/CD pipeline integration<\/p>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-686ea738d95abb35765f984e56f0da77\">&#8211; [ ] Implement data versioning<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-b5412ebd02749a5859e30f656832cd29\"><strong>License<\/strong><\/h2>\n\n\n\n<p class=\"has-contrast-color has-text-color has-background has-link-color has-large-font-size wp-elements-767e33342c76483d255c5e7c54994b8b\" style=\"background-color:#2b86d9a1\">This project is for educational and analysis purposes.<\/p>\n\n\n\n<div style=\"height:22px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div style=\"height:0px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-ec4b30116a4030f45bc6334922a44c52\"><strong>Author<\/strong><\/h2>\n\n\n\n<p class=\"has-contrast-color has-text-color has-link-color has-large-font-size wp-elements-6b243708c1f124227d9ec445eebde35a\">Rana<\/p>\n\n\n\n<div style=\"height:17px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-contrast-color has-text-color has-background has-link-color has-large-font-size wp-elements-95951b5f51181605ccf80f992faebb31\" style=\"background-color:#2b86d9a1\"><strong>**Note**<\/strong>: This project is under active development. Refer to individual notebooks for detailed implementation and analysis steps.<\/p>\n\n\n\n<div style=\"height:12px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div style=\"height:35px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Survey Analysis Medallion Pipeline Tools:&nbsp;Jupiter Notebook | PostgreSQL | Python: Pandas | NumPy | Matplotlib | Seaborn | SciPy Project Overview This project implements a multi-layer ETL pipeline for analyzing survey data using the Medallion Architecture pattern. The pipeline extracts raw survey data, performs data quality checks, applies transformations, and prepares, clean and normalized data [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1968","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Survey Analysis Medallion Pipeline - Rana Nasri Ghazzi<\/title>\n<meta name=\"description\" content=\"Explore Rana Ghazzi&#039;s data analytics portfolio \u2014 dashboards, visualizations, and insights built with Tableau, Power BI &amp; Python.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ranaghazzi.com\/?p=1968\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Survey Analysis Medallion Pipeline - Rana Nasri Ghazzi\" \/>\n<meta property=\"og:description\" content=\"Explore Rana Ghazzi&#039;s data analytics portfolio \u2014 dashboards, visualizations, and insights built with Tableau, Power BI &amp; Python.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ranaghazzi.com\/?p=1968\" \/>\n<meta property=\"og:site_name\" content=\"Rana Nasri Ghazzi\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-26T19:49:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-11T01:55:21+00:00\" \/>\n<meta name=\"author\" content=\"Rana Ghazzi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rana Ghazzi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/ranaghazzi.com\/?p=1968#article\",\"isPartOf\":{\"@id\":\"https:\/\/ranaghazzi.com\/?p=1968\"},\"author\":{\"name\":\"Rana Ghazzi\",\"@id\":\"https:\/\/ranaghazzi.com\/#\/schema\/person\/d8ee34f53cb0df9faaf816fb5363a4cc\"},\"headline\":\"Survey Analysis Medallion Pipeline\",\"datePublished\":\"2026-01-26T19:49:50+00:00\",\"dateModified\":\"2026-04-11T01:55:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/ranaghazzi.com\/?p=1968\"},\"wordCount\":448,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/ranaghazzi.com\/#\/schema\/person\/d8ee34f53cb0df9faaf816fb5363a4cc\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/ranaghazzi.com\/?p=1968#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ranaghazzi.com\/?p=1968\",\"url\":\"https:\/\/ranaghazzi.com\/?p=1968\",\"name\":\"Survey Analysis Medallion Pipeline - Rana Nasri Ghazzi\",\"isPartOf\":{\"@id\":\"https:\/\/ranaghazzi.com\/#website\"},\"datePublished\":\"2026-01-26T19:49:50+00:00\",\"dateModified\":\"2026-04-11T01:55:21+00:00\",\"description\":\"Explore Rana Ghazzi's data analytics portfolio \u2014 dashboards, visualizations, and insights built with Tableau, Power BI & Python.\",\"breadcrumb\":{\"@id\":\"https:\/\/ranaghazzi.com\/?p=1968#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ranaghazzi.com\/?p=1968\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ranaghazzi.com\/?p=1968#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ranaghazzi.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Survey Analysis Medallion Pipeline\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ranaghazzi.com\/#website\",\"url\":\"https:\/\/ranaghazzi.com\/\",\"name\":\"Rana Nasri Ghazzi\",\"description\":\"Turning Data into Decisions\",\"publisher\":{\"@id\":\"https:\/\/ranaghazzi.com\/#\/schema\/person\/d8ee34f53cb0df9faaf816fb5363a4cc\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ranaghazzi.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/ranaghazzi.com\/#\/schema\/person\/d8ee34f53cb0df9faaf816fb5363a4cc\",\"name\":\"Rana Ghazzi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ranaghazzi.com\/wp-content\/uploads\/2025\/11\/logo.png\",\"url\":\"https:\/\/ranaghazzi.com\/wp-content\/uploads\/2025\/11\/logo.png\",\"contentUrl\":\"https:\/\/ranaghazzi.com\/wp-content\/uploads\/2025\/11\/logo.png\",\"width\":1024,\"height\":1024,\"caption\":\"Rana Ghazzi\"},\"logo\":{\"@id\":\"https:\/\/ranaghazzi.com\/wp-content\/uploads\/2025\/11\/logo.png\"},\"url\":\"https:\/\/ranaghazzi.com\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Survey Analysis Medallion Pipeline - Rana Nasri Ghazzi","description":"Explore Rana Ghazzi's data analytics portfolio \u2014 dashboards, visualizations, and insights built with Tableau, Power BI & Python.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ranaghazzi.com\/?p=1968","og_locale":"en_US","og_type":"article","og_title":"Survey Analysis Medallion Pipeline - Rana Nasri Ghazzi","og_description":"Explore Rana Ghazzi's data analytics portfolio \u2014 dashboards, visualizations, and insights built with Tableau, Power BI & Python.","og_url":"https:\/\/ranaghazzi.com\/?p=1968","og_site_name":"Rana Nasri Ghazzi","article_published_time":"2026-01-26T19:49:50+00:00","article_modified_time":"2026-04-11T01:55:21+00:00","author":"Rana Ghazzi","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Rana Ghazzi","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ranaghazzi.com\/?p=1968#article","isPartOf":{"@id":"https:\/\/ranaghazzi.com\/?p=1968"},"author":{"name":"Rana Ghazzi","@id":"https:\/\/ranaghazzi.com\/#\/schema\/person\/d8ee34f53cb0df9faaf816fb5363a4cc"},"headline":"Survey Analysis Medallion Pipeline","datePublished":"2026-01-26T19:49:50+00:00","dateModified":"2026-04-11T01:55:21+00:00","mainEntityOfPage":{"@id":"https:\/\/ranaghazzi.com\/?p=1968"},"wordCount":448,"commentCount":0,"publisher":{"@id":"https:\/\/ranaghazzi.com\/#\/schema\/person\/d8ee34f53cb0df9faaf816fb5363a4cc"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ranaghazzi.com\/?p=1968#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ranaghazzi.com\/?p=1968","url":"https:\/\/ranaghazzi.com\/?p=1968","name":"Survey Analysis Medallion Pipeline - Rana Nasri Ghazzi","isPartOf":{"@id":"https:\/\/ranaghazzi.com\/#website"},"datePublished":"2026-01-26T19:49:50+00:00","dateModified":"2026-04-11T01:55:21+00:00","description":"Explore Rana Ghazzi's data analytics portfolio \u2014 dashboards, visualizations, and insights built with Tableau, Power BI & Python.","breadcrumb":{"@id":"https:\/\/ranaghazzi.com\/?p=1968#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ranaghazzi.com\/?p=1968"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ranaghazzi.com\/?p=1968#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ranaghazzi.com\/"},{"@type":"ListItem","position":2,"name":"Survey Analysis Medallion Pipeline"}]},{"@type":"WebSite","@id":"https:\/\/ranaghazzi.com\/#website","url":"https:\/\/ranaghazzi.com\/","name":"Rana Nasri Ghazzi","description":"Turning Data into Decisions","publisher":{"@id":"https:\/\/ranaghazzi.com\/#\/schema\/person\/d8ee34f53cb0df9faaf816fb5363a4cc"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ranaghazzi.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/ranaghazzi.com\/#\/schema\/person\/d8ee34f53cb0df9faaf816fb5363a4cc","name":"Rana Ghazzi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ranaghazzi.com\/wp-content\/uploads\/2025\/11\/logo.png","url":"https:\/\/ranaghazzi.com\/wp-content\/uploads\/2025\/11\/logo.png","contentUrl":"https:\/\/ranaghazzi.com\/wp-content\/uploads\/2025\/11\/logo.png","width":1024,"height":1024,"caption":"Rana Ghazzi"},"logo":{"@id":"https:\/\/ranaghazzi.com\/wp-content\/uploads\/2025\/11\/logo.png"},"url":"https:\/\/ranaghazzi.com\/?author=2"}]}},"_links":{"self":[{"href":"https:\/\/ranaghazzi.com\/index.php?rest_route=\/wp\/v2\/posts\/1968","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ranaghazzi.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ranaghazzi.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ranaghazzi.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ranaghazzi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1968"}],"version-history":[{"count":150,"href":"https:\/\/ranaghazzi.com\/index.php?rest_route=\/wp\/v2\/posts\/1968\/revisions"}],"predecessor-version":[{"id":3393,"href":"https:\/\/ranaghazzi.com\/index.php?rest_route=\/wp\/v2\/posts\/1968\/revisions\/3393"}],"wp:attachment":[{"href":"https:\/\/ranaghazzi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1968"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ranaghazzi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1968"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ranaghazzi.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1968"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}