What I will show you in this article is how to use Power BI to connect to your favorite web performance monitoring service Google Analytics. It is true that this service already has its own web interface but sometime you might want to edit your data prior to visualization or create your own reports. Connecting… Read More »
Comments in SQL query have a simple purpose. They keep the code well-arranged for others and also explain its logic. If you mark some text as a comment it will not be taken as an SQL command and therefore it will not be executed. SQL Comment can be written down in two ways: Comment can… Read More »
MS SQL Server exists in many different editions so where to start? Best way is to get edition which is free and that is MS SQL Server Express. This edition is suitable for small projects and as a tool to familiarize yourself with SQL Server. SQL Server Express edition offers complete database engine and of… Read More »
MS Power Query is a very powerful business intelligence tool by Microsoft. As an Excel addin it can, together with Power Pivot, replace tools which were made only for experienced developers (SQL Server Integration Services etc.) The biggest advantage of this tool is the possibility to use a wide variety of connectors to data sources.… Read More »
Power BI Desktop is a desktop app for report preparation. It is free and offers a user-friendly interface for data visualization and management. Reports and dashboards do look good in the Power BI. Data Visualization using Power BI Desktop Report making used to be a job mainly for IT developers. Regular business users were not… Read More »
OVER clause can belong to commands working with so-called Window functions in SQL. These types of functions enable us to look at the data not only in their aggregated form (using GROUP BY), but we can also look at functional operations via multiple other attributes. We, in fact, create windows of some sort and we… Read More »
SQL Server 2016 Reporting Services SSRS have changed significantly since their strongly outdated predecessors. Report manager is no longer present and has been replaced by visually attractive web portal thanks to which users are able to define KPI quantities. Mobile report publisher enables user to create reports compatible with mobile phones and tablets and it… Read More »
GROUP BY clause is used to group data. In most of the cases, we talk of a situation when we need to make an aggregate operation in the table (sum of sales, number of records, average, etc.) GROUP BY in SQL Script SELECT FROM WHERE GROUP BY HAVING ORDER BY Syntax SELECT [Column 1], [Column… Read More »
The order in which are the SQL clauses entered into the query are quite known. However, the order of logical query processing is different than in which we enter it into the script. SQL clauses and their order in the script: SELECT FROM WHERE GROUP BY HAVING ORDER BY but SQL query is logically processed… Read More »
HAVING clause is a special type of SQL command. It works in a similar way as WHERE clause and we use it to define a condition. There are important differences between the two clauses. Let me explain the differences between SQL HAVING and WHERE. HAVING positioning in SQL script SELECT FROM WHERE GROUP BY HAVING… Read More »