Скачать или смотреть Connecting Power BI to Salesforce, NetSuite, and other CRMs and ERPs

Comment "Blueprint" below and I'll send you the ERD/Blueprint from this video!

Are you considering connecting Power BI to an ERP or CRM?

My thoughts: the best way to connect to it, is to not connect to it at all.

In this video, I'll discuss why connecting Power BI directly to a CRM or ERP is not my preference, and what alternatives you can use, including building out a Data Warehouse in SQL Server, Oracle, or any other DB Platform.
We'll also use ChatGPT to generate a list of Benefits and Drawbacks, and we'll discuss them as well!

-----------------------------------
Data Sources
https://kaggle.com
https://data.gov
https://statista.com
https://www.microsoft.com/en-us/resea...
  / datasets  
https://datos.estadisticas.pr
-----------------------------------------
Resources:
https://Trailhead.Salesforce.com

Notepad ++: https://notepad-plus-plus.org/downloads
Power BI Visual Vocabulary: https://community.fabric.microsoft.co...
https://dbatools.io/commands
https://liveSQL.oracle.com
-----------------------------------------
Favorite PBI Channels:
/ @howtopowerbi
/ @datapears
/ @guyinacube
/ @powerbipark
-----------------------------------------
Favorite SQL Server Channels
‪@ErikDarlingData‬
‪@BrentOzarUnlimited‬
‪@AndyLeonard‬
‪@Kendra_Little‬

Catch me live on Twitch!   / sqldevdba  

Blogs: https://SQLDevDBA.com/blog
Power BI Demos: https://SQLDevDBA.com/power-bi-demos

-----------------------------------------
Chapters
00:00 - Intro
03:18 - Let's ask ChatGPT!
09:21 - Diagram of Solution/Proposal
10:06 - DataByJosh in the house!
13:28 - BlackGoku uses paint for Diagrams
19:49 - Connecting via ODBC/API (Benefits/Drawbacks)
27:58 - DataByJosh Asks: How do you get started working with CRM/ERPs?
33:14 - Data Rig: Macbook M1 and Micro PCs
37:58 - Back to diagramming!
41:02 - Connecting via Data Warehouses / Data Marts
42:49 - Evascroll in the house!
45:56 - Quick conversation on triggers
47:49 - Reviewing ETL (Data Collection) Methods
48:20 - Wait...SQL Server INFORMATION Services? :(
50:25 - BownerSoup in the house! Chat about ERP/Oracle
1:02:20 - I make mistakes...One was connecting PBI to ERPs/CRMs
1:04:35 - Virtual Data Platforms
01:11:08 - We're still using ODBC and API! It's about the destination.
01:12:40 - Quick chat about database platforms
01:17:30 - Outro / closing remarks (Try Chat GPT for yourself!)
------------------------------------
Tags
#powerbi #dataanalysis #datavisualization #sqlserver #sql #datawarehouse #crm #erp #salesforce #netsuite #turorial #powerbitutorial #databasemanagementsystem #database #datawarehousing #ETL