HOT
blank

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

Business

Power BI Developer (Power BI,DAX,Power Query,Datamodelling), available at $74.99, has an average rating of 3.15, with 127 lectures, based on 34 reviews, and has 1138 subscribers.

Rating3.2
Enroll Now

You will learn about 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 This course is ideal for individuals who are Beginners to Power BI It is particularly useful for Beginners to Power BI.

Enroll now: Power BI Developer (Power BI,DAX,Power Query,Datamodelling)

Summary

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

Price: $74.99

Average Rating: 3.15

Number of Lectures: 127

Number of Published Lectures: 125

Number of Curriculum Items: 127

Number of Published Curriculum Objects: 125

Original Price: $59.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

  • Beginners to Power BI

Target Audiences

  • Beginners to Power BI

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.

Course Curriculum

Chapter 1: Power BI Setup

Lecture 1: Introduction

Lecture 2: What is Power BI

Lecture 3: What is Power BI Desktop

Lecture 4: Install Power BI Desktop

Lecture 5: Exploring Power BI Desktop Interface

Lecture 6: Getting started with Microsoft 365

Lecture 7: Creating a new user account in Microsoft 365

Chapter 2: Connecting to Data Sources

Lecture 1: Introduction

Lecture 2: Connecting to online data sources

Lecture 3: Connecting to NOSQL Database

Lecture 4: Getting data into Power BI Desktop

Lecture 5: Create and save a new Power BI Desktop file

Lecture 6: Set Power BI Desktop options

Lecture 7: Get data from SQL Server

Lecture 8: Preview SQL Server queries

Lecture 9: Getting data from files

Lecture 10: Get data from a CSV file

Lecture 11: Get additional data from a CSV file

Lecture 12: Connect to data in a database

Lecture 13: Connect to data in Power Platform

Lecture 14: Connect to Azure SQL Database

Lecture 15: Data Source Settings

Lecture 16: Storage Modes

Lecture 17: Change the source file

Lecture 18: Selecting a storage mode

Chapter 3: Power BI Overview

Lecture 1: Introduction

Lecture 2: Power BI Overview : Part 1

Lecture 3: Power BI Overview : Part 2

Lecture 4: Power BI Overview : Part 3

Lecture 5: Parts of Power BI

Lecture 6: Power BI Building blocks

Lecture 7: Exploring Power BI Service

Chapter 4: Connect & Transform Online Data

Lecture 1: Connect to Web Data

Lecture 2: Clean & transform data : Part 1

Lecture 3: Clean & transform data : Part 2

Lecture 4: Combine data sources

Lecture 5: Creating Data Visuals : Part 1

Lecture 6: Creating Data Visuals : Part 2

Lecture 7: Publish report to Power BI Service

Chapter 5: Power BI | Databases Interaction

Lecture 1: Download SQL Server

Lecture 2: SQL Server Installation

Lecture 3: Installing SQL Server Management Studio

Lecture 4: Connect to SQL Server with SSMS

Lecture 5: Install Database

Lecture 6: Restore AdventureWorksDW2020 Database

Lecture 7: Connecting to SQL Server Database with Power BI Desktop

Lecture 8: Install PostgreSQL

Lecture 9: Connecting to PostgreSQL Database Server : Part 1

Lecture 10: Connecting to PostgreSQL Database Server : Part 2

Lecture 11: Download and load sample database

Lecture 12: Connect to PostgreSQL Databases

Lecture 13: Connect to PostgreSQL with Power BI Desktop – Part 1

Lecture 14: Connect to PostgreSQL with Power BI Desktop – Part 2

Lecture 15: Importing and Transforming Data from an Access Database File

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

Lecture 1: Shaping initial data

Lecture 2: Configure the Salesperson query

Lecture 3: Configure the SalespersonRegion query

Lecture 4: Configure the Product query

Lecture 5: Configure the Reseller query

Lecture 6: Configure the Region query

Lecture 7: Configure the Sales query

Lecture 8: Configure the Targets query

Lecture 9: Configure the ColorFormats query

Lecture 10: Update the Product query

Lecture 11: Update the ColorFormats query

Chapter 7: Data Modelling

Lecture 1: What is Data Modelling

Lecture 2: Create Model Relationships

Lecture 3: Configure the Product table

Lecture 4: Configure the Region table

Lecture 5: Configure the Reseller table

Lecture 6: Configure the Sales table

Lecture 7: Bulk update properties

Lecture 8: Review the model interface

Lecture 9: Create quick measures

Lecture 10: Create a many-to-many relationship

Lecture 11: Relate the Targets Table

Lecture 12: Enforce row-level security

Chapter 8: Introduction to DAX In Power BI Desktop

Lecture 1: What is DAX

Lecture 2: Create the Salesperson Calculated table

Lecture 3: Create the Date calculated table

Lecture 4: Create calculated columns

Lecture 5: Complete the Date table

Lecture 6: Mark the Date table

Lecture 7: Create simple Measures

Lecture 8: Create additional measures

Lecture 9: Time Intelligence

Lecture 10: Create a matrix visual

Lecture 11: Manipulate filter context

Lecture 12: Create a YTD measure

Lecture 13: Create a YoY growth measure

Lecture 14: Publish Power BI Desktop File

Chapter 9: Building Reports in Power BI

Instructors

Rating Distribution

  • 1 stars: 4 votes
  • 2 stars: 1 votes
  • 3 stars: 4 votes
  • 4 stars: 11 votes
  • 5 stars: 14 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Relationship Building Courses to Learn in November 2024

Top 10 Storytelling Courses to Learn in November 2024

Top 10 Resilience Training Courses to Learn in November 2024