esProc Desktopesproc-desktop.hashnode.dev·Nov 19, 2024#99 — Deduplication of Simple DataProblem description & analysis: There is a data table: Task: We want to duplicate the data. Solution: Use SPL XLL and enter the following formula: =spl("=?1.id()",A2:A17) Download esProc Desktop for FREE and level up your Excel game!!! 🚀🔥⬇️ ✨SP...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Nov 18, 2024#98 — Count Duplicates of Row-Based Data — by Key ColumnProblem description & analysis: Here below is a personnel data table: Task: Count the number of duplicate data (the judging basis is that the data in the Name field are the same). Solution: Use SPL XLL and enter the formula in the cell E2: =spl("=?1...Discuss·10 likes#Excel-tutorial
esProc Desktopesproc-desktop.hashnode.dev·Nov 14, 2024#96 — Identify Duplications of Row-Based Data — by Key ColumnProblem description & analysis: Here below is a personnel data table: Task: Identify whether there are duplicate data, if so, fill in 1 in the corresponding Dup field, otherwise fill in 0 (the identifying basis is that the data in the Name field are...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Nov 13, 2024#95 — Identify Duplications of Simple MembersProblem description and analysis: Here below is a data table of names: Task: Identify whether there are duplicate names, if so, fill in 1 in the corresponding Dup field, otherwise fill in 0. Solution: Use SPL XLL and enter the formula in cell B2: =s...Discuss·10 likesexcel
Queen Carine UMUVANDIMWEqueen-carine-the-analyst.hashnode.dev·Nov 12, 2024Giving Data a Voice that People Can Understand As a Data AnalystIntroduction Data storytelling is essential for any data analyst in today's data-driven world. Raw numbers and graphs only go so far; to drive real impact, data needs a narrative that brings insights to life. Data storytelling bridges the gap between...DiscussData Science
esProc Desktopesproc-desktop.hashnode.dev·Nov 12, 2024#94 — Intersection, Union, and Difference in the Case of Row-Based Data — Two Sets — by Whole RowProblem description: The following tables list the data of the products and salespersons that make the top 10 by sales in January and February: Solutions: Use SPL XLL to tackle the following tasks respectively. A. Find out the data of products and ...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Nov 11, 2024#93 — Intersection, Union and Difference in the Case of Row-Based Data — Two Sets — by Key ColumnProblem description: The following tables list the sales data of the top 10 products by sales in January and February: Solutions: Use SPL XLL to tackle the following tasks respectively: A. Find out the sales data of the products that make the top 1...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Nov 8, 2024#92 — Intersection, Union, And Difference in the Case of Simple Members — Multiple SetsProblem description: The following table lists the top 10 products by sales in the first couple of months of the year (the number of months will increase over time): Solutions: Use SPL XLL and deal with the following tasks respectively. A. Find out ...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Nov 7, 2024#91 - Intersection, Union, And Difference in the Case of Simple Members - Two SetsProblem description: The following table lists the top 10 products by sales in January and February: Solutions: Use SPL XLL and deal with the following tasks respectively. A. Find out the products that make the top 10 in both January and February: =...Discuss·10 likesexcel
BladePipebladepipe.hashnode.dev·Oct 31, 2024Accelerate GenAI: Stream Data from MySQL to KafkaIn the age of AI, Apache Kafka is becoming a pivotal force due to its high-performance in real-time data streaming and processing. Many organizations are seeking to integrate data to Kafka for an enhanced efficiency and business agility. In this case...Discusskafka
