Power BI and Tableau for Data Visualization [2-in-1 Bundle]

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

Learn the top 2 data visualization tools - Power BI and Tableau in 1 course | Beginner friendly | Basic to Advance Level

1. Introduction

1. Introduction

2.1 PowerBI and Tableau Course resources.zip

2. Course resources.html

3. This is a milestone

2. Installation and Setting up Power BI Desktop

1. Installation and Setting up Power BI Desktop

2. About the data and the way forward

3. Connecting Power BI to different Data Sources

1. Connecting to a CSV file

2. Connecting to an SQL database

3. Getting data from all files in a folder

4. Getting data from an XML file

4. Preparing and Manipulating data using Power Query

1. Introduction to Power Query Editor

2. Important checks before we transform data

3. Merging and Appending Queries - Theory

4. Appending queries in Power Query

5. Merging queries in Power Query

6. Manage table rows and columns

7. Split Column tool

8. Replace Values tool

9. Group By tool

10. Pivoting and unpivoting - Theory

11. Pivoting and unpivoting in Power Query

12. Extract tool

13. Format Text options

14. Number transformations

15. Date and Time transformations

5. Adding new columns using Power Query

1. Add column from examples

2. Add a custom column

3. Add conditional and Index column

6. Creating a data model using relationships

1. Introduction to Model View

2. Creating and modifying relationships

3. Cardinality and cross filter direction

4. Fact and Dimension tables

5. Star and Snowflake schemas

6. Data Pane and the Properties Pane

7. Creating Charts and Visuals in Power BI

1. Bar chart and Column chart

2. Clustered Bar chart and Stacked Bar chart

3. Chart formatting options

4. Small multiples, Tooltips and Drill Through

5. Line chart and Area chart

6. Combination chart or a combo chart

7. Pie chart and Donut chart

8. Scatter chart and Bubble chart

9. Applying filters

10. Add Further Analysis tab

11. Table and Matrix Visuals

12. Card and Multi-row cards

13. Hierarchies in Power BI

14. Tree map

15. Map charts for showing geographical data

16. Conditional formatting of charts

8. Advanced Charts

1. Gauge Chart

2. KPI Chart

3. Funnel Chart

4. Ribbon Chart

9. Data analysis using DAX

1. Introduction to DAX

2. DAX syntax and Row context vs Filter context

3. Types of operators and functions

4. Demonstration of new columns and new measures

5. Using explicit measures to create new measures

6. IF function with Logical operators

7. COUNT and DISTINCTCOUNT functions

8. RELATED function

9. CALCULATE function

10. All Function

11. Filter function

12. SUMX Iterator function

13. DATESYTD and DATEADD- Time intelligence function

10. Creating Beautiful and Interactive Reports in Power BI

1. Introduction to reports

2. Formatting report page and creating a template

3. Slicers on report page

4. Drill-through for report pages

5. Adding a page navigator

6. Adding Bookmarks to the report

11. TABLEAU STARTS HERE!

1.1 Tableau connection - Power BI vs Tableau.pdf

1. Comparision between Power BI vs Tableau

12. Installation and getting started With Tableau

1. Tableau Products

2. Installing Tableau desktop and Public

3. About the data

4. Connecting to data

5. Live vs Extract

13. Combining data to create Data model

1. Relationships in Tableau

2. Combining data from multiple tables

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

14. Data categorization in Tableau

1. Types of Data - Dimensions and Measures

2. Types of Data - Discreet and Continuous

3. Changing Data type in Tableau

15. Most used charts

1. Bar charts

2. Line charts

3. Scatterplots

16. 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

17. 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

18. 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

19. 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

20. 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

21. Sets and Parameters

1. Understanding sets in Tableau

2. Creating Sets in Tableau

3. Parameters

22. Dashboard and Story

1. Dashboard part -1

2. Dashboard part - 2

3. Story

23. Saving and Sharing your work

1.1 Saving and sharing your work.pdf

1. Saving and sharing tableau workbook

2. Saving and sharing data

3. Saving and sharing views and dashboards

24. Appendix

1. Connecting to SQL data source

2. Connecting to cloud storage services

3. The final milestone!

25. Congratulations and about your certificate

1. Bonus lecture.html

45,900 تومان

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

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

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

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