google-workspaceproject-managementapps-scriptpythongoogle-sheetsexcelgoogle-cloud-platformsqldata-engineeringguidedata-suite

• Steeve St Fleur

  How I used Google Sheets and Google Apps Script to send a WhatsApp Message.How I used Google Sheets and Google Apps Script to send a WhatsApp Message with each new entry.

  google-sheets

  apps-script
  
• Bruno Zimpel

  Project Management 101: Back to BasicsStandardizing project management practices, emphasizing flexibility and three key process components: documenting a source of truth, conducting effective update meetings, and implementing feedback loops for continuous improvement in project teams.

  project-management
  
• Max Pekarsky

  Coding 102: Writing code other people can readThat bootcamp may have taught you to write code that works. But the next level is to write code that works with other people.

  guide

  project-management
  
• Zubair Idris Aweda

  SQL Joins – LEFT Join, RIGHT Join, and INNER Join ExplainedSQL Joins – LEFT Join, RIGHT Join, and INNER Join Explained

  sql
  
• John Davidson

  Stakeholder AlignmentNavigating the maze of stakeholders to land a decision.

  project-management
  
• Kanshi Tanaike

  Benchmark: Efficiently Deleting Rows by Conditions on Google Spreadsheet using Google Apps ScriptBenchmark: Efficiently Deleting Rows by Conditions on Google Spreadsheet using Google Apps Script

  google-workspace

  google-sheets

  apps-script
  
• Yogesh Chavan

  How to Use JavaScript Promises Callbacks, Async/Await, and Promise Methods Explained

  guide
  
• Brandon Southern - AnalyticsMentor.io

  The Problem with SQL Sub-queries & Better OptionsWhile sub-queries are very helpful and aren’t inherently bad, they tend to be overused and many times a more optimal and preferable solutions exists in the form of a common table expressions (CTE) or a temporary (temp) table. By using a CTE or a temp table, your code become easier to read, more modular, reduces duplicated code (which reduces bugs), and can even increase performance.

  sql

  guide
  
• Ritesh Gupta

  Master Data Science with This Comprehensive Cheat SheetComprehensive Cheat Sheet for Data Science: Numpy, Pandas, Python, R, ML, DL, NLP, Stats, SQL, PySpark, Plotly, Seaborn, git, Excel, Tableau, and PowerBI

  sql

  python

  excel

  guide
  
• Aryan Irani

  Let Bard Answer Your Questions from Google Sheets with the PaLM API and Google Apps ScriptIn this blog we will be taking a look at how we can integrate Google Bard inside of your Google Sheets using the PaLM API and Google Apps Script. We will be using a custom function to call the PaLM API and pass a prompt and get back a response.

  google-workspace

  google-sheets

  apps-script
  
• Varun Joshi

  Automating Google Forms & Sheets using Apps ScriptSending emails or update spreadsheets based on triggers.

  google-sheets

  apps-script
  
• Sam Corcos

  Here are all the Git commands I used last week, and what they do.Like most newbies, I started out searching StackOverflow for Git commands, then copy-pasting answers, without really understanding what they did.

  guide
  
• Seattle Data Guy

  How To Set Up Your Data Analytics Team For Success – Centralized vs Decentralized vs Federated Data TeamsWhile the newest tech breakthroughs grab headlines, team organization is the unsung hero. A well-structured team boosts business impact, streamlines communication, and enhances information sharing among internal data units.

  project-management

  data-engineering
  
• Maulin Tolia 🔥

  Turn Your Google Sheet Into a Web ApplicationIn this article, I will show you how you can convert your Google Sheet into a web application to capture data and populate the sheet. This is a free alternative to using tools like Zapier but will require some coding experience.

  google-workspace

  apps-script
  
• James Collerton

  A Crash Course in Google Cloud PlatformA Crash Course in Google Cloud Platform

  google-cloud-platform
  
• Jérémy Dessalines

  Create a simple Approval process via Email with Google Form and Google Apps Script (Web Apps Deployment)At the end of this article, you will know how to create a workflow app, based on a Google Form that send an email to be approved or deny including logging of who is approving or denying with Apps Script.

  apps-script

  guide
  
• Ajay Kulkarni

  Why SQL is beating NoSQL, and what this means for the future of dataAfter years of being left for dead, SQL today is making a comeback. How come? And what effect will this have on the data community?

  sql
  
• DHH

  Conceptual compression means beginners don’t need to know SQL — hallelujah!It used to be a fundamental requirement that you learned an extensive amount of SQL before you were able to start working on database-backed applications.

  sql

  guide
  
• Fareed Khan

  Python Programming in Microsoft ExcelIn this blog, we’ll dive into what Python in Excel entails, its benefits, and how you can get started on your data analysis journey.

  python

  excel
  
• Seattle Data Guy

  What Is Trino And Why Is It Great At Processing Big DataIn this article, we outline what Trino is, why people use it and some of the challenges people face when deploying it.

  sql

  data-engineering
  
• Sharon Regina

  Automating Google Sheets ReportsSimple Formulas to Reduce Mundane Manual Report Update

  google-sheets

  google-workspace
  
• Zenphi

  How to Use Google Workspace Like a Pro: Five StrategiesGoogle Workspace, formerly known as Gsuite and Google Applications, is a powerful and immensely popular software suite that is packed with productivity, business, and educational tools that help millions of people be more productive.

  google-workspace
  
• Taylor Brownlow

  Why people don’t trust your numbers and what you can do about it“Those numbers aren’t right.” This phrase is a signal that something is wrong, or likely many things are wrong. Fundamentally, this question speaks to a lack of trust. Maybe this business user doesn’t trust anything that comes from the data team because they’ve been wrong in the past. Maybe they don’t trust you because they haven’t worked with you yet. Maybe they don’t trust data at all and prefer to rely on anecdotal evidence, or maybe the numbers are actually wrong.

  project-management

  guide
  
• Luisprooc

  Top 29 SQL Query Optimization Techniques You Must Know! 🚀By the end of this article, you’ll have the tools and knowledge you need to make your database applications run faster and more efficiently than ever before.

  sql

  guide
  
• Debbie Widjaja

  How Senior Product Managers Think DifferentlyThis article isn’t about how to get promoted to senior PM, but about how to advance your thinking and become a better PM. Anyone can think like a senior PM regardless of their title — and just because one has the senior PM title, doesn’t mean they truly deserve it.

  project-management

  guide
  
• Aryan Irani

  Integrating AI in Google Sheets with Google Apps Script: How to Pass Prompts to ChatGPT and Get a ResponseIn this blog, we’ll be exploring how to bring AI to your spreadsheets using the Open AI API and Google Apps Script.

  apps-script

  google-sheets

  guide
  
• Pablo Pallocchi

  Automatically Save Email Attachments to Google Drive Using Google Apps ScriptAutomatically Save Email Attachments to Google Drive Using Google Apps Script

  apps-script

  google-workspace
  
• Peng Jing

  Presto SQL Pre-validation Rules and Optimisation TipsThe newly launched Query Pre-Validation System by Presto introduces a comprehensive approach to enhancing query efficiency and saving valuable user resources. With this groundbreaking feature in place, all queries submitted to Presto undergo meticulous validation using a set of predefined rules. If you meet the validation error, do not worry, here are the definitions and suggestions according to the each validation rule.

  data-suite

  sql
  
• Jordan Gomes

  How to Build a Successful DashboardA checklist from someone who built a few unsuccessful ones

  data-engineering
  
• Dilip Kashyap

  Integrating Google Apps Script with Google Forms: Advanced TechniquesIn this article, we will explore advanced techniques for integrating Google Apps Script with Google Forms, complete with example code, and discuss the benefits of doing so.

  google-workspace

  apps-script
  
• Owen Jones

  How to prevent scope creep when managing a project from homeWhen unexpected changes are requested during the development process, your final product may be a lot more complicated than what your spec originally called for. This phenomenon is called “scope creep.” Add a fully remote team with thin work-life boundaries on top of that, and you've got problems.

  project-management
  
• Zeeshan Ahmad

  Building a Google Chatbot for Workspace RemindersTraditional reminders were easily overlooked amidst the sea of notifications. What we needed was an engaging, interactive way to send, receive, and act on these reminders. Thus, the idea of the Google Chatbot Scheduler was born, specifically tailored for our yoga sessions.

  apps-script

  google-workspace
  
• Himalaya Bir Shrestha

  Creating a Project Updates Tracker in Excel Using VBAIn this post, I am going to share how I created a simple project updates tracker tool for myself using Visual Basic Applications (VBA) in Excel in three simple steps.

  project-management

  excel
  
• Atakan Korez

  Advanced SQL Techniques You Should KnowStructured Query Language (SQL) is a widely used tool for managing and manipulating data in databases. Basic SQL queries can be simple and easy to learn, but mastering advanced SQL techniques can take your data analysis and management skills to the next level.

  sql
  
• Maulin Tolia 🔥

  How to Call APIs Directly From Google SheetsYou can manage an entire e-commerce site using just google sheets. In this tutorial, I will show you how to do that by making HTTP requests on Google Sheets.

  apps-script

  google-workspace

  google-sheets