Problem Statement A growing enterprise needed to streamline its email data management. Email activity data, stored in the organization’s CRM system, was essential for compliance, customer service tracking, and business intelligence. However, they faced major challenges: Email data was only accessible through complex CRM APIs returning paginated JSON. There was no centralized repository for email… Continue reading Email Data Migration from CRM to SQL Server using Azure Data Factory
Lakehouses combine the best features of data lakes and data warehouses, offering scalable and cost-effective solutions for storing and processing large datasets. However, they come with a notable limitation: insert, update, and delete operations on tables are not natively supported. This poses a challenge for use cases requiring data synchronization or incremental updates. To overcome… Continue reading Overcoming Lakehouse Limitations: Implementing Upserts with PySpark
In today’s fast-paced digital world, businesses are always looking for new ways to improve their data management. Before Microsoft Fabric technology came along, managing data was tough – there were silos, integration problems, and scalability issues. But with Microsoft Fabric, everything’s changed. Microsoft Fabric consultants are at the forefront of this revolution, guiding organizations to… Continue reading Revolutionizing Data Management with Microsoft Fabric Consultants
In the dynamic/diverse sphere of multi-sector businesses, it is essential to stay ahead in the market which requires strategic decision-making backed by insightful data analysis. Microsoft Business Intelligence (BI) emerges as a hero tool set in these diverse industries from empowering entrepreneurs to even large undertakings in order to unlock valuable business insights. Microsoft Business… Continue reading Microsoft Business Intelligence: A Game-Changer for Multi-Sector Business Owners
Adding custom fonts in SSRS or SQL Server Reporting Services is a powerful way to personalize and enhance the visual appeal of your reports. This process involves selecting a distinct typeface that aligns with your brand identity and integrating it seamlessly into your SSRS environment. Let’s explore how the addition of a custom font can… Continue reading Add custom fonts in SSRS Report
As any developer, one always follows the cycle of deployment using different environments, i.e., DEV (for development phase or the underground lab) -> UAT (for testing phase or Racoon city) -> PROD (for real-time application or the world). In SSIS also, we are able to deploy the same SSIS package in 3 different environments, but… Continue reading Copying environment variables from one environment to another using SQL query
For many reasons, we may feel the need of bringing additional fields to the SSRS dataset. A common issue faced when using SSRS i.e. Microsoft Business Intelligence shared datasets is when we change the backend query to bring additional fields for reporting, the dataset fails to recognize this change. Let us try to regenerate this… Continue reading Microsoft Business Intelligence: SSRS > Shared Dataset > Not detecting NEW fields > a simple fix
Problem Statement: We have different SQL databases for different tenants(or clients), and we want the same SSRS report to fetch data from different databases based on the user who is executing the report. To achieve this, we can have a data source that is dynamic by using an expression-based connection string. Below is a quick explanation… Continue reading SSRS – How to handle multi tenants in single instance?
These days, we live in some hyper-connected world where information works as the key to success for both the businesses and individuals. But raw details contained in the data repository can actually make some clear sense and this is the place where the business Intelligence tools mainly come into the picture. Microsoft offers an entire… Continue reading Few Things About The Microsoft Business Intelligence Services
‘‘INKEY’s ability pond” is your one stop shop to learn more about the services offered at INKEY. Here, our authors discuss on some of the topics like Microsoft SQL Server, Microsoft Dynamics CRM, Microsoft Business Intelligence, Microsoft Power BI, Microsoft Office Add-ins, Mobile Development, and Custom Application Development.
© All Rights Reserved. Inkey IT Solutions Pvt. Ltd. 2026
