Bump Chart in Tableau
Using Bump Chart, we can compare one dimension against another dimension using...
CLASSROOM AND ONLINE CLASSES
This is the most comprehensive Data Analytics course available, covering all steps of the Data Analytics process from Data Integration, Data Manipulation, Descriptive Analytics and Visualization to Statistical Analysis, using the most in-demand tools like Excel, VBA, SQL SERVER, and Tableau. It will enable you to master all the elements of Data Analytics and Visualization.
Next Batch
12th May’19 (SUNDAY) | 10:00 AM – 1:00 PM | CLASSROOM (GURGAON) + LIVE ONLINE
 70+ Assignments | Start Learning
|
|---|---|
| Real-life Case Studies | |
| Lifetime Access | |
| 300 plus Interview Questions |
TOOLS & CURRICULUM COVERED
EXCEL | VBA | SQL SERVER | TABLEAU | PYTHON
Course Curriculum
| SECTION 1: DATA FORMATTING | |||
| Custom Formatting – Part 1 | FREE | 00:09:00 | |
| Custom Formatting – Part2 | FREE | 00:15:00 | |
| Conditional Formatting – Part 1 | 00:16:00 | ||
| Conditional Formatting – Part2 | 00:16:00 | ||
| SECTION 2: FORMULAS AND FUNCTIONS | |||
| Dollar Use and IF Formula | 00:11:00 | ||
| Data Validation | 00:18:00 | ||
| SECTION 3: WHATIF ANALYSIS AND GOAL SEEK | |||
| Goal Seek in Excel | 00:04:00 | ||
| SECTION 4: ADVANCED FORMULAS | |||
| Text Functions in Excel | 00:09:00 | ||
| Offset, Index and Match Formulas | 00:08:00 | ||
| VLOOKUP and HLOOKUP Formulas | 00:07:00 | ||
| SECTION 5: PIVOT TABLES | |||
| Pivot Table Designing | 00:11:00 | ||
| Pivot Table Designing Part2 | 00:16:00 | ||
| Pivot Table-Part 2 (Show Values As and Group By) | 00:16:00 | ||
| Calculated Fields | 00:15:00 | ||
| Pivot Charts | 00:11:00 | ||
| Pivot Slicer and Dashboard | 00:17:00 | ||
| SECTION 6: CHARTING | |||
| Chart Creation in Excel | 00:08:00 | ||
| SECTION 7: CUSTOM CHARTS | |||
| Custom Indicators in Excel Charts | 00:09:00 | ||
| Bullet Graph in Excel | 00:12:00 | ||
| Step Chart in Excel | 00:07:00 | ||
| Progress Chart in Excel | 00:06:00 | ||
| Pareto Chart in Excel | 00:10:00 | ||
| Bump Chart in Excel | 00:17:00 | ||
| Waterfall Chart in Excel | 00:06:00 | ||
| SECTION 8: INTERACTIVE CHARTS | |||
| Name Ranges in Excel | 00:07:00 | ||
| Interactive Chart Using Combobox | 00:06:00 | ||
| Interactive Chart Using Radio Button | 00:16:00 | ||
| SECTION 9: DASHBOARDING | |||
| SALES DASHBOARD: Introduction | 00:03:00 | ||
| Sales Dashboard: Section1 Introduction | 00:05:00 | ||
| Sales Dashboard: Section 1 | 00:21:00 | ||
| Sales Dashboard: Section2 | 00:17:00 | ||
| Sales Dashboard: Section3 | 00:17:00 | ||
| Sales Dashboard: Section 4 | 00:00:00 | ||
| Sales Dashboard: Section 5 | 00:16:00 | ||
| Sales Dashboard: Final Formatting | 00:12:00 | ||
| SECTION 10: CALL CENTER DASHBOARD | |||
| Call Center – Dashboard Understanding | 00:04:00 | ||
| Call Center: Section 1 Part 1 | 00:23:00 | ||
| Call Center: Section1 Part 2 | 00:19:00 | ||
| Call Center: Section 2 – Part 1 | 00:20:00 | ||
| Call Center – Section 2 – Part 2 | 00:10:00 | ||
| Call Center – Section 3 | 00:11:00 | ||
| Call Center: Final Formatting | 00:06:00 | ||
| VBA | |||
| SECTION 1: COURSE INTRODUCTION AND OVERVIEW | |||
| SECTION 2: VBA AND VBE UNDERSTANDING | |||
| SECTION 3: LOGICAL STATEMENTS | |||
| SECTION 4: LOOPS | |||
| SECTION 5: USERFORM | |||
| SECTION 6: ERROR HANDLING | |||
| SECTION 7 : BUILT IN AND USER DEFINED FUNCTIONS | |||
| SECTION 8: EVENTS | |||
| SECTION 9: CHARTS AND PIVOT TABLE CREATION | |||
| SECTION 10: ADO | |||
| SQL SERVER | |||
| SECTION 1: COURSE AND PRODUCT INTRODUCTION | |||
| SECTION 1: INTRODUCTION TO SQL SERVER | |||
| SECTION 2: USER AND AUTHENTICATIONS | |||
| SECTION 3: TABLES, PRIMARY KEY AND FOREIGN KEY | |||
| SECTION 4: SELECT STATMENTS | |||
| SECTION 5: FUNCTIONS | |||
| SECTION 6: JOINS AND VIEWS | |||
| SECTION 7: STORED PROCEDURES | |||
| SECTION 8: TEMPORARY TABLES | |||
| SECTION 9: TRANSACTIONS | |||
| TABLEAU | |||
| SECTION 2: DATA IMPORT | |||
| SECTION 3: JOINS, UNION AND DATA CONNECTIONS | |||
| SECTION 4: WORKSHEET OVERVIEW | |||
| SECTION 5: PERCENTAGE CALCULATIONS | |||
| SECTION 6: CHARTING | |||
| How to perform Cohort Analysis in Tableau | FREE | 00:08:00 | |
| The cohort is a subset of users who are grouped by shared characteristics. Learn how to perform cohort analysis in tableau. | |||
| SECTION 7: CALCULATED FIELD & PARAMETERS | |||
| SECTION 8: FILTERS & SETS | |||
| SECTION 9: ACTIONS | |||
| SECTION 10: DASHBOARDING | |||
| SECTION 11: STORIES | |||
| SECTION 12: TABLEAU SERVER | |||
| LIVE CLASS RECORDINGS | |||
| Recordings – Excel Charting Day1 | 01:20:00 | ||
| Recording – Excel Chart Day 2 | 00:42:00 | ||
| Excel Chart Day3 | 00:54:00 | ||
| Excel Pivot Table Day1 | 00:50:00 | ||
| Recording – Pivot Table Day 2 | 01:12:00 | ||
| Recording – Sales Dashboard | 01:03:00 | ||
| Recording – VBA Day 1 | 01:10:00 | ||
| Recording – VBA Day 2 | 01:26:00 | ||
| Recording VBA Day 3 | 00:00:00 | ||
| Recording VBA Day 4 | 00:00:00 | ||
| Recording VBA Day 5 | 00:00:00 | ||
| Recording VBA DAY 6 | 00:00:00 | ||
| ADO – Part 1 | 00:00:00 | ||
| ADO – Part 2 | 00:00:00 | ||
| SQL Day1 | 01:34:00 | ||
| SQL Day2 | 01:33:00 | ||
| SQL Day3 | 01:41:00 | ||
| Tableau Day1 | 01:04:00 | ||
| Tableau Day2 | 02:00:00 | ||
| Recording – Tableau Day 3 | 01:43:00 | ||
| Recording – Tableau Day 4 | 01:36:00 | ||
| Recording Tableau Day 5 | 01:30:00 | ||
| Live Recordings - Mar'19 | |||
| Day1 – Data Analysis and Visualization – Mar’19 | FREE | 00:00:00 | |
| Day2 – Data Analysis and Visualization – Mar’19 | 00:00:00 | ||
| Day3- March’19 | 00:00:00 | ||
| Day4 – March’19 | 00:00:00 | ||
| Day5 – March’19 | 00:00:00 | ||
| Day6 – March’19 | 00:00:00 | ||
| Day7-March’19 | 00:00:00 | ||
| Day8-March’19 | 00:00:00 | ||
| Day9-Mar’19 (VBA Consolidation) | 00:00:00 | ||
Course Reviews
5024 STUDENTS ENROLLED
Testimonials
I’d received very good feedback about Lokesh even before I signed up for his course. Few of my last organisation colleague have done “Data Analytics for Essentials” program from him and are now...Read more
Kartika Saraswat
Report Analyst (WNS)Recent Posts
Sample Superstore Dashboard in Tableau
Let's talk about tableau training in Gurgaon here. This dashboard helps you to...
ONLINE RETAIL DASHBOARD USING PIVOT TABLE
Dashboard Dashboards often provide at-a-glance views of KPIs (key performance...
Excel Pareto Add-In
What is Pareto Analysis? The Pareto principle (also known as the 80/20 rule,...
Online Retail Store Sales Dashboard
In this article, we will visualize one sales dashboard of an online retail...
A Non-Tech Professional Moves to Analytics
The quality of course content is really good and neatly explained by Lokesh Paliwal with real time examples, Case studies , assignments , projects work helped a lot to be perfect whatever I learnt during the training sessions,he is very well versed with domain knowledge and having corporate experience in respective field .. Thank you Lokesh Paliwal .