Prepare for the Power BI 70-778 Certification with Training
I recently completed and passed the Microsoft Power BI Certification Exam 70-778—officially titled Analyzing and Visualizing Data with Microsoft Power BI. This was my first time taking the exam via online proctoring. While many have shared mixed reviews about this testing method, my experience was smooth and positive. Having completed the exam myself, I want… Read More
Mastering Power BI Custom Visuals: Data Image by CloudScope
In this tutorial, you will discover how to effectively use the Data Image custom visual for Power BI, developed by CloudScope. This powerful visual allows you to display images dynamically based on image URLs stored within your dataset, enhancing your reports with visual context. Comprehensive Guide to Using Data Image by CloudScope in Power BI… Read More
Unlocking the True Potential of Big Data for Actionable Insights
In today’s data-driven world, gaining deep insights and making informed decisions has become essential at every level of an organization—from the executive boardroom to marketing teams and even on the production floor. The promise of Big Data technologies is to deliver these valuable insights. While the hype around Big Data is undeniable, its true power… Read More
Understanding Slowly Changing Dimensions in Data Modeling
Data modeling remains a fundamental practice, especially in today’s era of big data. It focuses on identifying what data is necessary and organizing it effectively. One crucial concept in data modeling is managing Slowly Changing Dimensions (SCDs), which play a vital role in maintaining accurate and insightful data over time. Understanding Slowly Changing Dimensions in… Read More
Exploring Power BI Custom Visuals: The Pie Chart Tree
In this training module, you’ll discover how to leverage the Pie Chart Tree custom visual in Power BI. This innovative visual combines the functionality of an expandable decomposition tree with pie chart segments, allowing you to analyze your data hierarchically while simultaneously visualizing the proportionate values within each category. Introducing the Pie Chart Tree Visual… Read More
Understanding the Absence of SQL Server Agent in Azure SQL Database
SQL Server Agent, a key component for managing scheduled jobs and alerts in traditional SQL Server environments, is not available in Azure SQL Database. So, how can you effectively manage tasks that typically rely on SQL Server Agent in the Azure cloud? In a recent free webinar, Senior Business Intelligence Consultant Bob Rubocki explained why… Read More
How to Integrate Microsoft Translation Services into Power Apps
Do you want to overcome language barriers and improve communication with your customers? In this guide, I’ll show you how to seamlessly incorporate Microsoft Translation Services into your Power Apps application. This integration allows you to translate emails, text inputs, and more, enhancing user experience across multiple languages. Enhancing Your Power Apps with Dynamic Translation… Read More
Why Cosmos DB Is the Fastest Growing Service on Azure
Cosmos DB has quickly become one of the fastest expanding services within the Microsoft Azure ecosystem. Many organizations wonder: if they already use SQL Server, Azure SQL Database, or Azure Data Warehouse, should they consider adding Cosmos DB to their data strategy? Let’s explore why Cosmos DB might be the perfect fit for your needs.… Read More
How to Build a Simple Report Using Power Query and Power View in Excel
In this step-by-step guide, you’ll learn how to import data into Excel with Power Query and create a straightforward report using Power View. While these tools offer advanced capabilities, this tutorial focuses on the basics: creating a report that displays sales figures by country over multiple years. Initiating Data Importation Using Power Query in Excel… Read More
Real-World Use Case: eBay Price Monitoring with SSIS
Let’s say you’re a small business owner listing products on platforms like eBay. You want to regularly monitor competitors’ pricing to stay competitive. Instead of checking manually every day, you can build an ETL solution that does the work for you. Here’s how it works in this example: The process starts in Visual Studio, using… Read More