Power Query, Power Pivot, Data Viz & Power BI – 4in1 POWER

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

POWER course bundle for every Excel user & Power BI developer - Start a new life with Power tools

1. Power Query for Excel & Power BI users

1. Power Query for Excel & Power BI -1.1. Append workbooks

2. 1.2. DYI Append two sheets of the same workbook

3. 1.3. Get data from folder of Excel files

4. 1.4. DYI Get data from folder of CSV files

5. 1.5. Get data from sheets with different names

6. 1.6. Appending problems

7. 2.1. Merge Excel sheets

8. 2.2. Merge scenarios

9. 2.3. DYI Merge

10. 3.1. Create a pivot table on a query

11. 3.2. New columns for pivot tables

12. 3.3. DYI Operating on columns

13. 3.4. Column from examples

14. 4.1. Group by = Pivot table

15. 5.1. Unpivot

16. 5.2. Unpivot dates

17. 5.3. Pivot column

18. 6.1. Get data from Web

19. 6.2. Get data from Web 2

20. 6.3. Get data from SQL

21.1 Power Query course.zip

21. 7. Repetition

2. Data model & DAX language for Excel Power Pivot & Power BI users

1.1 Data model & DAX language course.zip

1. 1.1. Where to find data model in Power Pivot and Power BI

2. 1.2. How not to build a data model in Excel

3. 1.3. Creating queries in Power Query

4. 1.4. Creating relations in Power Pivot

5. 2.1. Designing a pivot table

6. 2.2. Product with no sales and basics of data model

7. 2.3. Distinct count

8. 2.4. Drill down

9. 3.1. Creating a hierarchy

10. 3.2. Hierarchy in a Pivot table

11. 3.3. Hierarchy on a slicer

12. 4.1. Creating a date table

13. 4.2. Hiding fields in Power Pivot

14. 4.3. Sorting by column

15. 5.1. My first measure SUM

16. 5.2. DIY SUM

17. 5.3. DIVIDE

18. 5.4. COUNT

19. 5.5. DIY COUNT

20. 5.6. COUNT vs COUNTROWS

21. 5.7. DIY basic formulas

22. 6.1. SUMIF vs SUM in a pivot table

23. 6.2. CALCULATE 6

24. 6.3. Pivot table not working filter context

25. 6.4. Basic measures with columns

26. 6.5. Limitations 6

27. 6.6. DIY CALCULATE

28. 7.1. SUMPRODUCT in Excel

29. 7.2. SUMX

30. 7.3. AVERAGEX

31. 7.4. DIY formulas with X

32. 7.5. Context transition

33. 8.1. SEARCH, FIND, IF, BLANK, SWITCH

34. 8.2. VALUES

35. 8.3. HASONEVALUE

36. 8.4. Other formulas DIY

37. 9.1. ALL on a table

38. 9.2. ALL on column and ALLEXCEPT

39. 9.3. ALLSELECTED

40. 9.4. DYI ALL functions

41. 10.1. How does the FILTER work

42. 10.2. FILTER with CALCULATE

43. 10.3. Row and filter context

44. 10.4. CALCULATE and CALCULATE with FILTER

45. 10.5. DIY FILTER

46. 11.1. SAMEPERIODLASTYEAR

47. 11.2. Year-To-Date

48. 11.3. Last Month

49. 11.4. Time formulas without Time Intelligence

3. Data visualization and dashboard design course

1.1 Data Visualization & Dashboard Design course.zip

1. Data Visualization & Dashboard-1.1. Simplicity is the ultimate sophistication

2. Data Visualization & Dashboard-1.2. Perception process

3. Data Visualization & Dashboard-1.3. Iconic memory and pre-attentive attributes

4. Data Visualization & Dashboard-1.4. Short-term memory and the limit of 4

5. Data Visualization & Dashboard-1.5. Brief history of data visualization

6. Data Visualization & Dashboard-1.6. The most famous chart ever created

7. Data Visualization & Dashboard-1.7. 5 elements of the well-designed chart

8. Data Visualization & Dashboard-1.8. Data-ink ratio

9. Data Visualization & Dashboard-1.9. Data-ink ratio exercise

10. Data Visualization & Dashboard-1.10. DIY Test

11. Data Visualization & Dashboard-1.11. Test results

12. Data Visualization & Dashboard-1.12. 7 data visualization rules

13. Data Visualization & Dashboard-12.1. DIY Redesign the charts

14. Data Visualization & Dashboard-12.2. Exercise 1

15. Data Visualization & Dashboard-12.3. Exercise 2

16. Data Visualization & Dashboard-12.4. Exercise 3

17. Data Visualization & Dashboard-12.5. Exercise 4

18. Data Visualization & Dashboard-12.6. Exercise 5

19. Data Visualization & Dashboard-12.7. Exercise 6

20. Data Visualization & Dashboard-12.8. Exercise 7

21. Data Visualization & Dashboard-12.9. DIY Summary

22. Data Visualization & Dashboard-3.1. Column chart exercise

23. Data Visualization & Dashboard-3.2. Line chart exercise

24. Data Visualization & Dashboard-3.3. Scatter chart exercise

25. Data Visualization & Dashboard-3.4. DIY Additional elements exercise

26. Data Visualization & Dashboard-3.5. Financial chart exercise

27. Data Visualization & Dashboard-3.6. DIY Guess the relationship

28. Data Visualization & Dashboard-3.7. Graph Selection Matrix

29. Data Visualization & Dashboard-3.8. Good practices summary

30. Data Visualization & Dashboard-4.1. Rules of using colors

31. Data Visualization & Dashboard-4.2. DIY Color on a chart exercise

32. Data Visualization & Dashboard-4.3. DIY Color in a table exercise

33. Data Visualization & Dashboard-4.4. DIY Heat map on a pivot table exercise

34. Data Visualization & Dashboard-5.1. Cascade chart

35. Data Visualization & Dashboard-5.2. Pareto chart

36. Data Visualization & Dashboard-5.3. Histogram

37. Data Visualization & Dashboard-5.4. Box and whisker chart

38. Data Visualization & Dashboard-5.5. Funnel chart

39. Data Visualization & Dashboard-5.6. Panel chart (aka small multiples)

40. Data Visualization & Dashboard-5.7. DIY Panel chart

41. Data Visualization & Dashboard-5.8. Maps

42. Data Visualization6.1. DIY Find 2 differences & What would you tell the driver

43. Data Visualization & Dashboard-6.2. What is a dashboard

44. Data Visualization & Dashboard-6.3. Dashboard example

45. Data Visualization & Dashboard-6.4. Bullet graph

46. Data Visualization & Dashboard-6.5. Bullet graph exercise

47. Data Visualization & Dashboard-6.6. Sparklines

48. Data Visualization & Dashboard-6.7. Sparklines exercise

49. Data Visualization & Dashboard-6.8. Traffic lights & icons

50. Data Visualization & Dashboard-6.9. DIY Traffic lights & icons exercise

51. Data Visualization & Dashboard-6.10. Organize and add simple interactions

52. Data Visualization & Dashboard-6.11. Overview of well-designed dashboards

53. Data Visualization & Dashboard-7.1. Analytical dashboard vs Management dashboard

54. Data visualization and dashboard -7.2. KPIs exercise

55. Data visualization and dashboard -7.3. Table exercise

56. Data visualization and dashboard -7.4. Top 10 customers exercise

57. Data visualization and dashboard -7.5. Map exercise

58. Data visualization and dashboard -7.6. Slicers exercise

4. Quick start with Power BI

1. Quick start with Power BI-1.1. Introduction to Power BI

2. Quick start with Power BI-1.2. Interface & Getting data

3. Quick start with Power BI-1.3. My first column chart

4. Quick start with Power BI-1.4. Hierarchy on a chart

5. Quick start with Power BI-1.5. Hierarchy in the data model

6. Quick start with Power BI-1.6. Grouping data

7.1 1.7. dyi column chart.zip

7. Quick start with Power BI-1.7. DIY Column chart

8. Quick start with Power BI-1.8. Matrix = Pivot table

9.1 1.9. diy matrix.zip

9. Quick start with Power BI-1.9. DIY Matrix

10. Quick start with Power BI-1.10. Table = Pivot table

11. Quick start with Power BI-1.11. Line chart & Analytics

12. Quick start with Power BI-1.12. Explain the increase decrease

13.1 1.13. diy line chart.zip

13. Quick start with Power BI-1.13. DIY Line chart

14. Quick start with Power BI-1.14. Waterfall, Funnel chart, Treemap

15. Quick start with Power BI-1.15. Q&A

16. Quick start with Power BI-1.16. DIY Q&A

17. Quick start with Power BI-1.17. Scatter chart & Zoom slider

18. Quick start with Power BI-1.18. Maps

19.1 1.9. diy matrix.zip

19. Quick start with Power BI-1.19. DIY Maps

20. Quick start with Power BI-1.20. Chart interactions

21. Quick start with Power BI-Quick start with Power BI-1.21. Slicers

22. Quick start with Power BI-1.22. Slicers options

23. Quick start with Power BI-1.23. Publishing the report to Power BI Online

24.1 1.24. DYI Repetition.pptx

24.2 sales.xlsx

24. Quick start with Power BI-1.24. DYI Repetition

25. Quick start with Power BI-2.1. DIY Test your skillsData Visualization Basics

26. Quick start with Power BI-2.2. Data viz rules

27. Quick start with Power BI-2.3. DIY Exercise 1

28. Quick start with Power BI-2.4. DIY Exercise 2

29. Quick start with Power BI-2.5. DIY Exercise 3

30. Quick start with Power BI-2.6. DIY Exercise 4

31. Quick start with Power BI-2.7. DIY Exercise 5

32. Quick start with Power BI-2.8. DIY Exercise 6

33.1 Test.docx

33.2 test.zip

33.3 Test.xlsx

33. Quick start with Power BI-2.9. DIY Exercise 7

34. Quick start with Power BI-3.1. Creating a data model

35. Quick start with Power BI-3.2. Defining measures

36. Quick start with Power BI-3.3. Gauge

37. Quick start with Power BI-3.4. Conditional formatting

38. Quick start with Power BI-3.5. KPI chart

39. Quick start with Power BI-3.6. Sorting by column

40. Quick start with Power BI-3.7. URL image

41. Quick start with Power BI-3.8. Quick measures YTD

42. Quick start with Power BI-3.9. Quick measures YoY % change

43. Data model-3.10. Quick measures Average per category

44. Quick start with Power BI-3.11. Quick measures Filtered value

45.1 data model.zip

45.2 diy quick measures.zip

45.3 region.xlsx

45.4 sales.xlsx

45.5 targets.xlsx

45. Quick start with Power BI-3.12. DIY Quick measures

46.1 advanced & ai charts.zip

46.2 Hans Rosling.pptx

46.3 population 1960-2050.csv

46.4 Rosling.xlsx

46. Data model-Advanced & AI charts-4.1. Hans Roslings chart

47.1 advanced & ai charts.zip

47.2 power bi animations.zip

47. Quick start with Power BI-4.2. Animated charts

48. Quick start with Power BI-4.3. Small multiples

49. Quick start with Power BI-4.4. Histogram

50. Quick start with Power BI-4.5. Ribbon chart

51. Quick start with Power BI-4.6. Clusters

52. Quick start with Power BI-4.7. Dot plot

53. Quick start with Power BI-4.8. Explain distribution

54. Quick start with Power BI-4.9. Decomposition tree

139,000 تومان

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

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

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

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