Data analysis with excel for dummies pdf

#Data analysis with excel for dummies pdf how to#
#Data analysis with excel for dummies pdf install#

Note: As an SQL query tool I prefer SQL Workbench over pgadmin4, but this is kind of question of taste.

#Data analysis with excel for dummies pdf install#

If something is missing, please read the article again: Install bash, Python, R and SQL!

Pgadmin4 (or preferably SQL Workbench) on your computer.

PostgreSQL installed on your data server.

A data server with Terminal (or iTerm) access.

If you went through the above-linked article, please double-checkР вЂ™Р’В that you have these 3 things: I picked postgreSQL because itР Р†Р вЂљРІвЂћСћs very popular (lots of the online businesses are using it) and itР Р†Р вЂљРІвЂћСћsР вЂ™Р’В said to be the most advanced open source SQL language. The good news is that all SQL languages are very similar Р Р†Р вЂљРІР‚Сљ if you learn postgreSQL, it will be a matter of hours (or even minutes) to adapt to another one.

Note: in my Р Р†Р вЂљРЎС™SQL for Data AnalysisР Р†Р вЂљРЎСљ articles IР Р†Р вЂљРІвЂћСћll use postgreSQL! There are other types of SQL languages (another well-known open source one is mySQL).

#Data analysis with excel for dummies pdf how to#

ItР Р†Р вЂљРІвЂћСћs a step by step tutorial about how to set up your own Data Server and install bash, Python, R and SQL on it. Note: if you have your own SQL environment already, you can skip further to STEP 2 Р Р†Р вЂљРІР‚Сљ Get some data!Р вЂќР вЂЎirst, please go through this article. Spark, Hive, etc.) also supportР вЂ™Р’В SQL!Р вЂќР’В«ut now, letР Р†Р вЂљРІвЂћСћs jump on the practical part! STEP #0 Р Р†Р вЂљРІР‚Сљ Install your own SQL environment to practice! The main differences will be syntax, Р Р†Р вЂљРЎС™featuresР Р†Р вЂљРЎСљ and performanceР Р†Р вЂљР’В¦ But I really donР Р†Р вЂљРІвЂћСћt want to go into that topic right now, because:Р вЂќР вЂћ) I promised a practical tutorial and that topic is a bit more theoretical (even philosophical)Р вЂќР’В¬) at this level, you donР Р†Р вЂљРІвЂћСћt have to worry about performance at all Р Р†Р вЂљРІР‚Сљ and when you will, most probably a senior data scientist or a data engineer will help you out. Once you start to apply these languages on real life analyticsР вЂ™Р’В projects, you will see that Python is good for some things and SQL is goodР вЂ™Р’В for other things. The answer isР Р†Р вЂљР’В¦ well, there is no categorical answer for this question! If you have done my bash or Python tutorials already, you might ask: is SQL better or worse than Python, R or bash?

But you will be able to do these more efficiently and on muchР вЂ™Р’В larger data sets than before. When you use SQL for data analysis, you will use it (most probably) for simple tasks: aggregating data, joining datasets, using simple statistical and mathematical methods. Here are justР вЂ™Р’В two practical advantages: joining tables is much easier in SQL than it is in Excel - and automating and reusing yourР вЂ™Р’В code will become more convenient with SQL, too.

But believe me, once youР Р†Р вЂљРІвЂћСћve understood the basics of SQL, you will find it much clearer and more much easier than Excel.