Accessing Excel Files Using OPENROWSET and OPENDATASOURCE in SQL Server
Learn how to access Excel files with OPENROWSET and OPENDATASOURCE in SQL Server. Streamline your data integration today!
Simplify Your Database Operations with SQL Upsert: A Comprehensive Guide for Modern Data Engineering Teams
Discover how to streamline database operations and improve data integrity with SQL upsert. Learn from our real-world case study today.
How to Add One Document (Report) Per Page
Discover our case study on streamlining your reports with the step-by-step process of adding one document per page. Improve readability and clarity!
Dynamic Date Table in Power Query(Using Different Date)
Discover how dynamic date tables in Power Query can supercharge your analytics in our case study, unlocking time-based insights.
Download Standard Source Code for APIs in Business Central
Explore our case study on simplifying API development in Business Central with easy access to standard source code downloads.
Database Deployment and Backup Strategies using DACPAC and BACPAC Files in Microsoft SQL Server
Explore our case study on optimizing database deployment and backup with DACPAC and BACPAC files in Microsoft SQL Server.
Creating a Table Using Table Constructor
Explore the power of creating tables using table constructors in our case study, simplifying data organization and management.
Lookup Table driven Dynamic Data Masking
Discover how lookup table-driven dynamic data masking fortified data security in our latest case study, bolstering privacy and compliance.
Display the selected value from the slicer in the card..
Agenda: Problem Statements. Solution. 1. Problem Statement: We need one card that will show some text and selected values from the slicer. e.g., I have one slicer (i.e., year) and I want to display “Year is: 2022” depending on the slicer. 2. Solution: Take one slicer, “Year.” For the dynamic card, we need to create […]
Highlight rows using Slicer Visual
Agenda: 1. Expectation 2. Problem Statement 3. Solution Here we have data for all products, and we want to see the sales of each product, but we also want to highlight the products without filtering them. The visuals must look like this: 2 . Problem Statement As we know, we have two options in terms […]