Power BI Developer (Power BI,DAX,Power Query,Datamodelling)

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

Power BI Hands-on learning experience- Data Analytics, Data Visualization,DAX,Power Query,Datamodelling,Databases

1. Power BI Setup

1. Introduction

2. What is Power BI

3. What is Power BI Desktop

4. Install Power BI Desktop

5. Exploring Power BI Desktop Interface

6. Microsoft 365 Setup

7. Getting started with Microsoft 365

8. Creating a new user account in Microsoft 365

2. Connecting to Data Sources

1. Introduction.html

2. Connecting to online data sources.html

3. Connecting to NOSQL Database.html

4. Getting data into Power BI Desktop

5. Create and save a new Power BI Desktop file

6. Set Power BI Desktop options

7. Get data from SQL Server

8. Preview SQL Server queries

9. Getting data from files.html

10. Get data from a CSV file

11. Get additional data from a CSV file

12. Connect to data in a database

13. Connect to data in Power Platform

14. Connect to Azure SQL Database

15. Data Source Settings

16. Storage Modes

17. Change the source file.html

18. Selecting a storage mode.html

3. Power BI Overview

1. Introduction

2.1 Financial+Sample.xlsx

2. Power BI Overview Part 1

3. Power BI Overview Part 2

4. Power BI Overview Part 3

5. Parts of Power BI

6. Power BI Building blocks

7. Exploring Power BI Service

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. Power BI Databases Interaction

1. Download SQL Server

2. SQL Server Installation

3. Installing SQL Server Management Studio

4. Connect to SQL Server with SSMS

5. Install Database

6. Restore AdventureWorksDW2020 Database

7. Connecting to SQL Server Database with Power BI Desktop

8. Install PostgreSQL

9. Connecting to PostgreSQL Database Server Part 1

10. Connecting to PostgreSQL Database Server Part 2

11. Download and load sample database

12. Connect to PostgreSQL Databases

13. Connect to PostgreSQL with Power BI Desktop - Part 1

14. Connect to PostgreSQL with Power BI Desktop - Part 2

15. Importing and Transforming Data from an Access Database File

6. Clean, transform, and load SQL Server data in Power BI

1. Shaping initial data.html

2. Configure the Salesperson query

3. Configure the SalespersonRegion query

4. Configure the Product query

5. Configure the Reseller query

6. Configure the Region query

7. Configure the Sales query

8. Configure the Targets query

9. Configure the ColorFormats query

10. Update the Product query

11. Update the ColorFormats query

7. Data Modelling

1. What is Data Modelling.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. Create a many-to-many relationship

11. Relate the Targets Table

12. Enforce row-level security

8. Introduction to DAX In Power BI Desktop

1. What is DAX.html

2. Create the Salesperson Calculated table

3. Create the Date calculated table

4. Create calculated columns

5. Complete the Date table

6. Mark the Date table

7. Create simple Measures

8. Create additional measures

9. Time Intelligence.html

10. Create a matrix visual

11. Manipulate filter context

12. Create a YTD measure

13. Create a YoY growth measure

14. Publish Power BI Desktop File

9. Building Reports in Power BI

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. Explore Updated Report

10. Building Dashboards Perform Data Analysis

1. What are Dashboards.html

2. Create a dashboard

3. Configure an alert

4. Refresh the dataset

5. Create the report

6. Connect to the Sales Analysis Dataset

7. Create an animated scatter chart

8. Create a forecast

9. Work with a decomposition tree

10. Work with key influencers

11. Building Paginated Reports

1. What are Paginated Reports

2. Installing Power BI Report Builder

3. Create a blank report

4. Configure the report header

5. Create a data source and dataset

6. Configure the report parameter

7. Add textboxes to report header region

8. Add a table to the report

9. Format the table data region

10. Finalize the report design

139,000 تومان

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

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

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

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