Lucas chang

insert : insert is use for insert data into tables.

INSERT INTO customers (C_Id, Name, City, Address, Phone) VALUES (3, 'lucas', 'taipei', 'street', '07-12345678');

update : If we want to change the data in our tables we use update.

UPDATE customers SET Phone='03-87654321' WHERE Name='lucas';

merge

stored procedure

function

trigger

having

group by

--

--

Using api to get instant coin price data from coinbase.

  • python coinbase package to get data.

Familiar with line developer/line manager webpage usage.

  • create provider account on line developer.
  • messenger api.
  • get channel access token and channel secret.

write python flask script to run server to get message and reply message.

  • write flask scripts.

run ngrok on localhost.

  • let your localhost a website server.
  • webhook settings.

test the application on line account.

  • input message and test the application.

--

--

Talking about Statistics !

Why do we need statistics?

Statistics help us to know the trend by data or help to give advice about some decisions. Such like:how is our customer spend between male and female?

What are important content of statistics?

  1. Normal distribution
  2. Sampling distribution
  3. Probability
  4. Descriptive statistics and plotting.

--

--

Decision making analysis(in finance industry)

In finance industry, the manager or ceo prefer to use data to decide some of the strategy. So if you are a data analyst in finance comp there must be some decision making tasks in your work mission. There are some cases I have counter before.

  1. CIF client report:
  • Goal:handling the client amount situations.
  • Client vip distribution(YOY,MOM)

2. Sub client cluster:family client, salary client

  • Goal:know the picture of each sub client cluster, and promote diff campaign for it.
  • family vip distribution, salary vip comp categories.

3.client product penatration

  • 40–60 old client have 30% buy insurance.
  • Deposit client have 50% have insurance product.

4.kpi report

  • How is each channel mutual fund product do(client amount,amount,volume,revenue)

5.year report

  • Year performance of insurance client,volume,revenue. cross compare between different channel,different year.

--

--

Lucas chang

Lucas chang

graduate from applied statistic in Taiwan Good at Machine Learning, Text mining, Deep Learning, Data Analysis....