Data Analytics

How to count working days excluding public holidays

Last Dataset Refresh DateTime

SQL Server Management Studio 19 installation part1

How to Unpivot the SQL Table or How to Convert into Skinny Table

SQL Server 2019 installation part2

Calendar with Min and Max values from Multiple tables

Power BI DAX - What is DateAdd and How to calculate previous month sales

How to count number of working days per month

How to add Adventure works database|| Restore database in SQL

How to Compare Current Year and Last Year Sales in Power BI

How to create a SQL pivot table

How do we control Interaction between visuals in PowerBI Report

How to sync slicers in multiple pages of PowerBI reports

DAX Percentage Calculations

SSIS Package deployment in SQL server and Job Schedule

How to ignore Filter selections in PowerBI

Conditional Formatting using Measure

How to Navigate between pages in Power BI