Become A Power BI Data Analyst

Focused View

247 Learning

10:01:08

24 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

1. What is Power BI.mp4

05:47

2. What is Power BI Desktop.mp4

03:40

3. Install Power BI Desktop.mp4

02:55

4. Exploring Power BI Desktop Interface.mp4

05:02

3. Microsoft 365 Setup

1. Microsoft 365 Setup.mp4

03:43

2. Getting started with Microsoft 365.mp4

04:04

3. Creating a new user account in Microsoft 365.mp4

02:54

4. Overview of Power BI

1. Introduction.mp4

01:18

2. Power BI Overview Part 1.mp4

04:24

3. Power BI Overview Part 2.mp4

04:05

4. Power BI Overview Part 3.mp4

04:49

5. Changing regional settings.mp4

01:47

6. Parts of Power BI.mp4

02:57

7. Power BI Building blocks.mp4

09:31

8. Exploring Power BI Service.mp4

04:28

9. The flow of work in Power BI.html

10. Data refresh in Power BI.html

5. Power BI Data Sources

1. Getting data into Power BI Desktop.mp4

04:48

2. Connect to data in a file.mp4

02:57

3. Connect to data in a database.mp4

04:14

4. Connect to data in Power Platform.mp4

03:51

5. Connect to Azure SQL Database.mp4

02:39

6. Data source settings.mp4

05:48

7. Storage Modes.mp4

06:18

6. Connect, Transform, Visualize and Publish Web Data

1. Connect to Web Data.mp4

05:07

2. Clean & transform data Part 1.mp4

07:12

3. Clean & transform data Part 2.mp4

09:45

4. Combine data sources.mp4

07:59

5. Creating Data Visuals Part 1.mp4

06:09

6. Creating Data Visuals Part 2.mp4

05:23

7. Publish report to Power BI Service.mp4

04:47

7. Microsoft SQL Server Setup

1. What is SQL Server.mp4

02:57

2. SQL Server Editions.mp4

04:45

3. SQL Server Installation Requirements.mp4

04:21

4. Download SQL Server.mp4

04:31

5. SQL Server Installation.mp4

09:43

6. SQL Server Configuration Manager.mp4

08:10

7. Installing SQL Server Management Studio.mp4

09:43

8. Connect to SQL Server with SSMS.mp4

02:16

9.1 AdventureWorksDW2020.zip

9. Restore AdventureWorksDW2020 Database.mp4

03:41

8. Connect to data sources from Power BI

1. Create a new Power BI Desktop file.mp4

02:12

2. Set Power BI Desktop Options.mp4

02:04

3. Get data from a relational database (SQL Server).mp4

05:51

4. Preview SQL Server queries.mp4

10:16

5.1 ColorFormats.csv

5.2 ResellerSales_202006.csv

5.3 ResellerSalesTargets.csv

5. Get data from files ( CSV).mp4

05:07

6. Get additional data from files ( CSV).mp4

02:51

9. Clean, transform and load data into Power BI

1. Shape the initial data.html

2. Configure the Salesperson query.mp4

08:31

3. Configure the Salesperson Region query.mp4

01:50

4. Configure the Product query.mp4

07:22

5. Configure the Reseller query.mp4

04:58

6. Configure the Region query.mp4

02:40

7. Configure the Sales query.mp4

05:55

8. Configure the Targets query.mp4

05:50

9. Configure the ColorFormats query.mp4

00:42

10. Update the Product query.mp4

02:33

11. Update the ColorFormats query.mp4

01:49

10. Model Data in Power BI Desktop

1. Create Model Relationships.mp4

13:19

2. Configure the Product table.mp4

03:37

3. Configure the Region table.mp4

02:56

4. Configure the Reseller table.mp4

05:20

5. Configure the Sales table.mp4

02:48

6. Bulk update properties.mp4

03:07

7. Review the model interface.mp4

04:40

8. Create quick measures.mp4

06:36

9. Create a many-to-many relationship.mp4

10:03

10. Relate the Targets Table.mp4

01:56

11. Enforce row-level security.mp4

05:14

11. Working with DAX in Power BI

1. What is DAX.html

2. Create the Salesperson Calculated table.mp4

07:23

3. Create the Date calculated table.mp4

03:17

4. Create calculated columns.mp4

06:55

5. Complete the Date table.mp4

04:40

6. Mark the Date table.mp4

02:21

12. Time Intelligence and Measures

1. Create simple Measures.mp4

16:56

2. Create additional measures.mp4

11:07

3. Create a matrix visual.mp4

03:53

4. Manipulate filter context.mp4

15:40

5. Create a YTD measure.mp4

02:46

6. Create a YoY growth measure.mp4

06:45

7. Publish Power BI Desktop File.mp4

04:15

13. Design and Publish Reports in Power BI

1. Create a new file.mp4

00:41

2. Create a live connection.mp4

02:13

3. Design page 1.mp4

14:11

4. Design page 2.mp4

06:57

5. Design page 3.mp4

10:00

6. Publish report.mp4

01:17

7. Explore the report.mp4

05:23

8. Configure Sync Slicers.mp4

05:21

9. Configure drill through page.mp4

06:01

10. Add Conditional Formatting.mp4

04:28

11. Add Bookmarks to Report.mp4

05:30

12. Add Buttons to Report.mp4

04:30

13. Publish Updated Report.mp4

01:53

14. Explore Updated Report.mp4

02:53

14. Create Power BI Dashboards

1. Create a dashboard.mp4

07:21

2. Configure an alert.mp4

00:45

3. Refresh the dataset.mp4

08:28

15. Perform data analysis in Power BI Desktop

1. Create the report.mp4

00:38

2. Connect to the Sales Analysis Dataset.mp4

01:18

3. Create an animated scatter chart.mp4

04:50

4. Create a forecast.mp4

05:31

5. Work with a decomposition tree.mp4

04:37

6. Work with key influencers.mp4

05:16

16. Create Paginated reports

1. What are paginated reports.mp4

00:30

2. Installing Power BI Report Builder.mp4

02:47

3. Create a blank report.mp4

01:22

4. Configure the report header.mp4

04:34

5.1 salesorder.zip

5. Create a data source and dataset.mp4

06:13

6. Configure the report parameter.mp4

02:29

7. Add a textboxes to the report header region.mp4

10:11

8. Add a table to the report.mp4

04:35

9. Format the table data region.mp4

09:46

10. Finalize the report design.mp4

11:10

Description

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

What You'll Learn?

Connect to data sources from Power BI
Ingest, clean, transform and model data
Design and create reports for data analysis
Model data for performance and scalability
Manage and share report assets
Create paginated reports in Power BI Report Builder
Create measures with DAX formulas
Work with time intelligence
Create Power BI Dashboards
Perform data analysis
This course will help you prepare for the Microsoft Power BI Data Analyst Exams (PL300)

Who is this for?

Beginner Power BI Data Analyst

Beginner Data Analyst

Beginner Data Engineers

Beginner Data Scientist

What You Need to Know?

Knowledge of working with relational data.

Knowledge of working with non-relational data

Some Understanding of Power BI is recommended

More details

Description
A Power BI Data Analyst should have a fundamental understanding of data repositories and data processes, both on-premises and in the cloud. Youâ€™re also a subject matter expert who enables organizations to maximize the value of their data assets by using Power BI. Your responsibilities include designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value. You also collaborate with key stakeholders across verticals to deliver relevant insights based on identified business requirements.

Overview
This course covers 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. This course willÂ also show how to build paginated reports .

Audience Profile
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.

Prerequisites

Understanding core data concepts.
Knowledge of working with relational data.
Knowledge of working with non-relational data
Knowledge of data analysis and visualization concepts.
Understanding of Power BI is recommended

What You Will Learn

How to Ingest, clean, and transform data
How to Model data for performance and scalability
How to Design and create reports for data analysis
How to Apply and perform advanced report analytics
How to use DAX to create measures
How to Manage and share report assets
How to Create paginated reports in Power BI Report Builder

Who this course is for:
Beginner Power BI Data Analyst
Beginner Data Analyst
Beginner Data Engineers
Beginner Data Scientist

User Reviews

Rating

average 0

Total votes0

Focused display

Hello and welcome to 247 Learning.We create online courses that will help you acquire useful and productive technical skills that can be applied to real world jobs. We have over 18,000 students on Udemy that have signed up to our courses . We are continuously adding more courses to our course catalogues. We are looking forward to welcoming you to one or more of our courses.

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.