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 …
The Excel and SQL Server experts blog
What is Power Apps? Quick Start Guide
Andy McDonald - Feb 18, 2022Creating Reports with Power BI, SQL and Excel
Andy McDonald - Feb 09, 2022In 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, 2022Power 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, 2021Master 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, 2021What 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, 2021In 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, 2020SQL 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, 2019We 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, 2018This 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, 2015I 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 >>
Hi,
I am the founder of SQL Spreads, the lightweight data management
solution to update SQL Server data using Excel
In this blog we share the Excel and SQL Server knowledge that we have learnt during our work
with hundreds of customers worldwide.
Hope you find it useful!
Best regards,
Johannes Åkesson
Chalmers Innovation, Stena Center 1A
S-412 92 Göteborg, SWEDEN
Registration number: 556671-8564
VAT: SE556671856401