Web3 Learning Orbweb3learningorb.hashnode.dev·Dec 6, 2024Decentralized Storage and Data OwnershipIntroduction In 2018, it was revealed that in the 2010s, Cambridge Analytica, a data analytics firm, had harvested the personal data of millions of Facebook users without their consent. The data was then used to influence the 2016 US presidential ele...DiscussWeb3
Santhoshprogrammerzero.hashnode.dev·Nov 24, 2024Database Resilience 101: Replication and Disaster Recovery DemystifiedImagine this: your company’s database server crashes unexpectedly. Customer orders are piling up, your team is scrambling, and the pressure is mounting. Without a solid plan, this could turn into hours or even days of chaos. This is where disaster re...Discuss·1 likeDatabases
Piotr Czarnasdqops.hashnode.dev·Nov 23, 2024Data Architecture for Data QualityThe purpose of data quality validation Data quality validation is the process of ensuring that data is accurate, complete, and suitable for its intended use. Just as a baker checks the freshness and quantity of ingredients before baking a cake, busin...Discussdata-quality
esProc Desktopesproc-desktop.hashnode.dev·Nov 22, 2024#102 — Deduplication of Simple Data — Keeping the Original OrderProblem description & analysis: There is a data table: Task: Duplicate the data and keep the original order. Solution: Use SPL XLL and enter the following formula: =spl("=?1.id@u()",A2:A17) The results are as follows: Download esProc Desktop for ...Discuss·10 likesexcel
Muhammad Irfanirfanmustafvi.hashnode.dev·Nov 15, 2024Mastering Filesystem Management in RHEL1. Introduction: Today marks another milestone in my Linux journey as I delved deep into creating, managing, and troubleshooting different filesystem types in Red Hat Enterprise Linux. Let me share some valuable insights that are crucial for enterpri...Discuss·1 likeTech community
John Martechaitechjohn.hashnode.dev·Nov 7, 2024BeCause, CEO, Frederik Steensgaard - AITech InterviewSustainability has become a key focus for many companies. What do you see as the most significant challenges that businesses face when trying to manage and streamline their sustainability data? Without a doubt, it is the reliance on expensive, ineffi...Discussdata management
esProc Desktopesproc-desktop.hashnode.dev·Nov 5, 2024#89 — Calculate Proportion Using the Aggregation Values of the Data from the Same GroupProblem description & analysis: Here below is an annual and quarterly sales data table: Task: Calculate the proportion of each quarterly sales to the total sales of the year (to calculate in cell D1). Solution: Use SPL XLL and the code is as follows...Discuss·10 likes#Excel-tutorial
Lucy ZhangforNocoBase's blognocobase.hashnode.dev·Nov 5, 2024The Ultimate Guide to Data Transformation ToolsOriginally published at The Ultimate Guide to Data Transformation Tools - NocoBase. In the era of big data, businesses and organizations face the challenge of handling vast amounts of data. As applications become more complex and user needs evolve, d...DiscussOpen Source
esProc Desktopesproc-desktop.hashnode.dev·Nov 1, 2024#87 — Merge Data of The Same GroupProblem description & analysis: Here below is an annual and quarterly sales data table: Task: In this table, column A is ordered and has duplicate values. Now we want to clear the data from all rows in the same group except the first row. Solution: ...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Oct 31, 2024#86 — Calculate Using Adjacent Row/Interval When Data of The Same Group Is Discontinuous (LRR/YOY in The Case of Missing Data)Problem description & analysis: Here below is an annual and quarterly sales data table: Task: In this table, the data for the first quarter of 2020 is missing. When the data of this quarter is used to calculate LRR, skip this quarter directly, and u...Discuss·10 likesexcel
