Data Analytics

AI/ML roadmap Topic: Mathematics - Subtopic: Linear Algebra - Vectors, Matrices, Eigenvalues and Eigenvectors - Subtopic: Calculus - Differentiation, Integration, Partial Derivatives - Subtopic: Probability and Statistics - Probability Theory, Random Variables, Statistical Inference Topic: Programming - Subtopic: Python - Python Basics, Libraries like NumPy, Pandas, Matplotlib Topic: Machine Learning - Subtopic: Supervised Learning - Linear Regression, Logistic Regression, Decision Trees - Subtopic: Unsupervised Learning - Clustering, Dimensionality Reduction[1](https://i.am.ai/roadmap) - Subtopic: Neural Networks and Deep Learning - Feedforward Neural Networks, Convolutional Neural Networks, Recurrent Neural Networks Topic: Specializations - Subtopic: Natural Language Processing - Text Preprocessing, Topic Modeling, Word Embeddings - Subtopic: Computer Vision - Image Processing, Object Detection, Image Segmentation - Subtopic: Reinforcement Learning - Markov Decision Processes, Q-Learning, Policy Gradients Join for more: https://t.me/machinelearning_deeplearning

Top 10 Excel Interview Questions with Answers ✅ 1. Question: What is the difference between CONCATENATE and "&" in Excel?    Answer: CONCATENATE and "&" both combine text, but "&" is more concise. For example, =A1&B1 achieves the same result as =CONCATENATE(A1, B1). 2. Question: How can you freeze rows and columns simultaneously in Excel?    Answer: Use the "Freeze Panes" option under the "View" tab. Select the cell below and to the right of the rows and columns you want to freeze, and then click on "Freeze Panes." 3. Question: Explain the VLOOKUP function and when would you use it?    Answer: VLOOKUP searches for a value in the first column of a range and returns a corresponding value in the same row from another column. It's useful for looking up information in a table based on a specific criteria. 4. Question: What is the purpose of the IFERROR function?    Answer: IFERROR is used to handle errors in Excel formulas. It returns a specified value if a formula results in an error, and the actual result if there's no error. 5. Question: How do you create a PivotTable, and what is its purpose?    Answer: To create a PivotTable, select your data, go to the "Insert" tab, and choose "PivotTable." It summarizes and analyzes data in a spreadsheet, allowing you to make sense of large datasets. 6. Question: Explain the difference between relative and absolute cell references.    Answer: Relative references change when you copy a formula to another cell, while absolute references stay fixed. Use a $ symbol to make a reference absolute (e.g., $A$1). 7. Question: What is the purpose of the INDEX and MATCH functions?    Answer: INDEX returns a value in a specified range based on the row and column number, while MATCH searches for a value in a range and returns its relative position. Combined, they provide a flexible way to look up data. 8. Question: How can you find and remove duplicate values in Excel?    Answer: Use the "Remove Duplicates" feature under the "Data" tab. Select the range containing duplicates, go to "Data" -> "Remove Duplicates," and choose the columns to check for duplicates. 9. Question: Explain the difference between a workbook and a worksheet.    Answer: A workbook is the entire Excel file, while a worksheet is a single sheet within that file. Workbooks can contain multiple worksheets. 10. Question: What is the purpose of the COUNTIF function?    Answer: COUNTIF counts the number of cells within a range that meet a specified condition. For example, =COUNTIF(A1:A10, ">50") counts the cells in A1 to A10 that are greater than 50. Free Excel Resources: https://t.me/excel_data Hope it helps ✅

𝗕𝗲𝗰𝗼𝗺𝗲 𝗮 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗶𝗻 𝟮𝟬𝟮𝟱 — 𝗦𝘁𝗮𝗿𝘁 𝘄𝗶𝘁𝗵 𝗝𝘂𝘀𝘁 𝟯 𝗖𝗼𝗿𝗲 𝗦𝗸𝗶𝗹𝗹𝘀!😍 Want to break into Data Analytics without a degree or expensive bootcamps?👨‍💻📌 All you need are 3 essentials to get started👇 📊 Excel | 🛢 SQL | 🧠 Basic Maths 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/3IwVWGE You can learn & practice them 100% FREE✅️

Let's now understand the above Data Analyst Roadmap in detail: 🧠↗️ 1️⃣ Learn Excel ⭐️ The foundation of data analysis. Learn formulas, pivot tables, charts, VLOOKUP/XLOOKUP, and conditional formatting. It helps in quick data cleaning and presenting insights. Excel Resources: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i 2️⃣ Learn SQL 💻 Essential for working with databases. Focus on SELECT, JOIN, GROUP BY, WHERE, and subqueries to extract and manipulate data from relational databases. SQL Resources: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v 3️⃣ Learn Python 📱 A powerful tool for data manipulation and automation. Master libraries like pandas, numpy, matplotlib, and seaborn for data cleaning and visualization. Python Resources: https://whatsapp.com/channel/0029VaiM08SDuMRaGKd9Wv0L 4️⃣ Learn Power BI / Tableau 📈 These tools help create interactive dashboards and visual reports. Learn how to import data, create filters, use DAX (Power BI), and design clear visualizations. Power BI Resources: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c 5️⃣ Learn Statistics & Probability 🛍 Know about descriptive stats (mean, median, mode), inferential stats, distributions, hypothesis testing, and correlation. Vital for making sense of data trends. Statistics Resources: https://whatsapp.com/channel/0029Vat3Dc4KAwEcfFbNnZ3O 6️⃣ Learn Data Transformation 📈 Learn how to clean, shape, and prepare data for analysis. Use Python (pandas) or Power Query in Power BI, and understand ETL (Extract, Transform, Load) processes. Data Cleaning: https://whatsapp.com/channel/0029VarxgFqATRSpdUeHUA27 7️⃣ Learn Machine Learning 🧠 Understand basic concepts like regression, classification, clustering, and decision trees. You don’t need to be an ML expert, just grasp how models work and when to use them. Machine Learning: https://whatsapp.com/channel/0029VawtYcJ1iUxcMQoEuP0O 8️⃣ Build Projects & Portfolio 🏹 Apply what you’ve learned to real datasets—like sales analysis, churn prediction, or dashboard creation. Showcase your work on GitHub or a personal website. Data Analytics Projects: https://whatsapp.com/channel/0029VbAbnvPLSmbeFYNdNA29 9️⃣ Apply for Jobs 💼 With your skills and portfolio in place, start applying for data analyst roles. Tailor your resume using keywords from job descriptions and prepare to answer SQL and Excel tasks in interviews. Jobs & Internship Opportunities: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226 Share with credits: https://t.me/sqlspecialist Double Tap ♥️ for more

Roadmap to become a Data Analyst: 📂 Learn Excel ∟📂 Learn SQL ∟📂 Learn Python ∟📂 Learn Power BI / Tableau ∟📂 Learn Statistics & Probability ∟📂 Learn Data Transformation ∟📂 Learn Machine Learning Basics ∟📂 Build Projects & Portfolio ∟✅ Apply for Job React ❤️ for More 📊

𝐇𝐨𝐰 𝐭𝐨 𝐏𝐫𝐞𝐩𝐚𝐫𝐞 𝐭𝐨 𝐁𝐞𝐜𝐨𝐦𝐞 𝐚 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐭 𝟏. 𝐄𝐱𝐜𝐞𝐥- Learn formulas, Pivot tables, Lookup, VBA Macros. 𝟐. 𝐒𝐐𝐋- Joins, Windows, CTE is the most important 𝟑. 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈- Power Query Editor(PQE), DAX, MCode, RLS 𝟒. 𝐏𝐲𝐭𝐡𝐨𝐧- Basics & Libraries(mainly pandas, numpy, matplotlib and seaborn libraries) 5. Practice SQL and Python questions on platforms like 𝐇𝐚𝐜𝐤𝐞𝐫𝐑𝐚𝐧𝐤 or 𝐖𝟑𝐒𝐜𝐡𝐨𝐨𝐥𝐬. 6. Know the basics of descriptive statistics(mean, median, mode, Probability, normal, binomial, Poisson distributions etc). 7. Learn to use 𝐀𝐈/𝐂𝐨𝐩𝐢𝐥𝐨𝐭 𝐭𝐨𝐨𝐥𝐬 like GitHub Copilot or Power BI's AI features to automate tasks, generate insights, and improve your projects(Most demanding in Companies now) 8. Get hands-on experience with one cloud platform: 𝐀𝐳𝐮𝐫𝐞, 𝐀𝐖𝐒, 𝐨𝐫 𝐆𝐂𝐏 9. Work on at least two end-to-end projects. 10. Prepare an ATS-friendly resume and start applying for jobs. 11. Prepare for interviews by going through common interview questions on Google and YouTube. I have curated top-notch Data Analytics Resources 👇👇 https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02 Hope this helps you 😊

I was lost in crypto noise — until I found a channel that shows where the real money is made👍 No hype, just clear signals and smart entries. 👉🏼 Subscribe now — all you need to do is follow the trades. It’s that simple: https://t.me/+ixExN-YdZsc5M2Iy

Ad 👇👇

Essential Skills Excel for Data Analysts 🚀 1️⃣ Data Cleaning & Transformation Remove Duplicates – Ensure unique records. Find & Replace – Quick data modifications. Text Functions – TRIM, LEN, LEFT, RIGHT, MID, PROPER. Data Validation – Restrict input values. 2️⃣ Data Analysis & Manipulation Sorting & Filtering – Organize and extract key insights. Conditional Formatting – Highlight trends, outliers. Pivot Tables – Summarize large datasets efficiently. Power Query – Automate data transformation. 3️⃣ Essential Formulas & Functions Lookup Functions – VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH. Logical Functions – IF, AND, OR, IFERROR, IFS. Aggregation Functions – SUM, AVERAGE, MIN, MAX, COUNT, COUNTA. Text Functions – CONCATENATE, TEXTJOIN, SUBSTITUTE. 4️⃣ Data Visualization Charts & Graphs – Bar, Line, Pie, Scatter, Histogram. Sparklines – Miniature charts inside cells. Conditional Formatting – Color scales, data bars. Dashboard Creation – Interactive and dynamic reports. 5️⃣ Advanced Excel Techniques Array Formulas – Dynamic calculations with multiple values. Power Pivot & DAX – Advanced data modeling. What-If Analysis – Goal Seek, Scenario Manager. Macros & VBA – Automate repetitive tasks. 6️⃣ Data Import & Export CSV & TXT Files – Import and clean raw data. Power Query – Connect to databases, web sources. Exporting Reports – PDF, CSV, Excel formats. Here you can find some free Excel books & useful resources: https://t.me/excel_data Hope it helps :) #dataanalyst

If you’re a Data Analyst, chances are you use 𝐒𝐐𝐋 every single day. And if you’re preparing for interviews, you’ve probably realized that it's not just about writing queries it's about writing smart, efficient, and scalable ones. 1. 𝐁𝐫𝐞𝐚𝐤 𝐈𝐭 𝐃𝐨𝐰𝐧 𝐰𝐢𝐭𝐡 𝐂𝐓𝐄𝐬 (𝐂𝐨𝐦𝐦𝐨𝐧 𝐓𝐚𝐛𝐥𝐞 𝐄𝐱𝐩𝐫𝐞𝐬𝐬𝐢𝐨𝐧𝐬) Ever worked on a query that became an unreadable monster? CTEs let you break that down into logical steps. You can treat them like temporary views — great for simplifying logic and improving collaboration across your team. 2. 𝐔𝐬𝐞 𝐖𝐢𝐧𝐝𝐨𝐰 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬 Forget the mess of subqueries. With functions like ROW_NUMBER(), RANK(), LEAD() and LAG(), you can compare rows, rank items, or calculate running totals — all within the same query. Total 3. 𝐒𝐮𝐛𝐪𝐮𝐞𝐫𝐢𝐞𝐬 (𝐍𝐞𝐬𝐭𝐞𝐝 𝐐𝐮𝐞𝐫𝐢𝐞𝐬) Yes, they're old school, but nested subqueries are still powerful. Use them when you want to filter based on results of another query or isolate logic step-by-step before joining with the big picture. 4. 𝐈𝐧𝐝𝐞𝐱𝐞𝐬 & 𝐐𝐮𝐞𝐫𝐲 𝐎𝐩𝐭𝐢𝐦𝐢𝐳𝐚𝐭𝐢𝐨𝐧 Query taking forever? Look at your indexes. Index the columns you use in JOINs, WHERE, and GROUP BY. Even basic knowledge of how the SQL engine reads data can take your skills up a notch. 5. 𝐉𝐨𝐢𝐧𝐬 𝐯𝐬. 𝐒𝐮𝐛𝐪𝐮𝐞𝐫𝐢𝐞𝐬 Joins are usually faster and better for combining large datasets. Subqueries, on the other hand, are cleaner when doing one-off filters or smaller operations. Choose wisely based on the context. 6. 𝐂𝐀𝐒𝐄 𝐒𝐭𝐚𝐭𝐞𝐦𝐞𝐧𝐭𝐬: Want to categorize or bucket data without creating a separate table? Use CASE. It’s ideal for conditional logic, custom labels, and grouping in a single query. 7. 𝐀𝐠𝐠𝐫𝐞𝐠𝐚𝐭𝐢𝐨𝐧𝐬 & 𝐆𝐑𝐎𝐔𝐏 𝐁𝐘 Most analytics questions start with "how many", "what’s the average", or "which is the highest?". SUM(), COUNT(), AVG(), etc., and pair them with GROUP BY to drive insights that matter. 8. 𝐃𝐚𝐭𝐞𝐬 𝐀𝐫𝐞 𝐀𝐥𝐰𝐚𝐲𝐬 𝐓𝐫𝐢𝐜𝐤𝐲 Time-based analysis is everywhere: trends, cohorts, seasonality, etc. Get familiar with functions like DATEADD, DATEDIFF, DATE_TRUNC, and DATEPART to work confidently with time series data. 9. 𝐒𝐞𝐥𝐟-𝐉𝐨𝐢𝐧𝐬 & 𝐑𝐞𝐜𝐮𝐫𝐬𝐢𝐯𝐞 𝐐𝐮𝐞𝐫𝐢𝐞𝐬 𝐟𝐨𝐫 𝐇𝐢𝐞𝐫𝐚𝐫𝐜𝐡𝐢𝐞𝐬 Whether it's org charts or product categories, not all data is flat. Learn how to join a table to itself or use recursive CTEs to navigate parent-child relationships effectively. You don’t need to memorize 100 functions. You need to understand 10 really well and apply them smartly. These are the concepts I keep going back to not just in interviews, but in the real world where clarity, performance, and logic matter most.

𝟲 𝗥𝗲𝗮𝗹-𝗪𝗼𝗿𝗹𝗱 𝗦𝗤𝗟 𝗣𝗿𝗼𝗷𝗲𝗰𝘁𝘀 𝘁𝗼 𝗕𝗼𝗼𝘀𝘁 𝗬𝗼𝘂𝗿 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗣𝗼𝗿𝘁𝗳𝗼𝗹𝗶𝗼 (𝗙𝗥𝗘𝗘 𝗗𝗮𝘁𝗮𝘀𝗲𝘁𝘀!)😍 🎯 Want to level up your SQL skills with real business scenarios?📚 These 6 hands-on SQL projects will help you go beyond basic SELECT queries and practice what hiring managers actually care about👨‍💻📌 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/40kF1x0 Save this post — even completing 1 project can power up your SQL profile!✅️

Everyone thinks being a great data analyst is about advanced algorithms and complex dashboards. But real data excellence comes from methodical habits that build trust and deliver real insights. Here are 20 signs of a truly effective analyst 👇 ✅ They document every step of their analysis ➝ Clear notes make their work reproducible and trustworthy. ✅ They check data quality before the analysis begins ➝ Garbage in = garbage out. Always validate first. ✅ They use version control religiously ➝ Every code change is tracked. Nothing gets lost. ✅ They explore data thoroughly before diving in ➝ Understanding context prevents costly misinterpretations. ✅ They create automated scripts for repetitive tasks ➝ Efficiency isn’t a luxury—it’s a necessity. ✅ They maintain a reusable code library ➝ Smart analysts never solve the same problem twice. ✅ They test assumptions with multiple validation methods ➝ One test isn’t enough; they triangulate confidence. ✅ They organize project files logically ➝ Their work is navigable by anyone, not just themselves. ✅ They seek peer reviews on critical work ➝ Fresh eyes catch blind spots. ✅ They continuously absorb industry knowledge ➝ Learning never stops. Trends change too quickly. ✅ They prioritize business-impacting projects ➝ Every analysis must drive real decisions. ✅ They explain complex findings simply ➝ Technical brilliance is useless without clarity. ✅ They write readable, well-commented code ➝ Their work is accessible to others, long after they're gone. ✅ They maintain robust backup systems ➝ Data loss is never an option. ✅ They learn from analytical mistakes ➝ Errors become stepping stones, not roadblocks. ✅ They build strong stakeholder relationships ➝ Data is only valuable when people use it. ✅ They break complex projects into manageable chunks ➝ Progress happens through disciplined, incremental work. ✅ They handle sensitive data with proper security ➝ Compliance isn’t optional—it’s foundational. ✅ They create visualizations that tell clear stories ➝ A chart without a narrative is just decoration. ✅ They actively seek evidence against their conclusions ➝ Confirmation bias is their biggest enemy. The best analysts aren’t the ones with the most tools—they’re the ones with the most rigorous practices. Which of these habits could transform your data work today? 🚀 Join biggest telegram channel to master data analytics: https://t.me/sqlspecialist

Here's a formatted version of the commonly used DAX functions: DATE AND TIME FUNCTIONS: - CALENDAR - DATEDIFF - TODAY, DAY, MONTH, QUARTER, YEAR AGGREGATE FUNCTIONS: - SUM, SUMX, PRODUCT - AVERAGE - MIN, MAX - COUNT - COUNTROWS - COUNTBLANK - DISTINCTCOUNT FILTER FUNCTIONS: - CALCULATE - FILTER - ALL, ALLEXCEPT, ALLSELECTED, REMOVEFILTERS - SELECTEDVALUE TIME INTELLIGENCE FUNCTIONS: - DATESBETWEEN - DATESMTD, DATESQTD, DATESYTD - SAMEPERIODLASTYEAR - PARALLELPERIOD - TOTALMTD, TOTALQTD, TOTALYTD TEXT FUNCTIONS: - CONCATENATE - FORMAT - LEN, LEFT, RIGHT INFORMATION FUNCTIONS: - HASONEVALUE, HASONEFILTER - ISBLANK, ISERROR, ISEMPTY - CONTAINS LOGICAL FUNCTIONS: - AND, OR, IF, NOT - TRUE, FALSE - SWITCH RELATIONSHIP FUNCTIONS: - RELATED - USERRELATIONSHIP - RELATEDTABLE Remember, DAX is more about logic than the formulas.

🔥𝗙𝗿𝗲𝗲 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 – 𝗘𝗻𝗿𝗼𝗹𝗹 𝗕𝗲𝗳𝗼𝗿𝗲 𝗜𝘁 𝗘𝗻𝗱𝘀! Get certified in data analytics with expert-designed modules, live projects, and placement assistance. ✅ 100% Free | 💼 Career-Boosting | 🕒 Limited Seats 𝐋𝐢𝐧𝐤 👇:-    https://pdlink.in/4lp7hXQ   Enroll For FREE & Get Certified 🎓

SQL Zero to Hero ✅

SQL Joins Simplified ✅

𝟯 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗦𝘁𝗮𝗿𝘁 𝗬𝗼𝘂𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗮𝗿𝗲𝗲𝗿 𝗶𝗻 𝟮𝟬𝟮𝟱!😍 Want to break into Data Analytics but don’t know where to start? 🤔 These 3 beginner-friendly and 100% FREE courses will help you build real skills — no degree required!👨‍🎓 𝗟𝗶𝗻𝗸:-👇 https://pdlink.in/3IohnJO No confusion, no fluff — just pure value✅️

9 tips to get started with Data Analysis: Learn Excel, SQL, and a programming language (Python or R) Understand basic statistics and probability Practice with real-world datasets (Kaggle, Data.gov) Clean and preprocess data effectively Visualize data using charts and graphs Ask the right questions before diving into data Use libraries like Pandas, NumPy, and Matplotlib Focus on storytelling with data insights Build small projects to apply what you learn Data Science & Machine Learning Resources: https://whatsapp.com/channel/0029Va8v3eo1NCrQfGMseL2D ENJOY LEARNING 👍👍

𝗕𝗲𝗰𝗼𝗺𝗲 𝗮 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗲𝗱 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝘁𝗶𝘀𝘁 𝗜𝗻 𝗧𝗼𝗽 𝗠𝗡𝗖𝘀😍 Learn Data Analytics, Data Science & AI From Top Data Experts  Curriculum designed and taught by Alumni from IITs & Leading Tech Companies. 𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝗲𝘀:-  - 12.65 Lakhs Highest Salary - 500+ Partner Companies - 100% Job Assistance - 5.7 LPA Average Salary 𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗻𝘀𝗲𝗹𝗹𝗶𝗻𝗴 𝗦𝗲𝘀𝘀𝗶𝗼𝗻👇 : https://bit.ly/4g3kyT6 (Hurry Up🏃‍♂️. Limited Slots )

🚀 Excel vs SQL vs Python (Pandas): 1️⃣ Filtering Data ↳ Excel: =FILTER(A2:D100, B2:B100>50) (Excel 365 users) ↳ SQL: SELECT * FROM table WHERE column > 50; ↳ Python: df_filtered = df[df['column'] > 50] 2️⃣ Sorting Data ↳ Excel: Data → Sort (or =SORT(A2:A100, 1, TRUE)) ↳ SQL: SELECT * FROM table ORDER BY column ASC; ↳ Python: df_sorted = df.sort_values(by="column") 3️⃣ Counting Rows ↳ Excel: =COUNTA(A:A) ↳ SQL: SELECT COUNT(*) FROM table; ↳ Python: row_count = len(df) 4️⃣ Removing Duplicates ↳ Excel: Data → Remove Duplicates ↳ SQL: SELECT DISTINCT * FROM table; ↳ Python: df_unique = df.drop_duplicates() 5️⃣ Joining Tables ↳ Excel: Power Query → Merge Queries (or VLOOKUP/XLOOKUP) ↳ SQL: SELECT * FROM table1 JOIN table2 ON table1.id = table2.id; ↳ Python: df_merged = pd.merge(df1, df2, on="id") 6️⃣ Ranking Data ↳ Excel: =RANK.EQ(A2, $A$2:$A$100) ↳ SQL: SELECT column, RANK() OVER (ORDER BY column DESC) AS rank FROM table; ↳ Python: df["rank"] = df["column"].rank(method="min", ascending=False) 7️⃣ Moving Average Calculation ↳ Excel: =AVERAGE(B2:B4) (manually for rolling window) ↳ SQL: SELECT date, AVG(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS moving_avg FROM table; ↳ Python: df["moving_avg"] = df["value"].rolling(window=3).mean() 8️⃣ Running Total ↳ Excel: =SUM($B$2:B2) (drag down) ↳ SQL: SELECT date, SUM(value) OVER (ORDER BY date) AS running_total FROM table; ↳ Python: df["running_total"] = df["value"].cumsum()