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 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 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
Anix LynchProanixblog.hashnode.dev·Nov 3, 202455 Essential SQL Functions with Sample Codes & OutputHere's the comprehensive list of function names and sample code & output mentioned in this blog SELECT INSERT UPDATE DELETE TRUNCATE COUNT SUM AVG MIN MAX GROUP BY HAVING ORDER BY LIKE IN AND OR NOT UNION JOIN (including INNER JOI...DiscussSQL
Iman Adekoimanadeko.hashnode.dev·Oct 22, 2024Addressing Customer Frustration: How Data Can Improve Order FulfillmentBusiness Introduction Streamline Logistics is a well-established company that has been providing logistics services for over 20 years. They are known for their reliable and fast delivery of products. However, they are currently facing challenges in t...Discuss·10 likes·32 readslogistics
esProc Desktopesproc-desktop.hashnode.dev·Oct 16, 2024#75 - Find out The Intervals in Which A Certain Condition Occurs ContinuouslyProblem description & analysis: We have a statistical table for daily sales: Task: Find out the date when the sales rises for three consecutive days or more. Solution: Use SPL XLL and enter the following code: A 1 =0 2 =E(‘A1:B32’).group@o(if(Sales...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Oct 15, 2024#74 - Filter by Maximum Or Minimum Value within A Group (Find out One for Each Group)Problem description & analysis: We have an Excel table for the daily sales of products: Task: Find out products with the largest daily sales and their sales: Solution: Use SPL XLL and enter the following formula: =spl("=E(?1).group(OrderDate).(~.max...Discussexcel
Anu Josenetworkingtechniques.hashnode.dev·Oct 14, 2024Networking Techniques for Aspiring Data Scientists: Establishing Relationships within an Environment Characterized by CompetitorsNetworking is especially important to the independence and career opportunities of a data scientist because it provides exposure to avenues, potential morsels of knowledge, or collaborations that are otherwise unavailable to those who do not have con...DiscussData Science
