Jada Ng Pooi LingAnalyze Telco Customer Churn Dataset (Part 1) — Using SQLCustomer churn or customer attrition is a crucial metric in the business world, especially in the telecommunication industry. It…6 min read·Nov 4, 2023----
Jada Ng Pooi LingBuild Excel Dashboard for E-Commerce DataAre you tired of feeling like a clueless driver when it comes to analyzing your data? Well, get ready to buckle up and take control of your…6 min read·Apr 19, 2023----
Jada Ng Pooi LingCase Study: Creating Integrated Financial Statements ModelAn integrated financial model has a balance sheet, income statement, and cash flow statement projecting how your business will be doing.2 min read·Jan 25, 2023--1--1
Jada Ng Pooi LingWorking With Common Excel FunctionsThe difference between a formula and a function, the method to find the function you need, and the most commonly used functions in Excel.6 min read·Jan 22, 2023----
Jada Ng Pooi LingCreating Pokemon Database with MySQL & PythonPerform CRUD operations on databases using MySQL & Python.4 min read·Nov 5, 2022--2--2
Jada Ng Pooi LingAnalyzing HR Metrics With SQL To Measure Diversity & InclusionA workforce of diverse talents and backgrounds could help companies to succeed in this complex world. To unlock the potential of workplace…10 min read·Sep 24, 2022--3--3
Jada Ng Pooi LingAnalyzing Worker Productivity In Garment Industry With SQLThe decision-makers in the garment industry would be in a better position in the industry if they track, analyze, and predict the…7 min read·Sep 10, 2022----
Jada Ng Pooi LingBuilding SQL Project With E-Commerce Dataset From KagglePerform sales analysis with SQL to find insights from the sales data and to compare the sales target with the actual sales.10 min read·Sep 3, 2022----
Jada Ng Pooi LingIntermediate & Advanced SQL For Data AnalysisIt is unavoidable for an analyst to deal with strings, numbers, and dates in their daily job. Below are some examples of how to use SQL to…6 min read·Aug 27, 2022--2--2
Jada Ng Pooi LingBasic & Intermediate SQL for Data AnalysisStructured Query Language (SQL) is a programming language that is used to interact with the relational database management system (RDBMS)…7 min read·Aug 21, 2022--2--2