Sutapa Biswassutto.hashnode.dev·3 hours agoSQL for Data Analysis (Learn what matters)SQL Queries show tables; It shows all the tables available in dataset desc products; Describe a particular table, here ‘products’ is a table select * from yearly_sales; ‘*’ refers everything, this means showing everything in ‘yearly_sa...DiscussSQL
Javed AhmedforHandlingandAnalyzingBigData:handlingandanalyzingbigdata.hashnode.dev·5 hours agoHandling and Analyzing Big Data: A Professional GuideIntroduction In the digital era, organisations and businesses swim into a sea of massive data from various sources. If well managed and analyzed, this data, referred to as Big Data can afford the user a lot of insights. However, the handling of such ...DiscussData Science
esProc Desktopesproc-desktop.hashnode.dev·13 hours ago#82 — Filter by AccumulationProblem description & analysis: There is a sales data table: Task: Count the date when the sales volume of each person reaches 50,000. Solution: Use SPL XLL and the code is as follows: =spl("=E(?1).group(Name).new(Name,~.select@1(Sales[:0].sum()>500...Discussexcel
LMdigitndreams.hashnode.dev·21 hours agoThe P&L Playbook: Your Essential Guide to Financial MetricsA Profit and Loss (P&L) statement is one of the most fundamental financial documents that provides a clear picture of a company's financial performance over a specific period. By detailing revenue, costs, and profits, it allows stakeholders to evalua...DiscussFinancial Literacy
LMdigitndreams.hashnode.dev·21 hours agoSupply Chain Essentials: Cracking the Forecasting CodeForecasting in supply chain management might sound like a dry topic, but it’s a real game-changer! Imagine being able to predict what customers will want before they even know it themselves. That’s the magic of accurate forecasting, and it’s essentia...DiscussSupply Chain Management
Anu JoseforEthicalAI:ethicalai.hashnode.dev·Oct 24, 2024Ethical AI: Commons and Organizations: Managing Challenges in Meeting Bias and Fairness NeedsKnown under the abbreviated term AI, Artificial Intelligence is a crucial factor and a fundamental change driver in industries, operations, and possibilities. Nevertheless, as it continuously influences every aspect of society, ethical issues, mainly...DiscussArtificial Intelligence
esProc Desktopesproc-desktop.hashnode.dev·Oct 24, 2024#81 — Accumulate Data in Each GroupProblem description & analysis: There is a sales data table: Task: Calculate the cumulative sales of each person. Solution: Use SPL XLL and the code is as follows (to calculate in cell D1): =spl("=E(?1).new(cum(~~+Sales;Name):'Cumulative Sales')",A1...Discussexcel
afoma ahumaraezethe-newbie-data-analyst-journal.hashnode.dev·Oct 23, 2024Why pursue a career in tech? Why data analysis, and why now?For some people, the answer to these questions are as clear as night and day but for me, it is quite the opposite. The idea of a career in tech first came to me when I picked interest in blogging and built my first Wordpress website. Prior to that ti...Discuss·1 likedata analysis
Innocent Ezamaezama.hashnode.dev·Oct 23, 2024DO HARD THINGS: My Journey at ALX KenyaPart 1: “Just Start”, Again! A few years ago, I embarked on a quest to break into the tech industry, inspired by a mentor who navigated the field without the modern conveniences we take for granted today. His tales of handwritten code and grueling ho...DiscussData Science
venkatapraneeth marellaanalysing-customer-churn-in-power-bi.hashnode.dev·Oct 23, 2024Analyzing student's mental healthProblem Statement: Does going to university in a different country affect your mental health? A Japanese international university surveyed its students in 2018 and published a study the following year that was approved by several ethical and regulato...DiscussData Analysis using SQLSQL
