#datacleaning — Public Fediverse posts

📊 LA ANATOMÍA DE UNA BASE DE DATOS EN EXCEL
La mayoría usa Excel como una simple hoja de cálculo, pero cuando aplicas arquitectura de datos, se convierte en una herramienta poderosa para analizar, filtrar y procesar información con precisión quirúrgica 🧠:
✅ Encabezados obligatorios
✅ Llave primaria
✅ Reglas de integridad
✅ Autofiltros de precisión
✅ Funciones BD
🏷️ #ExcelAvanzado #BasesDeDatos #DataManagement #FuncionesBD #ExcelTips #DataCleaning #AnalisisDeDatos #Productividad #ExcelParaNegocios

Vos données sont un bordel ? Je les range. #DataEngineering #Humour #DataCleaning #NoBullshit #Tech ... https://www.linkedin.com/posts/gabriel-chandesris_dataengineering-humour-datacleaning-share-7469335754180304896-qbgF/

FedTech Magazine: How NIH Is Translating 70 Years of Health Data to Speak the Same Language. “The National Institutes of Health sits on one of the largest collections of biomedical research data in the world. Decades of federally funded studies on health issues such as heart disease, lung conditions, sleep disorders and genomics have generated petabytes of information. But for most of that […]

🐘 Αποκωδικοποιώντας τα #NULL!, #VALUE! και #REF! στο @ONLYOFFICE

Στο νέο post:

🔹 Γιατί η =SUM(A1:A5 C1:C5) επιστρέφει #NULL!
🔹 Το #VALUE! από αόρατα spaces ή αριθμούς ως κείμενο (και πώς τα φτιάχνει η VALUE() & TRIM() )
🔹 Το #REF! – ο "δολοφόνος" όταν διαγράφετε γραμμές

👉 Όλα αυτά, με παραδείγματα, στο άρθρο του ONLYOFFICE (Open Source, δωρεάν, συμβατό με .xlsx)

https://www.onlyoffice.com/blog/el/2026/05/most-frequent-errors-in-spreadsheet-tables

#OnlyOffice #OpenSource #Spreadsheets #FOSS #Excel #DataCleaning #Tech #TechWriting

Data engineering = 80% nettoyage, 20% glamour. Exemple : 3 semaines pour corriger doublons. Solution : automatisation, documentation. #DataEngineering #Tech #Humeur #DataCleaning #Réalité ... https://www.linkedin.com/posts/gabriel-chandesris_dataengineering-tech-humeur-share-7455896944264081408-Ln7L

Missing [Survey, etc] Data Can Be A Geographic Phenomenon
--
https://doi.org/10.1080/24694452.2026.2640220 <-- shared paper
--
#GIS #mapping #spatial #DataScience #missing #data #spatial #AAG #autocorrelation #geographicallyweightedregression #GWR #imputation #missingdata #survey #surveynonresponse #incomplete #surveyquestions #ethnicity #income #spatialdata #alldataisspatial #UK #FinancialLives #geography #spatialanalysis #geostatistics #location #imputing #statistics #dataset #DataImputation #MissingData #DataCleaning #DataPreprocessing #DataWrangling #DataQuality #DataEngineering #FinancialData #FinancialAnalytics #FinincialModeling #FinDataScience

🌐Christof Schöch, University of Trier, details how the #DOAJ journal #dataset is used to teach #Python programming for the Machine Learning in a Digital Humanities Master's program @christof

#PythonProgramming #APCs #DataClassiication #DataCleaning #MachineLearning
🔗 https://blog.doaj.org/2026/03/30/teaching-python-programming-with-doajs-journal-dataset/

Just wrapped up cleaning TheLook's eCommerce data — so satisfying when your dataset plays nice! 🧹✅
Only 2 missing product names in 29k rows & no dupes. Solid foundation for KPIs!
But… how do you handle messy data? Any go-to SQL tricks for spotting hidden issues?

👇 Let’s swap stories — and if you want the full deep dive, check out the blog:
https://manueltechlabs.com/posts/data-cleaning-and-preparation-setting-the-fundation-for-reliable-insights/

#DataCleaning #SQL #DataAnalysis #DataCommunity

What is lable and Text box in Tool box in VBA Excel - S1 EP19 P9 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning

How insert simple user Form in excel using VBA Excel- S1 EP19 P8 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning

Write a Universal code to delete empty rows in VBA Excel - S1 EP19 P7 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning

Write a Universal code to Fix Cases in Data in VBA Excel - S1 EP19 P6 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning

Remove double spaces within text with code in VBA Excel - S1 EP19 P5 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning

How to add buttons to run Macros in VBA Excel - S1 EP19 P3 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning

How to Filter and Clear Filters in VBA Excel - S1 EP19 P2 #ExcelTips #ExcelTutorial #ExcelVBA #VBATutorial #ExcelFilter #ClearFilters #DataFiltering #ExcelAutomation #ExcelSkills #TechTutorials #HowToExcel #ExcelSeries #ExcelForBeginners #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning

How to sort data with code in VBA - S1 EP19 P1 #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to Write And Edit a macro in VBA .S1 EP18 P9 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to write First Code in Vba Excel S1 EP18 P8 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

What is a Subroutine comment and a Basic Syntax in VBA Explained S1 EP18 P7 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to Refer to a cell in VBA Code S1 EP18 P6 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to Write and change Values in Excel with Code S1 EP18 P5 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to save your Macro in Your Macro Library and Reuse- S1 EP18 P4 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

Selecting and Formatting Cells using VBA in Excel - EP18 P3 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries

S1 EP18 P2 How to Enable the Developer Tab in excel #excel #microsoftexcel #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries

S1 EP17 P9 Standard Mathematical Operations in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit

S1 EP17 P8 View Section in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit