All posts by Lokesh Paliwal

05

Mar'19

Bump Chart in Tableau

Using Bump Chart, we can compare one dimension against another dimension using one measure value. For Example: In the below …

Read More

14

Jan'19

HOW TO PRINT A PASCAL TRIANGLE USING VBA CODE

Problem Statement Now today we are going to create Pascal Triangle using VBA. This is not a reporting problem statement …

Read More

13

Jan'18

Sample Superstore Dashboard in Tableau

Let’s talk about tableau training in Gurgaon here. This dashboard helps you to analyze product wise sales and profit. You …

Read More

10

Jan'18

ONLINE RETAIL DASHBOARD USING PIVOT TABLE

Dashboard Dashboards often provide at-a-glance views of KPIs (key performance indicators) relevant to a particular objective or business process. In …

Read More

08

Jan'18

DIFFERENCE BETWEEN BYVAL AND BYREF-EXCEL VBA

ByRef If you pass an argument by reference when calling a procedure, the procedure access to the actual variable in …

Read More

01

Jan'18

HOW TO PRINT PYRAMID PATTERN “*” USING VBA CODE

Problem Statement Now today we are going to create pyramid using VBA. This is not a reporting problem statement but …

Read More

31

Dec'17

Find nth word from text string-EXCEL/VBA

Problem Statement Now this time we have an interesting challenge, what we want to extract is, Nth text from a …

Read More

28

Dec'17

Sort Sheets Alphabetically-Excel VBA

PROBLEM STATEMENT Sort all worksheets in A-Z/Z-A order For Example: In the below screenshot worksheets are not sorted in any …

Read More

27

Dec'17

Merging Multiple Rows based on Criteria -Excel VBA

PROBLEM STATEMENT Most of the time we deal with duplicate values in excel, same situation we have here. In our …

Read More

21

Dec'17

EXTRACT NUMBER FROM STRING – UDF

PROBLEM STATEMENT One of my student asked me this question in this weekend class, how can we extract characters from …

Read More

Tableau Training in Delhi

All Rights Reserved. EC Analytics Consulting 2014 - 2019.

NM 23, Sector 14, OLD DLF Colony - Gurgaon (Haryana) India. 9582876837 | Privacy Policy

Drop us a Query

Call Us: +91 8826547882

Drop us a Query