Published 9/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.54 GB | Duration: 9h 27m

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

Download link

rapidgator.net:
Kod:
https://rapidgator.net/file/4b0f4da3141572ed168c4a1c32677f3e/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part1.rar.html
https://rapidgator.net/file/858710b7e9aed07859c905771f443531/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part2.rar.html
https://rapidgator.net/file/373a9b348e862f35849b71b68e025ab7/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part3.rar.html
https://rapidgator.net/file/6e09705ceee5a377dab0c4b8ca184917/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part4.rar.html
uploadgig.com:
Kod:
https://uploadgig.com/file/download/5979b70556cd3f09/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part1.rar
https://uploadgig.com/file/download/4e3d191e1E9C2C06/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part2.rar
https://uploadgig.com/file/download/329260Ea22990c45/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part3.rar
https://uploadgig.com/file/download/b5B5a7414d2ee266/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part4.rar
1dl.net:
Kod:
https://1dl.net/4urzjefnmrv2/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part1.rar.html
https://1dl.net/3g44x033r7kn/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part2.rar.html
https://1dl.net/j9t71qj34kvn/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part3.rar.html
https://1dl.net/853odbgs0c5n/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part4.rar.html
nitroflare.com:
Kod:
https://nitroflare.com/view/C997CADBEC21123/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part1.rar
https://nitroflare.com/view/71C144A231D9425/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part2.rar
https://nitroflare.com/view/CB7FC6F057774A7/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part3.rar
https://nitroflare.com/view/7E0778D9E4D1012/otskq.Become.A.Microsoft.Power.Bi.Data.Analyst..udemy.part4.rar