EC Analytics

Welcome to EC Analytics - Data Science | Data Visualization | Training | Solutions

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

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

28

Oct'17

Excel Pareto Add-In

What is Pareto Analysis? The Pareto principle (also known as the 80/20 rule, the law of the vital few, or …

Read More

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.

Social Media

ECAnalytics-facebookECAnalytics_Linkedin

Address:

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

EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED