Need Help? Chat with us
[email protected] +1 203-349-9909 / +91-8080042523

Category

Tutorials

Business Analyst Interview Questions & Answer (Q&A)

Business Analyst Interview Questions & Answer (Q&A) Business Analyst in an organization helps to bridge the gap between IT and the actual business flow. learn about Business Analyst Interview Questions he takes into consideration the business process, data, requirements, and provides necessary recommendations to the business superiors for the business to flourish further. Now let...
Read More

TOP 60 DATA ANALYST INTERVIEW QUESTIONS AND ANSWERS

1. Why should we hire you as a Data Analyst? Data Analysts can collect, run and crunch data for insight that helps the organization make good decisions. They look for relationships and can discuss their results well. Their main job role is to use the data to grab opportunities for preventive measures. Data Analyst requires...
Read More

Power BI Dashboard vs. Power BI Report | BI Dashboard

A Power BI dashboard is usually known as a canvas and it can have only one page to tell a story using visualizations. Since it is restricted to one page, a perfect dashboard contains only the most important fundamentals of the story. The visualizations on the dashboard are referred to as tiles and are pinned to the dashboard by...
Read More

Create Power BI Layouts – Power BI Tips and Tricks

Power BI has this excessive functionality where you can go and download preset layouts which make your Power BI reports look more effective. There is a simple trick to create these Power BI layouts. You can create layouts in PowerPoint and then convert them into images. After that, you can insert them into your Power...
Read More

5 Steps to Create your first Power BI Dashboard | Power BI Dashboard

A Power BI dashboard is usually known as a canvas and it can have only one page to tell a story using visualizations. Since it is restricted to one page, a perfect dashboard contains only the most important fundamentals of the story. A dashboard is not only attractive but also very interactive and highly customizable. The...
Read More

POWER BI TEMPLATE

When you are using Power BI for your report analysis, you also need to create a few dashboards that can be really helpful and used often. You can restructure your process and update your reports by creating Power BI templates that give you the ability to upload a number of data sources and automatically rebuild...
Read More

Power Query Tips & Tricks

Power Query is one of the most powerful features in Power BI and the easiest to learn. It is used for cleaning & transforming the data downloaded from ERP or accounting systems and display it in a report for Power BI to work with. You can learn more tips & tricks in our Power Query...
Read More

Learn How to Display A Monospaced Font in Power Query

Normally data is viewed in the Unicode Font for any kind of data. But do you know you can also change this font to a monospaced font? Display A Monospaced Font With Power Query Power Query has a solution for this also. If you want to use another font other than Unicode font then follow...
Read More

How to Add Comments In M Using Power Query

You can add comments to your code either with single-line comments that start with ‘//’ or multi-line comments that start with ‘/*’ and end with ‘*/’. Adding Comments In M With Power Query Let’s take an example to see how it works. Step 1: Load Data in Power Query Load the data in Power Query first to apply comments in...
Read More

Top 5 Steps to do Comments In Query Steps

The new feature of Power Query allows you to add descriptions to each step in the Applied Steps pane. The step descriptions become comments in the M code in Power Query. If you write M code in the Advanced Editor window, then your comments appear as descriptions in the Applied Steps pane. Comments In Query Steps...
Read More

Steps to Create A List Query From A Table Column

Power Query also allows you to create a list query from a data table available. The column from the given data table can be used to create a list query. This can be explained with the help of an example. Creating A List Query From A Table Column Here, we have a data table containing...
Read More

How to Manage Parameters in Power Query

Power Query can create a query parameter and link to the List Query. This is one of the most unknown features of Power Query. Let us study this unique feature along with an example. We have considered the same example of list query explained above. Manage Parameters By Power Query Step 1: Create a List...
Read More

Learn How to Rename A Column Using Power Query

One of the important and most needed features of Power Query is Renaming Column Headers. You can rename a column in Power Query very easily. Rename A Column With Power Query Let’s observe the below steps to rename column headers- Step 1: Load Data in Power Query When you load the data in Power Query,...
Read More

Learn How to Merge Columns in Power Query

Merging columns is also a feature of Power Query which is very useful for transforming data. You can use this feature easily by following below steps. Merge Columns With Power Query Step 1: Select the Columns in Power Query for Merging If you have a data table as shown below and you want to merge...
Read More

Top 3 Steps to Append Queries Using Power Query

You can even append queries in Power Query. This feature is very useful if you want to combine two data tables together. Let us understand this using an example. As shown in the below picture, you have two sales data for the year 2015 and 2016. We want to combine these two data tables together....
Read More

Steps to Format Columns Using Power Query

Another important feature of Power Query is Formatting Columns. There are various formatting options available in Power Query for columns like Trim, Clean, Add Prefix, Uppercase etc. In this example, we are going to see how to capitalize each word from the column using the formatting feature. Format Columns By Power Query Step 1: Select...
Read More

Top 5 Steps to Extract Age Using Date in Power Query

This is an amazing feature as it allows you to extract the age out of the date provided. Let us elaborate on this feature using an example. Extract Age Using Date With Power Query Here, we have a data table containing employee information which includes their Date of the Birth column. If you want to...
Read More
1 2 3 12