• The Excel and SQL Server experts blog

  • 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 1. How Does Power BI Work? A Brief Overview 2. 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. …

  • Master Data Management: What is it and Why is it Important?

    Andy McDonald - Dec 02, 2021

    Master Data Management (MDM) is an information management discipline focusing on data quality and data governance. Its goal is to mitigate problems caused when Master Data is inconsistent, fragmented, or out of date. In this article, we’re going to explain what MDM is and provide some tips on how to start an MDM journey. Table …

  • Simple Data Validation in SQL

    Andy McDonald - Oct 24, 2021

    What is data validation in SQL and why is it important?  Data validation is a method for checking the accuracy and quality of data.  Information in databases is constantly being updated, deleted, queried, or moved by multiple people or processes, so ensuring that data is valid at all times is essential. In this article, we’re …

  • How to create Pivot Tables in SQL Server

    Andy McDonald - Oct 10, 2021

    In this article, we’re going to show you how to create pivot tables in SQL Server.  This is the third article aimed at teaching Excel users some basic SQL server queries, and how to mimic some of the main functions used in Excel. In a previous article we looked at the equivalent of Excel’s VLOOKUP …

  • What’s new in SQL Spreads 5.0?

    Johannes Åkesson - May 07, 2020

    SQL Spreads 5.0 is the largest update in over two years, with several new and exciting improvements. We have implemented a couple of long-anticipated features, such as: We have also implemented several changes to improve how you can develop and deploy SQL Spreads documents: To try SQL Spreads 5.0, you can download the 14-day free …

  • What’s new in SQL Spreads 4.4?

    Johannes Åkesson - Feb 01, 2019

    We are proud to announce the release 4.4 of SQL Spreads – the solution for easily letting your non-technical people manage and update data in SQL Server using Excel. In this article, we will shortly describe what’s new in this release. A complete list of the changes in SQL Spreads release 4.4 can be found …

  • Happy Holidays from the SQL Spreads team

    Johannes Åkesson - Dec 18, 2018

    This year has been a successful year for SQL Spreads thanks to our fantastic customer and partners. There are now more than 200 customers in over 30 countries that use SQL Spreads to simplify for their non-technical users to update and manage their important data stored in Microsoft SQL Server. We would like to thank …

  • SQL Spreads exhibiting at PASS SQL Saturday

    Johannes Åkesson - Sep 01, 2015

    I am excited to announce that SQL Spreads is sponsoring the PASS SQL Saturday event in Gothenburg at September 5th. PASS is the global community for sharing knowledge and insights in the data analytics and business intelligence technologies on the Microsoft platform. Read more about the event >>

  • Page 4 of 5«12345»