Discover the Azure SQL Database Hyperscale Service Tier

If your existing Azure SQL Database service tier doesn’t meet your performance or scalability needs, you’ll be excited to learn about the newly introduced Hyperscale service tier. Hyperscale is a next-generation service tier designed to provide exceptional storage and compute scalability for Azure SQL Database, surpassing the limits of traditional General Purpose and Business Critical… Read More

Key Insights About Azure Managed Instance You Should Know

Over the coming days, I’ll be sharing valuable insights on various Azure services. Today, let’s dive into Azure Managed Instance, which became generally available in fall 2018. Although there’s a lot to explore with Managed Instances, here are three crucial points every user should understand: Advanced Security Capabilities of Azure Managed Instance Azure Managed Instance… Read More

Comprehensive Guide to Azure Data Studio

Are you familiar with Azure Data Studio? This versatile, cross-platform database management tool is designed for data professionals who handle data analysis and ETL processes. While it shares similarities with SQL Server Management Studio (SSMS), Azure Data Studio offers enhanced capabilities tailored specifically for data engineering tasks. Navigating the Azure Data Studio Environment When you… Read More

Introduction to Azure Data Factory Data Flow

I’m excited to share that Azure Data Factory (ADF) Data Flow is now available in public preview. This powerful new feature enables users to design graphical data transformation workflows that can be executed as part of ADF pipelines, offering a no-code approach to complex data processing. Understanding Azure Data Factory Data Flow: A Comprehensive Guide… Read More

Introduction to Power BI Small Multiples Visual Preview

In the February 2021 update of Power BI Desktop, Microsoft introduced an exciting preview feature called Small Multiples. As of the May 2021 release, users need to enable this feature within the Preview Features settings to start using it. Understanding the Concept and Benefits of Small Multiples in Power BI Small multiples in Power BI… Read More

How to Integrate Bing Maps with Power Apps for Dynamic GPS Functionality

Have you ever considered adding GPS capabilities to your Power Apps? In this guide, I’ll walk you through creating a Power Apps application that incorporates Bing Maps, enabling your users to interact with a dynamic, location-aware mapping system powered by GPS. Leveraging Maps to Revolutionize Salesforce Account Management In today’s data-driven sales environment, effectively managing… Read More

Improving Accessibility in Power BI Using Universal Design Principles

In the latest episode of Universal Design in Power BI YouTube series, Greg Trzeciak delivers an in-depth guide on enhancing Power BI report visuals to better serve diverse audiences, including users with accessibility challenges. This blog post highlights key takeaways from Greg’s presentation, focusing on effective use of lines and markers to create more inclusive… Read More

Introduction to Azure Stream Analytics

In today’s data-driven world, analytics plays a crucial role in transforming raw data into actionable insights that support informed decision-making. Azure Stream Analytics is a powerful, real-time event processing service designed to analyze and process vast volumes of streaming data from various sources such as devices, websites, and social media platforms. Understanding the Power of… Read More

Using Power BI Dataflows for ETL Processes

Power BI continues to evolve, offering powerful features to manage and transform data. One such feature currently in preview is Power BI Dataflows, which enables you to use Power BI as a robust ETL (Extract, Transform, Load) tool. In this article, we’ll explore how Dataflows transform Power BI from a reporting tool into a flexible… Read More

Unlocking ETL Capabilities with Power BI Dataflows

Power BI, Microsoft’s powerful business analytics platform, enables users to visualize data, share insights across organizations, and embed reports into apps or websites. With connectivity to hundreds of data sources, Power BI transforms raw data into live, interactive dashboards and reports. But have you ever wondered if Power BI can function as an ETL (Extract,… Read More

Mastering Azure Data Factory Lookup Activity: A Step-by-Step Guide

Mitchell Pearson dives into the powerful Lookup activity within Azure Data Factory (ADF), explaining how it can be effectively utilized in data pipelines. This post is part of a series focusing on key ADF activities such as Lookup, If Condition, and Copy, designed to build dynamic and efficient ETL workflows. Mastering Conditional Pipeline Execution with… Read More

Discover the Most Exciting Features in SQL Server 2016

John Welch shares insights on the highly anticipated SQL Server 2016 release, highlighting the powerful new features set to enhance data management, analytics, and business intelligence workflows. As SQL Server 2016 approaches its launch, it is actively updating its product lineup to ensure full compatibility with the latest innovations. Significant Innovations in SQL Server 2016… Read More

Unlocking Creativity with Free Templates in Word, Excel, and PowerPoint Using Microsoft Create

Allison Gonzalez, a Microsoft Certified Trainer, introduces Microsoft Create—a powerful new tool designed to help professionals effortlessly kickstart their projects with beautifully designed templates and AI-enhanced features. Whether you’re creating reports, presentations, or social media content, Microsoft Create simplifies the design process and boosts productivity. Related Exams: Microsoft MB6-889 Microsoft Dynamics AX 2012 Service Management… Read More

Mastering Power BI Custom Visuals: The Bowtie Chart Explained

Devin Knight walks you through the powerful Bowtie Chart custom visual in Power BI. This unique visual is perfect for illustrating data flow between categories or processes, making it easier to understand transitions and relationships within your dataset. The Bowtie Chart visual in Power BI is a fascinating tool for visualizing transitions and distribution of… Read More

Exploring Power BI Custom Visuals: The Image Timeline

Devin Knight presents a comprehensive guide on leveraging the Image Timeline custom visual in Power BI. This visual is ideal for showcasing data points sequentially along a timeline, enhanced with the ability to display images corresponding to each data event, making your reports visually engaging and informative. Understanding the Image Timeline Custom Visual in Power… Read More