All posts by Lokesh Paliwal

12

Feb'20

How to Create Histogram in Microsoft Power BI

A histogram is used to provide a visual interpretation of discrete or continuous data. It is represented as a bar …

Read More

20

Jan'20

How to create Bookmarks in Microsoft Power BI

A bookmark is a method of saving a specific page view for future reference. It is a saved shortcut that …

Read More

05

Mar'19

Bump Chart in Tableau

In this tutorial we will learn how to create Bump chart in Tableau.Using Bump Chart, we can compare one dimension …

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 Guru gram here. This dashboard helps you to analyze product wise sales and profit. …

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

Social Media

ECAnalytics-facebookECAnalytics_Linkedin

Address:

NM 23, SECTOR 14, OLD DLF COLONY,
GURGAON (HARYANA)
0124- 4601426

ABOUT EC ANALYTICS CONSULTING

EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED