Become A Microsoft Power Bi Data Analyst - Udemy 2022

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 Download 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 Changing 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 dаta: Part 1
Lecture 32 Clean & transform dаta: 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: Time 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
Beginner Power BI Data Analyst,Beginner Data Analyst
Screenshots