Become A Microsoft Power Bi Data Analyst - Udemy 2022

[LeeAndro]

Published 9/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 3.39 GB | Duration: 9h 7m

Ingest, clean, transform and model data | Design and create reports for data analysis

What you'll 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
Requirements
Understanding core data concepts is advised but not mandatory
Basic knowledge of Excel is advised but not mandatory
Basic knowledge of relational databases is advised but not mandatory
Description
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.

Overview

Section 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

Section 2: Power BI Setup

Lecture 6 What is Power BI

Lecture 7 What is Power BI Desktop

Lecture 8 Install Power BI Desktop

Lecture 9 Exploring Power BI Desktop Interface

Lecture 10 Microsoft 365 Setup

Lecture 11 Getting started with Microsoft 365

Lecture 12 Creating a new user account in Microsoft 365

Section 3: Microsoft SQL Server Setup

Lecture 13 What is SQL Server

Lecture 14 SQL Server Editions

Lecture 15 SQL Server Installation Requirements

Lecture 16 SQL Server

Lecture 17 SQL Server Installation

Lecture 18 SQL Server Configuration Manager

Lecture 19 Installing SQL Server Management Studio

Lecture 20 Connect to SQL Server with SSMS

Lecture 21 Restore AdventureWorksDW2020 Database

Section 4: Overview of Power BI

Lecture 22 Power BI Overview: Part 1

Lecture 23 Power BI Overview: Part 2

Lecture 24 Power BI Overview: Part 3

Lecture 25 Chag regional settings

Lecture 26 Parts of Power BI

Lecture 27 Power BI Building blocks

Lecture 28 Exploring Power BI Service

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

Lecture 29 Shaping data

Lecture 30 Connect to Web Data

Lecture 31 Clean & transform data: Part 1

Lecture 32 Clean & transform data: Part 2

Lecture 33 Combine data sources

Lecture 34 Creating Data Visuals: Part 1

Lecture 35 Creating Data Visuals: Part 2

Lecture 36 Publish report to Power BI Service

Section 6: Preparing Data in Power BI Desktop

Lecture 37 Create a new Power BI Desktop file

Lecture 38 Set Power BI Desktop Options

Lecture 39 Get data from a relational database (SQL Server)

Lecture 40 Get data from CSV file

Lecture 41 Get additional data from csv file

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

Lecture 42 Configure the Salesperson Region query

Lecture 43 Configure the Product query

Lecture 44 Configure the Reseller query

Lecture 45 Configure the Region query

Lecture 46 Configure the Sales query

Lecture 47 Configure the Targets query

Lecture 48 Configure the ColorFormats query

Lecture 49 Update the Product query

Lecture 50 Update the ColorFormats query

Section 8: Model Data in Power BI Desktop

Lecture 51 Create Model Relationships

Lecture 52 Configure the Product table

Lecture 53 Configure the Region table

Lecture 54 Configure the Reseller table

Lecture 55 Configure the Sales table

Lecture 56 Bulk update properties

Lecture 57 Review the model interface

Lecture 58 Create quick measures

Lecture 59 Create a many-to-many relationship

Lecture 60 Relate the Targets Table

Lecture 61 Enforce row-level security

Section 9: Using DAX in Power BI

Lecture 62 What is DAX

Lecture 63 Create the Salesperson Calculated table

Lecture 64 Create the Date calculated table

Lecture 65 Create calculated columns

Lecture 66 Complete the Date table

Lecture 67 Mark the Date table

Lecture 68 Create simple Measures

Lecture 69 Create additional measures

Section 10: Intelligence and Measures

Lecture 70 Create a matrix visual

Lecture 71 Manipulate filter context

Lecture 72 Create a YTD measure

Lecture 73 Create a YoY growth measure

Lecture 74 Publish Power BI Desktop File

Section 11: Design and Publish Reports in Power BI

Lecture 75 Create a new file

Lecture 76 Create a live connection

Lecture 77 Design page 1

Lecture 78 Design page 2

Lecture 79 Design page 3

Lecture 80 Publish report

Lecture 81 Explore the report in Power BI Service

Lecture 82 Configure Sync Slicers

Lecture 83 Configure drill through page

Lecture 84 Add Conditional Formatting

Lecture 85 Add Bookmarks to Report

Lecture 86 Add Buttons to Report

Lecture 87 Publish Updated Report

Lecture 88 Explore Updated Report

Section 12: Create Power BI Dashboards

Lecture 89 Create a dashboard

Lecture 90 Configure an alert

Lecture 91 Refresh the dataset

Section 13: Perform data analysis in Power BI Desktop

Lecture 92 Create the report

Lecture 93 Connect to the Sales Analysis Dataset

Lecture 94 Create an animated scatter chart

Lecture 95 Create a forecast

Lecture 96 Work with a decomposition tree

Lecture 97 Work with key influencers

Section 14: Create Paginated Reports

Lecture 98 What are paginated reports

Lecture 99 Install Power BI report builder

Lecture 100 Create a blank report

Lecture 101 Configure the report header

Lecture 102 Create a data source and dataset

Lecture 103 Configure the report parameter

Lecture 104 Add textboxes to report header region

Lecture 105 Add a table to the report

Lecture 106 Format the table data region

Lecture 107 Finalize the report design

Bner Power BI Data Analyst,Bner Data Analyst

HomePage:

Https://anonymz.com/https://www.udemy.com/course/become-a-microsoft-power-bi-data-analyst-n/

DOWNLOAD

https://1dl.net/syo53tpfnqkp/0cw2VnMQ__Become_A_M.part1.rar.html
https://1dl.net/qzip4qwyi0wo/0cw2VnMQ__Become_A_M.part2.rar.html
https://1dl.net/pxw8fqmeotz7/0cw2VnMQ__Become_A_M.part3.rar.html
https://1dl.net/t2i7az142dqt/0cw2VnMQ__Become_A_M.part4.rar.html