SQL
Query any databaseSELECT, joins, aggregation, window functions and the performance tips that matter.
打开 · 免费 →Knowledge Base
Learn data & AI — free.
Practical one-page cheat sheets and plain-language guides for teams going through digital transformation. Free to read, print and share. Written in English; Bahasa Melayu and 中文 on request.
JY
About the author
JY
Founder, JYnapse · AI / ML Engineer · MSc Data ScienceJY holds a Master’s in Data Science and builds production data pipelines, dashboards and grounded AI systems for Malaysian businesses — then teaches teams to run them, in plain language and on their own examples.
This Knowledge Base is the same material used in JYnapse workshops, made free to read. Everything here is available in English, Bahasa Melayu and 中文 on request.
Cheat sheets
Ten one-page references
The tools our clients reach for most, distilled to a single printable page each. Open, read, or save as PDF — no sign-up.
Python
The language, essentialTypes, collections, loops, functions and comprehensions on one page. Python 3.
打开 · 免费 →pandas
Wrangle data in PythonLoad, clean, filter, group, merge and reshape DataFrames.
打开 · 免费 →Excel
The SME workhorseLookups, IF logic, SUMIFS, pivot tables and the shortcuts worth memorising.
打开 · 免费 →Data Visualization
Charts that communicatePick the right chart, then build it in matplotlib, seaborn or Plotly.
打开 · 免费 →Statistics
Read numbers with careDistributions, confidence intervals, hypothesis tests and the traps that catch everyone.
打开 · 免费 →Power BI & DAX
Dashboards people trustPower Query, star-schema modelling, measures, CALCULATE and time intelligence.
打开 · 免费 →Machine Learning
The scikit-learn workflowFrame, split, train, evaluate — and the metrics that tell you if it works.
打开 · 免费 →Prompt Engineering
Reliable output from LLMsPrompt anatomy, few-shot examples, structured output and grounding.
打开 · 免费 →AI Agents
RAG, agents & MCPRetrieval, the agent loop, tools, orchestration, guardrails — and which build to choose.
打开 · 免费 →
洞察
In-depth guides
Longer reads for when a decision needs the whole picture — written for business owners, not engineers.
Automation or AI? It isn’t a choice
The distinction that decides what you buildWhere automation ends, where AI earns its cost, and why almost every workflow needs both — in that order.
Read · 免费 →Three builds, not one
RAG vs automation vs agents“Build us an AI assistant” hides three projects that cost wildly different amounts. How to tell them apart.
Read · 免费 →Not training. Retrieval.
What a document assistant really isWhy “train it on our documents” almost always means retrieval — cheaper, updatable, and able to cite its sources.
Read · 免费 →想让团队一起学？
Every cheat sheet and guide here can become a live workshop — on your own data, in the language your team works in.
咨询工作坊