Become A Microsoft Power Bi Data Analyst - udemy

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

What you'll learn
Connect to various data sources
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
Connect, Transform, Visualize and Publish Web Data
Create measures using DAX formulas
Work with time intelligence
Transforming data in Power BI Desktop using Power Query Editor
Model Data and create relationships
Requirements
Understanding of core data concepts.
Knowledge of working with relational data.
Knowledge of working with non-relational data
Understanding of Power BI is recommended
Description
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 .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.PrerequisitesUnderstanding 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 recommendedWhat You Will Learn How to Ingest, clean, and transform dataHow to Model data for performance and scalabilityHow to Design and create reports for data analysisHow to Apply and perform advanced report analyticsHow to use DAX to create measuresHow to Manage and share report assetsHow to Create paginated reports in Power BI Report Builder

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

Section 3: Microsoft 365 Setup

Lecture 10 Microsoft 365 Setup

Lecture 11 Getting started with Microsoft 365

Lecture 12 Creating a new user account in Microsoft 365

Section 4: Overview of Power BI

Lecture 13 Power BI Overview: Part 1

Lecture 14 Power BI Overview: Part 2

Lecture 15 Power BI Overview: Part 3

Lecture 16 Changing regional settings

Lecture 17 Parts of Power BI

Lecture 18 Power BI Building blocks

Lecture 19 Exploring Power BI Service

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

Lecture 20 Connect to Web Data

Lecture 21 Clean & transform data: Part 1

Lecture 22 Clean & transform data: Part 2

Lecture 23 Combine data sources

Lecture 24 Creating Data Visuals: Part 1

Lecture 25 Creating Data Visuals: Part 2

Lecture 26 Publish report to Power BI Service

Section 6: Microsoft SQL Server Setup

Lecture 27 What is SQL Server

Lecture 28 SQL Server Editions

Lecture 29 SQL Server Installation Requirements

Lecture 30 Download SQL Server

Lecture 31 SQL Server Installation

Lecture 32 SQL Server Configuration Manager

Lecture 33 Installing SQL Server Management Studio

Lecture 34 Connect to SQL Server with SSMS

Lecture 35 Restore AdventureWorksDW2020 Database

Section 7: Connect to data sources from Power BI

Lecture 36 Create a new Power BI Desktop file

Lecture 37 Set Power BI Desktop Options

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

Lecture 39 Preview SQL Server queries

Lecture 40 Get data from a CSV file

Lecture 41 Get additional data from a CSV file

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

Lecture 42 Configure the Salesperson Region query

Lecture 43 Configure the SalespersonRegion query

Lecture 44 Configure the Product query

Lecture 45 Configure the Reseller query

Lecture 46 Configure the Region query

Lecture 47 Configure the Sales query

Lecture 48 Configure the Targets query

Lecture 49 Configure the ColorFormats query

Lecture 50 Update the Product query

Lecture 51 Update the ColorFormats query

Section 9: Model Data in Power BI Desktop

Lecture 52 Create Model Relationships

Lecture 53 Configure the Product table

Lecture 54 Configure the Region table

Lecture 55 Configure the Reseller table

Lecture 56 Configure the Sales table

Lecture 57 Bulk update properties

Lecture 58 Review the model interface

Lecture 59 Create quick measures

Lecture 60 Create a many-to-many relationship

Lecture 61 Relate the Targets Table

Lecture 62 Enforce row-level security

Section 10: Working with DAX in Power BI Desktop

Lecture 63 What is DAX

Lecture 64 Create the Salesperson Calculated table

Lecture 65 Create the Date calculated table

Lecture 66 Create calculated columns

Lecture 67 Complete the Date table

Lecture 68 Mark the Date table

Section 11: Time Intelligence and Measures

Lecture 69 Create simple Measures

Lecture 70 Create additional measures

Lecture 71 Create a matrix visual

Lecture 72 Manipulate filter context

Lecture 73 Create a YTD measure

Lecture 74 Create a YoY growth measure

Lecture 75 Publish Power BI Desktop File

Section 12: Design and Publish Reports in Power BI

Lecture 76 Create a new file

Lecture 77 Create a live connection

Lecture 78 Design page 1

Lecture 79 Design page 2

Lecture 80 Design page 3

Lecture 81 Publish report

Lecture 82 Explore the report

Lecture 83 Configure Sync Slicers

Lecture 84 Configure drill through page

Lecture 85 Add Conditional Formatting

Lecture 86 Add Bookmarks to Report

Lecture 87 Add Buttons to Report

Lecture 88 Publish Updated Report

Lecture 89 Explore Updated Report

Section 13: Create Power BI Dashboards

Lecture 90 Create a dashboard

Lecture 91 Configure an alert

Lecture 92 Refresh the dataset

Section 14: Perform data analysis in Power BI Desktop

Lecture 93 Create the report

Lecture 94 Connect to the Sales Analysis Dataset

Lecture 95 Create an animated scatter chart

Lecture 96 Create a forecast

Lecture 97 Work with a decomposition tree

Lecture 98 Work with key influencers

Section 15: Create paginated reports

Lecture 99 What are paginated reports

Lecture 100 Install Power BI Report Builder

Lecture 101 Create a blank report

Lecture 102 Configure a report header

Lecture 103 Create a data source and dataset

Lecture 104 Configure report parameter

Lecture 105 Add textboxes to report header region

Lecture 106 Add a table to the report

Lecture 107 Format the table data region

Lecture 108 Finalize the report region

Data professionals,Business intelligence professionals,Beginner Data Analyst,Beginner Power BI Data Analyst

without You and Your Support We Can’t Continue
Thanks for Buying Premium From My Links for Support
Click >>here & Visit My Blog Daily for More Udemy Tutorial. If You Need Update or Links Dead Don't Wait Just Pm Me or Leave Comment at This Post