Price$1
Section 1Downloading and Installing Resources
Lecture 1Downloading and Installing SQL Server
Lecture 2Downloading and Installing Power Bi Desktop
Lecture 3Microsoft.ACE.OLEDB.16.0 SQL Error in Importing Ex
Lecture 4Resource Link
Lecture 5Importing Staff Table
Lecture 6Importing Product and Site Table
Lecture 7Importing Leads Table
Lecture 8Importing Prospect Table
Lecture 9Importing Applications Table
Lecture 10Importing Accounts Table
Lecture 11Importing Cards Table
Lecture 12Importing Sales Table
Section 2Querying SQL and Creating Views
Lecture 13Problem Statement
Lecture 14Task
Lecture 15Querying Padi Cards Tasks Part 1
Lecture 16Querying Padi Cards Tasks Part 2
Lecture 17Grouping Accounts By Average Profit
Lecture 18Create View for Number of Padi Cards
Lecture 19Create view for Account First Transaction
Lecture 20Padi Sales View
Lecture 21Exporting SQL view into csv and Excel
Section 3Padi Cards Phase out Project
Lecture 22Project One Overview
Lecture 23Padi Cards Only View
Lecture 24Padi Sales Only View
Lecture 25Create View of Counts of Padi and Other Cards
Lecture 26Connect Power BI to SQL Server Padi
Lecture 27Power Query Transformation Card Count
Lecture 28Power Query Transformation on End Date
Lecture 29Power Query Transformation on Padisales view
Lecture 30Creating Rolling Calendar
Lecture 31Power BI Enviroment
Lecture 32Data Modelling
Lecture 33Building Padi Cards Project Report
Section 4Sales Analytics Project
Lecture 34Loading Data for Sales Analytics Project
Lecture 35Modelling Data for the Project
Lecture 36Download Background Image File
Lecture 37Importing Background and Creating Measures
Lecture 38Working with New Cards Visual
Lecture 39Working with Clustered Column Chart
Lecture 40Working with Table Visual
Lecture 41Clustered Bar Chart Visual
Lecture 42Clustered Bar Chart Visual 2
Lecture 43Working with Treemap Visual
Section 5Working with Power BI Service
Lecture 44Power BI Service and Workspaces
Lecture 45Publishing Report into Power BI Service
Lecture 46Installing Personal Gateway for PowerBI Service
Lecture 47Enable Data Credentials and Refresh Report
Lecture 48Automatic Schedule PowerBI Report Update
Lecture 49Setting up Email Alert for your Report
