Modeling Data in Power BI

Focused View

Stacia Misner Varga

4:56:37

52 View

01 - Course Overview

01 - Course Overview.mp4

02:02

02 - Using the Query Editor to Prepare a Power BI Data Model

02 - Overview.mp4

01:38

03 - Loading Data.mp4

01:48

04 - Exploring Power BI Data Sources.mp4

03:57

05 - Databases - DirectQuery and Analysis Services Connect Live.mp4

02:39

06 - Demonstration Data Overview.mp4

04:44

07 - Loading the Demonstration Data - Single TSV Files and Groups of Files.mp4

05:20

08 - Loading the Demonstration Data - CSV Files.mp4

01:19

09 - Loading the Demonstration Data - XML and HTML Table.mp4

02:34

10 - Saving the Demonstration Data and Counting Loaded Rows.mp4

05:16

11 - Shaping Data - The Basics.mp4

01:42

12 - Filtering Rows in a Query.mp4

02:58

13 - Eliminating Columns in a Query.mp4

03:33

14 - Combining Queries.mp4

05:39

15 - Fixing Metadata.mp4

04:42

16 - Summary.mp4

01:44

03 - Exploring Additional Techniques in the Power BI Query Editor

17 - Overview.mp4

02:47

18 - Query Enhancements.mp4

01:26

19 - Adding Columns by Expanding XML.mp4

02:04

20 - Adding Columns by Splitting by Delimiter.mp4

02:50

21 - Adding Custom Columns.mp4

04:46

22 - Converting an Epoch Timestamp.mp4

02:35

23 - Renaming Queries.mp4

02:19

24 - Restructuring Data.mp4

01:30

25 - Duplicating vs. Referencing a Query.mp4

03:50

26 - Using Unpivot.mp4

02:17

27 - Introducing Custom Functions.mp4

02:43

28 - Reviewing a Custom Function to Expand XML.mp4

04:59

29 - Naming and Using a Custom Function.mp4

03:18

30 - Consolidating the Data Model by Merging Queries.mp4

05:41

31 - Data Cleansing.mp4

01:19

32 - Using Data Cleansing Transformations.mp4

04:40

33 - Summary.mp4

02:25

04 - Enhancing a Power BI Model with Relationships and Hierarchies

34 - Overview.mp4

01:43

35 - Understanding Relationships.mp4

03:10

36 - Checking for Relationship Problems in the Model.mp4

03:26

37 - Introduction to Managing Relationships.mp4

01:30

38 - Reviewing and Creating Relationships in the Model.mp4

04:15

39 - Using the Relationship Editor.mp4

02:46

40 - Resolving Relationship Issues by Fixing Data Quality.mp4

02:48

41 - Introducing Bridge Table Relationships.mp4

02:32

42 - Resolving Relationship Issues with a Bridge Table.mp4

06:10

43 - Working with Hierarchies (Ad Hoc).mp4

04:08

44 - Adding a Permanent Hierarchy to the Model.mp4

04:13

45 - Summary.mp4

00:57

05 - Improving the Data Model for Reporting

46 - Overview.mp4

01:21

47 - Configuring Model Properties.mp4

03:03

48 - Renaming and Hiding Columns and Reviewing Sort by Column.mp4

04:53

49 - Configuring Column Data Types and Formatting.mp4

04:34

50 - Configuring Default Summarization.mp4

03:37

51 - Using Data Categories.mp4

01:38

52 - Preparing Data for Geographic Data Categories.mp4

05:42

53 - Assigning Fields to Geographic Data Categories.mp4

01:23

54 - Assigning Fields to the Web URL Data Category.mp4

02:19

55 - Enhancing the Model for Q&A.mp4

02:16

56 - Adding a Synonym to the Model.mp4

04:40

57 - Exploring Q&A Linguistic Issues in the Model.mp4

01:58

58 - Introducing the Power BI Linguistic Schema.mp4

05:06

59 - Editing the Linguistic Schema.mp4

04:53

60 - Summary.mp4

01:18

06 - Using DAX to Enhance a Power BI Model

61 - Overview.mp4

02:09

62 - Introducing DAX.mp4

01:52

63 - Defining New Columns - Concatenating Columns.mp4

05:17

64 - Defining New Columns - Translating a Value.mp4

05:51

65 - Using Variables in a DAX Expression.mp4

02:01

66 - Defining New Columns - Performing a Lookup to a Related Table.mp4

05:47

67 - Creating Measures.mp4

03:46

68 - Adding Measures to the Model.mp4

04:50

69 - Using DAX Parameters - Creating Query Parameters.mp4

05:17

70 - Using DAX Parameters - Using Query Parameters.mp4

02:40

71 - Using DAX Parameters - Working with What if Parameters.mp4

05:13

72 - Summary.mp4

02:25

07 - Working with Dates and Time in Power BI

73 - Overview.mp4

01:36

74 - Creating a Calculated Date Table.mp4

02:45

75 - Using DAX Functions for Date and Time Operations.mp4

03:53

76 - Creating Calculated Columns for a Date Table.mp4

04:01

77 - Working with Date Hierarchies.mp4

03:41

78 - Applying Time Intelligence.mp4

01:23

79 - Using the TOTALYTD() Function.mp4

04:11

80 - Using the CALCULATE() Function with the SAMEPERIODLASTYEAR() Function.mp4

03:25

81 - Using the OPENINGBALANCEMONTH() Function.mp4

03:08

82 - Summary.mp4

00:58

08 - Applying Evaluation Context

83 - Overview.mp4

01:31

84 - Exploring Row Context.mp4

01:20

85 - Using the RELATED() Function to Explore Row Context.mp4

04:20

86 - Using the AVERAGEX() Iterator Function.mp4

04:07

87 - Understanding Filter Context.mp4

02:08

88 - Using the CALCULATE() Function with ALL() .mp4

02:50

89 - Using the CALCULATE() Function with KEEPFILTERS().mp4

03:13

90 - Working with Parent-child Functions.mp4

01:04

91 - Using the PATH() and PATHITEM() Functions.mp4

03:22

92 - Using the PATHLENGTH() and ISFILTERED() Functions.mp4

05:05

93 - Summary.mp4

02:05

Description

Learn how to work with data that comes from different sources and is structured in different ways by using Power BI transformations to combine, reshape, cleanse, and enhance that data to create a model that supports reporting and analytics.

What You'll Learn?

Data in its raw form is rarely useful for reporting and analysis. In this course, Modeling Data in Power BI, you'll learn how to use Power BI to transform raw data into meaningful insights. First, you'll learn how to gather data and apply transformations to easily blend multiple sources together, reduce the data to its most useful elements, and prepare the data for exploration. Next, you'll discover how to configure the model to support Power BI features for insightful visualizations, geospatial analysis, and natural language queries. Finally, you'll explore the basics of DAX, Power BI's expression language, to add calculations to your model. When you're finished with this course, you'll have the skills and knowledge of Power BI data modeling that you can use to build your own models that support a variety of analytical requirements and take full advantage of Power BI's capabilities.

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.