The 1-Hour Analyst — Data Analyst Guide PDF with AI: Excel, SQL, Python & Power BI (59 Prompts)

Do a day's data work in an hour, with free AI tools and skills you can prove.

Most of a data analyst's day isn't analysis. It's cleaning messy exports, hunting for the right formula and fixing SQL errors. The 1-Hour Analyst shows you how to hand that repetitive work to ChatGPT, Gemini, Claude or Copilot, and how to check every answer, so you can spend your time on the thinking that gets you hired.

What's inside (42 pages)

• Clean & prepare data: duplicates, text dates, missing values and hidden spaces, in Excel, Google Sheets and pandas
• Excel & Sheets formulas on demand: XLOOKUP, INDEX-MATCH, SUMIFS, IFS and pivot tables, explained
• SQL without the struggle: JOINs explained by row counts, GROUP BY, window functions (ROW_NUMBER, LAG) and debugging errors
• Python for non-coders: a 10-line EDA and charts in free Google Colab
• Power BI + AI: star schema, DAX measures (YoY, YTD, % of total) and choosing the right visual
• From numbers to story: insights, executive summaries and stakeholder emails
• 3 portfolio projects with real Indian public data: Delhi air quality, crop production (SQL) and UPI growth
• Guardrails: how to catch wrong AI formulas and never leak company data
• Interview edge + 30-day analyst sprint

Example prompt (#22 · SQL)

"Act as a senior SQL analyst. Database: [POSTGRESQL]. Tables: [TABLES AND COLUMNS]. Write a query that [GOAL]. Explain each clause and tell me what row count to expect so I can sanity-check it."

Tested, not guessed: every spreadsheet formula, SQL query and Python snippet in this book was run before printing.

Who it's for: final-year students (BCom, BSc, BTech, BBA), freshers in MIS or reporting roles, career switchers into data analytics, and professionals who spend hours in Excel.

Works with free tools: ChatGPT, Gemini, Claude, Copilot, Excel for the web, Google Sheets, Google Colab and Power BI Desktop. No paid subscription needed.

📥 Instant PDF download · 42 pages · 59 ready prompts · 3 portfolio projects

Part of the Truhetu AI Series (AI Career Tracks, Book 01). Pair it with Campus to Offer Letter for placement prep.

Disclaimer: Microsoft Excel, Power BI, Copilot, Google Sheets, Gemini, Google Colab, ChatGPT, Claude, Python, pandas, PostgreSQL, SQLite, Kaggle and other names belong to their respective owners. Truhetu is not affiliated with, endorsed by or sponsored by any of them. Data sources (data.gov.in, DES, NPCI, CPCB, OpenCity) belong to their publishers. Tool features and plans change; always confirm on official websites. This guide does not guarantee a job or interview call. — Truhetu Team