transformação Digital nos Negócios
-
Building a Real-World Data Analysis Template Using the World Bank API: A Comprehensive Guide for Power BI and Analysis Services
I’ve always wanted to access an API to create a more complex tutorial, something that went beyond the basics and dealt with real-world data. Microsoft’s API examples are extensive, but I was looking for something with more tangible applications. This… Continue reading
-
Introduction: Why Access to World Bank Indicators Matters
In an increasingly interconnected and data-driven world, access to reliable global indicators has become a critical resource for businesses, governments, researchers, and policy-makers. The World Bank, a vital source of open global data, provides insight into hundreds of variables affecting… 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
-
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
-
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
-
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
-
Understanding Relationships in Power BI
Relationships in Power BI are crucial for building a cohesive data model that allows you to analyze data from different tables effectively. A relationship defines how data from one table relates to data in another, enabling you to combine and… Continue reading
-
Understanding Perspectives in Power BI
Perspectives in Power BI are a valuable feature that allows users to create simplified views of a data model. This can enhance usability and focus, enabling different users or roles within an organization to interact with only the data that… Continue reading
-
Understanding Calculation Groups in Power BI
Calculation Groups in Power BI are a powerful feature that allows you to manage complex calculations efficiently. They help streamline your data model by reducing redundancy and ensuring consistency across measures, ultimately enhancing performance and maintainability. In this article, we’ll… Continue reading
-
Understanding the Semantic Model: A Comprehensive Overview
The Semantic Model is crucial for creating intuitive data interactions within analytical systems. By structuring data in a way that aligns with user understanding, it enhances data exploration and decision-making. In this article, we’ll explore key components of the Semantic… Continue reading
-
Understanding the Power BI Semantic Model
The semantic model in Power BI is a crucial framework that underpins the platform’s capability for effective data analysis and business intelligence. It acts as an intermediary layer between the raw data stored in databases and the end-users who need… Continue reading
-
Introduction to DAX Studio: A Comprehensive Guide
DAX Studio is a powerful tool designed to work with DAX (Data Analysis Expressions) queries, primarily used in environments like Power BI, SSAS (SQL Server Analysis Services), and Excel PowerPivot. If you’re dealing with large datasets, complex calculations, and performance… Continue reading
-
Creating a Complete Power BI Model Using DAX and Query View: A Detailed Guide
In this article, we will walk through a detailed process of building a complete Power BI model using DAX (Data Analysis Expressions) in the Query View. The objective is to demonstrate how to create tables, apply DAX functions, join data,… Continue reading
-
Expanding on Model Creation: Using DAX to Create Tables within the Power BI Model
To work directly with the Model View in Power BI (often referred to as Diagram View) through the Query View (or DAX Query Editor), where you define the actual structure of your tables, measures, and relationships programmatically, you can leverage… Continue reading
-
Building a Power BI Report: From Data to Visualization
Creating a comprehensive Power BI report requires a structured approach, moving from raw data to meaningful insights that can drive business decisions. Power BI’s flexibility and power come from its ability to handle data transformations, complex calculations, and visual storytelling… Continue reading
-
Augmented Intelligence: The Synergy between Humans and Machines
In recent years, artificial intelligence (AI) has become a cornerstone of digital transformation, impacting entire industries and profoundly altering how we interact with technology. However, a new concept is emerging: augmented intelligence, which is redefining this relationship. Just as augmented… Continue reading
-
DAX for Beginners Series: Understanding Programming Concepts in DAX – Part 1
DAX (Data Analysis Expressions) is a powerful programming language used in Power BI, Excel, and SQL Server Analysis Services. It allows for advanced calculations and analytics on your data. This is the first part of a 10-article series that will… Continue reading
-
Introduction to DAX in Power BI
In this first article of our 10-part series on DAX (Data Analysis Expressions), we will explore one of the fundamental building blocks of Power BI: DAX formulas. DAX is a powerful formula language designed specifically for working with relational data,… Continue reading
-
Automating SharePoint Services with PowerShell
Managing SharePoint services in a server environment can be a complex and time-consuming task, particularly when restarting services or ensuring their availability during server boot. PowerShell provides a powerful way to automate these tasks, simplifying the management of SharePoint environments.… Continue reading
-
Embracing Flat Architecture in Modern SharePoint: A Better Way to Build
In the evolution of SharePoint, information architecture has always played a key role in how organizations structure their intranet. With the rise of modern SharePoint, there has been a significant shift in how these structures are designed. The traditional nested,… Continue reading
-
Creating a Coffee Machine Sales List in SharePoint with PowerShell
Creating lists in SharePoint to manage information is a common practice in many organizations. In this article, we will explore how to create a list called “Coffee Machine Sales” using PowerShell with the PnP PowerShell module. The goal is to… Continue reading
-
Creating SharePoint Lists with PowerShell PnP: A Guide to Sample Data Generation
In the realm of SharePoint development, the PowerShell PnP (Patterns and Practices) module stands out as a powerful tool for automating and managing SharePoint environments. It simplifies tasks such as creating lists, adding fields, and populating data, enabling developers to… Continue reading
-
Automating PowerPoint Creation from Excel Using C#
Automating the creation of PowerPoint presentations from Excel data can save a significant amount of time, especially when dealing with large datasets. Using C# in combination with the Microsoft Office Interop Libraries allows us to programmatically generate PowerPoint slides based… Continue reading
-
Automating Microsoft Office: Comparing VB.NET, C#, and VBA
In the realm of Microsoft Office automation, three primary programming languages are commonly used: VB.NET, C#, and VBA (Visual Basic for Applications). Each of these languages has its strengths and weaknesses, depending on the scenario. This introduction will provide a… Continue reading
-
Article: Creating a SharePoint Online List and Loading World Bank GDP Data
The World Bank API offers a wealth of global data, including key economic indicators like Gross Domestic Product (GDP), which tracks the economic performance of countries over time. Accessing this data programmatically can provide valuable insights for analysis or integration… Continue reading
edvaldo b. guimarães filho 