Renjitha Krenjithak.hashnode.dev·Dec 21, 2024Unlocking Financial Success: The Power of Vendor Feeds in Client Reference Data ManagementAlright, Lets Imagine you're working at a financial institution or wealth management firm, where you're constantly dealing with dynamic market prices, evolving regulations, and fast-moving financial transactions. In such a fast-paced environment, hav...49 readsVendorFeeds
Niels Humbeckbuilding-data-products.com·Dec 18, 2024From Data Lifecycle to DataOps ArchitectureData is a valuable asset for the most companies in the 21st century. Like other assets data needs to be managed over the whole lifecycle. Mismanagement of data can result in many risks like: data losses or breaches resulting in disclosure of private ...Building Data Products with DataOps MethodologyTeamDataScienceProcess
esProc Desktopesproc-desktop.hashnode.dev·Dec 10, 2024#114 — Ranking of Row-Based Data — by the Combination of Multiple ColumnsProblem description & analysis: Here below is a data table: Task: Rank the data (in descending order) by the order combination of three columns, Maths, English, and PE. Solution: Use SPL XLL and enter the following code in cell F2: =spl("=?1.rank@z(...10 likesexcel
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...Web3
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...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...data-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 ...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...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...data 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...10 likes#Excel-tutorial
