Getting Started with Power BI

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

This course teaches you the basic skills required for using Power BI to acquire and transform data, enhance the data for analysis, and produce reports and dashboards.

01. Course Overview

01. Course Overview

02. Introducing Power BI

02. Introducing Power BI

03. Introducing Globomantics Requirements

04. Power BI Key Ideas

05. Datasets Data Models and Data Files

06. Signing up for the Power BI Service

07. Uploading a PBIX File to the Power BI Service

08. Using Quick Insights

09. Viewing Reports

10. Dashboard Features

11. Exploring a Dashboard

12. Choosing a Development Tool

13. Power BI Desktop Workflow

14. Getting Familiar with Power BI Desktop

15. Using Excel for Power BI Development

16. Summary

03. Getting Data

17. Getting Data

18. Supported Data Sources

19. Accessing Data Sources

20. Globomantics Data Sources

21. Getting Data from Databases

22. Getting Data from Individual Files

23. Getting Data from a Group of Files

24. Getting Data from Individual Files in Power Query Editor

25. Getting Data from the Web and Manual Entry

26. Loading the Data Model

27. Getting Data into the Excel Data Model

28. Summary

04. Transforming Data

29. Transforming Data

30. Renaming Queries

31. Appending Queries

32. Grouping Queries

33. Promoting Headers

34. Fixing Column Metadata

35. Filtering Rows

36. Eliminating Columns

37. Merging Queries

38. Adding Columns by Splitting Text

39. Adding Columns by Splitting XML

40. Adding Columns for Sorting

41. Disabling the Data Load for Selected Queries

42. Transforming Data in Excel

43. Summary

05. Modeling Data for Analysis

44. Modeling Data for Analysis

45. Reviewing Missing Relationships

46. Creating a Relationship

47. Creating More Relationships

48. Defining New Columns

49. Concatenating Columns

50. Performing a Lookup to a Related Table

51. Translating a Value

52. Using the If Function

53. Adding a Date Table

54. Modeling Data in Excel

55. Summary

06. Enhancing the Data Model

56. Enhancing Data Models

57. Defining Hierarchies

58. Configuring Properties

59. Hiding Objects and Configuring the Sort by Columns

60. Configuring Data Categories Formatting and Default Summarization

61. Creating Measures

62. Defining the Customer Count Measure

63. Defining the Percent of Total Customers Measure

64. Defining the Total Sales Measure

65. Defining the Previous Year Sales Measure

66. Enhancing the Excel Data Model

67. Summary

07. Visualizing Data

68. Visualizing Data

69. Globomantics Requirements

70. Creating a Table

71. Creating a Clustered Column Chart

72. Creating a Bar Chart

73. Creating a Map

74. Creating a Card

75. Creating a Matrix

76. Globomantics Requirements

77. Creating and Adjusting a Clustered Column Chart

78. Creating a Filled Map

79. Creating a KPI

80. Filtering

81. Slicer Filtering

82. Highlighting

83. Setting Properties

84. Drilling within a Hierarchy

85. Visualizing Data in Excel Part 1

86. Visualizing Data in Excel Part 2

87. Summary

08. Refreshing Data

88. Refreshing Data

89. Publishing to Power BI

90. Power BI Gateway

91. Rules for Refreshing Data

92. Summary

45,900 تومان

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

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

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

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