Edvaldo Guimrães Filho
-
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
-
Building Calculated Tables in DAX: Best Practices and Practical Examples
Building Calculated Tables in DAX: Best Practices and Practical Examples In Data Analysis Expressions (DAX), calculated tables are a powerful tool that allows you to create new tables in your data model based on existing data. They can enhance your… Continue reading
-
Advanced DAX Measures: Best Practices and Practical Examples
Data Analysis Expressions (DAX) is not only powerful but also complex. Understanding the best practices for creating DAX measures can significantly enhance your data modeling and reporting efficiency in tools like Power BI, Excel, and SQL Server Analysis Services. In… Continue reading
-
Understanding DAX Measures: A Comprehensive Guide
Data Analysis Expressions (DAX) is a powerful formula language used in Microsoft Power BI, Excel, and SQL Server Analysis Services. DAX allows users to create custom calculations and aggregations on their data, enabling deeper insights and advanced analytics. In this… Continue reading
-
DAX Measures: 20 Practical Examples
DAX (Data Analysis Expressions) is a powerful formula language used in Power BI, Excel, and SQL Server Analysis Services. It allows users to create custom calculations and aggregations in their data models. In this article, we will explore 20 practical… Continue reading
-
DAX for Beginners: Understanding Programming Concepts in DAX – Part 1
Introduction DAX (Data Analysis Expressions) is a powerful programming language used in Power BI, Excel, and SQL Server Analysis Services. It facilitates advanced calculations and analytics on your data. This is the first part of a 10-article series that will… Continue reading
-
DAX for Beginners: 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 facilitates advanced calculations and analytics on your data. This is the first part of a 10-article series that will cover… Continue reading
-
Article 1: Introduction to DAX in Power BI
Article 1: Introduction to DAX in Power BI Welcome to the first article in our series on DAX (Data Analysis Expressions) for Power BI! In this series, we will explore DAX step by step, starting with the basics and gradually… 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
-
Registering and Managing Azure AD Applications with PnP PowerShell
Integrating with Azure Active Directory (Azure AD) is essential for building modern enterprise solutions. By registering applications in Azure AD, you enable them to authenticate and gain access to secure APIs like Microsoft Graph. This blog post will guide you… Continue reading
-
Visualizing World Bank Data: SPFx with React and Python with Matplotlib
Here’s an article structure with two sections: one focusing on creating a SharePoint Framework (SPFx) chart with React and Recharts, and the other demonstrating how to visualize World Bank data using Python and Matplotlib. Continue reading
-
Accessing Economic Data Using Python and the World Bank API with wbdata
Analyzing economic data is critical for a range of applications, from governmental policy-making to financial forecasting and academic research. The World Bank API provides a rich dataset, offering access to thousands of economic indicators from over 200 countries. In this… Continue reading
-
Como Obter Dados Econômicos Usando Python e a API do Banco Mundial com wbdata
No mundo moderno, a análise de dados econômicos desempenha um papel crucial na tomada de decisões empresariais e políticas. O Banco Mundial oferece uma API poderosa para acessar diversos indicadores econômicos, como o Produto Interno Bruto (PIB), inflação, taxas de… Continue reading
-
Managing Custom Scripts in SharePoint: A Comprehensive Guide
Custom scripts in SharePoint allow users to enhance the functionality and appearance of their sites by adding custom JavaScript, CSS, and HTML. This capability can significantly improve user experience by enabling developers to create tailored solutions, integrate third-party applications, and… Continue reading
-
Understanding SharePoint Hub Sites: Features, Creation, Management, and Advanced Customization
SharePoint Hub Sites are a powerful feature in SharePoint Online that allow organizations to connect various sites for improved navigation and content organization. Hub Sites create a unified experience for users, making it easier to discover and share information across… Continue reading
-
O que é um SharePoint Hub Site?
Um Hub Site oferece uma barra de navegação consistente que é aplicada a todos os sites associados. Isso significa que, independentemente do site em que um usuário esteja, a navegação permanece a mesma, facilitando a descoberta de informações. A navegação… Continue reading
-
Introduction to SharePoint Online Management Shell: .NET Framework and .NET Core Versions with Troubleshooting (Telerik Fiddler/AADSTS700016)
The SharePoint Online Management Shell is a powerful tool for managing SharePoint Online environments, offering a wide range of cmdlets for administrators to automate tasks. This article covers the installation and usage of the SharePoint Online Management Shell, including both… Continue reading
-
Comprehensive Guide to SharePoint Online Management Shell: .NET Framework and .NET Core Versions with Troubleshooting Tips
The SharePoint Online Management Shell is a powerful command-line tool that simplifies the management of SharePoint Online environments. Designed for administrators and developers, this shell allows you to perform various administrative tasks such as managing site collections, users, permissions, and… Continue reading
-
SharePoint Online Management Shell with .NET Framework: Installation and Usage
SharePoint Online Management Shell with .NET Framework: Installation and Usage The SharePoint Online Management Shell is a powerful tool for managing SharePoint Online environments. It allows administrators to perform automated tasks using PowerShell cmdlets that simplify managing the environment. This… Continue reading
-
Introduction to SharePoint Online Management Shell (.NET Framework and .NET Core Versions)
Introduction to SharePoint Online Management Shell (.NET Framework and .NET Core Versions) The SharePoint Online Management Shell is a command-line tool that provides a set of PowerShell cmdlets for managing SharePoint Online environments. With two distinct versions, one built on… Continue reading
-
Introduction to SharePoint Online Management Shell (V2)
The SharePoint Online Management Shell is an essential tool for administrators managing SharePoint Online environments. Based on Windows PowerShell, it offers a robust set of cmdlets that allow the execution of various administrative tasks directly from the command line. This… Continue reading
-
Introduction to SharePoint Online Management Shell (.NET Core Version)
The SharePoint Online Management Shell with .NET Core provides a modern, cross-platform experience for administrators who need to manage SharePoint Online environments. By leveraging the power of PowerShell Core and .NET Core, this version can be installed and run on… Continue reading
-
Introduction to SharePoint Online Management Shell (.NET Framework Version)
The SharePoint Online Management Shell is a powerful command-line tool specifically designed for managing SharePoint Online environments. It allows administrators to automate tasks, configure settings, and manage SharePoint Online sites and users via PowerShell cmdlets. This version of the SharePoint… Continue reading
-
Introduction to Recharts and How to Use It with SPFx
In modern web development, visualizing data with interactive charts has become essential. Whether you are building dashboards, reports, or analytics platforms, having easy-to-use charting libraries makes a difference. Recharts is a simple, responsive charting library built on React and D3,… Continue reading
-
Creating a D3.js Bar Chart in SPFx Web Part (Dynamic)
In this article, we’ll learn how to create a bar chart using D3.js within a SharePoint Framework (SPFx) web part. D3.js is a powerful library for visualizing data using web standards. We’ll fetch data from a SharePoint list and render… Continue reading
-
Introduction to D3.js and Building a Bar Chart in SPFx
D3.js, or Data-Driven Documents, is a powerful JavaScript library for producing dynamic, interactive data visualizations in web browsers. It utilizes HTML, SVG (Scalable Vector Graphics), and CSS to bring data to life. D3 is particularly known for its ability to… Continue reading
-
Using Chart.js in a SharePoint Framework (SPFx) Web Part with PnPjs – All codes and Graphs
In this tutorial, we’ll demonstrate how to integrate Chart.js into a SharePoint Framework (SPFx) web part using PnPjs to fetch data from SharePoint lists. Chart.js is a popular JavaScript library for creating beautiful and interactive charts, and we’ll show how… Continue reading
-
Using Chart.js in a SharePoint Framework (SPFx) Web Part with PnPjs
In this tutorial, we’ll demonstrate how to integrate Chart.js into a SharePoint Framework (SPFx) web part using PnPjs to fetch data from SharePoint lists. Chart.js is a popular JavaScript library for creating beautiful and interactive charts, and we’ll show how… Continue reading
-
Visualizing SharePoint List Data with Recharts in SPFx
Visualizing data is a crucial part of data analysis and reporting. In the SharePoint ecosystem, many organizations store their data in SharePoint lists. This article will guide you through the process of retrieving data from a SharePoint list and visualizing… Continue reading
-
Transitioning from Fluent UI 8 to Fluent UI 9: Understanding the Removal of Graphs and Exploring Alternatives
Fluent UI, developed by Microsoft, serves as a robust design framework that helps developers create user interfaces for web applications, particularly in the Microsoft ecosystem. With the recent release of Fluent UI 9, a key question arises: What happens to… Continue reading
-
Complete CRUD Example in SPFx Using React and PnPjs
This article will guide you through creating a complete CRUD (Create, Read, Update, Delete) application in SharePoint Framework (SPFx) using React and PnPjs. We’ll build a simple component that allows users to add, view, and delete items from a SharePoint… Continue reading





























