Excel Charts & Pivots Plus Tableau For Beginners (2 in 1)

Bundled 2 in  1 Course . Learn Excel Charts & Pivots + Tableau For Beginners .

Software1 : MS Excel 2007 to 2021.

Software2 : Tableau 2022 (recommended) else any

WHO’S THIS FOR?

This course is designed specifically for Beginners.

MS Excel

Excel is flexible and versatile tool for data analysis, data cleaning and data visualization. It is up to person imagination and creativity to capture utilization potential of Excel can offer. Flexibility means you can represent or format data as per your need and can do same task in more than one way.

Advantages of Excel

1. Excel helps to analyze data. Today companies have large data. It becomes easy to analyze and interpret large with the help of excel.

2. It helps to know the trend in the data with the help of charts, graphs, 3-D images, etc.

3. Excel helps in bringing data together. It is possible to import files and documents in excel.

4. We can work with others simultaneously with the help of an excel web app.

5. It helps to store data, do calculations, organize, and format the cells.

6. Excel file is secured with a password, therefore, security is assured.

Disadvantages of Excel

1. Can’t handle large amounts of data.

2. File hanging, Corrupting issue if size is large.

3. Excel becomes slow or crashes when you have lots of data, formatting and Charts inside a workbook.

My Opinion on Excel

Excel will always be a heart of organization. we have Tableau, Power BI tools which are becoming the backbone of Industry but Excel will always be a Part of the the industry. we can’t ignore it.

COURSE STRUCTURE

Excel Charts

Pivots Tables

Reports

Pivot Charts

Tableau For Beginners .

WHO’S THIS FOR?

This course is designed specifically for freshers and absolute beginners.

Tableau is a leading data visualization tool used for data analysis and business intelligence. Gartner’s Magic Quadrant classified Tableau as a leader for analytics and business intelligence.

Advantages of Tableau

• Data visualization.

• Quickly Create Interactive visualizations.

• Ease of Implementation.

• Tableau can handle large amounts of data.

• Use of other scripting languages in Tableau.

• Mobile Support and Responsive Dashboard.

• Tableau Company Strategy.

• Scheduling or notification of reports.

Tableau For Beginners

Section 1:Introduction

Lecture 1:Introduction

(Preview enabled)

Lecture 2:Download

Lecture 3:Install

Lecture 4:Connect with Database

Lecture 5:Tableau Live & Extract

Lecture 6:View tables

Lecture 7:Data Types

Lecture 8:Tableau Work Sheet Interface

Lecture 9:Data Types Symbol

(Preview enabled)

Lecture 10:Adding new Sheet

Lecture 11:Product Category & Sales

Lecture 12:Dimension & Measures

Lecture 13:Grouping

Lecture 14:Granularity

Lecture 15:Table into chart form

Lecture 16:Filtering

Lecture 17:Date Filter

Section 2:Chart

Lecture 18:Create a Chart

Lecture 19:Line Chart

Lecture 20:Bar Chart

Lecture 21:Pie Chart

Lecture 22:Tree map

Lecture 23:Stacked Tree Map

Lecture 24:Bar Chart Color Measure

Lecture 25:Bar Chart size Measure

Lecture 26:Bar Chart Size and color Measure

Lecture 27:Bar Chart with dual axis

Lecture 28:Bar Stacked Part1

Lecture 29:Bar Stacked Part2

Lecture 30:Heat Map1

Lecture 31:Heat Map2

Lecture 32:Heat Map3

Lecture 33:Heat Map4

Lecture 34:Scattered chart

Lecture 35:Line Chart Dual Axis

Lecture 36:Line Char Size Measure

Lecture 37:Line Chart multidimension and measures

Section 7 : Tableau Filters

Filters

Rating Distribution

• 1 stars: 0 votes
• 2 stars: 0 votes
• 3 stars: 1 votes
• 4 stars: 0 votes
• 5 stars: 3 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!