Author: Ben Richardson

Ben Richardson runs Acuity Training. Acuity is an IT training business offering classroom courses in London and Guildford. It is a leading provider of SQL training the UK and offers a full range of SQL training from introductory training to advanced administration courses.

Install Azure CLI 2.0 on Microsoft Windows

Azure, Cloud

Azure CLI is a Microsoft cross-platform tool that allows users to remotely access Azure services...
Read More

Using INNER JOIN to Combine SQL Server Tables and Display Them in ASP.NET Webforms

ASP .NET CORE, Database development, Languages & Coding, Tables

This article describes the ways of using an INNER JOIN to combine results from two tables in the SQL Server database and display them in an...
Read More

Pivoting, Unpivoting, and Splitting Columns in Power BI Query Editor

Database development, Tables, Tools & technologies, Utilities & Extensions

For reference, Power BI is a data visualization and analytics software developed by Microsoft. Power BI can be used for static as well as...
Read More

Formatting Data in Power BI Desktop Visualizations

Business intelligence, Power BI, Work with data

Microsoft’s Power BI is a data analytics tool that can be used for interactive data...
Read More

Implementing Hierarchies in Power BI Desktop Visualizations

Business intelligence, Power BI

For starters, Microsoft Power BI is one of the most commonly used data analytics and visualization tools. With its help, you can import and...
Read More

Data Visualization in Microsoft Power BI

Business intelligence, Power BI, Work with data

Contents Introduction. How to create a table. How to create a Power BI pie chart. Creating a line chart in Power BI. Report creation....
Read More

How to Load and Manage Data within Microsoft Power BI

Business intelligence, Power BI, Work with data

Contents: Introduction Importing data from Excel, SQL Server, and the Web. Importing data from...
Read More

Introduction to Microsoft Power BI

Business intelligence, Power BI

This article will help you get to grips with the basics of Power BI and what it has to offer as an analytics tool. Along the way, we’ll...
Read More

Analytic Functions in SQL Server

Code Management, Tools & technologies

Aggregate and Analytic functions in SQL Server operate on a set of rows. However, unlike such aggregate functions as sum, count and average...
Read More

Ranking Functions in SQL Server

Database development, Statements

Suppose you are designing an SQL Server database application for a company’s CEO and you have to...
Read More
Close