Become A Microsoft Power Bi Data Analyst

Prepare Data | Model Data | Visualize and Analyse Data | Deploy and Maintain Assets

What you'll learn
Prepare the data
Get data from different data sources
Clean, transform, and load the data
Model the data
Design a data model
Develop a data model
Create model calculations by using DAX
Optimize model performance
Visualize and analyze the data
Create reports
Create dashboards
Enhance reports for usability and storytelling
Identify patterns and trends
Deploy and maintain assets
Manage files and datasets
Manage workspaces
Requirements
None
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. Candidates for this exam should be proficient using Power Query and writing expressions by using DAX.Prepare the data -  ( Get data from different data sources)Identify and connect to a data sourceChange data source settingsSelect a shared dataset or create a local datasetSelect a storage modeUse Microsoft DataverseChange the value in a parameterConnect to a data flowClean, transform, and load the dataProfile the dataResolve inconsistencies, unexpected or null values, and data quality issues Identify and create appropriate keys for joinsEvaluate and transform column data typesShape and transform tablesCombine queriesApply user-friendly naming conventions to columns and queriesConfigure data loadingResolve data import errorsModel the data  -  ( Design a data model )Define the tablesConfigure table and column propertiesDesign and implement role-playing dimensionsDefine a relationship's cardinality and cross-filter directionDesign a data model that uses a star schemaCreate a common date tableDevelop a data modelCreate calculated tablesCreate hierarchiesCreate calculated columnsImplement row-level security rolesUse the Q&A featureCreate model calculations by using DAXCreate basic measures by using DAXUse CALCULATE to manipulate filtersImplement Time Intelligence using DAXReplace implicit measures with explicit measuresUse basic statistical functionsCreate semi-additive measuresUse quick measuresOptimize model performanceRemove unnecessary rows and columnsIdentify poorly performing measures, relationships, and visualsReduce cardinality levels to improve performanceVisualize and analyze the data ( Create reports & Dashboards)Add visualization items to reportsChoose an appropriate visualization typeFormat and configure visualizationsUse a custom visualApply and customize a themeConfigure conditional formattingApply slicing and filteringConfigure the report pageUse the Analyze in Excel featureChoose when to use a paginated reportManage tiles on a dashboardConfigure mobile viewUse the Q&A featureAdd a Quick Insights result to a dashboardApply a dashboard themePin a live report page to a dashboardEnhance reports for usability and storytellingConfigure bookmarksCreate custom tooltipsEdit and configure interactions between visualsConfigure navigation for a reportApply sortingConfigure Sync SlicersGroup and layer visuals by using the selection paneDrilldown into data using interactive visualsExport report dataDesign reports for mobile devicesIdentify patterns and trendsUse the Analyze feature in Power BIIdentify outliersChoose between continuous and categorical axesUse groupings, binnings, and clusteringUse AI visualsUse the Forecast featureCreate reference lines by using the Analytics paneDeploy and maintain assets  (Manage files, datasets and Manage workspaces)Identify when a gateway is requiredConfigure a dataset scheduled refreshConfigure row-level security group membershipProvide access to datasetsManage global options for filesCreate and configure a workspaceAssign workspace rolesConfigure and update a workspace appPublish, import, or update assets in a workspaceApply sensitivity labels to workspace contentConfigure subscriptions and data alertsPromote or certify Power BI content

Overview

Section 1: Introduction to Microsoft Data Analytics

Lecture 1 Introduction

Lecture 2 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: Building with 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 Parts of Power BI

Lecture 17 Power BI Building blocks (Video)

Lecture 18 Exploring Power BI Service

Lecture 19 Building blocks of Power BI

Lecture 20 The flow of work in Power BI

Lecture 21 Tour and use of Power BI Service

Lecture 22 Update data in Power BI Service

Lecture 23 Summary

Section 4: Connect & Transform Online Data

Lecture 24 Connect to Web Data

Lecture 25 Clean & transform data : Part 1

Lecture 26 Clean & transform data : Part 2

Lecture 27 Combine data sources

Lecture 28 Creating Data Visuals : Part 1

Lecture 29 Creating Data Visuals : Part 2

Lecture 30 Publish report to Power BI Service

Section 5: SQL Server Setup

Lecture 31 What is SQL Server

Lecture 32 SQL Server Editions

Lecture 33 SQL Server Installation Requirements

Lecture 34 Download SQL Server

Lecture 35 SQL Server Installation

Lecture 36 SQL Server Configuration Manager

Lecture 37 Installing SQL Server Management Studio

Lecture 38 Connect to SQL Server with SSMS

Lecture 39 Restore AdventureWorksDW2020 Database

Lecture 40 Download Sample Database

Section 6: Prepare data ( Get data from different data sources )

Lecture 41 Introduction

Lecture 42 Get data from online services

Lecture 43 Get data from a NoSQL database

Lecture 44 Create and save a new Power BI Desktop file

Lecture 45 Set Power BI Desktop options

Lecture 46 Get data from relational data sources

Lecture 47 Preview SQL Server queries

Lecture 48 Get data from files

Lecture 49 Get data from a CSV file

Lecture 50 Get additional data from a CSV file

Lecture 51 Change the source file

Lecture 52 Selecting a storage mode

Lecture 53 Get data from Azure Analysis Services

Lecture 54 Fix performance issues

Lecture 55 Resolve data import errors

Lecture 56 Summary

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

Lecture 57 Introduction

Lecture 58 Shape the initial data

Lecture 59 Configure the Salesperson query

Lecture 60 Configure the SalespersonRegion query

Lecture 61 Configure the Product query

Lecture 62 Configure the Reseller query

Lecture 63 Configure the Region query

Lecture 64 Configure the Sales query

Lecture 65 Configure the Targets query

Lecture 66 Configure the ColorFormats query

Lecture 67 Update the Product query

Lecture 68 Update the ColorFormats query

Section 8: Model Data In Power BI Desktop

Lecture 69 Introduction

Lecture 70 Create Model Relationships

Lecture 71 Configure the Product table

Lecture 72 Configure the Region table

Lecture 73 Configure the Reseller table

Lecture 74 Configure the Sales table

Lecture 75 Bulk update properties

Lecture 76 Review the model interface

Lecture 77 Create quick measures

Lecture 78 Create a many-to-many relationship

Lecture 79 Relate the Targets Table

Lecture 80 Enforce row-level security

Section 9: Introduction to DAX In Power BI Desktop

Lecture 81 Create the Salesperson Calculated table

Lecture 82 Create the Date calculated table

Lecture 83 Create calculated columns

Lecture 84 Complete the Date table

Lecture 85 Mark the Date table

Lecture 86 Create simple Measures

Lecture 87 Create additional measures

Section 10: Time Intelligence and Measures in DAX

Lecture 88 Create a matrix visual

Lecture 89 Manipulate filter context

Lecture 90 Create a YTD measure

Lecture 91 Create a YoY growth measure

Lecture 92 Publish Power BI Desktop File

Section 11: Design a report in Power BI Desktop

Lecture 93 Create a new file

Lecture 94 Create a live connection

Lecture 95 Design page 1

Lecture 96 Design page 2

Lecture 97 Design page 3

Lecture 98 Publish report

Lecture 99 Explore the report

Lecture 100 Configure Sync Slicers

Lecture 101 Configure drill through page

Lecture 102 Add Conditional Formatting

Lecture 103 Add Bookmarks to Report

Lecture 104 Add Buttons to Report

Lecture 105 Publish Updated Report

Lecture 106 Explore Updated Report

Section 12: Create a Power BI dashboard (Create a sales monitoring dashboard)

Lecture 107 Create a dashboard

Lecture 108 Configure an alert

Lecture 109 Refresh the dataset

Section 13: Perform data analysis in Power BI Desktop

Lecture 110 Create the report

Lecture 111 Connect to the Sales Analysis Dataset

Lecture 112 Create an animated scatter chart

Lecture 113 Create a forecast

Lecture 114 Work with a decomposition tree

Lecture 115 Work with key influencers

Section 14: Exam PL-300: Microsoft Power BI Data Analyst Preparation

Lecture 116 Introduction

Lecture 117 What is the exam Format

Lecture 118 Prepare the Data (15-20%)

Lecture 119 Model the Data (30-35%)

Lecture 120 Visualize and Analyze the Data (25-30%)

Lecture 121 Deploy and Maintain Assets (20-25%)

Beginner Data Analyst,Beginner Power BI Data Analyst