SSIS Most Overlooked Features – Fuzzy Lookup, Fuzzy Grouping, Profile
Learn about features to enhance your SSIS projects such as Fuzzy Lookup and Fuzzy Grouping, Data Profiling Task, and DQS Cleansing Transformation.
Amira Bedhiafi is the Data Witch extraordinaire! Armed with a keyboard that doubles as a magic wand, she wields the mystical powers of a C# MVP, conjuring code spells that bring data to life. With her sorcery in Microsoft technologies, particularly in Power BI, she became a Super User, transforming raw data into captivating visualizations that mesmerize audiences. When not brewing up data-driven magic, Amira Bedhiafi can be found exploring the realms of business intelligence, unraveling the mysteries hidden within the numbers. So buckle up and get ready for an enchanting journey into the realm of data, guided by the spellbinding expertise of the one and only Data Witch!
- MSSQLTips Awards: Rookie of the Year Contender - 2023
Getting Started with Microsoft Fabric
This article covers Microsoft Fabric, describing its use and capabilities.
Choosing Between SSIS vs ADF
In this article, we look at how you might go about choosing whether to use SSIS or ADF for your next ETL/ELT project.
Comparing Azure Analysis Services vs. Azure Synapse Analytics
Learn about the similarities and differences of Azure Analysis Services versus Azure Synapse Analytics and why you would choose one over the other.
Compare Azure Analysis Services vs SQL Server Analysis Services
This article compares Azure Analysis Services with On-Premises SQL Server Analysis Services and why you might choose one over the other.
Power BI Overlooked Features to Adopt for Dashboards
Learn about some of the overlooked but extremely useful features when building Power BI reports and dashboards.
Azure Data Factory (ADF) for Cloud Data Integration and Orchestration
Learn how Azure Data Factory provides a cloud-based data integration service that orchestrates and automates data movement and transformation.
ETL Best Practices from Traditional to Modern Processes
Learn about the evolutionary journey of ETL (Extract, Transform, Load) from traditional processes to modern cloud solutions.
Azure Analysis Services Architecture, Elements, Programming Languages
In this article, we explore the features and benefits of Azure Analysis Services, its architecture, key components, and development languages.