• The Excel and SQL Server experts blog

  • How a Business Analyst can help with data conversion projects

    Andy McDonald - Nov 25, 2022

    Businesses today are required to manage more data than ever before. Change is also occurring at a faster rate. Organizations therefore need to be agile with regard to data management and this means being able to move data around from one system to another or between parties with relative ease. In this article we’ll discuss …

  • Master Data Management Tools for Azure

    Andy McDonald - Nov 07, 2022

    Maintaining a “single source of truth” is critical for all organizations. The discipline of Master Data Management (MDM) is one of the means to achieve this. In this article, we’re going to look at some Master Data Management tools for Azure. Table of contents 1. Introduction 2. What is Master Data Management? 3. Microsoft Purview: an …

  • Master Data Management Tools for SQL Server

    Andy McDonald - Oct 21, 2022

    Maintaining a “single source of truth” is critical for all organizations. There are many Master Data Management (MDM) tools out there to help achieve this. In this article, we’re going to look at some Master Data Management tools for SQL Server. Table of contents 1. Introduction 2. What is Master Data Management? 3. What are …

  • What is the equivalent of the IF THEN function in SQL?

    Andy McDonald - Aug 24, 2022

    This is the fifth in a series of articles aimed at introducing the basics of SQL to Excel users. This article shows how to use the IF THEN function in SQL. If you’re interested in the other articles, check them out here: Introduction to SQL for Excel Users What is the equivalent to VLOOKUP in …

  • Excel Linked Data Types: An Introduction

    Andy McDonald - Aug 18, 2022

    There’s a cool feature in Excel for Microsoft 365 that not many people know about. Linked Data Types allow you to access data from a range of subject areas such as finance, geography, nutrition, and media directly in Excel. Do you need to include the latest exchange rates, company stock prices, or city population figures …

  • SQL Spreads release 6.2.8

    Johannes Åkesson - Aug 09, 2022

    SQL Spreads 6.2.8 is now available for download. Fixed issue with bigint numbers with more than 17 digits that were truncated. Fixed issue with commas in text key columns. Fixed issue with uninstalling when both the per-machine and the per-user versions was installed. Fixed issue with the database connection setting “Remember password on local machine”. …

  • How to Export Data from SQL Server to Excel

    Andy McDonald - Jul 04, 2022

    In a previous article, SQL and Excel: Why you need both, we showed that for many businesses the use of both SQL Server and Excel is an optimum approach to data management.  For organizations that use SQL Server and Excel extensively, there is often a need to export data from SQL Server to Excel.  The …

  • How to Use SQL with Excel for Data Analysis

    Andy McDonald - Jun 08, 2022

    In a previous article, we talked about why most organizations should use SQL Server and Excel for their data management needs. In this article, we’re going to look at an example of how to perform data analysis using SQL and Excel. Table of contents 1. Data Analysis Using SQL and Excel: An Overview 2. Step-by-Step …

  • SQL Spreads release 6.2.1

    Johannes Åkesson - May 23, 2022

    SQL Spreads 6.2.1 is now available for download. Support for connecting to Azure SQL using Azure AD Authentication. Support for using Multi-Factor Authentication when authenticating to Azure AD. Download the latest version of SQL Spreads »

  • Export Power BI to Excel: Solved

    Andy McDonald - May 03, 2022

    Power BI is a Business Intelligence (BI) platform. With Power BI, users can get data, analyze it, and create visualizations that help turn raw data into actionable information for their business.  It’s normally the case that you want to import data from Excel to Power BI to create a dashboard or report, but there are …

  • Page 1 of 3123»