Data Management & Analysis
Technical Notes
I am a data analyst with two years' experience manipulating, analyzing, and reporting on data.
This page is an archive of my notes on technical subjects related to data management and analysis. The notes are based on content from learning platforms like Udacity, Coursera, Udemy, and Salesforce's Trailhead.
View that content using the links below, or learn more about me.
Salesforce
Certification Study Notes
Process Exercises
Intro to Machine Learning
Supervised Learning
- Linear Regression
- Linear Regression Implementations
- Decision Trees
- Decision Tree Titanic Example
- Decision Tree Implementations
- Naive Bayes
- Naive Bayes Impementations
- Naive Bayes SMS Example
- Support Vector Machines
- Support Vector Machine Implementations
- Ensemble Methods
- Ensemble Methods Implementations
- Model Evaluation
- Visualizing Decision Boundaries
- Classification Model Evaluation
- Regression Model Evaluation
- Training and Tuning
- Learning Curve Examples
- Grid Search Examples
- Random Search Diabetes Example
Deep Learning
- Perceptron
- Perceptron Implementations
- Neural Networks
- Neural Network Implementations
- Neural Network Architecture
- Neural Network Admissions Example
- Gradient Descent
- Gradient Descent Implementations
- Multilayer Perceptrons
- Feed Forward Implementations
- Backpropagation
- Backpropagation Implementations
- Training Considerations
Unsupervised Learning
- Unsupervised Learning
- Clustering
- Clustering Examples
- Feature Scaling with KMeans
- Hierarchical and Density Based Clustering
- Hierarchical Clustering
- DBSCAN
- Gaussian Mixture Models and Cluster Validation
- Gaussian Mixture Model Examples
- Dimensionality Reduction and PCA
- Using PCA on MNIST
- Using PCA on Cars Dataset
- Using ICA on Sound Files
- Random Projection and ICA
Data Visualization
Common Types of Visuals
Pandas and Seaborn
Applied Machine Learning
Theory of Machine Learning
General Learning Theory
Database Systems Concepts and Design
SQL
Relational Databases
Useful Scripts
- Dates and Times in Python
- Working with Dates in Pandas
- Setting up Folders Named as Today's Date
- Programmatically Capturing Filenames
- Flatten JSON
- Setting Up New Project Directories
- Useful Pandas Options
- Array Mechanics in Numpy
- Writing Multiple Excel Sheets from Pandas
- Use a Config File to store User Credentials
Web Scraping and Data Sourcing
Statistics
Data Science as a Discipline
Data Analysis Process
Other Interests
Finances, Investments, and Business
- Internal Rate of Return (Unequal Timing) in Python
- Calculating a Loan Balance Over Time
- Equity to Offset Home Purchase Transaction Costs
- Electric Vehicle Total Cost of Ownership
- Total Interest over Life of Loan
- Dynamic Dollar Cost Averaging into Bitcoin
- Exiting Altcoin Positions
- Average Bitcoin Returns Analysis
- Crypto Mining and Trading Tax Implications
- Tax Implications of Different Business Structures
- Setting Up an LLC