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
MO-200 Microsoft Excel Certification: Preview of the Ultimate Prep Course
In today’s data-driven world, mastering Microsoft Excel is essential for professionals across industries. To meet this growing demand, Launched a comprehensive training course designed specifically to prepare learners for the MO-200 Microsoft Office Specialist Excel 2019 certification exam. Yasmine Brooks, an expert trainer, introduces this expertly crafted program aimed at helping students gain the skills… Read More
Power BI Custom Visuals Explained: Using the Mekko Chart
In this tutorial, you will discover how to effectively use the Mekko Chart, a powerful custom visual available in Power BI. The Mekko Chart is ideal for comparing two distinct dimensions within a single, intuitive chart. The Mekko Chart, also known as a Marimekko chart, is an advanced and visually compelling data visualization tool available… Read More
Understanding Direct Query Constraints in Power BI
Are you encountering challenges with Direct Query in Power BI due to its inherent limitations? In this post, I’ll share some practical tips to help you overcome these common obstacles and enhance your data reporting experience using Direct Query mode. Power BI’s Direct Query mode provides the advantage of real-time data access without the need… Read More
Moving from Traditional Data Architectures to Azure-Based Solutions
In this article, I’ll explore the shift from classic Microsoft data tools like SSIS, SSAS, and SSRS to the modern Azure data ecosystem. If you’re transitioning from on-premises SQL Server environments to Azure’s cloud-native services, this guide will serve as a valuable roadmap. In today’s rapidly evolving data landscape, organizations are increasingly considering the shift… Read More
How to Perform Data Merging Using Change Data Capture in Databricks
In this post from our Azure Every Day Databricks mini-series, we explore how to effectively use Change Data Capture (CDC) in Databricks. CDC is widely used to track and merge changes from multiple data sources into Databricks Delta tables. This process helps you seamlessly handle inserts, updates, and deletes in your data pipeline. In modern… Read More