imD - An Ignorant Mind is a fool's pursuit

Tag data analysis

Triggers with referential integrity constraint:

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 →

Advanced Power query:

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 basics:

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 →

Power BI

Getting started: Load sample financial dataset: Transform data: Web scrapping for World Happiness Report: Previewing to Select data: Tagging geo location: Creating visual Map: GDP per capita in Bubble size: Creating hierarchy for countries: Power query editor: Create relation: Continent… Continue Reading →

Research Questions

Nov-2020  Assertion (A): Concurrent validity coefficients are generally higher than predictive validity coefficient Reason (R) : This does not mean that the test with higher validity coefficient is more suitable for a given purpose Both (A) and (R) are true and (R)… Continue Reading →

Research in Education:

Meaning and Scope of Educational  Research:– The correct sequence of actions in conducting an intervention-based action research in education, Plan, act, observe  and reflect Selection of the problem Formulation of hypothesis Methodology Data collection Analysis and interpretation of data Report of result The… Continue Reading →

© 2024 foolaa — Powered by WordPress

Theme by Anders NorenUp ↑