Courses floor › Tech, AI and Security
Data Analysis with Python and SQL for Spreadsheet Users
| SKU | FB-16-85644B75 |
|---|---|
| Format | ZIP: Markdown, PDF, PNG, Python |
| File size | 652.8 KB |
| Delivery | Instant download, unlimited re-downloads from your account |
| Licences | Personal, Commercial, Extended |
All sales are final. Refund policy.
About this product
8-module beginner course for business people who use spreadsheets. Explain how a table, a row and a column map onto familiar spreadsheet ranges and why that structure matters for analysis. Includes written lessons, worked examples, a quiz with answer key per module, runnable companion scripts, a workbook, a cheat sheet, a final project and a NorthFraim completion certificate. Made with AI assistance. Modules: 1. From Spreadsheet Ranges to Tables: Seeing Your Data as Rows and Records; 2. Asking Questions in SQL: SELECT, WHERE and ORDER BY for Business Filters; 3. Summarising with GROUP BY: Totals, Counts and Averages by Category; 4. Cleaning Messy Data in Python: Missing Values, Duplicates and Inconsistent Labels; 5. Exploring with Python: Distributions, Outliers and Time Patterns in Plain Scripts; 6. Joining Tables: Combining Orders, Customers and Products Without Losing Rows; 7. Charts That Tell the Truth: Choosing and Labelling Business Visuals; 8. Reporting with Honest Conclusions: Stating What the Data Shows and What It Does Not. What you will be able to do: Explain how a table, a row and a column map onto familiar spreadsheet ranges and why that structure matters for analysis; Write SQL queries that filter, group, aggregate and sort business data to answer specific questions; Use Python to load, clean and summarise tabular data stored in plain CSV files; Produce clear charts and a short written report that separates what the data shows from what it cannot show; Check results for missing values, duplicates and misleading comparisons before drawing conclusions. Format: self-paced written course you download and keep (652.8 KB, 8 modules, 24 lessons, about 13,734 words), plus workbook, cheat sheet, quizzes and scripts.
What's included
- 8 modules, 24 written lessons (13,734 words of teaching text)
- A worked example per module
- A 2-question quiz and answer key per module
- Runnable companion Python scripts per module (checked in a sandbox)
- workbook.pdf: practice exercises for every module
- cheatsheet.pdf
- final-project.md with steps, deliverables and rubric
- certificate.pdf (completion certificate)
- syllabus.md, README.md, PROVENANCE.md
Download and use
- After payment, click your download link (on screen, in your email receipt and in your account dashboard; re-download any time).
- Unzip the file: double-click it on Windows or Mac, or tap it in the Files app on a phone.
- Open README.md, then syllabus.md, to see the plan.
- Work through modules/m1 to the last module: read the three lessons, study the worked example, do the practice (practice.md or the workbook), take quiz.md and check quiz-answer-key.md.
- Run each module's companion script with Python 3.9 or newer: open a terminal in the module's code folder and run the command shown in the lesson (standard library only, no internet or keys needed).
- Print or fill in workbook.pdf as you go, keep cheatsheet.pdf at hand, then complete final-project.md.
- Print certificate.pdf and write your name on it when you finish.
Tags
analysisandbeginnercoursedataforlessonspythonquizspreadsheet








