Experience is a great teacher. And in my experience, the beginning has always been tough.

As a BI consultant & trainer, I have worked with various people: from the frontline employees to CEOs. Our interactions gave me great insights into the multiple challenges they face.

I have put together a few pages from my experience and learning; covering Power BI, Excel, Power Query, Power Pivot, Tableau, data analytics & data visualization.

The purpose of the blog is to get you started.

I hope you’ll find them helpful.

Vivek

VLOOKUP (and now XLOOKUP) is one of the most popular functions in Excel. And we primarily use it to combine two tables. And most of us can agree that it takes time to get the hang of this formula. With Power Query, we can simplify this process using a feature called Merge Queries. It is equivalent to SQL JOINS. And Power Query offers six types of JOINS, which are simple to apply.




Related article:

VLOOKUP & JOINS using Power Query

Self Join in Power Query


Join the group BI Simplified to stay updated on future webinars and articles.

@imvivran

Dimensions play a vital part in the analysis. Text transformations help in simplifying the effort required to perform tasks like:

· split data into multiple columns using delimiter or certain text length,

· merging two or more columns,

· removing unwanted spaces and characters using TRIM & CLEAN,

· extracting specific texts or numbers from a column & more.

All of this is a simple task in Power Query. This segment of the webinar highlights a few such features.



Related article:

Text transformations using Power Query


Join the group BI Simplified to stay updated on future webinars and articles.

@imvivran

QuickBytes is a series of articles for simple and easy to implement techniques with exponential benefits



In the previous article and video, we have seen how we can use the Merge Queries feature to join two different tables. This QuickBytes article covers how we can use Merge Queries for doing self-join. We perform self-join where we need inputs from the same table.

Consider the following example:









Objective: Add a column for Manager ID

Step 1: Merge Queries

Select the same table in Merge Query:

Step 2: Expand the table

Expand table and select ID


Output










@imvivran

Drop Me a Line, Let Me Know What You Think

 

contact@vivran.in

+91 9871-641-146

Join WhatsApp group: BI Simplified

MS EXCEL || POWER BI || POWER APPS || POWER QUERY || TABLEAU || DATA ANALYTICS || TRAINING