Effective Requirement Gathering for Power Apps Development

The very first step in creating any successful application is gathering clear and detailed requirements. In this tutorial video, Brian Knight walks you through the process of defining requirements for a Power App designed for Forgotten Parks, a conservation non-profit organization working to restore two heavily damaged parks in the Democratic Republic of Congo. These… Read More

Essential Steps for Gathering Requirements to Build a Power App

The foundation of any successful application starts with clearly gathering and understanding requirements. In this tutorial video, Brian Knight walks you through the initial phase of building a Power App tailored for Forgotten Parks, a conservation non-profit organization focused on restoring two vast parks totaling 26,000 square kilometres in the Democratic Republic of Congo. Related… Read More

How to Use Rollup Columns in Dataverse for Power Apps

In this tutorial, Matthew Peterson demonstrates how to leverage rollup columns within Dataverse for Power Apps. Rollup columns play a crucial role in aggregating data from related records, enabling users to effortlessly calculate totals, averages, minimums, or maximums across connected child records. This feature simplifies data management and reporting within Power Apps by minimizing manual… Read More

How to Use Power Apps Portals Entity Lists with Record-Level Security

Are you interested in learning how to display data from Common Data Service (CDS) entities on a Power Apps Portal? In this tutorial, I’ll walk you through how to use Entity Lists to show data on a Power Apps Portal page and implement record-level security so users only see their own data, leveraging Entity Permissions… Read More

Introduction to HDInsight Interactive Query for Big Data Analytics

Last week, we began exploring the capabilities of Azure HDInsight, and today we continue with a detailed look at HDInsight Interactive Query. This powerful feature utilizes Hive combined with LLAP (Long-Lived Analytical Processing), enabling fast and interactive querying of big data stored in cost-effective storage options such as Azure Blob Storage or Data Lake Storage.… Read More

Essential Changes Every Power Platform Administrator Should Make Immediately

Congratulations on stepping into the role of a Power Platform administrator! Managing your Power Platform environments effectively can seem complex at first. To help you get started on the right foot, here are the top five critical changes you should implement now to ensure your environments remain organized, secure, and efficient. Related Exams: Microsoft AZ-203… Read More

Mastering Notification Automation with Power Automate: A Practical Guide

In today’s fast-paced work environment, leveraging automation tools to enhance communication workflows is critical. Jonathon Silva presents an in-depth guide on using Power Automate to streamline notifications by connecting SharePoint with email and Microsoft Teams. This article summarizes Silva’s tutorial, providing professionals with actionable insights to improve their automation strategies. Related Exams: Microsoft MB-220 Microsoft… Read More

Comparing SSAS Tabular and SSAS Multidimensional: Understanding Business Logic Differences

In this detailed comparison, we continue our exploration of SSAS Tabular versus SSAS Multidimensional by focusing on how business logic is implemented and leveraged within each model type to enhance analytics and reporting. Related Exams: Microsoft MB-920 Microsoft Dynamics 365 Fundamentals Finance and Operations Apps (ERP) Practice Tests and Exam Dumps Microsoft MB2-700 Microsoft Dynamics… Read More

The Rare Phenomenon of a Full Moon on Halloween

According to The Old Farmer’s Almanac, a full moon occurring on Halloween is a rare event, happening roughly once every 19 years. When calculated using Greenwich Mean Time, this translates to about three or four times per century. And coincidentally, on October 31st, 2020 — the date I’m writing this — there was indeed a… Read More

Simple Ways to Instantly Enhance Your Power Apps Model-Driven Views

Are your PowerApps model-driven apps looking a little flat or outdated? Many developers and makers often ask: “How can I make my app views more engaging and easier to use?” In this quick tutorial, Brian Knight walks you through practical techniques to instantly upgrade the aesthetics and usability of your model-driven views — and it… Read More

How to Maintain PivotTable Column Widths After Data Refresh in Excel 2013

Welcome back to our Excel at Excel series with Steve Hughes! In this article, Steve shares a valuable tip for business intelligence users: how to keep your PivotTable column widths consistent even after refreshing the data in Excel 2013. Troubleshooting PivotTable Column Resizing Issues in Excel Dashboards When creating dynamic dashboards in Excel, especially for… Read More

Do You Really Need a Star Schema in Your Data Warehouse?

Data warehousing has been a cornerstone of business intelligence for decades, and within that world, the star schema has long held a position of near-universal recommendation. Ask most data engineers or business intelligence professionals whether you should use a star schema in your data warehouse, and the majority will say yes without much hesitation. But… Read More

How to Clean and Optimize Your Client Address Database

A company’s customer database is one of its most valuable assets. However, inaccurate or duplicate client address data can cost your business thousands of dollars annually. In a recent webinar, Software Engineer Philip de la Cal demonstrated how to effectively de-duplicate and cleanse your address data using Task Factory’s USPS Address Verification feature. The Vital… Read More

Why Data Warehouse and Business Intelligence Testing Are Crucial for Success

In today’s data-driven landscape, testing your data warehouse and Business Intelligence (BI) systems early and often is essential. Neglecting proper testing can lead to inaccurate results and sluggish system performance, which could force you to restart your BI project—wasting valuable time, resources, and money, while also risking poor business decisions and lost opportunities. Expert Perspectives… Read More

Comprehensive Guide to Exposure Data Audit for Personally Identifiable Information in SQL Server

As a Business Intelligence Architect or Developer, performing an Exposure Data Audit to identify Personally Identifiable Information (PII) within your SQL Server 2016 environment is essential. This process helps uncover potential data security risks and supports the implementation of robust, enterprise-grade security policies. Microsoft SQL Server 2016 represents a significant leap forward in database security… Read More