• The Excel and SQL Server experts blog

  • Connect Excel to SQL Server: 3 Easy Steps

    Andy McDonald - May 06, 2022

    In a previous article, we spoke about why you need both Excel and SQL in your data management solutions, but how do you connect Excel to SQL Server?  In this article, we’re going to show you the steps and highlight a key benefit of using an Excel add-in like SQL Spreads. But, first, we’re going …

  • 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 …

  • Connect Power BI to SQL Server: Step-by-step Guide

    Andy McDonald - Apr 23, 2022

    Power BI is a great way to visualize your data. In previous articles, we’ve introduced Power BI dashboards and gone through a step-by-step example to create a Power BI report using data from SQL and Excel. In this article, we’re going to look in more detail at the process for how to connect Power BI …

  • Power BI Fact and Dimension Tables

    Andy McDonald - Apr 01, 2022

    In an earlier article, we looked at how to create a dashboard based on some sales data.  The data source for that example was several tables in a SQL database.  In this article, we’re going to look in more detail at the data model we built in that Power BI example, and specifically the use …

  • SQL Spreads release 6.1.32

    Johannes Åkesson - Mar 29, 2022

    SQL Spreads 6.1.32 is now available for download. Improved deleting of rows in the database to align with Excel’s Delete rows. Added check if per-machine or per-user installer exists. Added a possibility to call Excel’s Refresh All command after data is saved to the database. Fixed bug so that commas can be used in Pivot …

  • Power BI write back to SQL Database: 2 methods

    Andy McDonald - Mar 12, 2022

    Power BI dashboards and reports are often created using a SQL database as a data source. In this article, we’re going to discuss 2 methods on how to write back to SQL from Power BI. Power BI write-back to SQL: Use cases We all use dashboards and reports on a regular basis to help give …

  • SQL and Excel: Why you need both

    Andy McDonald - Mar 12, 2022

    SQL vs. Excel: which is better?  As you can see from the title of this article, it’s not the case that you should choose one over the other; you actually need SQL and Excel. Introduction Excel is a really great application.  There are not many applications that are used by such a wide variety of …

  • How to use XLOOKUP: Guide and Examples

    Andy McDonald - Mar 02, 2022

    If you’ve been using Excel for a while, you’ll undoubtedly have used one of its most useful functions – VLOOKUP.  This lookup function is invaluable when manipulating data or preparing reports in Excel.  If you’re already familiar with VLOOKUP, then you’ll love the new XLOOKUP function that Microsoft released in late 2019.  It overcomes some …

  • What is Power Apps? Quick Start Guide

    Andy McDonald - Feb 18, 2022

    More and more people are using no-code technologies to create mobile apps, and there are a growing number of vendors in this area.  In this article, we’ll be focusing on Microsoft’s no-code platform, Power Apps. Because it’s a no-code platform it should be easy to create apps, right?! Well, yes, it is easy to use …

  • Creating Reports with Power BI, SQL and Excel

    Andy McDonald - Feb 09, 2022

    In an earlier post, we introduced Power BI and looked at what makes a good dashboard.  In this article, we’re going to go through the steps for creating reports with Power BI, SQL, and Excel.   How Does Power BI Work? A Brief Overview Power BI is a Business Intelligence (BI) platform. With Power BI, …

  • Page 5 of 10« First...«34567»...Last »