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, …
The Excel and SQL Server experts blog
-
Creating Reports with Power BI, SQL and Excel
Andy McDonald - Feb 09, 2022 -
CSV to SQL: How to Convert, Open & Import
Andy McDonald - Jan 31, 2022In this article, we’re going to look at 3 ways to convert a CSV file to SQL. This is a common use case, so hopefully, you’ll find the following information useful in your day-to-day work. Introduction Comma Separated Values (CSV) files are commonly used to exchange data from one system or application to another. The …
-
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. …
-
SQL Spreads release 6.1.15
Johannes Åkesson - Dec 09, 2021SQL Spreads 6.1.15 is now available for download. Added support for the new pricing model with Basic, Pro and Premium plans and separate Editor licenses. Added a checkbox to the Table Creator to decide if columns in a new table should be nullable. Added a field to set the name of the Identity column in …
-
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. What …
-
How to Update an SQL Table from Excel
Johannes Åkesson - Nov 26, 2021SQL Spreads solves some common data management problems for Microsoft SQL Server. It makes it fast and simple to update an SQL table from an Excel spreadsheet. And it gives you the control you need to manage data entered by various users on a collaborative team. End users love working in Excel End users love …
-
SQL Spreads release 6.0.44
Johannes Åkesson - Oct 29, 2021SQL Spreads 6.0.44 is now available for download. This new release focus on stability improvements – we have made a number of stability improvements and fixes in the areas around Excel table formatting, detection of changes in SQL Server etc. Added the possibility to set a Default value for a column to use when a …
-
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 …
-
SQL Spreads release 6.0.30
Johannes Åkesson - Jun 17, 2021SQL Spreads 6.0.30 is now available for download. This new release introduce a new feature to use the Tree filter selection as the key column when inserting new rows into a table. Added a new Parameter selection dialog to easily insert Tree Filter and Cell parameters. Added the possibility to remove key columns that are …
