These are the course materials for the analytics module 1. Module 1 will cover basic algebra, SQL Basics, Probability I, and intro to python. Over the course of the next few weeks, I will create a github repo for module 2.
This github repo will contain all the materials for the Analytics Training Sessions pertaining to module 1. Please take some time to get familir with the layout of this repo. You will need to create your own personal github repo. Github will be ideal for sharing work and keeping sessions organized. We want to keep our workflow as self contained as possible. (Independent of sending attached documents) You will need to use your own personal email to make your own github account. Directions are included in the getting started section.
Please set up your personal github account and follow the instructions here: https://guides.github.com/activities/hello-world/ You will be uploading your Homework Results to your personal github and sharing the link to your guthub repo with the instructor.
-
Please install Anaconda on your personal machines. Anaconda is a distributed system that includes an IDE to write r and python coding. Instructions here: https://www.anaconda.com/distribution/
-
If anaconda does not have r-studio, you will need to get r and r studio directly following these instructions https://courses.edx.org/courses/UTAustinX/UT.7.01x/3T2014/56c5437b88fa43cf828bff5371c6a924/
-
Please install a text editor. I personally like sublime text editor because it color codes the syntax according to detected language. Text editors allow you to write and format code sublime: https://www.sublimetext.com/ EM-Editor: https://www.emeditor.com/
-
Complete diagnostics self tests without looking up answers or methods. This is simply to see where your current knowledge is.
-
SQL Self Diagnostic: https://github.com/vindication09/Data-Science-Mathematics/blob/master/Prerequisites/sql-self-test-2015-business-intelligence.pdf
-
Math Self Diagnostic: https://github.com/vindication09/Data-Science-Mathematics/blob/master/Prerequisites/Mathematics_Test_samples.pdf
-
Complete the DIY SQL tutorial if you are unable to answer questions on the self diagnostic SQL test: https://www.w3schools.com/sql/
-
Additional Lectures on SQL https://www.youtube.com/watch?v=HXV3zeQKqGY
-
Once SQL tutorials have been complete, please become familiar with Google Big Query. There will be a more formal training but its good to become familiar early on. https://medium.com/google-cloud/getting-started-with-google-cloud-a-codelab-for-geohackweek-2017-848c25ed72fd
-
If you are unable to complete math questions on the self diagnostic math test, you will stat with the Algebra lesson I have prepared.
-
As additional reference, if you do not have access to BigQuery, there are open source playforms you can use. Here is the information for how to install mySQL https://towardsdatascience.com/learning-sql-the-hard-way-4173f11b26f1
-
Please get started on the DIY tutorial for Python https://www.w3schools.com/python/default.asp
-
Download Python on corp machine https://github.com/vindication09/Data-Science-Mathematics/blob/master/Python/Anaconda_simple_setup.docx
-
For Algebra, we will be using Pauls Online Math notes. These open source notes are a popular choice among undergraduates as complimentary material. http://tutorial.math.lamar.edu/
-
For Probability, we will be using A First Course in Probability by Sheldon Ross. I will include a download link. If you are unable to download the book from this link, I will share the PDF via google drive. https://readyforai.com/download/a-first-course-in-probability-9th-edition-pdf/
-
Intro to R https://github.com/vindication09/Data-Science-Mathematics/blob/master/R-intro.pdf
-
I will share the links to the github repos where SQL materials are stored. You can download the materials from each link. I highly encourage you to get "The Language of SQL" by Larry Rockoff
-
If you are having difficulty downloading r and r studio, you can use this in the meantime. https://rdrr.io/snippets/
Lessons for Live Sessions will be published online via rpubs. You can access them anytime using your web browser. Links to HW problems are posted at the end of each lesson. This section will continue to update as more lessons come out. Please check this section often for updates. Please see the lessons below:
- Algebra Review, Session 1: https://rpubs.com/vharo00/559162
- Algebra Review, Session 2: https://rpubs.com/vharo00/559167
- Algebra Review, Session 3: https://rpubs.com/vharo00/559168
- Algebra Review, Session 4: https://rpubs.com/vharo00/559172
- Algebra Review, Session 5: https://rpubs.com/vharo00/559178
- Algebra Review, Session 6: https://rpubs.com/vharo00/559183
- Algebra Review, Session 7: https://rpubs.com/vharo00/559189
- Algebra Review, Session 8: https://rpubs.com/vharo00/559190
- Intro to R, Session 1: https://rpubs.com/vharo00/506239
- Intro to R, Session 2: https://rpubs.com/vharo00/509960
- My First Program, Session 1 https://github.com/vindication09/Data-Science-Mathematics/blob/master/Python/MyFirstProgram.ipynb
- Python Session 2 https://github.com/vindication09/Data-Science-Mathematics/blob/master/Python/Introduction%20to%20Python%2C%20Session%202.ipynb
- Probability, Session 1 https://rpubs.com/vharo00/520872
- Probability, Session 2 https://rpubs.com/vharo00/541384
- Probability, Session 3 http://rpubs.com/vharo00/544580
- SQL Basics, Session 1 https://github.com/vindication09/Data-Science-Mathematics/blob/master/SQL/SQL%20Session%20Training%201.pdf
- SQL Basics, Session 2 https://github.com/vindication09/Data-Science-Mathematics/blob/master/SQL/SQL%20session%20training%202.pdf
- SQL Basics, Session 3 GA Training
- SQL Basics, Session 4 https://github.com/vindication09/Data-Science-Mathematics/blob/master/SQL/SQL%20Training%20Session%204.pdf
- SQL Basics, Session 5 https://github.com/vindication09/Data-Science-Mathematics/blob/master/SQL/SQL%20Training%20Session%205.pdf
I will continue to update the following section with the materials that will be covered in each training session.
- Session 1 (SQL Basic S1)
- Session 2 (Algebra S1, SQL Basics S2)
- Session 3 (GA Training)
- Session 4 (algebra S2, SQL HW 1 Review)
- Session 5 (algebra S3, SQL Basics S4)
- Session 6, (Algebra S4, SQL Basics S5)
- Session 7, (Algebra S5, Python S1)
- Session 8, (Algebra S6, Python S2)
- Session 8 (Alternate) Pat Presents some SQL Based work