Data analysis learning directory

some time 5 In the months , I will accompany you to learn about data analysis , Including thinking from data , Data tools （Excel,Mysql,Hive,Python）, Data methodology , Data presentation （Tableau,BI）, data mining 、 A complete set of contents of data actual combat project , Synchronization will sort out the possible and useful knowledge points . The content will be updated slowly .
————————————————

The following is the entire directory of data analysis

One 、 Data analysis thinking

Two 、 Commonly used in data analysis Excel skill

2.1、 Calculate two dates ( Belt time ) Time difference between

2.2、VLOOKUP Reverse lookup of function

2.3、Text Format conversion function

2.4、SUMIF Summation of function conditions

2.5、COUNTIFS function

2.6、Ctrl+E Fast fill

2.7、Datedif function

3、 ... and 、MySQL Programming

3.0、MySQL Addition, deletion and modification of

3.1、Mysql Inquire about

        3.1.1、 Simple query

        3.1.2、 Query operator

        3.1.3、 Sort query

        3.1.4、 Aggregate query

        3.1.5、 Group query

        3.1.6、 Paging query

 3.2、Mysql Multi table joint query

        3.2.1、 Cross-join query

        3.2.2、 Internal connection query

                Implicit inner join

                Explicit inner connection

        3.2.3、 External connection query

        3.2.4、 Subquery

                Subquery keyword

        3.2.5、 Self association query

3.3、Mysql function

        3.3.1、 Mathematical functions

        3.3.2、 String function

        3.3.3、 Date time function

        3.3.4、 Conditional judgment function

        3.3.5、 System information function

        3.3.6、 Advanced window functions

3.4、Mysql Indexes

3.5、Mysql Regular expressions

3.6、 other Mysql matter

        3.6.1、Mysql Three paradigms

        3.6.2、Mysql Optimize

        3.6.3、Mysql Locking mechanism

        3.6.4、Mysql Business

        3.6.5、Mysql journal

 3.7、Mysql project 、 Important and difficult questions 、 The real interview question of Dachang

Four 、 visualization BI Software

Data visualization

        Everyone is a data analyst ： Turing original 《 By Dr. Liu Hongge 》

4.1、 First time to know Tableau

        4.1.1、 View

        4.1.2、 The page in figure

        4.1.3、 Filter

        4.1.4、 Data mixing relationship

4.2、 Initial visualization of data

        4.2.1、 Bar chart

        4.2.2、 Histogram

        4.2.3、 Discount chart

        4.2.4、 The pie chart

        4.2.5、 Doughnut

        4.2.6、 Scatter 、 Bubble chart

        4.2.7、 Bull's eye

        4.2.8、 Map

4.3、 High order visualization of data

        4.3.1、 Pareto Diagram

        4.3.2、 Box picture

        4.3.3、 Waterfall Plot

        4.3.4、 Dynamic graph

        4.3.5、 Funnel diagram

4.4、 function

        4.4.1、 Special functions ： Quick table calculation

                4.4.1.1、 Cumulative summary

                4.4.1.2、 differences

                4.4.1.3、 Percentage difference

                4.4.1.4、 Total percentage

                4.4.1.5、 Sort

                4.4.1.6、 Sort

                4.4.1.7、 Percentile

                4.4.1.8、 Compound growth rate

        4.4.2、 Special functions ： Detailed expression

                4.4.2.1、Include function

                4.4.2.1、Exclude function

                4.4.2.1、Fixned function

4.5、 Advanced operation of data

        4.5.1、 Hierarchical structure

        4.5.2、 Group structure

        4.5.3、 Set structure

        4.5.4、 Parameters to create

        4.5.5、 Field creation

        4.5.6、 Guide line creation

4.6、 Data visualization project

5、 ... and 、 big data

6、 ... and 、 Programming basis of data analysis

7、 ... and 、 Statistical theory

8、 ... and 、 data mining

Nine 、 Data analysis project