Microsoft 365
-
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
-
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
-
Introduction to SPFx Development with React: Listing SharePoint Items Using PnPJS
In this article, you’ll learn how to create React components within the SharePoint Framework (SPFx) using the PnPJS library to interact with SharePoint lists. We’ll walk through a simple example of building a component that displays items from a SharePoint… Continue reading
-
Mastering React Hooks in SPFx: 10 Practical Examples for Web Parts
In this article, we will explore the use of React Hooks by creating various functional components for a SharePoint Framework (SPFx) project. We’ll walk through the full code for integrating these components into the main TSX file (ControlesBasicos.tsx), ensuring everything… Continue reading
-
Building a Basic SPFx Web Part with PnP.js and React Hooks
This article will guide you through the process of creating a SharePoint Framework (SPFx) web part that retrieves items from a SharePoint list using PnP.js and React Hooks. We will cover the necessary components, configurations, and how to manage state… Continue reading
-
Building a Basic Web Part with PnPjs in SharePoint Framework (SPFx)
In this article, we will build a basic web part in SharePoint Framework (SPFx) using PnPjs to fetch and display items from a SharePoint list. We will walk through the configuration, fetching data, and rendering it in a web part… Continue reading



























