Data Analyst Vs Business Analyst Vs Data Engineer Vs BI Specialist

Image
  Data Science - Complete Track • Step 1 - Identify the business problem/value addition/question – ( Data Insights ) this has to be the starting point. • Step 2 - Data availability ( Data Governance ) - Have the structure of your data set defined – The real challenge starts here-                o Do we have the data?                o Do we have access to the required data? • Step 3 -Getting Data ( Data Mining / Data Pipeline ) – How to collect the data from different sources in the system • Step 4 - Data preparation (ETL / ELT) – Once you have data there will be lot of cleaning and preparation required, reduce/increase/combine/split the predictors, determine and eliminate outliers, populate missing values convert few categorical variables into numerical etc. • Step 5 –Exploratory Data Analysis (EDA) – In this step we do descriptive and diagnostic analysis of the existing data. We build multiple graphs that give us direction towards the next steps of predictive analytics. We migh

KPIs FOR DASHBOARDS



KPIs FOR DASHBOARDs

KPI Examples for Finance

Revenue

Profit margin

Cash flow

Return on investment (ROI)

Current ratio (liquidity)

Debt-to-equity ratio

Working capital efficiency

Budget-to-actual performance

Accounting costs

Accounts payable turnover

Accounts receivable collection period

Accounts receivable turnover

Actual expenses

Amount due (per customer)

Average customer receivable

Average monetary value of invoices outstanding

Average monetary value of overdue invoices

Average number of trackbacks per post

Budget variance for each key metric

Budgeted expenses

Capital expenditures

Cash conversion cycle (CCC)

Cash flow return on investments (CFROI)

Cost of goods sold (COGS)

Cash dividends paid

Cost per pay slip issued

Creditor days

Current receivables

Cumulative annual growth rate (CAGR)

Cycle time for expense reimbursements

Cycle time to process payroll

Cycle time to resolve an invoice error

Cycle time to resolve payroll errors

Days payable

Debtor days

Direct cost

Discounted cash flow

Earnings before interest and taxes (EBIT)

Earnings before interest, taxes, depreciation (EBITDA)

Economic value added (EVA)

Employee available time

Employee scheduled time

Employee work center loading

Enterprise value/ takeover value

Expense account credit transactions

Expense account debit transactions

Expense account transactions

Fixed costs

Gross profit

Gross profit margin

Indirect costs

Inventory turnover

Inventory value

Invoice processing costs

Internal rate of return (IRR)

Market share gain comparison percentage

Net change in cash

Net income

Net present value (NPV)

Number of invoices outstanding

Number of unapplied receipts

Number of past-due loans

Open receivables

Open receivables amount (per customer)

Operating leverage

Past-due receivables

Payables turnover

Payment errors as a percentage of total payroll disbursement

Percentage accuracy of financial reports

Percentage of bad debts against invoiced revenue

Percentage of electronic invoices

Percentage in dispute (per customer)

Percentage of invoices being queried

Percentage of invoices requiring special payment

Percentage of low-value invoices

Percentage of open receivables (per customer)

Percentage of payable invoices without purchase order

Percentage of service requests posted via web (self-help)

Perfect order measure

Quick ratio

Receivables

Receivables turnover

Return on capital employed (ROCE)

Sales growth

Share price

Systems cost of payroll process as a percentage of total payroll cost

Total payables

Total energy used per unit of production

Total receivables

Total sales

Unapplied receipts

Variable costs

Weighted days delinquent sales outstanding

Weighted days delinquent sales outstanding (per customer)

Weighted terms outstanding

Weighted terms outstanding (per customer)

KPI Examples for RETAIL TRADE


PRODUCT SALES

Average inventory

Cost of goods sold

Gross profit budget percentage

Sales budget percentage

Discount

Gross profit

Gross profit and prognostics

Gross profit and prognostics percentage

Gross profit budget

Gross profit campaign

Gross profit percentage KPI

Gross profit prognostics

Gross profit prognostics percentage

Gross profit standard

Gross profit year to date

Number of stores

Product quantity

Total sales

Sales per square foot

Same-store sales growth

Sales and prognostics

Sales campaign

Sales growth period

Sales growth year

Sales growth year by week

Sales prognostics

Sales standard

Sales trend percentage KPI

Sales value-added tax (VAT)

Sales view

Sales view year-to-date

Share prognostics

Time range

FINANCE AND ACCOUNTING

Accounts payable turnover

Accounts receivable turnover days

Acid test ratio

Administrative cost percentage

Break-even (dollars)

Cash conversion cycle

Contribution margin

Cost of goods

Cost of goods sold

Current ratio

Ending inventory at retail

Gross margin

Gross margin return on investment

Initial mark-up

Interest cost percentage

Inventory turnover

Maintained mark-up (dollars)

Margin percentage

Mark-up percentage

Net receipts

Net sales

Retail price

Return on capital invested

Sales per square foot

Stock turnover days

Total asset sales ratio

Turnover

SALARY

Real absence hours

Real absence share

Real GPWH

Real overtime hours

Real overtime share

Real TWH

Real working hours

Salary

Salary amount

Salary amount exchange currency

Salary hours

Salary turnover share

SALARY TARGETS

Real absence hours

Real GP work hours

Real total work hours

Salary absence percentage

Salary GP work hour

Salary overtime percentage

Salary target absence percentage

Salary target GP work hour

Salary target overtime percentage

Salary target turnover percentage

Salary target work hour

Salary turnover percentage

HOURLY SALES

Customers per hour

Discount

Gross profit

Items

Margin per customer

Number of customers

Sales growth year

Sales growth year percentage

Sales last year

Sales per customer

Sales trend percentage

Sales view

Total number of stores

BUDGET SALES

Budget gross profit

Budget number of customers

Budget sales

Customers

Discount

Gross profit

Items

Sales

Sales exchange currency

Sales VAT

PAYMENT WITH POINT-OF-SALE (POS) STATISTICS

Amount

Amount exchange currency

Items

Number of customers

Number of items

Refund amount

Refund count

Sales income VAT

Time range

Transaction cancel amount

Transaction cancel count

Transaction cancel percentage

Void amount

Void count

Void percentage

Zero sale count

HOURLY PRODUCT SALES

Gross profit percentage

Item discount

Item gross profit

Item quantity

Item sales

Item sales exchange currency

Item sales VAT

Items sold

 

Comments

Popular Post

Covid 19 Rapid Antigen Test Kit

Portable Pulse Oximeter

NVIDIA DGX B200

KEY PERFORMANCE METRICS FOR BANKS

DATA ENGINEER CERTIFICATIONS

Essentials You Need to Know Before Investing in Stocks

Comparison between COVID-19 Vaccines