Choosing Between SSAS Multidimensional and Tabular: An Introduction
Are you currently involved in a project where you need to decide which version of SQL Server Analysis Services (SSAS) — Multidimensional or Tabular — to use? During a recent presentation on SSAS Multidimensional best practices, an insightful question was raised: “How do I decide between SSAS Tabular and SSAS Multidimensional?” This sparked a deeper… Read More
Exploring SQL Server 2016 Security Features: Dynamic Data Masking and Always Encrypted
SQL Server 2016 introduced powerful security features designed to protect sensitive data — Dynamic Data Masking (DDM) and Always Encrypted. These technologies help organizations safeguard information by limiting data exposure and encrypting data both at rest and in transit. Dynamic Data Masking (DDM) is an advanced data protection mechanism designed to enhance security by selectively… Read More
Unlocking Paginated Reports: Connecting Lakehouse Tables in Power BI Report Builder
Austin Libal, a veteran trainer specializing in Microsoft Fabric and Power BI, recently showcased two effective methods to connect to Lakehouse tables using Power BI Report Builder. This powerful tool is essential for creating paginated reports that offer pixel-perfect formatting, ideal for printing or exporting to PDF with precise control. Connecting reports to a central… Read More
Unlocking Power BI’s Modern Visual Tooltips: A Game-Changing Feature for Drill Through and Drill Down
If you haven’t yet explored the modern visual tooltip preview feature in Power BI, now is the perfect time to start. This innovative functionality significantly enhances user experience by making drill through and drill down capabilities more intuitive and accessible within your reports. In the evolving landscape of data analytics, user interface innovation plays a… Read More
Power BI Text Search Slicer: Problem, Approach, and Solution Explained
In this edition of the “Problem, Approach, Solution” series, we’ll explore how to implement text search functionality using slicers in Power BI, mimicking a SQL “LIKE” search. For a detailed walkthrough, there is a video tutorial linked at the end under “Resources.” Addressing the Limitations of Default Slicer Functionality in Power BI Power BI is… Read More
Introduction to Azure Databricks: A Beginner’s Guide
Azure Databricks is making waves in the data and analytics space. Whether you’re new to it or looking to refresh your understanding, this beginner’s guide walks you through what Azure Databricks is, how it works, and how leading enterprises are transforming their operations with it. Azure Databricks is a transformative cloud-based Platform as a Service… Read More
Understanding Azure SQL Database Reserved Capacity for Cost Savings
Last week, I discussed the Azure Reserved VM Instances and how they help save money. Similarly, Azure offers SQL Database Reserved Capacity, a powerful option to reduce your cloud expenses by up to 33% compared to the license-included pricing model. This savings comes by pre-purchasing SQL Database v-cores for either a 1-year or 3-year commitment.… Read More
Exploring Visual Calculations in Power BI: A New Era of Data Analysis
In a recent video released on the YouTube channel, Senior Trainer Mitchell Pearson unveils the innovative visual calculations feature in Power BI, designed to simplify complex data analysis by minimizing the need for advanced DAX formulas. Unlocking the Power of Visual Calculations in Power BI Power BI has long been a frontrunner in business intelligence… Read More
How to Send Emails and Format Dates Using Power Apps and Power Automate
Power Apps provides an excellent platform for users to create new records and submit them to various data sources. A common question that arises after mastering record creation is: “Can I automate sending or receiving emails after a record is created?” The answer is a definite yes. In the contemporary digital workspace, automating communication processes… Read More
Exploring Image Recognition with Azure Computer Vision API
In this article, we dive into the powerful features of the Azure Computer Vision API and explore how it can transform your approach to image analysis and recognition. In the age of artificial intelligence and intelligent automation, image analysis has moved far beyond simple pattern recognition. Microsoft’s Azure Computer Vision API stands at the forefront… Read More