[3-in-1] Data Viz Bundle: Tableau, Excel & Looker Studio

سرفصل های دوره

Learn and compare the three most used data visualization tools in one course- Tableau, Microsoft Excel & Google's Looker

1. Introduction

1. Introduction

2. Course Resources.html

3. Why Tableau

4. This is a milestone!

5. Tableau Products

2. Installation and getting started

1. Installing Tableau desktop and Public

2. About the data

3. Connecting to data

4. Live vs Extract

3. Combining data to create Data model

1. Combining data from multiple tables

2. Relationships in Tableau

3. Joins in Tableau

4. Types of Joins in Tableau

5. Union in Tableau

6. Physical Logical layer and Data models

7. The visualization screen - Sheet

4. Data categorization in Tableau

1. Types of Data - Dimensions and Measures

2. Types of Data - Discreet and Continuous

3. Changing Data type in Tableau

5. Most used charts

1. Bar charts

2. Line charts

3. Scatterplots

6. Customizing charts using Marks shelf

1. Marks cards

2. Dropping Dimensions and Measures on marks card

3. Dropping Dimensions on Line chart

4. Adding marks in scatterplot

7. Other important charts

1. Text tables, heat map and highlight tables

2. Pie charts

3. Area charts

4. Creating custom hierarchy

5. Tree map

6. Dual combination charts

7. Creating Bins

8. Histogram

8. Grouping and Filtering data

1. Grouping Data

2. Filtering data

3. Dimension filters

4. Measure filters

5. Date-Time filters

6. Filter options

7. Types of filters and order of operation

8. Customizing visual filters

9. Sorting options

9. Map chart in Tableau

1. How to make a map chart

2. Considerations before making a Map chart

3. Marks card for customizing maps

4. Customizing maps using map menu

5. Layers in a Map

6. Visual toolbar on a map

7. Custom background images

8. Territories in maps

9. Data blending for missing geocoding

10. Calculations and Analytics

1. Calculated fields in Tableau

2. Functions in Tableau

3. Table calculations theory

4. Table calculations in Tableau

5. Understanding LOD expressions

6. LOD expressions examples

7. Analytics pane

11. Sets and Parameters

1. Understanding sets in Tableau

2. Creating Sets in Tableau

3. Parameters

12. Dashboard and Story

1. Dashboard part -1

2. Dashboard part - 2

3. Story

13. Appendix

1. Connecting to SQL data source

2. Connecting to cloud storage services

14. Excel Charts

1.1 01 Why charts.pdf

1. Why are charts used

15. Excel Charts Basics

1.1 02 Conveying+Message.pdf

1. Excel Charts - Categories of messages that can be conveyed

2.1 03 Chart Elements.pdf

2. Elements of charts

3.1 04 oneclick.xlsx

3. The easy way of creating charts

16. Most important Charts And Best practices

1.1 05 Column Charts.xlsx

1. Bar and column charts

2.1 06 formatting.xlsx

2. Formatting charts - Part - 1

3. Formatting charts - Part 2

4.1 05 bar+chart adv.pdf

4. Best Practices Bar chart

5.1 07 Line charts.xlsx

5. Line Charts

6.1 10 Avoiding+Spaghetti+plot.pdf

6. Avoiding the Spaghetti plot

7.1 07 Area charts.xlsx

7. Area Charts

8.1 09 Pie charts.xlsx

8. Pie and Doughnut Charts

9.1 06 pie.pdf

9. Why we should avoid Pie charts

10.1 09 Scatter charts.xlsx

10. Scatter plot or XY chart

11. Frequency Distribution and Histograms

12. Waterfall Charts

13.1 18 combine charts.xlsx

13. Combination charts

14.1 08 Highlighting+message.pdf

14. Highlighting chart message

15.1 11 Eliminating distraction+.pdf

15. Eliminating Distractions from the Graph

16.1 08 Avoiding+Clutter.pdf

16. Avoiding clutter

17. Pivot Charts

1. Pivot table

2. Pivot Charts

18. Less used charts

1.1 10 Stock.xlsx

1. Stock charts

2.1 12 Radar.xlsx

2. Radar charts

3.1 13 Surface.xlsx

3. Surface charts

4.1 16 heatmap.xlsx

4. Heatmaps

19. Sparklines

1.1 19 sparklines.xlsx

1. Mini charts Sparklines

20. Infographics using Excel charts

1.1 Lecture 15 Infographics.xlsx

1. Creative Infographic 1

2.1 Lecture 16 Infographics.xlsx

2. Creative Infographic 2

21. New! Maps chart - Excel 2019 and above

1.1 Lecture Maps Solved.xlsx

1.2 Lecture Maps Unsolved.xlsx

1. Maps chart

22. Looker Studio

1. Why Data Studio

23. Terminologies And Theoretical concepts for Data Studio

1. Data Studio Home Screen And Dataset vs Data Source

2. Structure of Input data

3. Dimensions vs Measures (new definition)

24. Practical part begins here

1. Opening Data Studio and preparing data

2. Adding data source

3. Managing added data source

25. Charts to highlight numbers

1. Data Table

2. Styling tab for data table

3. Scorecards

26. Charts for comparing categories Bar charts and stacked charts

1. Simple Bar and Column chart

2. Stacked Column chart

27. Charting maps of a country, continent, or region - Geomaps

1. GeoMap

28. Charting to highlight trends Time Series, Line and Area charts

1. Time Series

2. Update to Time Series chart

3. Line Chart and Combo Chart

29. Highlighting contribution to total Pie charts And Donut Chart

1. Pie Chart and Donut Chart

2. Stacked Area Charts

3.1 Areachart updated (1).csv

3. Updated data file for area chart.html

30. Relationship between two or more variables Scatter plots

1. Scatter Plots and Bubble charts

31. Aggregating on two dimensions Pivot tables

1. Pivot tables for cross tabulation

32. All about a single Metric Bullet Chart

1. Bullet Chart

33. Chart for highlighting heirarchy TreeMap

1. TreeMaps

34. Branding a Report

1. Branding a Report Brand Logo and Company Details

2. Brand colors for report branding

35. Giving the power to filter Data to viewers

1. Filter controls for viewers

36. Add Videos, Feedback form etc. to your Report

1. URL Embed to include external content

37. Sometimes data is in multiple tables

1. Blending data from multiple tables

2. Different types of Joins while blending data

38. Sharing and Collaborating on Data Studio report

1. Downloading report as PDF and Page Management

2. Sharing report and Data Credentials

3. Sharing report using a link

4. Scheduling emails

5. Embeding report on Website

39. Google BigQuery Connection

1. Connecting and Visualizing Data in Google BigQuery

40. Charting Best Practices

1. Highlighting chart message

2. Eliminating Distractions from the Graph

3. Avoiding clutter

4. Avoiding the Spaghetti plot

5. The final milestone!

41. Congratulations And about your certificate

1. Bonus Lecture.html

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training