ShristiPower BI Data modelingData modeling is done to define relationship among the tables to represent the group of tables into Data2 min read·Aug 27, 2020----
ShristiPivot 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…2 min read·Feb 3, 2020----
ShristiConverting 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 variables3 min read·Jan 29, 2020----
ShristiSSRS Report with dropdownSQL Server Reporting Services is used to create reports using a bar graph, pie diagrams, tabular, etc.4 min read·Jan 28, 2020----
ShristiSSRS 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 form3 min read·Jan 25, 2020----
ShristiCreating SQL Profiler Type logging in SSISSQL Profiler is used to trace recreate and troubleshoot the problems in the MS SQL Server4 min read·Jan 24, 2020----
ShristiImplicit vs Explicit Conversion in terms of performanceImplicit and Explicit conversion is done to convert the data from one data type to another data type2 min read·Jan 15, 2020----