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

Focused View

Bluelime Learning Solutions

10:09:29

93 View

1. Power BI Setup

1. Introduction.mp4

00:20

2. What is Power BI.mp4

05:47

3. What is Power BI Desktop.mp4

03:40

4. Install Power BI Desktop.mp4

02:55

5. Exploring Power BI Desktop Interface.mp4

05:02

6. Microsoft 365 Setup.mp4

03:43

7. Getting started with Microsoft 365.mp4

04:04

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

02:54

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.mp4

04:48

5. Create and save a new Power BI Desktop file.mp4

02:12

6. Set Power BI Desktop options.mp4

02:04

7. Get data from SQL Server.mp4

05:51

8. Preview SQL Server queries.mp4

10:16

9. Getting data from files.html

10. Get data from a CSV file.mp4

05:07

11. Get additional data from a CSV file.mp4

02:51

12. Connect to data in a database.mp4

04:14

13. Connect to data in Power Platform.mp4

03:51

14. Connect to Azure SQL Database.mp4

02:39

15. Data Source Settings.mp4

05:48

16. Storage Modes.mp4

06:18

17. Change the source file.html

18. Selecting a storage mode.html

3. Power BI Overview

1. Introduction.mp4

01:18

2.1 Financial+Sample.xlsx

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. Parts of Power BI.mp4

02:57

6. Power BI Building blocks.mp4

09:31

7. Exploring Power BI Service.mp4

04:28

4. Connect & Transform Online 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

5. Power BI Databases Interaction

1. Download SQL Server.mp4

04:31

2. SQL Server Installation.mp4

09:43

3. Installing SQL Server Management Studio.mp4

05:48

4. Connect to SQL Server with SSMS.mp4

02:16

5. Install Database.mp4

06:28

6. Restore AdventureWorksDW2020 Database.mp4

04:14

7. Connecting to SQL Server Database with Power BI Desktop.mp4

07:15

8. Install PostgreSQL.mp4

08:20

9. Connecting to PostgreSQL Database Server Part 1.mp4

03:28

10. Connecting to PostgreSQL Database Server Part 2.mp4

05:00

11. Download and load sample database.mp4

11:49

12. Connect to PostgreSQL Databases.mp4

09:35

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

03:28

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

05:00

15. Importing and Transforming Data from an Access Database File.mp4

12:58

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

1. Shaping initial data.html

2. Configure the Salesperson query.mp4

08:31

3. Configure the SalespersonRegion 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

01:50

7. Configure the Sales query.mp4

02:40

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

7. Data Modelling

1. What is Data Modelling.html

2. Create Model Relationships.mp4

13:19

3. Configure the Product table.mp4

03:37

4. Configure the Region table.mp4

02:56

5. Configure the Reseller table.mp4

05:20

6. Configure the Sales table.mp4

02:48

7. Bulk update properties.mp4

03:07

8. Review the model interface.mp4

04:40

9. Create quick measures.mp4

06:36

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

10:03

11. Relate the Targets Table.mp4

01:56

12. Enforce row-level security.mp4

05:14

8. Introduction to DAX In Power BI Desktop

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

7. Create simple Measures.mp4

16:56

8. Create additional measures.mp4

11:07

9. Time Intelligence.html

10. Create a matrix visual.mp4

03:53

11. Manipulate filter context.mp4

15:40

12. Create a YTD measure.mp4

02:46

13. Create a YoY growth measure.mp4

06:45

14. Publish Power BI Desktop File.mp4

04:15

9. Building 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

10. Building Dashboards Perform Data Analysis

1. What are Dashboards.html

2. Create a dashboard.mp4

07:21

3. Configure an alert.mp4

00:45

4. Refresh the dataset.mp4

08:28

5. Create the report.mp4

00:38

6. Connect to the Sales Analysis Dataset.mp4

01:18

7. Create an animated scatter chart.mp4

04:50

8. Create a forecast.mp4

05:31

9. Work with a decomposition tree.mp4

04:37

10. Work with key influencers.mp4

05:16

11. Building 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. Create a data source and dataset.mp4

06:13

6. Configure the report parameter.mp4

02:29

7. Add textboxes to 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

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

What You'll Learn?

Install Power BI Desktop
Connect to multiple data sources
Clean, transform and load data
Analyse data
Visualize data
Create measures
Create paginated reports
Build dashboards

Who is this for?

Beginners to Power BI

More details

Description
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data might be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.
Power BI consists of several elements that all work together, starting with these three basics:
A Windows desktop application called Power BI Desktop.
An online software as a service (SaaS) service called the Power BI service.
Power BI Mobile apps for Windows, iOS, and Android devices.
These three elementsâ€”Power BI Desktop, the service, and the mobile appsâ€”are designed to let you create, share, and consume business insights in the way that serves you and your role most effectively.Â Beyond those three, Power BI also features two other elements:
Power BI Report Builder, for creating paginated reports to share in the Power BI service. Read more about paginated reports later in this article.
Power BI Report Server, an on-premises report server where you can publish your Power BI reports, after creating them in Power BI Desktop
How you use Power BI can be based on which feature or service of Power BI is the best tool for your situation. For example, you can use Power BI Desktop to create reports for your own team about customer engagement statistics and you can view inventory and manufacturing progress in a real-time dashboard in the Power BI service. You can create a paginated report of mailable invoices, based on a Power BI dataset. Each part of Power BI is available to you, which is why it's so flexible and compelling.
One common workflow in Power BI begins by connecting to data sources in Power BI Desktop and building a report. You then publish that report from Power BI Desktop to the Power BI service, and share it so business users in the Power BI service and on mobile devices can view and interact with the report.

Who this course is for:
Beginners to Power BI

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Bluelime Learning Solutions

Instructor's Courses

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

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.