What are Data Connectors and basic transformations in power bi

-

What are Data Connectors?

·       Data connectors in Power BI allow users to connect to data sources and access data from applications and services. 

·       These connectors enable users to create reports and dashboards and perform analytics on multiple data sources. 

Types of Data Connectors in Power BI

Power BI Data Connectors enable you to connect your data sources to the Power BI system securely without expensive re-engineering, testing, or retraining.

Subsequently, through a secure connection, you can:

1. File Connectors.

2. Database Connectors.

3. SaaS Connectors.

4. Other Connectors.




Basic Transformations in Power BI

·    Data transformation in Power BI is the process of converting data into a more suitable format for analysis, reporting, or further processing. 

·       This can include cleaning, shaping, and enriching the data.

·       Data Transformation is also known as Data mining.

 Here are some data transformation capabilities in Power BI:

§  Change data type

§  Unpivoting

§  Remove duplicates

§  Remove unnecessary rows

§  Replace values

What is Power Query Editor?

The Power Query Editor is the primary data preparation experience, where you can connect to a wide range of data sources and apply hundreds of different data transformations by previewing data and selecting transformations from the UI.

Steps to transform data in Power BI:

Step 1: Open Power BI and Create a Blank Report.

Step 2: Get data -> More -> Files -> Folder -> Connect.

Step 3: Browse the folder path and Enter OK.

Step 4: Enter Transform data after showing data files.

Step 5: Now right-click the files one by one and create new queries.

Step 6: Rename all the query files instead of a path name.

Step 7: Now select the first row and in the ribbon select use first row as the header. Here first row is converted to a header for all the files.

Step 8: In the Applied steps you can delete your unwanted steps.

Step 9: In the Power Query Editor, Transform is used to filter data, transpose, reverse rows, count rows, extract, fill, pivot tables, Etc can be done.

Please refer to the below youtube video for more details:



**Please do follow and subscribe to my YouTube channel for daily video updates. Thank you.

Comments

Post a Comment

Popular posts from this blog

Mobile performance testing using Perfecto

-
Image
 Mobile performance testing using Perfecto In this video we are going to see how to perform Mobile performance testing using Perfecto step by step in detail: There is the basic topics that are covered in the Mobile performance testing using Perfecto: Mobile Performance Testing - Perfecto Introduction to Mobile Performance Testing Understanding the importance of mobile performance testing Key goals and objectives of mobile performance testing Perfecto Overview Introduction to Perfecto Benefits of using the Perfecto Perfecto Features Defining performance metrics and goals Selecting target devices and platforms Setting up testing environments and tools Requirement for Mobile Performance Testing Types of Mobile Performance Testing Performance Testing Tools for Mobile Mobile Performance Testing Approach Steps in the Mobile Performance Testing Approach Mobile Performance Testing with (IOS) - Automation Testing The Smart Reporting API. Generate a report...
Read more

Topic - 1: Introduction to the Blogging

-
Image
Introduction to the Blogger * Steps to Create a New Blog:- Step 1: Go to Google and search Google blog. Step 2: Signup your Email ID with Google blogger and login in. Step 3: Enter your Blog Name and Started creating your New Blog. Step 4: Once you Created your Blog start buying Domain with Godaddy or Hostinger based on your Reach. Step 5: Now your blog is eligible to show the posts. The important thing is you need to post regularly or weekly. It increases your views among bloggers. Thank You. Step 6: For more information watch the video attached below: *Please Subscribe to our Youtube Channel and Give your Valuable Support It increases our Attention to post more like this......
Read more

Dealing with Text Tools in Power BI

-
Image
  Dealing with Text Tools in Power BI What are Text Tools in Power BI? ·       Text tools in Power BI  allow users to analyze and visualize text data to gain insights and make informed decisions. Steps to import data in Power BI & How text tools work. Step 1: Please refer the section 5.1 for get data and Transform Data steps for your reference. Step 2: Now move to the section text column in the transform section and add a column section on the power Query editor. Step 3: Here after creating a new query you can merge the first name and second name using merge columns by selecting the First name column shift second name column. Before merging columns, in format use the trim option to avoid additional spaces between names after merging columns. Now, after selecting two names Select the merge column option create a name as a full name where the separator is space, and hit enter. Here two columns are merged now. Step 4: To split the username from ...
Read more