Ahamad Tawsif Chowdhuryahamad.hashnode.dev·6 hours agoData Lakes Explained in Simple TermsAs businesses generate massive amounts of data, there comes a need to find efficient ways of storing and analysing that data. Traditional storage methods come with limitations when dealing with raw unstructured data. This is where data lakes come in....Data Science
esProc Desktopesproc-desktop.hashnode.dev·20 hours agoDo Ordered Grouping and Aggregation within Groups — From SQL to SPL #1Problem description & analysis: A certain database table describes the payment cycle for multiple projects (IDs), with one payment cycle consisting of regular months and a closing month. The regular month only has the current month’s amount but no in...#reporting
esProc Desktopesproc-desktop.hashnode.dev·Feb 17, 2025#145 — Insert Blank Row when Meeting with Data ChangeProblem description & analysis: Here below is a data table: Task: We want to insert one blank row when the values in two adjacent rows change, the result is as follows: Solution: Use SPL XLL and enter the following code: =spl("=?1.conj().group@o(~)...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Feb 14, 2025#144 — Insert Row after Specific RowProblem description & analysis: Here below is a data table: Task: Insert one row after the number 100, and fill in a001, a002, … in turn, like this: Solution: Use SPL XLL and enter the following code: =spl("=E@b(?1).group@i(~[-1].#1==100).(~|new(st...10 likesexcel
Olayinka Salakoolayinkasalako.hashnode.dev·Feb 12, 2025Analysis of OS Employee Attrition and Retention Trends"Summary This report highlights important trends in employee attrition and its connection to job roles, compensation, travel frequency, and distance to work. Addressing these insights can help improve employee retention strategies, especially in high-...data
esProc Desktopesproc-desktop.hashnode.dev·Feb 12, 2025#143 — Expand One Row into Multiple Rows after Splitting TextProblem description & analysis: The following is a data table, in which columns D and E have multiple lines of text, the number of lines is the same, and such lines are in one-to-one correspondence. For example, F corresponds to Fail, as shown below:...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Feb 11, 2025#142 — Expand One Row into Multiple Rows Based on ValueProblem description & analysis: There is a data table, which stores some information of products. The first column is the serial number, and the second column is the remaining quantity. The initial data is as follows: Task: Now we want to copy each ...10 likesexcel
Emmanuel A. Frankfrankolanari.hashnode.dev·Feb 10, 2025The Discreet Power of Asking “Why?”Too often, decision-makers settle for the first explanation, trusting assumptions or relying on good ol' rules of thumb—sometimes in a bid to avoid analysis or decision paralysis. While this may seem efficient, it can lead to decisions made blindly, ...data analysis
ojo_daojtech.hashnode.dev·Feb 10, 2025SQL Basics: A Beginner's HandbookCompany Database Creation In the previous blog we created a simple table. Let’s dive deeper in this blog. A primary key is an identifier that references a column in which each value is unique. In the example below, we shall create an employee table w...SQL
Bittu Sharmabittublog.hashnode.dev·Feb 10, 2025Roadmap to Mastering the Art of DataIn today’s data-driven world, the ability to analyze and interpret data is no longer just a skill—it’s a superpower. From businesses making strategic decisions to researchers uncovering groundbreaking insights, data analysis is at the heart of innova...1 likeData Science