DataViz-KPIVisualization & Analytics A picture is worth a thousand words

Sales & Marketing Analysis KPI

Cevi Herdian 2018-06-03

Sales & Marketing

The Sales and Marketing Sample contains a dashboard and report for a fictitious manufacturing company named VanArsdel Ltd.

Data source:

Please click the link: Doku at Github

Procurement Analysis KPI

Cevi Herdian 2018-06-03

What is Procurement?

Procurement is the process of finding, agreeing terms and acquiring goods, services or works from an external source, often via a tendering or competitive bidding process. (wikipedia.com)

Data source:

Please click the link: Doku at Github

IT Spend KPI

Cevi Herdian 2018-06-03

What is IT Spend?

IT spend is the amount of money or time spent on information technology systems and services

Data source:

Please click the link: Doku at Github

Opportunity Analysis KPI

Cevi Herdian 2018-06-03

The Opportunity Analysis

The Opportunity Analysis Sample contains a dashboard (and associated report) for a software company that has 2 sales channels: direct and partner. The Sales Manager created this dashboard to track opportunities and revenue by region, deal size, and channel.

Data source:

Please click the link: Doku at Github

Human Resources KPI

Cevi Herdian 2018-06-03

What is Human Resources?

Human resources are the people who make up the workforce of an organization, business sector, or economy. (wikipedia.com)

Data source:

Please click the link: Doku at Github

Supplier Analysis KPI

Cevi Herdian 2018-06-02

What is Supplier?

In a supply chain, a vendor, or a seller, is an enterprise that contributes goods or services. Generally, a supply chain vendor manufactures inventory/stock items and sells them to the next link in the chain. Today, these terms refer to a supplier of any good or service. (wikipedia.com)

Data source:

Please click the link: Doku at Github

Customer Profitability KPI

Cevi Herdian 2018-06-02

What is Customer Profitability?

Customer profitability (CP) is the profit the firm makes from serving a customer over a specified period of time, specifically the difference between the revenues earned from and the costs associated with the customer relationship in a specified period. (wikipedia.com)

Data source:

Please click the link: Doku at Github

Retail Analysis KPI

Cevi Herdian 2018-06-01

What is Retail?

Retail is the process of selling consumer goods or services to customers through multiple channels of distribution to earn a profit. (wikipedia.com)

Data source:

Please click the link: Doku at Github

Cars Sales KPI

Cevi Herdian 2018-05-16

What is sales?

The quantity of goods or services sold in a given time period

Data source:

kaggle.com

The dataset

Norway Car sales data:

  1. Quantity model
  2. Quantity manufacture (BMW, VW, etc)
  3. Quantity manufacture vs model
  4. Yearly manufacture sales
  5. Bensin vs diesel c02 emission
  6. All falling down
  7. Year over year quantity
  8. hybrid vs diesel vs electric quantity

Berlin Stat

Cevi Herdian 2018-05-16

Data source:

Federal Statistical Office of Germany & Statista

All about Berlin:

1. Demography and the Prediction

#Berlin population #Germany population density #Foreigner berlin

2. Economy

#Berlin BIP (Brutto Inlands Products) #Berlin unemploymentsrate #Year over year BIP (Brutto Inlands Products) #Young unemploymentsrate #Berlin economy KPI

3. Infrastructure

#Berlin total cars #federal state broadbrand #berlin traffic share #Infrastructure KPI

4. Education

#Berlin & germany student

Revenue KPI

Cevi Herdian 2018-05-15

What is Revenue?

All about money from sale of goods or services

Data source:

Microsoft Program for Data Science, Obvience

The dataset

Revenue:

  1. Revenue by customer age
  2. Revenue by state
  3. Revenue growth
  4. Revenue by country
  5. Revenue by category
  6. Revenue KPI (Key Performances Indicator)

Profit KPI

Cevi Herdian 2018-05-15

What is Profit?

The real money after accounting cost

Profit:=sales-cost

Data source:

Microsoft Program for Data Science, Obvience

The dataset

Profit:

  1. Profit by age group
  2. Profit by gender
  3. Profit vs revenue by age group
  4. Profit by product
  5. Profit-KPI (Key Performance Indicator