Become A Microsoft Power BI Data Analyst

Focused View

Skill Tree

9:06:33

10 View

1 - Get Started with Microsoft Data Analytics

1 - Introduction.html

2 - What is Microsoft Data Analytics.mp4

04:50

3 - Overview of Data Analysis.mp4

08:14

4 - Roles in Data Analysis.mp4

09:14

5 - Tasks of a Data Analyst.mp4

10:38

2 - Power BI Setup

6 - What is Power BI.mp4

05:47

7 - What is Power BI Desktop.mp4

03:40

8 - Install Power BI Desktop.mp4

02:55

9 - Exploring Power BI Desktop Interface.mp4

05:02

10 - Microsoft 365 Setup.mp4

03:43

11 - Getting started with Microsoft 365.mp4

04:04

12 - Creating a new user account in Microsoft 365.mp4

02:54

3 - Microsoft SQL Server Setup

13 - What is SQL Server.mp4

02:57

14 - SQL Server Editions.mp4

04:45

15 - SQL Server Installation Requirements.mp4

04:21

16 - Download SQL Server.mp4

04:31

17 - SQL Server Installation.mp4

09:43

18 - SQL Server Configuration Manager.mp4

08:10

19 - Installing SQL Server Management Studio.mp4

05:48

20 - Connect to SQL Server with SSMS.mp4

02:16

21 - AdventureWorksDW2020.zip

21 - Restore AdventureWorksDW2020 Database.mp4

03:41

4 - Overview of Power BI

22 - Power BI Overview Part 1.mp4

04:24

23 - Power BI Overview Part 2.mp4

04:05

24 - Power BI Overview Part 3.mp4

04:49

25 - Changing regional settings.mp4

01:47

26 - Parts of Power BI.mp4

02:57

27 - Power BI Building blocks.mp4

09:31

28 - Exploring Power BI Service.mp4

04:28

5 - Connect Transform Visualize and Publish Web Data

29 - Shaping data.html

30 - Connect to Web Data.mp4

05:07

31 - Clean & transform data Part 1.mp4

07:12

32 - Clean & transform data Part 2.mp4

09:45

33 - Combine data sources.mp4

07:59

34 - Creating Data Visuals Part 1.mp4

06:09

35 - Creating Data Visuals Part 2.mp4

05:23

36 - Publish report to Power BI Service.mp4

04:47

6 - Preparing Data in Power BI Desktop

37 - Create a new Power BI Desktop file.mp4

02:12

38 - Set Power BI Desktop Options.mp4

02:04

39 - Get data from a relational database SQL Server.mp4

05:51

40 - ColorFormats.csv

40 - Get data from CSV file.mp4

05:07

40 - ResellerSalesTargets.csv

40 - ResellerSales-202006.csv

41 - Get additional data from csv file.mp4

02:51

7 - Clean transform and load data into Power BI

42 - Configure the Salesperson Region query.mp4

01:50

43 - Configure the Product query.mp4

07:22

44 - Configure the Reseller query.mp4

04:58

45 - Configure the Region query.mp4

02:40

46 - Configure the Sales query.mp4

05:55

47 - Configure the Targets query.mp4

05:50

48 - Configure the ColorFormats query.mp4

00:42

49 - Update the Product query.mp4

02:33

50 - Update the ColorFormats query.mp4

01:49

8 - Model Data in Power BI Desktop

51 - Create Model Relationships.mp4

13:19

52 - Configure the Product table.mp4

03:37

53 - Configure the Region table.mp4

02:56

54 - Configure the Reseller table.mp4

05:20

55 - Configure the Sales table.mp4

02:48

56 - Bulk update properties.mp4

03:07

57 - Review the model interface.mp4

04:40

58 - Create quick measures.mp4

06:36

59 - Create a manytomany relationship.mp4

10:03

60 - Relate the Targets Table.mp4

01:56

61 - Enforce rowlevel security.mp4

05:14

9 - Using DAX in Power BI

62 - What is DAX.html

63 - Create the Salesperson Calculated table.mp4

07:23

64 - Create the Date calculated table.mp4

03:17

65 - Create calculated columns.mp4

06:55

66 - Complete the Date table.mp4

04:40

67 - Mark the Date table.mp4

02:21

68 - Create simple Measures.mp4

16:56

69 - Create additional measures.mp4

11:07

10 - Time Intelligence and Measures

70 - Create a matrix visual.mp4

03:53

71 - Manipulate filter context.mp4

15:40

72 - Create a YTD measure.mp4

02:46

73 - Create a YoY growth measure.mp4

06:45

74 - Publish Power BI Desktop File.mp4

04:15

11 - Design and Publish Reports in Power BI

75 - Create a new file.mp4

00:41

76 - Create a live connection.mp4

02:13

77 - Design page 1.mp4

14:11

78 - Design page 2.mp4

06:57

79 - Design page 3.mp4

10:00

80 - Publish report.mp4

01:17

81 - Explore the report in Power BI Service.mp4

05:23

82 - Configure Sync Slicers.mp4

05:21

83 - Configure drill through page.mp4

06:01

84 - Add Conditional Formatting.mp4

04:28

85 - Add Bookmarks to Report.mp4

05:30

86 - Add Buttons to Report.mp4

04:30

87 - Publish Updated Report.mp4

01:53

88 - Explore Updated Report.mp4

02:53

12 - Create Power BI Dashboards

89 - Create a dashboard.mp4

07:21

90 - Configure an alert.mp4

00:45

91 - Refresh the dataset.mp4

08:28

13 - Perform data analysis in Power BI Desktop

92 - Create the report.mp4

00:38

93 - Connect to the Sales Analysis Dataset.mp4

01:18

94 - Create an animated scatter chart.mp4

04:50

95 - Create a forecast.mp4

05:31

96 - Work with a decomposition tree.mp4

04:37

97 - Work with key influencers.mp4

05:16

14 - Create Paginated Reports

98 - What are paginated reports.mp4

00:30

99 - Install Power BI report builder.mp4

02:47

100 - Create a blank report.mp4

01:22

101 - Configure the report header.mp4

04:34

102 - Create a data source and dataset.mp4

06:13

103 - Configure the report parameter.mp4

02:29

104 - Add textboxes to report header region.mp4

10:11

105 - Add a table to the report.mp4

04:35

106 - Format the table data region.mp4

09:46

107 - Finalize the report design.mp4

11:10

Description

Ingest, clean, transform and model data | Design and create reports for data analysis

What You'll Learn?

Learn how to ingest, clean, transform, and model data
Model data for performance and scalability
Apply and perform advanced report analytics
Explore the different roles in data
Identify the tasks that are performed by a data analyst
Get data from various data sources
Identify and retrieve data from different data sources
Understand the connection methods and their performance implications
Design and create reports for data analysis
Manage and share report assets
Create paginated reports

Who is this for?

Beginner Power BI Data Analyst

Beginner Data Analyst

What You Need to Know?

Understanding core data concepts is advised but not mandatory

Basic knowledge of Excel is advised but not mandatory

Basic knowledge of relational databases is advised but not mandatory

More details

Description
The Power BI data analyst delivers actionable insights by leveragingÂ available data and applying domain expertise.
The Power BI data analyst collaborates with key stakeholders across verticals to identify business requirements, cleans and transforms the data, and then designs and builds data models by using Power BI.
The Power BI data analyst provides meaningful business value through easy-to-comprehend data visualizations, enables others to perform self-service analytics, and deploys and configures solutions for consumption.

Businesses need data analysis more than ever. In this learning path, you will learn about the life and journey of a data analyst, the skills, tasks, and processes they go through in order to tell a story with data so trusted business decisions can be made. You will learn how the suite of Power BI tools and services are used by a data analyst to tell a compelling story through reports and dashboards, and the need for true BI in the enterprise.
This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
Who this course is for:
Beginner Power BI Data Analyst
Beginner Data Analyst

User Reviews

Rating

average 0

Total votes0

Focused display

We are experienced company that provides quality video based training .Our courses are easy to follow and understand and will take you froman absolute beginner with no technical skills to being efficient and confident with various technical skill like SQL and databases.We have worked with companies of various sizes and provided consultancy services at various levels.Thank you for learning with us and we hope your experience will be pleasant.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.