Become a Microsoft Power BI Data Analyst

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

Prepare Data | Model Data | Visualize and Analyse Data | Deploy and Maintain Assets

1. Introduction to Microsoft Data Analytics

1. Introduction.html

2. Microsoft Data Analytics

3. Overview of Data Analysis

4. Roles in Data Analysis

5. Tasks of a Data Analyst

6. Data Analytics Quiz.html

2. Power BI Setup

1. What is Power BI

2. What is Power BI Desktop

3. Install Power BI Desktop

4. Exploring Power BI Desktop Interface

5. Microsoft 365 Setup

6. Getting started with Microsoft 365

7. Creating a new user account in Microsoft 365

3. Building with Power BI

1. Power BI Overview Part 1

2. Power BI Overview Part 2

3. Power BI Overview Part 3

4. Parts of Power BI

5. Power BI Building blocks (Video)

6. Exploring Power BI Service

7. Building blocks of Power BI.html

8. The flow of work in Power BI.html

9. Tour and use of Power BI Service.html

10. Update data in Power BI Service.html

11. Summary.html

12. Get started with Power BI.html

4. Connect & Transform Online Data

1. Connect to Web Data

2. Clean & transform data Part 1

3. Clean & transform data Part 2

4. Combine data sources

5. Creating Data Visuals Part 1

6. Creating Data Visuals Part 2

7. Publish report to Power BI Service

5. SQL Server Setup

1. What is SQL Server

2. SQL Server Editions

3. SQL Server Installation Requirements

4. Download SQL Server

5. SQL Server Installation

6. SQL Server Configuration Manager

7. Installing SQL Server Management Studio

8. Connect to SQL Server with SSMS

9.1 AdventureWorksDW2020.zip

9. Restore AdventureWorksDW2020 Database

10. Download Sample Database

6. Prepare data ( Get data from different data sources )

1. Introduction.html

2. Get data from online services.html

3. Get data from a NoSQL database.html

4. Create and save a new Power BI Desktop file

5. Set Power BI Desktop options

6. Get data from relational data sources

7. Preview SQL Server queries

8. Get data from files.html

9.1 ColorFormats.csv

9.2 ResellerSales 202006.csv

9.3 ResellerSalesTargets.csv

9. Get data from a CSV file

10. Get additional data from a CSV file

11. Change the source file.html

12. Selecting a storage mode.html

13. Get data from Azure Analysis Services.html

14. Fix performance issues.html

15. Resolve data import errors.html

16. Summary.html

17. Getting Data.html

7. Clean, transform, and load data in Power BI

1. Introduction.html

2. Shape the initial data.html

3. Configure the Salesperson query

4. Configure the SalespersonRegion query

5. Configure the Product query

6. Configure the Reseller query

7. Configure the Region query

8. Configure the Sales query

9. Configure the Targets query

10. Configure the ColorFormats query

11. Update the Product query

12. Update the ColorFormats query

13. Load and Transform Data.html

8. Model Data In Power BI Desktop

1. Introduction.html

2. Create Model Relationships

3. Configure the Product table

4. Configure the Region table

5. Configure the Reseller table

6. Configure the Sales table

7. Bulk update properties

8. Review the model interface

9. Create quick measures

10. Model Data In Power BI Desktop.html

11. Create a many-to-many relationship

12. Relate the Targets Table

13. Enforce row-level security

9. Introduction to DAX In Power BI Desktop

1. Create the Salesperson Calculated table

2. Create the Date calculated table

3. Create calculated columns

4. Complete the Date table

5. Mark the Date table

6. Create simple Measures

7. Create additional measures

10. Time Intelligence and Measures in DAX

1. Create a matrix visual

2. Manipulate filter context

3. Create a YTD measure

4. Create a YoY growth measure

5. Publish Power BI Desktop File

6. Time Intelligence Quiz.html

11. Design a report in Power BI Desktop

1. Create a new file

2. Create a live connection

3. Design page 1

4. Design page 2

5. Design page 3

6. Publish report

7. Explore the report

8. Configure Sync Slicers

9. Configure drill through page

10. Add Conditional Formatting

11. Add Bookmarks to Report

12. Add Buttons to Report

13. Publish Updated Report

14. Power BI Dashboard.html

15. Explore Updated Report

16. Designing Reports.html

12. Create a Power BI dashboard (Create a sales monitoring dashboard)

1. Create a dashboard

2. Configure an alert

3.1 ResellerSales 202006.csv

3.2 updatedatabase-2.zip

3. Refresh the dataset

13. Perform data analysis in Power BI Desktop

1. Create the report

2. Connect to the Sales Analysis Dataset

3. Create an animated scatter chart

4. Create a forecast

5. Work with a decomposition tree

6. Work with key influencers

7. Perform data analysis in Power BI Desktop.html

14. Exam PL-300 Microsoft Power BI Data Analyst Preparation

1. Introduction.html

2. What is the exam Format.html

3. Prepare the Data (15-20%).html

4. Model the Data (30-35%).html

5. Visualize and Analyze the Data (25-30%).html

6. Deploy and Maintain Assets (20-25%).html

7. PL-300 Exam Braindumps.html

139,000 تومان

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

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

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

تولید کننده: Udemy-Training