17.8 GB | 23min 17s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English
Files Included :
1 Course Introduction.mp4 (8.93 MB)
2 Downloading & Installing Microsoft Power BI Desktop.mp4 (11.5 MB)
3 Creating Microsoft Power BI Account.mp4 (56.07 MB)
1 Project Introduction.mp4 (9.07 MB)
10 Understanding the requirements & adding & formatting three report pages.mp4 (78.67 MB)
11 Adding Slicer & Span card visual on Batting Analysis Page.mp4 (48.28 MB)
12 Adding other card visuals on batting analysis report page.mp4 (77.6 MB)
13 Creating the bowling data analysis page.mp4 (90.42 MB)
14 Creating the fielding data analysis page.mp4 (67.93 MB)
15 Using Chat GPT & LOOKUPVALUE DAX function to populate category column.mp4 (69.33 MB)
16 Adding Rank Column using RANKX DAX Function.mp4 (33.64 MB)
17 Adding columns (POWER & ABS DAX Functions) & Publishing to Power BI Service.mp4 (45.7 MB)
2 Web Scraping using Power BI.mp4 (159.97 MB)
3 Data Cleaning.mp4 (92.38 MB)
4 Scraping India & South Africa Batting's Data.mp4 (123.17 MB)
5 Scraping India & South Africa Bowling's Data.mp4 (100.15 MB)
6 Scraping India & South Africa Fielding's Data.mp4 (87.24 MB)
7 Column definition & data cleaning (Batting's Data).mp4 (78.34 MB)
8 Column definition & data cleaning (Bowling's Data).mp4 (72.51 MB)
9 Column definition & data cleaning (Fielding's Data).mp4 (42.72 MB)
1 Project Introduction.mp4 (11.69 MB)
10 Requirements - 1.mp4 (11.76 MB)
11 Creating the first report page.mp4 (14.33 MB)
12 Creating second report page.mp4 (191.38 MB)
13 Creating third report page.mp4 (143.9 MB)
14 Creating Age Group Column using IFSWITCH DAX Functions.mp4 (47.15 MB)
15 COUNTROWS, FILTER & DIVIDE DAX Functions.mp4 (39.73 MB)
16 Adding the Age Group Analysis Page.mp4 (91.27 MB)
2 What are Panic Attacks.mp4 (28.99 MB)
3 Different columns in the dataset.mp4 (41.03 MB)
4 Creating Snowflake free trial account.mp4 (32.13 MB)
5 Loading Data into Snowflake.mp4 (35.39 MB)
6 Connecting Snowflake to Power BI.mp4 (39.45 MB)
7 Data understanding using snowflake SQL.mp4 (71.99 MB)
8 Data Understanding & Transformations using Power Query Editor.mp4 (77.77 MB)
9 Additional Data Transformations.mp4 (41.54 MB)
1 Project Introduction.mp4 (6.14 MB)
10 Last 12 month Sales (CALCULATE, DATESINPERIOD & SUM DAX functions).mp4 (38.09 MB)
11 Creating the Sales performance page.mp4 (33.53 MB)
12 Sales by Region (CALCULATE, SUM & ALLEXCEPT DAX Function).mp4 (60.66 MB)
13 TOTALYTD DAX Function & table visual.mp4 (43.15 MB)
14 Adding the donut chart on sales performance page.mp4 (41.8 MB)
15 Adding Age column & Key Influencers visual.mp4 (49.61 MB)
16 Offer to SQM Price.mp4 (45.53 MB)
17 Publishing the report to Power BI Service.mp4 (21.27 MB)
18 Creating & Publishing the report to New Workspace.mp4 (23.4 MB)
19 Adding clustered bar chart to show Avg offerpurchase price comparison.mp4 (60.07 MB)
2 Creating Free Google Cloud Account.mp4 (20.22 MB)
20 Adding other visuals on House type analysis & Publishing the report.mp4 (147.11 MB)
3 Loading Data into Google BigQuery & connecting BigQuery to Power BI.mp4 (80.92 MB)
4 Using SQL in BigQuery for Data understanding & transformations.mp4 (94.93 MB)
5 Understanding & Cleaning the data using Power Query Editor.mp4 (120.4 MB)
6 YOY Sales Growth (Calculate, Year, MAX, IF, BLANK DAX Functions).mp4 (81.48 MB)
7 Adding the Offer Price Column & Scatter Plot.mp4 (52.86 MB)
8 Using MEDIANX DAX Function to create median sales price change by region chart.mp4 (61.87 MB)
9 Adding Units Sold (CALCULATE, DISTINCTCOUNT, YEAR, QUARTER, MAX DAX Functions).mp4 (46.9 MB)
1 Project Introduction.mp4 (14.03 MB)
10 Adding & Formatting the slicers on overview page.mp4 (17.91 MB)
11 Creating a Bar chart to show number of Models by company.mp4 (36.77 MB)
12 Adding other charts to the overview page.mp4 (60.02 MB)
13 Adding Bar chart to represent processor count for different Models.mp4 (24.26 MB)
14 Adding the table visual & drill through filter.mp4 (74.95 MB)
15 Creating the price analysis page & adding slicers.mp4 (39.72 MB)
16 Cleaning the Launch Price Columns.mp4 (84.72 MB)
17 Using Chat GPT to create conversion factor table & adding additional columns.mp4 (59.58 MB)
18 Creating charts & bookmarks for India & Dubai.mp4 (115.75 MB)
19 Adding other bookmarks on price analysis page.mp4 (109.56 MB)
2 Creating 365 Trial Account.mp4 (45.46 MB)
20 Creating the Price Vs Feature comparison page.mp4 (91.02 MB)
21 Adding bookmarks for Feature Vs Price comparison page.mp4 (95.54 MB)
22 CONCATENATE, LEN, IF & LEFT DAX functions.mp4 (91.16 MB)
23 SUMMARIZE & AVERAGE DAX Functions.mp4 (113.74 MB)
24 Publishing the report to Power BI Service.mp4 (29.44 MB)
3 Signing in & placing order for 365 account.mp4 (26.14 MB)
4 Assigning License.mp4 (16.72 MB)
5 Creating sharepoint site, loading data & connecting sharepoint to Power BI.mp4 (54.45 MB)
6 Understanding the data & removing duplicates.mp4 (99.84 MB)
7 Using Chat GPT to clean PKR Price column.mp4 (47.78 MB)
8 Cleaning the RAM column & changing it's data type.mp4 (49.83 MB)
9 Trimming RAM column & inserting shape in report overview page.mp4 (32.29 MB)
1 Project Introduction.mp4 (16.59 MB)
10 Part 1 declaring variables & while loop.mp4 (49.64 MB)
11 Part 2 Creating dynamic SQL Code for column.mp4 (147.88 MB)
12 Part 3 Populating Mode & Distinct Count for numerical data type columns.mp4 (88.23 MB)
13 Part 4 Populating Median for numerical columns.mp4 (59.6 MB)
14 Part 5 Making arrangements for all data type columns.mp4 (118.24 MB)
15 Column Distribution.mp4 (90.15 MB)
16 Creating & Populating Clinical data table.mp4 (74.54 MB)
17 Data Profiling Clinical Table.mp4 (74.98 MB)
18 Clinical Data Column Distribution.mp4 (31.32 MB)
19 Updating the replica of Clinical data table.mp4 (43.72 MB)
2 Downloading & Installing Microsoft SQL Server.mp4 (63.03 MB)
20 Loading Data into Power BI Desktop & Troubleshooting the data load issues.mp4 (160.88 MB)
21 Formatting the Report Pages.mp4 (33.21 MB)
22 Adding Line Chart on page 1 to show total infections by hospital id.mp4 (77.04 MB)
23 Adding Other Visuals on first report page.mp4 (59.54 MB)
24 Creating the second report page & publishing the report to Power BI Service.mp4 (48.34 MB)
25 Replacing the published report in Power BI Service.mp4 (20.79 MB)
3 Create Table for Dynamic SQL example.mp4 (21.77 MB)
4 Dynamic SQL example.mp4 (73.11 MB)
5 Objective & Data Profiling Code.mp4 (11.77 MB)
6 Creating hash table & sample data for data profiling.mp4 (69.39 MB)
7 SQL Syntax for calculating different numerical quantities.mp4 (42.43 MB)
8 Median Concept & example.mp4 (71.72 MB)
9 Mode concept & example.mp4 (39.68 MB)
1 Project Introduction.mp4 (10.58 MB)
10 Loan Amount by Purpose (DAX Used SUMX, FILTER, NOT, ISBLANK).mp4 (126.47 MB)
11 Average Income by Employment Type (DAX Used CALCULATE, AVERAGE & ALLEXCEPT).mp4 (100.43 MB)
12 Default Rate by Employment type(DAX ALL,ALLEXCEPT,COUNTROWS,DIVIDE,FILTER etc).mp4 (123.31 MB)
13 Average Loan by Age Groups (DAX Used AVERAGE, AVERAGEX & VALUES).mp4 (81.6 MB)
14 Data Validation for Average Loan by Age Groups.mp4 (23.78 MB)
15 Default Rate by Year (DAX Used CALCULATE, COUNTROWS, ALLEXCEPT, FILTER, DIVIDE).mp4 (62.94 MB)
16 Data Validation for Default Rate by Year.mp4 (78.12 MB)
17 Median calculation & validation using MEDIANX DAX Function.mp4 (72.9 MB)
18 Median Loan Amount by credit score category.mp4 (49.46 MB)
19 Adding Donut Chart to show Average Loan Amount by Age Group & Marital Status.mp4 (61.1 MB)
2 Downloading, Installing & Configuring the Standard Mode Gateway.mp4 (48.43 MB)
20 Data Validation (Donut Chart).mp4 (53.91 MB)
21 Loan(Adults) by credit categories (DAX Used CALCULATE,AVERAGEX,SUM).mp4 (94.82 MB)
22 Total Loan (Middle Age Adults) by have MortgageDependents.mp4 (66.72 MB)
23 Data Validation (Clustered Column Chart).mp4 (55.8 MB)
24 Data Validation & Loans by education type.mp4 (64.92 MB)
25 Creating the YOY Loan amount DAX Measure.mp4 (82.39 MB)
26 Creating YOY Default Loans change DAX Measure.mp4 (65.87 MB)
27 Adding Line charts to represent YOY DAX Measures.mp4 (31.44 MB)
28 YTD Loan amount by credit score bins & marital status.mp4 (98.06 MB)
29 Adding Decomposition Tree (DAX Used SWITCH Function).mp4 (77.71 MB)
3 Downloading & Installing Microsoft SQL Server.mp4 (62.99 MB)
30 Setting up Schedule Refresh for Dataflow.mp4 (23.13 MB)
31 Setting up Incremental Refresh for Dataflow.mp4 (31.35 MB)
32 Publishing the report to Power BI Service & scheduling refresh for report.mp4 (46.36 MB)
33 Sharing the Report.mp4 (9.04 MB)
4 Importing Data to SQL Server.mp4 (36.02 MB)
5 Creating the Dataflow using Power BI Service.mp4 (45.6 MB)
6 Importing Data into Power BI Desktop from dataflow.mp4 (17.68 MB)
7 Column definitions & dataset description.mp4 (49.44 MB)
8 Data Types & Profiling in Power Query Editor.mp4 (70.33 MB)
9 Renaming & Inserting shape on Page 1.mp4 (13.21 MB)
1 Project Introduction.mp4 (22.16 MB)
10 Importing Data into Production Environment in SQL Server.mp4 (42.72 MB)
11 Data Cleaning using SQL & transitioning the report from test to Production.mp4 (154.05 MB)
12 Downloading & Installing the MYSQL Connector.mp4 (36 MB)
13 Importing data into MYSQL Database.mp4 (62.46 MB)
14 Creating Equivalent SQL Code in MYSQL Workbench to populate New Table.mp4 (62.19 MB)
15 Creating Workspace & Publishing SQL Server Data Source's report.mp4 (19.5 MB)
16 Importing Data into Power BI Desktop from MYSQL Database.mp4 (21.61 MB)
17 Transitioning the report using Advanced Editor in Power Query Editor.mp4 (29.74 MB)
18 Data Validation & Publishing New report to MYSQL Database Workspace.mp4 (27.67 MB)
2 Downloading & Installing Microsoft SQL Server.mp4 (63.02 MB)
3 Installing MYSQL Server & MYSQL Workbench.mp4 (51.07 MB)
4 Understanding the Test Environment Data & Requirements.mp4 (39.4 MB)
5 Importing the data in test environment in SQL Server.mp4 (39.6 MB)
6 Applying Left Join in SQL Server to prepare the data to be used for reporting.mp4 (114.52 MB)
7 Importing the Data to Power BI Desktop from Test Environment.mp4 (73.53 MB)
8 Creating the DAX Measures & KPIs for Page 1.mp4 (85.39 MB)
9 Creating the DAX Measures & KPIs for Page 2.mp4 (91.38 MB)
1 Project Introduction.mp4 (28.36 MB)
10 Formatting the Slicers & saving the report.mp4 (26 MB)
11 Using SUM DAX Measure to filter dimension table slicers.mp4 (134.84 MB)
12 Creating the Running Total DAX Measure.mp4 (86.38 MB)
13 Creating DAX Measure to represent YTD Sales.mp4 (36.73 MB)
14 Adding Charts to represent top 5 stores & bottom 5 customers.mp4 (75.83 MB)
15 Sharing the reports by embedding the report in a website.mp4 (35.85 MB)
16 Sharing the report through Microsoft teams.mp4 (11.21 MB)
17 Sharing the report by publishing it to web.mp4 (64.93 MB)
18 Creating a live connection to semantic models in Power BI Service.mp4 (28.96 MB)
2 Signing in to Power BI Service & creating the workspace.mp4 (21.68 MB)
3 Table & Column definitions.mp4 (39.89 MB)
4 Loading Data into Power BI Service.mp4 (29.36 MB)
5 Understanding the data model (Snowflake Schema).mp4 (30.34 MB)
6 Data cleaning, adding & formatting the line chart.mp4 (81.4 MB)
7 Adding & formatting the Customer name slicer.mp4 (48.43 MB)
8 Adding other slicers to the report page.mp4 (78.73 MB)
9 Adding the bookmark for average sales.mp4 (95.79 MB)
1 Project Introduction.mp4 (34.72 MB)
10 Adding the Brands Overview Page.mp4 (68.24 MB)
11 Adding Visuals from App Source to second report page.mp4 (44.27 MB)
12 Adding Bar chart to represent top 5 brands by highest average discount 39_mp4 (94.19 MB)
13 Adding Donut Chart to represent top 5 brands by variety count.mp4 (51.47 MB)
14 Adding a ribbon chart to represent top 5 brands by average sales price.mp4 (63.47 MB)
15 Adding an Area chart to show top 5 brands by highest average profit 39_mp4 (58.89 MB)
16 Adding Circle graph to represent bottom 5 brands by profit% & publishing report.mp4 (69.88 MB)
17 Sharing the report through Apps in Power BI Service.mp4 (57.4 MB)
2 Creating Free Azure Account.mp4 (59.56 MB)
3 Loading Data to Azure SQL Database.mp4 (96.83 MB)
4 Data Cleaning using Azure SQL.mp4 (31.04 MB)
5 Connecting Power BI to Azure SQL Database using 'Database' option in Power BI.mp4 (30.07 MB)
6 Connecting to Azure SQL Database using Microsoft Account option in Power BI.mp4 (50.12 MB)
7 Understanding the Data.mp4 (39.6 MB)
8 Data Cleaning.mp4 (59.2 MB)
9 Using DAX to create discount %, profit % & cost price column.mp4 (53.62 MB)
1 Project Introduction.mp4 (38.08 MB)
10 Data Cleaning Year Column Part 1.mp4 (91.35 MB)
11 Data Cleaning Year Column Part 2.mp4 (106.95 MB)
12 Additional Data Cleaning Steps.mp4 (41.06 MB)
13 Importing the Radar chart & creating chart to show North America Sales.mp4 (93.53 MB)
14 Creating radar chart & bookmarks for all other remaining regions.mp4 (131.86 MB)
15 Adding the Bookmark Navigator.mp4 (48.26 MB)
16 Approach 2 (Data Cleaning, adding a slicer & a radar chart on page 2).mp4 (156 MB)
17 Updating the slicer settings on page 2.mp4 (81.36 MB)
18 Adding a Page navigator & Sales by GenreYear Page.mp4 (170.87 MB)
19 Adding + Formatting the last page & Publishing the report to Power BI Service.mp4 (312.44 MB)
2 Creating Free AWS Account.mp4 (41.14 MB)
3 Creating AWS S3 bucket, loading data into it & configuring AWS Glue.mp4 (75.53 MB)
4 Creating the IAM User.mp4 (42.07 MB)
5 Downloading, Installing & Configuring the Athena Simba Connector.mp4 (46.39 MB)
6 Importing Data into Power BI Desktop using ODBC option.mp4 (25.43 MB)
7 Importing Data into Power BI Desktop using Amazon Athena option.mp4 (52.3 MB)
8 Column Definitions.mp4 (18.78 MB)
9 Cleaning & appending data imported from Athena & CSV file.mp4 (96.93 MB)
1 Project Introduction.mp4 (21.7 MB)
10 Different Types of Filters in Filters Pane.mp4 (49.39 MB)
11 Top Bottom 5 Products By Sales, Quantity and Profit.mp4 (134.59 MB)
12 Sales Trends Over Time.mp4 (66.5 MB)
13 Other Requirements.mp4 (205.16 MB)
14 Requirement 4 DAX.mp4 (192.62 MB)
15 Requirement 4 Edit Interactions.mp4 (77.36 MB)
16 Other Remaining Requirements.mp4 (107.05 MB)
17 Changing Filter Behaviour for Dimension Table Slicers.mp4 (105.09 MB)
2 Business Requirements.mp4 (34.82 MB)
3 Loading Data into Power BI Desktop.mp4 (58.27 MB)
4 Data Profiling & Data Transformations Part 1.mp4 (122.08 MB)
5 Data Transformations Part 2.mp4 (150.76 MB)
6 Primary & Foreign Key.mp4 (33.63 MB)
7 Cardinality.mp4 (56.32 MB)
8 Star Schema.mp4 (84.45 MB)
9 Data Model Overview.mp4 (57.85 MB)
1 Project Introduction.mp4 (36.02 MB)
10 Adding a Donut Chart & Matrix Visual.mp4 (92.02 MB)
11 Publishing the Report to Power BI Service.mp4 (65.31 MB)
12 Scheduling Refresh.mp4 (44.25 MB)
13 Drill Through Filter.mp4 (65.91 MB)
14 Testing Scheduled Refresh & Publishing the updated report.mp4 (39.65 MB)
15 Creating & Testing Roles in PBI Desktop.mp4 (33.1 MB)
16 Testing & Implementing RLS in Power BI Service.mp4 (26.71 MB)
17 Power BI Reports & Dashboards.mp4 (67.26 MB)
18 Sentiment Analysis Power Query.mp4 (69.99 MB)
19 Sentiment Analysis Adding Visuals to the Report.mp4 (128.59 MB)
2 Downloading & Installing MSSQL Server.mp4 (61.66 MB)
3 Importing Data to MSSQL Server.mp4 (44.83 MB)
4 Loading Data to Power BI Desktop.mp4 (64.8 MB)
5 Table View & Data Profiling.mp4 (64.23 MB)
6 Adding Slicers & Text.mp4 (27.83 MB)
7 Adding New Card Visuals.mp4 (44.13 MB)
8 Adding a Multi Row Card & a Ribbon Chart.mp4 (49.26 MB)
9 Adding a Bar & a Line Chart.mp4 (111.84 MB)
1 Project Introduction.mp4 (27.27 MB)
10 Adding Bookmarks for Transactions.mp4 (43.31 MB)
11 Adding Bookmarks for Remaining Balance.mp4 (71.56 MB)
12 Publishing the Report to Power BI Service.mp4 (21.22 MB)
2 Loading Data into Power BI Desktop.mp4 (120.5 MB)
3 Data Profiling.mp4 (44.91 MB)
4 Size & Position of slicers.mp4 (12.21 MB)
5 Formatting the Slicers.mp4 (83.36 MB)
6 Adding a Page & Age Group Column.mp4 (50.2 MB)
7 Adding a Line Chart.mp4 (66.33 MB)
8 Adding a Matrix Visual.mp4 (68.4 MB)
9 Syncing Slicers & Applying Conditional Formatting.mp4 (37.53 MB)
1 Creating Banking Dataset Using Perplexity.mp4 (107.53 MB)
10 Top 2 Customers by Transaction Amount.mp4 (71.36 MB)
11 Total Balance by Account Type.mp4 (32.26 MB)
12 Inactive Accounts by Year & Month.mp4 (33.03 MB)
13 Customer Count by Gender.mp4 (30.11 MB)
14 Number of Customers by Age Group.mp4 (33.99 MB)
15 Adding & Formatting the Tree Map.mp4 (26.83 MB)
16 Adding Remaining Charts.mp4 (41.97 MB)
17 Publishing the Report to Power BI Service.mp4 (15.79 MB)
2 Removing Inconsistencies from Date Column using SQL & Perplexity.mp4 (68.81 MB)
3 Combining Data From Three Tables Using SQL Joins.mp4 (48.1 MB)
4 Importing Data into Power BI Desktop.mp4 (38.06 MB)
5 KPI, Chart and DAX recommendation using Perplexity.mp4 (54.12 MB)
6 Data Cleaning.mp4 (91.99 MB)
7 Cleaning Other Date Columns.mp4 (29.24 MB)
8 Number of Transactions by Type.mp4 (48.9 MB)
9 Transaction Amount By Month.mp4 (38.91 MB)
1 DAX Lecture 1.mp4 (172.36 MB)
2 DAX Lecture 2.mp4 (145.42 MB)
3 DAX Lecture 3.mp4 (246.94 MB)
4 DAX Lecture 4.mp4 (75.85 MB)
5 DAX Lecture 5.mp4 (126.86 MB)
6 DAX Lecture 6.mp4 (82.49 MB)
1 Creating the Github Account (Refer to resource section for signup Link).mp4 (18.38 MB)
2 Uploading Power BI Project to Github Account.mp4 (113.41 MB)
1 Explaining the projects in Interview.mp4 (36.71 MB)
2 Real Time Data Streaming in Power BI Using PUBNUB.mp4 (42.99 MB)]
Screenshot
DDownload
https://ddownload.com/0rl1a9f34eb3 https://ddownload.com/5diwagpds2cl https://ddownload.com/bpt94ev7nppu https://ddownload.com/vyqoi34miy9p https://ddownload.com/edywhel0zsmw https://ddownload.com/foymyrqhtvrs https://ddownload.com/9wa3quaxoe85 https://ddownload.com/j9jm043xdfbc https://ddownload.com/qi5mgdg4ty89 https://ddownload.com/8kp13cup15ip https://ddownload.com/wrdoe9a6h53h https://ddownload.com/0rcihopm424t https://ddownload.com/i64thr8j0bye https://ddownload.com/abqtowdjf83g https://ddownload.com/dqdkpy9jdz3r https://ddownload.com/4x7gdwhgze0v
