Learn Advance Excel, Data Analysis, Sql and Python Programming using notebook jupyter
DAX stands for Data Analysis Expressions. It is a formula language used in Power BI for performing calculations and queries on data. It performs calculations that create new measure, new columns and even new tables. Types of DAX Calculations in Power BI When we want to do our DAX Calculations we go to the Table …
What is Power BI? in this introduction to Power BI, let’s start with the definition of the tool. Power BI is a tool made by Microsoft that helps you see and understand your data easily. Power BI helps you understand your data clearly and visually so you can take action confidently. When you have a …
Data Preparation and Cleaning is the process of transforming raw, unstructured or messy data into clean, organized & usable datasets for analysis. Power BI uses the Power Query Editor for these tasks. Our data has to be clean so we can come up with trends and predictions accurately. Power Query is a powerful software used …
Power BI – Data Preparation and Cleaning In Power Query Read More »
Microsoft Excel is a powerful spreadsheet program used for calculating, data analysis, graphing etc. CELLS AND RANGE A cell is where a data is entered while a range is a selection of multiple cells. FORMULAS It is used to perform calculations with basic arithmetic operations. FUNCTIONS: e.g.SUMSum (Number 1,Numberb 2). It adds value in the …
There are mainly two methods for creating a table in SQL. They are as follows: Manually Writing the Code Making use of an Icon
Introduction of Data Importation in Mysql Workbench importation is very important in data analysis, manipulation and visualization. Before a data can be analyze you will need to import it into Mysql Workbench before you can continue with data analysis. For example data can be downloaded from a server in sql format or any other format …
SUMIFS function is a little bit different from SUMIF function in that you can use it to get summation output/result from multiple criteria unlike SUMIF function that can only to get the summation based on a particular condition or criteria. The table below will help you to comprehend the difference between the two functions and …
A function is a block of code which only run when it is called. A function can return data as a result. For Example: my_function<-function (“Hello, “World”) Output: “Hello, World” In this example, In this case, the function is called with the argument “Hello, World”, and it prints that value to the console using the …
R Global and Local Variables R Global Variable In the context of the R programming language, a global variable is a variable that is defined outside of any function or block of code. Unlike variables defined within functions, global variables are accessible and modifiable from any part of the R script or session. It is …
R Data types relate to the many classes of values that variables can hold. R is a dynamically typed language, which means that you don’t have to explicitly declare the data type of a variable when you create it; R will infer the data type based on the value you assign to it. Here are …
