Edvaldo Guimrães Filho
-
Carregando Dados de PIB de Países em um Banco de Dados SQL com C#
Neste artigo, abordaremos como carregar dados do PIB (Produto Interno Bruto) de vários países em um banco de dados SQL utilizando C#. O objetivo é criar um aplicativo que se conecte a uma API do Banco Mundial, recupere os dados… Continue reading
-
The AMP Lab: A Catalyst for Innovation
The AMP Lab: A Catalyst for Innovation What is AMP Lab? The AMP Lab (Algorithms, Machines, and People Laboratory) is a research laboratory at the University of California, Berkeley, established in 2010. The lab focuses on advancing research in computer science, particularly… Continue reading
-
Apache Spark and the AMP Lab
Apache Spark is a powerful open-source data processing engine designed for big data analytics. Known for its speed and versatility, Spark has transformed how organizations handle large datasets. This article will explore the technical details of Apache Spark, its historical… Continue reading
-
Introduction to SQL Joins
Structured Query Language (SQL) is a powerful tool used for managing and manipulating relational databases. One of the key features of SQL is its ability to combine data from multiple tables through the use of joins. Joins allow users to… Continue reading
-
Understanding OLAP (Online Analytical Processing)
Online Analytical Processing (OLAP) is a category of database technology that allows users to perform complex analyses on large volumes of data efficiently. OLAP systems are structured to support multidimensional queries and are optimized for fast data retrieval, enabling businesses… Continue reading
-
Microsoft SQL Server Family Overview
The Microsoft SQL Server family is a suite of database products designed to provide end-to-end solutions for data management, analytics, and business intelligence (BI). It includes multiple components that handle a range of functions, from database storage to complex data… Continue reading
-
Microsoft Fabric: The All-in-One Data and Analytics Solution
In today’s data-driven landscape, companies need robust, scalable, and integrated platforms to manage data workflows and generate actionable insights efficiently. Microsoft Fabric, launched in 2023, aims to fill this role by consolidating data storage, transformation, visualization, and analytics under a… Continue reading
-
Understanding SQL Joins: Examples with Country GDP Data
In SQL, JOIN clauses allow you to combine records from two or more tables based on a related column. In this article, we’ll create tables for years and GDP (Gross Domestic Product) data for three countries (Brazil, the United States,… Continue reading
-
Azure DevOpsAligned with Agile and Scrum
In Agile and Scrum frameworks, work items in Azure DevOps provide structure to organize and prioritize work according to Agile principles, ensuring each sprint delivers incremental value. This article explores work item types, their role within the Agile and Scrum… Continue reading
-
Work Items in Azure DevOps
In Azure DevOps, work items are crucial for planning, tracking, and managing software development tasks—from high-level goals to actionable tasks. Each work item type serves a specific purpose in organizing work within a team, making it easier to break down… Continue reading
-
Adapting a PowerShell SharePoint Script to .NET Framework C# Using SQL Databases
In this article, we will take a PowerShell script initially designed to create and manage SharePoint Online lists and adapt it for .NET Framework C# to interact with SQL Server databases instead of SharePoint lists. This scenario assumes you want… Continue reading
-
Automating SharePoint Lists for Global GDP Data: Power BI & Power Apps Integration
In this article, we’ll walk through a PowerShell script that automates the creation of SharePoint lists populated with GDP (Gross Domestic Product) data for various countries, sourced directly from the World Bank API. This solution is ideal for integrating real-time… Continue reading
-
Automating SharePoint List Creation and Data Population with PnP PowerShell
Automating SharePoint List Creation and Data Population with PnP PowerShell In this article, we will walk through a PowerShell script that connects to SharePoint Online using the PnP PowerShell module and automates the creation of SharePoint lists. The script dynamically… Continue reading
-
Creating Summary Measures in Power BI for Date Columns: Counting Rows by Year
One common requirement when working with data is summarizing information based on date columns. For example, you might need to count how many rows were created in each year to understand data trends over time. This article will guide you… Continue reading
-
Complete Guide to DAX Functions in Power BI
Data Analysis Expressions (DAX) is a powerful language in Power BI, designed to perform complex calculations, filter data, and create dynamic reports. Whether you’re new to DAX or looking to expand your knowledge, this guide provides 50 essential DAX functions,… Continue reading
-
50 Exemplos de Medidas DAX
50 Exemplos de Medidas DAX Continue reading
-
Silicon Valley Snake Oil: The Illusion of Silicon Valley
The term “snake oil” refers to products or promises that offer extraordinary results without scientific evidence or efficacy. This phrase originated in the 19th-century American West, where traveling salesmen marketed “snake oil” as a miraculous cure-all for various ailments. These… Continue reading
-
Understanding Storage Calculation in Azure: Differences Between SharePoint, OneDrive, and Teams
Understanding Storage Calculation in Azure: Differences Between SharePoint, OneDrive, and Teams In the Microsoft 365 ecosystem, SharePoint Online, OneDrive for Business, and Microsoft Teams are tightly integrated to provide seamless collaboration, file storage, and sharing functionalities. Despite their synergy, understanding… Continue reading
-
Diferenças entre SharePoint, OneDrive e Teams: Como o Armazenamento é Calculado no Azure
O ecossistema de colaboração do Microsoft 365 combina ferramentas poderosas, como SharePoint, OneDrive e Teams, que atuam em conjunto para armazenar, compartilhar e gerenciar arquivos e informações dentro das organizações. Entretanto, a integração entre essas plataformas pode causar confusão, especialmente… Continue reading
-
Comprehensive Technical Guide: Azure AD B2C
Azure AD B2C is a customer identity management solution designed for web and mobile applications. It supports a variety of identity providers (Google, Facebook, Microsoft accounts, etc.), allowing developers to secure applications using existing credentials or custom accounts. Below is… Continue reading
-
SharePoint Governance for Microsoft Teams Sites
Governance in SharePoint is essential, particularly in collaborative environments like Microsoft Teams, where sites are often created automatically. A well-structured governance plan ensures that these sites remain organized, secure, and aligned with organizational objectives. This article outlines strategies for managing… Continue reading
-
How to Publish and Obtain an Existing WDL Workflow in Visual Studio Code
How to Publish and Obtain an Existing WDL Workflow in Visual Studio Code In this section, we will focus on the process of publishing your Workflow Definition Language (WDL) workflow from Visual Studio Code to Azure Logic Apps. Additionally, we’ll… Continue reading
-
How to Generate and Use SSH Keys (id_rsa) on Windows
Secure Shell (SSH) is a protocol that provides a secure way to access remote computers. It is widely used to securely manage servers, especially through the use of SSH key pairs. This article will guide you on how to generate… Continue reading
-
A Comprehensive Comparison of Power Automate and Python with Technical Overview of Workflow Definition Language (WDL)
In this article, we will explore a detailed comparison between Power Automate and Python, focusing on key programming structures such as conditionals, loops, variables, and API calls. Additionally, we will dive deep into the Workflow Definition Language (WDL), which powers… Continue reading
-
World Bank API (WBAPI)
Comprehensive Guide to the World Bank API (WBAPI) The World Bank API (WBAPI) is a powerful tool for accessing a vast array of economic and development data. This guide provides detailed information about the API’s endpoints, examples of how to… Continue reading
-
Understanding Webhooks in Power Automate
Webhooks are a powerful and flexible way to enable real-time communication between different systems. In the context of Power Automate, webhooks allow you to trigger flows based on events that occur in external systems. This article provides a detailed technical… Continue reading
-
Introduction to Power Automate and Azure Functions
Power Automate and Azure Functions are two powerful tools from Microsoft that enable automation and serverless computing, respectively. Power Automate, formerly known as Microsoft Flow, was introduced in 2016 as part of the Microsoft Power Platform. It allows users to… Continue reading
-
Azure Functions and Power Automate Integration: A Technical Deep Div
As modern cloud platforms evolve, the need for more dynamic, scalable, and cost-efficient solutions has grown. This is where Azure Functions come into play. Azure Functions are a core component of serverless computing, a model where developers focus solely on… Continue reading
-
Introduction to Power Automate: A Comprehensive Overview
Power Automate, formerly known as Microsoft Flow, is part of the Microsoft Power Platform, which also includes Power BI, Power Apps, and Power Virtual Agents. Power Automate enables users to create automated workflows between their apps and services, connecting tools… Continue reading
-
Integrating Power Automate with AI Builder: Enhancing Workflows with Artificial Intelligence
Integrating Power Automate with AI Builder: Enhancing Workflows with Artificial Intelligence Artificial intelligence (AI) is rapidly transforming the way we automate processes, and Power Automate is at the forefront of this shift with its AI Builder capabilities. AI Builder allows… Continue reading
-
Power Automate for Beginners: Understanding Triggers, Actions, and Conditions
Power Automate is a versatile tool that allows users to automate repetitive tasks and streamline workflows without needing advanced coding knowledge. However, before diving into more complex automations, it’s essential to understand the building blocks of any flow: triggers, actions,… Continue reading
-
Power Automate and Microsoft Teams: Enhancing Collaboration with Automated Workflows
Microsoft Teams is a hub for teamwork and communication, but integrating it with Power Automate unlocks even more potential for automating repetitive tasks, boosting collaboration, and keeping your team informed. In this article, we’ll explore how to create automated workflows… Continue reading
-
Automating Approval Processes with Power Automate: A Complete Guide
Approval processes are crucial in many business workflows, from document sign-offs to leave requests. Power Automate offers a powerful, easy-to-use solution for automating these processes, ensuring tasks are approved quickly and efficiently, while providing transparency and tracking for all involved.… Continue reading
-
Power Automate and Excel: Automating Data Processing and Reporting
Power Automate and Excel: Automating Data Processing and Reporting Power Automate integrates seamlessly with Excel, allowing users to automate data entry, manipulation, and reporting tasks. This can help save time, reduce errors, and ensure consistency in data processing workflows. In… Continue reading
-
Power Automate for Approval Workflows: Streamlining Business Processes
Approval workflows are a critical part of many business processes, from document approvals to expense reports and leave requests. Power Automate enables users to automate these workflows, ensuring timely and consistent approvals. In this article, we’ll dive into how to… Continue reading
-
Power Automate for Task Automation in Microsoft Teams: Boosting Collaboration
Microsoft Teams is a hub for teamwork in Office 365, and with Power Automate, you can automate repetitive tasks to enhance collaboration. From sending notifications to creating tasks, Power Automate offers numerous possibilities for automating workflows in Teams. In this… Continue reading
-
Power Automate for Document Management: Streamlining File Organization
Power Automate for Document Management: Streamlining File Organization Managing documents efficiently is a critical aspect of many businesses. Power Automate can help streamline document management processes by automating tasks like file organization, notifications, and approval workflows. In this article, we… Continue reading
-
Creating Approval Workflows with Power Automate: Streamlining Decision-Making
Creating Approval Workflows with Power Automate: Streamlining Decision-Making Approval workflows are essential for managing requests and ensuring that decisions are made efficiently within organizations. Power Automate allows you to create automated approval workflows, streamlining the process and making it easier… Continue reading
-
Automating Notifications with Power Automate: Stay Informed Effortlessly
Effective communication is key in any organization, and automating notifications can help keep team members informed without manual effort. Power Automate allows you to create workflows that send notifications based on specific triggers, ensuring that your team stays up-to-date with… Continue reading
-
Power Automate for Data Collection: Automate Surveys and Forms
Power Automate for Data Collection: Automate Surveys and Forms Power Automate for Data Collection: Automate Surveys and Forms Collecting data efficiently is crucial for businesses, and Power Automate can help streamline the process of gathering information through surveys and forms.… Continue reading
edvaldo b. guimarães filho 