Looker Studio: Sorting Rows, Columns and Axis in any Order You Want
This tutorial explains how to sort data in Looker Studio in a custom order, beyond the standard alphabetical or numerical…
Data analysis
Read More
Introduction to the Looker Studio
Looker Studio (formerly Google Data Studio) is a powerful and user-friendly data visualization and reporting tool that helps you transform…
The DAX Text Detective: Find and Search Functions
Find and Search, both functions are used to locate substrings within a larger text string. They return the position (as…
Power Pivot Advanced Concepts – A Complete Guide to Power Pivot
This tutorial provides a comprehensive overview of Power Pivot in Excel, covering topics such as data modeling, creating relationships, working…
Pivot and Unpivot Data in SQL Server Database Including Multiple Columns – A Step-By-Step Guide
This tutorial provides a comprehensive guide to pivoting and unpivoting data within SQL Server. We’ll delve into the process of…
Creating Business Intelligence Dashboards from SQL Server Tables and Views
This tutorial demonstrates how to create a comprehensive Power BI report using data from a SQL Server database. We’ll delve…
Analysing Data in SQL Server Database Using Views – Bank Accounts Analysis Example
This video tutorial introduces SQL views and demonstrates how to create and use them for data analysis. It begins by…
Time Intelligence in Power BI: A Visual Guide
This video tutorial introduces time intelligence calculations and their visualization using Power BI dashboards. It covers various time intelligence concepts,…
Using Gemini for SQL Data Analysis: Impress people without knowing SQL
The video tutorial demonstrates how to use Gemini to analyze data using SQL without writing SQL queries manually. It covers…
Using Dropdown Lists Effectively to Summarize Data and Build Dashboards and Reports in MS Excel
The video tutorial demonstrates how to create a comprehensive report in MS Excel using a drop-down list. The tutorial begins…