Archives | Naixin's blog

2020

09

16

https://www.1point3acres.com/bbs/interview/amazon-data-science-478865.html 亚麻BIE physical retail seatle 1)一个manuafacture

2020-09-16

15

SQL_notes_Mode

Learning from https://mode.com/sql-tutorial/ Basic1.SELECT * FROM table rename column names: SELECT west AS "West

2020-09-15 SQL

SQL Learning notes

10

2.0_leetcode_database_practice

EASY tag:176. SELECT IFNULL( (SELECT ... LIMIT 1 OFFSET 1,NULL ) AS SecondHighestSalary SELECT MAX(salary) AS

2020-09-10 SQL

SQL Learning notes

09

title: Lean Analytics date: 2020-09-9 11:26:09 top: false cover: false password: toc: true mathjax: false tags: Produc

2020-09-09

03

22

Hackerrank(medium and hard)

15 Days of Learning SQL SELECT SUBMISSION_DATE, (SELECT COUNT(DISTINCT HACKER_ID) FROM SUBMISSIONS S2 WHERE S2.SUB

2020-03-22 SQL

SQL Learning notes

06

FreddieThis is a computer program that simulates a Data Analyst chatbot, named Freddie, capable of processing user inpu

2020-03-06

02

24

AB_test_prep

What is A/B testing? A/B testing (sometimes called split testing) is basically statistical hypothesis testing applied t

2020-02-24 A/B TEST

A/B TEST

19

statistics_interview_prep

P-Value The p-value is the probability of obtaining at least as extreme results given that the null hypothesis is true.

2020-02-19 statistic knowlege review

statistic knowlege review

15

1.0_leetcode_database_practice

*175. SELECT Person.FirstName, Person.LastName, Address.City, Address.State FROM Person LEFT JOIN Address ON Person.Per

2020-02-15 SQL

SQL Learning notes

01

23

Investment opportunities Identify

IntroductionYou have been approached by a Venture Capital Fund. The board of Directors are currently review 1000 interes

2020-01-23 Tableau

Tableau

23

Coal Terminal Maintenance Analysis

IntroductionYou have been hired by a Coal Terminal to assess which of their Coal Reclaimer machines require maintenance

2020-01-23 Tableau

Tableau

23

Clothing Retailing Expansion Analysis

IntroductionYou are a Data Scientist working for an Australian retail chain operating in the “Clothing Retailing” indust

2020-01-23 Tableau

Tableau

23

populations developing across countries of the world

IntroductionYou are hired by the World Bank as a Tableau Developer. You assignment is to deliver an animated dashboard s

2020-01-23 Tableau

Tableau

23

Regional profit analysis

IntroductionYou have been approached by a retail chain operating in the US. They would like you to re-create the visuali

2020-01-23 Tableau

Tableau

02

KPI dashboard

This is my kPI dashboard making by Excel. I learned it from Udemy https://www.udemy.com/course/excel-dashboards-reports/

2020-01-02 EXCEL

DashBoard

2019

12

22

AB Test summary

Main script to perform an A/B experiment using simulated dataModules: N/A Author: Cornelia Ilin Email: cilin@wisc.edu

2019-12-22 A_B Test

A_B Test

15

CS301_Proj10

CS301_Proj10IntroductionFor your final CS 301 project, you’re going to analyze the whole world! Specifically, you’re goi

2019-12-15 CS301Proj

CS301 Data Programming I

11

30

CS301_Proj9

CS301_Proj9IntroductionIn this project, you’ll be analyzing a collection of reviews of Amazon products (adapted from htt

2019-11-30 CS301Proj

CS301 Data Programming I

23

CS301_Proj8

CS301_Proj8IntroductionHaving worked our way through soccer and hurricanes, we are now going to work on the IMDB Movies

2019-11-23 CS301Proj

CS301 Data Programming I

22

Free Trail Screen

📘 Experiment design📖 Experiment Overview: Free Trial ScreenerAt the time of this experiment, Udacity courses currentl

2019-11-22 A_B Test

A_B Test

14

CS301_Proj7

CS301_Proj7IntroLet’s Play Fifa19, Python style! In this project, you will get more practice with lists and start using

2019-11-14 CS301Proj

CS301 Data Programming I

10

31

CS301_Proj6

CS301_Proj6IntroductionThis project is a wine connoisseurs’ delight! Data Science can help us understand people’s drink

2019-10-31 CS301Proj

CS301 Data Programming I

23

CS301_Proj5

CS301_Proj5OverviewHurricanes often count among the worst natural disasters, both in terms of monetary costs and, more i

2019-10-23 CS301Proj

CS301 Data Programming I

09

23

CS301_Proj3

CS301_Proj3DescriptionThe City of Madison has many different agencies providing a variety of services. In this project,

2019-09-23 CS301Proj

CS301 Data Programming I

23

ISLR_ch3.3 Potential Problems

ISLR_ch3.3 Potential ProblemsQualitative PredictorsPredictors with Only Two LevelsSuppose that we wish to investigate di