
Connect to a database in Tableau by creating a new data source and selecting Excel. Drag the orders table to view data; live and extract connections will be covered next.
Explore granularity by dividing data into chunks, illustrated with pizza slices and Tableau sales analysis. Learn to use dimensions and subcategories to reveal grand totals and insights.
Convert a table to a bar chart in Tableau by placing the product subcategory in rows, dragging sales to marks and columns, then apply ascending or descending sorts.
Learn to create a line chart in Tableau for beginners by dragging product name to rows and sales to columns, then swap to a line chart using the mark shelf.
Create a bar chart in Tableau by dragging product subcategory and sales to columns, toggle between dimension and measure, and sort results ascending or descending, with sales numbers shown.
Create a bar chart in Tableau by dragging product subcategory to rows and measure value sales to columns, set as text, and sort descending to display size by sales.
Discover how to build a dual-axis bar chart in Tableau by pairing sales and profit, using subcategory on rows and measures on columns, with proper mark types and view adjustments.
Learn heat map chart three to visualize sales with two dimensions (product category and subcategory or other) using color and size by sales, with square boxes and drill-down by year.
Learn to build a line chart in Tableau, use the size measure to adjust line width, place product subcategory on rows, sort sales in descending order, and compare outputs.
Learn to apply mesa filter in Tableau, along with dimension and measure filters, using range, at least, at most, and special values, plus non-null handling and category and subcategory filters.
WHO'S THIS FOR?
This course is designed specifically for freshers and absolute beginners only.
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.
PROBLEMS YOU'VE EXPERIENCED WITH EXCEL IN THE PAST
Excel becomes slow or crashes when you have lots of data, formatting and Charts inside a workbook.
Mistakenly working on the wrong file you saved.
It’s so annoying to email multiple Excel files to the same people everyday.
It takes hours to create a dashboard with multiple charts and formula functions.
Some time Excel files are used to store the large amount data which is a very wrong decision because to update the data everyday on that file is a headache because it takes so much time to get open and then to get save.
Note : Excel is also an Excellent Application. Yes Excel has some draw backs but it doesn't means its useless. Excel is also the Excellent tool to visualize and analyze the data.
Section 1:Introduction
Lecture 1:Introduction
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
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