Become A Power BI Data Analyst

Become A Power BI Data Analyst, available at $49.99, has an average rating of 4.75, with 119 lectures, based on 2 reviews, and has 22 subscribers.

You will learn about 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) This course is ideal for individuals who are Beginner Power BI Data Analyst or Beginner Data Analyst or Beginner Data Engineers or Beginner Data Scientist It is particularly useful for Beginner Power BI Data Analyst or Beginner Data Analyst or Beginner Data Engineers or Beginner Data Scientist.

Enroll now: Become A Power BI Data Analyst

Summary

Title: Become A Power BI Data Analyst

Price: $49.99

Average Rating: 4.75

Number of Lectures: 119

Number of Published Lectures: 119

Number of Curriculum Items: 119

Number of Published Curriculum Objects: 119

Original Price: $149.99

Quality Status: approved

Status: Live

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

Beginner Power BI Data Analyst
Beginner Data Analyst
Beginner Data Engineers
Beginner Data Scientist

Target Audiences

Beginner Power BI Data Analyst
Beginner Data Analyst
Beginner Data Engineers
Beginner Data Scientist

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

Course Curriculum

Chapter 1: Get Started with Microsoft Data Analytics

Lecture 1: Introduction

Lecture 2: What is Microsoft Data Analytics

Lecture 3: Overview of Data Analysis

Lecture 4: Roles in Data Analysis

Lecture 5: Tasks of a Data Analyst

Chapter 2: Power BI Setup

Lecture 1: What is Power BI

Lecture 2: What is Power BI Desktop

Lecture 3: Install Power BI Desktop

Lecture 4: Exploring Power BI Desktop Interface

Chapter 3: Microsoft 365 Setup

Lecture 1: Microsoft 365 Setup

Lecture 2: Getting started with Microsoft 365

Lecture 3: Creating a new user account in Microsoft 365

Chapter 4: Overview of Power BI

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: Changing regional settings

Lecture 6: Parts of Power BI

Lecture 7: Power BI Building blocks

Lecture 8: Exploring Power BI Service

Lecture 9: The flow of work in Power BI

Lecture 10: Data refresh in Power BI

Chapter 5: Power BI Data Sources

Lecture 1: Getting data into Power BI Desktop

Lecture 2: Connect to data in a file

Lecture 3: Connect to data in a database

Lecture 4: Connect to data in Power Platform

Lecture 5: Connect to Azure SQL Database

Lecture 6: Data source settings

Lecture 7: Storage Modes

Chapter 6: Connect, Transform, Visualize and Publish Web 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 7: Microsoft SQL Server Setup

Lecture 1: What is SQL Server

Lecture 2: SQL Server Editions

Lecture 3: SQL Server Installation Requirements

Lecture 4: Download SQL Server

Lecture 5: SQL Server Installation

Lecture 6: SQL Server Configuration Manager

Lecture 7: Installing SQL Server Management Studio

Lecture 8: Connect to SQL Server with SSMS

Lecture 9: Restore AdventureWorksDW2020 Database

Chapter 8: Connect to data sources from Power BI

Lecture 1: Create a new Power BI Desktop file

Lecture 2: Set Power BI Desktop Options

Lecture 3: Get data from a relational database (SQL Server)

Lecture 4: Preview SQL Server queries

Lecture 5: Get data from files ( CSV)

Lecture 6: Get additional data from files ( CSV)

Chapter 9: Clean, transform and load data into Power BI

Lecture 1: Shape the initial data

Lecture 2: Configure the Salesperson query

Lecture 3: Configure the Salesperson Region 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 10: Model Data in Power BI Desktop

Lecture 1: Create Model Relationships

Lecture 2: Configure the Product table

Lecture 3: Configure the Region table

Lecture 4: Configure the Reseller table

Lecture 5: Configure the Sales table

Lecture 6: Bulk update properties

Lecture 7: Review the model interface

Lecture 8: Create quick measures

Lecture 9: Create a many-to-many relationship

Lecture 10: Relate the Targets Table

Lecture 11: Enforce row-level security

Chapter 11: Working with DAX in Power BI

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

Chapter 12: Time Intelligence and Measures

Lecture 1: Create simple Measures

Lecture 2: Create additional measures

Lecture 3: Create a matrix visual

Lecture 4: Manipulate filter context

Lecture 5: Create a YTD measure

Lecture 6: Create a YoY growth measure

Lecture 7: Publish Power BI Desktop File

Chapter 13: Design and Publish Reports in Power BI

Lecture 1: Create a new file

Instructors

247 Learning
An investment in knowledge pays the best interest

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 1 votes
5 stars: 1 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!

Menu