Power BI Data modelingData modeling is done to define relationship among the tables to represent the group of tables into DataAug 27, 2020Aug 27, 2020
Pivot and Unpivot in Power BIPivot tables are used to summarize, sort, reorganize, group, count, total or average data stored in a database. It allows its users to…Feb 3, 2020Feb 3, 2020
Converting hours column into day & hours and Concatenation in Power BIIn here we are going to convert the hour's column to days and hour by using variablesJan 29, 2020Jan 29, 2020
SSRS Report with dropdownSQL Server Reporting Services is used to create reports using a bar graph, pie diagrams, tabular, etc.Jan 28, 2020Jan 28, 2020
SSRS Report from Stored procedure with multiple parametersA report contains data retrieval and layout information it is used to interpret the data in the tables in a more understandable formJan 25, 2020Jan 25, 2020
Creating SQL Profiler Type logging in SSISSQL Profiler is used to trace recreate and troubleshoot the problems in the MS SQL ServerJan 24, 2020Jan 24, 2020
Implicit vs Explicit Conversion in terms of performanceImplicit and Explicit conversion is done to convert the data from one data type to another data typeJan 15, 2020Jan 15, 2020