End-to-End Data Coaching
SQL | Python | Tableau
Learn how to use data in the real world
Personalized coaching and consulting services
Self-paced
Follow our YouTube channel for training videos demonstrating how to grow into a fully functional analyst using SQL, Python, and Tableau.
Live
Learn SQL, Python, and Tableau from a business intelligence executive through private or group coaching sessions, personalized to your specific career goals.
Consulting
Comprehensive evaluation of your business intelligence department with recommendations to optimize your practice.
Training Options
Register for Live Private or Group Training
If you are interested in joining live group or private SQL, registration details are shown below. If you are interested in Tableau training, please book a free consultation here or drop us an email: Contact
NFL Analytics: Python | SQL | Streamlit
Group Training:
Begins August 28th, 2024 | Two hours per week Wednesdays @ 6pm EST
Private Training:
Begins August 10th, 2024 | One hour per week on your schedule
Training Strategy:
A 4 week program following the below agenda.
Week 1:
Set up Python environment, explore NFL data sets, and agree on NFL scenario to analyze.
Week 2:
Prep data set(s) using Python and SQL in Jupyter Notebook.
Week 3:
Design Streamlit application and visualizations.
Week 4:
Deploy application to Streamlit community.
Book Securely with Stripe by Scanning or Clicking the QR Code Below
Interest Free Payment Plan with Klarna
Save 50% with Code: SAVE50
Group Training
Private Training
Download our Free SQL Training Guide for Self-Paced Learning
If you are interested in self-paced learning, download our SQL training guide for free below. If you have any issues getting started, please book a free trouble shooting session here: Contact
Dashboard Samples
Yahoo Finance Stock History (via Python & Streamlit)
This tool gives users the ability to understand how a specific stock is performing over time. It is refreshed through the previous day.
Superstore Sales Analysis
This dashboard shows sales performance across regions, categories, and month.
NFL QB Comparison Tool
This tool highlights how NFL quarterbacks are performing across various scenarios such as down and distance, personnel groupings, air yards / pass location, etc.
Attrition Analysis
This analysis demonstrates how to run a sample data set through several machine learning models, ultimately selecting the one offering the highest degree of accuracy.
SQL Training Videos
SQL
Set up your SQL environment for free using PostgreSQL, hosted in the cloud by Neon. Reach out if you prefer a different db platform: Visit Neon. PostgreSQL is where we will host your NFL database.
Python
Set up your Python environment for free using Jupyter Notebook, available from Anaconda Navigator: Visit Anaconda. Jupyter Notebook is where we will access the NFL database from Python and push it to your PostgreSQL database.
DBeaver (Desktop SQL Editor)
Set up a desktop SQL editor to make it easier to write, read, and execute SQL statements because web editors suck: Visit DBeaver
Load NFL Play-by-Play Data from Python to SQL
Once you have all your data tools set up, this video will walk you through the steps and code necessary to move the NFL database from Python to your PostgreSQL database. Once the database is available in your PostgreSQL server, you will be able to start writing SQL queries.
SQL Training: Introduction
Review of your SQL training environment. At this point, you should already have PostgreSQL database, Jupyter Notebook, and DBeaver set-up with NFL Play-by-Play data loaded to PostgreSQL. If you are missing anything listed here, please review the videos above.
SQL Training: Database and DBeaver Navigation
Learn how to navigate DBeaver to write and execute SQL queries. In addition, explore the NFL Play-by-Play database in DBeaver’s Database Navigator window.
SQL Training: Select and From Statements
Learn about the basic structure of a SQL query. All queries should have a Select and From statement. Select is where you identify fields to display in the output of a query. From is where you identify the table(s) that those fields reside.
SQL Training: Selecting Specific Fields with Alias Names
Use column alias names to clean the column labels in the output of a SQL query. This is particularly useful when column names are hard to read or when you create a calculated field.
SQL Training: Filtering Using Where
Eliminate unwanted records from a SQL query by filtering them out in a Where statement.
SQL Training: Summarizing Data Using Aggregation
Summarize detailed data into a more compact view. This is very similar to how pivot tables work in Microsoft Excel.
SQL Training: Filtering Using Having
Eliminate unwanted rollups from a SQL aggregate query by filtering them out in a Having statement. Filtering using Where eliminates detailed records (before aggregation) and filtering using Having eliminates summarized rows (after aggregation).
SQL Training: Table Joining Introduction
Introduction to connecting multiple tables together in order to use more fields in a SQL query.
SQL Training: Joining Tables Using an Inner Join
Understand when it is appropriate to use an Inner Join to connect two tables together. An Inner Join will be used when you want to display columns from multiple tables and only include rows when related values exist in both tables.
SQL Training: Joining Tables Using a Left Join
Understand when it is appropriate to use a Left Join to connect two tables together. A Left Join will be used when you want to display columns from multiple tables and always include rows from the first table even when related values don’t exist in both tables.
SQL Training: Subqueries
Placeholder. Video to be released shortly.
SQL Training: Common Table Expressions (CTEs)
Placeholder: Video to be released shortly.
SQL Training: Window Functions
Placeholder. Video to be released shortly.
Tableau
Set up your Tableau account and Tableau Desktop, available from Tableau Public. Browse the community for ideas: Visit Tableau. Tableau is used for data visualization.
Load Yahoo Finance Stock Data from Python to SQL
Create a real-life, practical, familiar database that you can use to learn both SQL and Python (for those not interested in NFL football!).
About Me
I’m Robert Simon, a seasoned data analytics professional with nearly two decades of experience across various industries. Currently, I serve as the Senior Vice President of Enterprise Business Intelligence at a leading global marketing firm. I thrive on the daily challenges and continuous learning opportunities this dynamic field offers. My true passion lies in empowering aspiring analysts by teaching fundamental data analytics skills and showcasing their real-world applications.
Through our training program, I have helped many individuals transform their careers, enabling them to secure positions with Fortune 500 companies and earn salaries above $100K per year. Book a free consult below!
Get in touch!
For a free consultation to discuss your learning goals or your business intelligence strategy, please book me below or send an email at robert.simon@datacoaching.io