Understanding of Power Query


Power Query is a data transformation and cleaning tool developed by Microsoft, which is available as an add-in for Microsoft Excel and as part of the Microsoft Power BI suite. Power Query allows users to import, transform, and cleanse data from various sources in order to create clean, organized data tables that can be used for analysis and reporting.

With Power Query, users can connect to a wide range of data sources, including databases, spreadsheets, text files, and web pages. Once connected, Power Query provides a range of tools for transforming the data, such as filtering, sorting, grouping, pivoting, and merging. Users can also create custom calculations and transformations using the M language, which is the scripting language used by Power Query.

Power Query has a user-friendly interface that allows users to easily navigate through the various data transformation steps. It also provides a preview of the transformed data, allowing users to see the changes in real-time.

Power Query is particularly useful when working with messy, unorganized data or large data sets that require cleaning and transformation. It can also help automate repetitive data cleaning tasks, saving time and reducing errors. Additionally, Power Query provides a way to merge data from different sources and format it in a way that is suitable for analysis or visualization using Excel or Power BI.

Overall, Power Query is a powerful data transformation and cleaning tool that can help users import, transform, and cleanse data from various sources in order to create clean, organized data tables that can be used for analysis and reporting.


These are Aspects related to Power Platform like 

Power Apps 

Power Query 

Power Automate 

Power BI



Comments

Post a Comment

Popular posts from this blog

How to use lamda expression for updating using LINQ

This is small example showing how we use lamda expression in the programming section , Generally we use lamda expression when working wiht LINQ , or the classs of list type where need to get the data based on any where clause. public Boolean Update(string id) { int flag = 0; string str = DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year; foreach (var c in obj.Task_Details.Where(x => x.task_no == id)) { c.task_date = str; flag = 1; c.status = "Complete"; } obj.SaveChanges(); if (flag == 1) { return true; } else { return false; } }
Read more

using session for login and logout in asp.net

firstly open the "Global.aspx". then create a function there  protected void Application_Start() { //we give the name of the session  here and declare it null ..username is the name of the session //we can change it according to our needs Sesssion["username"]=""; } now we can create the function where we are login as function boolean login( string username, string password) {   // firstly we match the login details from the database. if(username == logincredintialfromdb && password ==logincredintialfromdb ) { // the values are matched here so are assiging the value to the session variable Session["username"]= username ; return true; } else { return false; } }
Read more

How to post data in MVC using form collection for Beginners.

Here we can simply put the data into the form tag and give each component an name .We are creating a login form using the MVC Architecture. <form method="post" action="Name_of_the_function> <input type="text" name=username id=username> <input type="password" name =pass id=pass> <input id=submit type="submit"> on controller [httppost] public ActionResult Name_of_the_function(formcollection form) { string str=form["username"]; string str1= form["pass"]; }
Read more