Become A Microsoft Power BI Data Analyst

Become A Microsoft Power BI Data Analyst, available at $49.99, has an average rating of 4.5, with 107 lectures, based on 12 reviews, and has 50 subscribers.

You will learn about Learn how to ingest, clean, transform, and model data Model data for performance and scalability Apply and perform advanced report analytics Explore the different roles in data Identify the tasks that are performed by a data analyst Get data from various data sources Identify and retrieve data from different data sources Understand the connection methods and their performance implications Design and create reports for data analysis Manage and share report assets Create paginated reports This course is ideal for individuals who are Beginner Power BI Data Analyst or Beginner Data Analyst It is particularly useful for Beginner Power BI Data Analyst or Beginner Data Analyst.

Enroll now: Become A Microsoft Power BI Data Analyst

Summary

Title: Become A Microsoft Power BI Data Analyst

Price: $49.99

Average Rating: 4.5

Number of Lectures: 107

Number of Published Lectures: 107

Number of Curriculum Items: 107

Number of Published Curriculum Objects: 107

Original Price: $119.99

Quality Status: approved

Status: Live

What You Will Learn

Learn how to ingest, clean, transform, and model data
Model data for performance and scalability
Apply and perform advanced report analytics
Explore the different roles in data
Identify the tasks that are performed by a data analyst
Get data from various data sources
Identify and retrieve data from different data sources
Understand the connection methods and their performance implications
Design and create reports for data analysis
Manage and share report assets
Create paginated reports

Who Should Attend

Beginner Power BI Data Analyst
Beginner Data Analyst

Target Audiences

Beginner Power BI Data Analyst
Beginner Data Analyst

The Power BI data analyst delivers actionable insights by leveraging available data and applying domain expertise.

The Power BI data analyst collaborates with key stakeholders across verticals to identify business requirements, cleans and transforms the data, and then designs and builds data models by using Power BI.

The Power BI data analyst provides meaningful business value through easy-to-comprehend data visualizations, enables others to perform self-service analytics, and deploys and configures solutions for consumption.

Businesses need data analysis more than ever. In this learning path, you will learn about the life and journey of a data analyst, the skills, tasks, and processes they go through in order to tell a story with data so trusted business decisions can be made. You will learn how the suite of Power BI tools and services are used by a data analyst to tell a compelling story through reports and dashboards, and the need for true BI in the enterprise.

This course will discuss 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. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.

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

Lecture 5: Microsoft 365 Setup

Lecture 6: Getting started with Microsoft 365

Lecture 7: Creating a new user account in Microsoft 365

Chapter 3: 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 4: Overview of Power BI

Lecture 1: Power BI Overview: Part 1

Lecture 2: Power BI Overview: Part 2

Lecture 3: Power BI Overview: Part 3

Lecture 4: Changing regional settings

Lecture 5: Parts of Power BI

Lecture 6: Power BI Building blocks

Lecture 7: Exploring Power BI Service

Chapter 5: Connect, Transform, Visualize and Publish Web Data

Lecture 1: Shaping data

Lecture 2: Connect to Web Data

Lecture 3: Clean & transform data: Part 1

Lecture 4: Clean & transform data: Part 2

Lecture 5: Combine data sources

Lecture 6: Creating Data Visuals: Part 1

Lecture 7: Creating Data Visuals: Part 2

Lecture 8: Publish report to Power BI Service

Chapter 6: Preparing Data in Power BI Desktop

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: Get data from CSV file

Lecture 5: Get additional data from csv file

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

Lecture 1: Configure the Salesperson Region query

Lecture 2: Configure the Product query

Lecture 3: Configure the Reseller query

Lecture 4: Configure the Region query

Lecture 5: Configure the Sales query

Lecture 6: Configure the Targets query

Lecture 7: Configure the ColorFormats query

Lecture 8: Update the Product query

Lecture 9: Update the ColorFormats query

Chapter 8: 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 9: Using 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

Lecture 7: Create simple Measures

Lecture 8: Create additional measures

Chapter 10: Time Intelligence and Measures

Lecture 1: Create a matrix visual

Lecture 2: Manipulate filter context

Lecture 3: Create a YTD measure

Lecture 4: Create a YoY growth measure

Lecture 5: Publish Power BI Desktop File

Chapter 11: Design and Publish Reports in Power BI

Lecture 1: Create a new file

Lecture 2: Create a live connection

Lecture 3: Design page 1

Lecture 4: Design page 2

Lecture 5: Design page 3

Lecture 6: Publish report

Lecture 7: Explore the report in Power BI Service

Lecture 8: Configure Sync Slicers

Lecture 9: Configure drill through page

Lecture 10: Add Conditional Formatting

Lecture 11: Add Bookmarks to Report

Lecture 12: Add Buttons to Report

Lecture 13: Publish Updated Report

Lecture 14: Explore Updated Report

Chapter 12: Create Power BI Dashboards

Instructors

Skill Tree
Skill based learning

Rating Distribution

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