SQL Series | Searching for Answers in Your Data Using MySQLImagine you want to keep track of your daily expenses — like the money you spend on groceries, transportation, or entertainment, you can…Sep 1Sep 1
Analyze 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…Nov 4, 2023Nov 4, 2023
Build 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…Apr 19, 2023Apr 19, 2023
Case 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.Jan 25, 20231Jan 25, 20231
Working 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.Jan 22, 2023Jan 22, 2023
Creating Pokemon Database with MySQL & PythonPerform CRUD operations on databases using MySQL & Python.Nov 5, 20222Nov 5, 20222
Analyzing 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…Sep 24, 20223Sep 24, 20223
Analyzing 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…Sep 10, 2022Sep 10, 2022
Building 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.Sep 3, 2022Sep 3, 2022
Intermediate & 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…Aug 27, 20222Aug 27, 20222
