Month September 2023
Practice: Current Year sales: Previous Year Sales: Formatting profitablity: Steps building Dashboard: 1.First adjust dashboard size as per your requirement2.Ensure Floating selected and drag vertical container, Go to Layout and adjust its x,y and Height and Width3.Click on Tiled, Add… Continue Reading →
For primary key and Unique key in a table, index is created automatically. Using indexes appropriately can significantly improve query efficiency for large tables and sorting/grouping operations. Create indexes to increase the performance of query. Like tableau’s context filter that… Continue Reading →
Creating triggers: Before insert trigger: To Create before insert trigger to make sure any new value of Working hours, if it is negative, then it should be inserted as positive. — Create the table create table emp_bit(name varchar(55),occupation varchar (100),working_date… Continue Reading →
Understanding Cardinality: In our data, we have a relationship between country table and sample table using the country field. The country table in the first model have unique values for the respective fields. However, sample table have each value repeating… Continue Reading →
Power Query Editor is a data transformation and cleansing available in power BI. Performing data transformations: Split the columns into seperate columns based on delimiter Unpivot columns: Unpivoted Columns: Replace Value: String data cleaning: Age calculation: Adding conditional column: By… Continue Reading →