• SQL Spreads Blog

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

  • 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. Table of contents • Power BI write-back to SQL: Use cases • Power BI write-back to SQL using Power Apps …

  • 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.   Table of contents • How Does Power BI Work? A Brief Overview • Step-by-Step Example: Create a Report in …

  • Power BI Dashboards: Examples & Use Cases

    Andy McDonald - Jan 21, 2022

    Power BI is a Business Intelligence (BI) platform. With Power BI, users can get data, analyze it, and create visualizations that help turn data into actionable information for their business.  In this article, we’re going to look at creating Power BI dashboards and reports, and give some examples of how and when to use them. …

  • Page 1 of 212»