Getting Started with Power BI

Focused View

Stacia Misner Varga

4:56:44

105 View

01. Course Overview

01. Course Overview.mp4

01:44

02. Introducing Power BI

02. Introducing Power BI.mp4

01:49

03. Introducing Globomantics Requirements.mp4

04:43

04. Power BI Key Ideas.mp4

04:16

05. Datasets Data Models and Data Files.mp4

01:48

06. Signing up for the Power BI Service.mp4

01:47

07. Uploading a PBIX File to the Power BI Service.mp4

02:00

08. Using Quick Insights.mp4

02:49

09. Viewing Reports.mp4

03:34

10. Dashboard Features.mp4

02:16

11. Exploring a Dashboard.mp4

02:53

12. Choosing a Development Tool.mp4

02:15

13. Power BI Desktop Workflow.mp4

01:33

14. Getting Familiar with Power BI Desktop.mp4

04:42

15. Using Excel for Power BI Development.mp4

03:57

16. Summary.mp4

01:26

03. Getting Data

17. Getting Data.mp4

01:56

18. Supported Data Sources.mp4

02:47

19. Accessing Data Sources.mp4

03:11

20. Globomantics Data Sources.mp4

02:30

21. Getting Data from Databases.mp4

05:05

22. Getting Data from Individual Files.mp4

03:43

23. Getting Data from a Group of Files.mp4

03:58

24. Getting Data from Individual Files in Power Query Editor.mp4

02:29

25. Getting Data from the Web and Manual Entry.mp4

03:28

26. Loading the Data Model.mp4

04:23

27. Getting Data into the Excel Data Model.mp4

07:17

28. Summary.mp4

01:10

04. Transforming Data

29. Transforming Data.mp4

01:26

30. Renaming Queries.mp4

04:21

31. Appending Queries .mp4

04:39

32. Grouping Queries.mp4

02:10

33. Promoting Headers.mp4

02:47

34. Fixing Column Metadata.mp4

04:36

35. Filtering Rows.mp4

02:57

36. Eliminating Columns.mp4

04:59

37. Merging Queries.mp4

05:47

38. Adding Columns by Splitting Text.mp4

02:41

39. Adding Columns by Splitting XML.mp4

05:48

40. Adding Columns for Sorting.mp4

03:17

41. Disabling the Data Load for Selected Queries.mp4

01:44

42. Transforming Data in Excel.mp4

02:04

43. Summary.mp4

00:58

05. Modeling Data for Analysis

44. Modeling Data for Analysis.mp4

01:49

45. Reviewing Missing Relationships.mp4

04:58

46. Creating a Relationship.mp4

07:20

47. Creating More Relationships.mp4

04:06

48. Defining New Columns.mp4

01:25

49. Concatenating Columns.mp4

06:13

50. Performing a Lookup to a Related Table.mp4

02:49

51. Translating a Value.mp4

02:27

52. Using the If Function.mp4

06:05

53. Adding a Date Table.mp4

06:17

54. Modeling Data in Excel.mp4

04:08

55. Summary.mp4

01:12

06. Enhancing the Data Model

56. Enhancing Data Models.mp4

01:59

57. Defining Hierarchies.mp4

03:36

58. Configuring Properties.mp4

01:42

59. Hiding Objects and Configuring the Sort by Columns.mp4

04:14

60. Configuring Data Categories Formatting and Default Summarization.mp4

02:55

61. Creating Measures.mp4

03:22

62. Defining the Customer Count Measure.mp4

02:40

63. Defining the Percent of Total Customers Measure.mp4

06:13

64. Defining the Total Sales Measure.mp4

02:25

65. Defining the Previous Year Sales Measure.mp4

05:25

66. Enhancing the Excel Data Model.mp4

04:17

67. Summary.mp4

00:52

07. Visualizing Data

68. Visualizing Data.mp4

01:24

69. Globomantics Requirements.mp4

02:25

70. Creating a Table.mp4

03:53

71. Creating a Clustered Column Chart.mp4

02:36

72. Creating a Bar Chart.mp4

02:29

73. Creating a Map.mp4

02:03

74. Creating a Card.mp4

01:07

75. Creating a Matrix.mp4

03:56

76. Globomantics Requirements.mp4

01:18

77. Creating and Adjusting a Clustered Column Chart.mp4

02:25

78. Creating a Filled Map.mp4

02:00

79. Creating a KPI.mp4

02:55

80. Filtering.mp4

04:13

81. Slicer Filtering.mp4

02:14

82. Highlighting.mp4

02:16

83. Setting Properties.mp4

06:31

84. Drilling within a Hierarchy.mp4

04:57

85. Visualizing Data in Excel Part 1.mp4

04:26

86. Visualizing Data in Excel Part 2.mp4

05:05

87. Summary.mp4

00:40

08. Refreshing Data

88. Refreshing Data.mp4

01:54

89. Publishing to Power BI.mp4

04:47

90. Power BI Gateway.mp4

03:08

91. Rules for Refreshing Data.mp4

03:07

92. Summary.mp4

00:43

Description

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.

What You'll Learn?

Power BI is a fantastic tool from Microsoft that helps you understand your data with interactive, easy-to-use visualizations. In this course, Getting Started with Power BI, you'll gain a fundamental understanding of the capabilities of Power BI. First, you'll learn how to work with reports and dashboards to develop an understanding of the model and reports that you’ll be building throughout the course. Then, you’ll discover how to quickly and easily gather data from a variety of sources, and cleanse and transform that data with just a few clicks. Next, you'll explore how you can enhance the results by integrating disparate data sources and adding simple calculations. Finally, you'll learn how to enable data exploration with visualizations in reports and the necessary steps to keep your data up-to-date. By the end of this course, you'll have a firm understanding of the basic skills required for using Power BI to acquire and transform data, enhance the data for analysis, and produce reports and dashboards.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Stacia Misner Varga

Instructor's Courses

Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.