Тёмный
Jie Jenn
Jie Jenn
Jie Jenn
Подписаться
Hi. I am Jie, a data professional with over 10 years of expertise in analytics engineering, data analytics, and automation. I offer comprehensive data solutions to help businesses harness the power of their data. Topics I cover on my channel:

➡️ Data Analytics and Engineering: SQL optimization, BigQuery implementation, data modeling, ETL/ELT processes.

➡️ Business Intelligence and Reporting: Custom dashboards, KPI tracking, automated reporting solutions.

➡️ Cloud Integration and Migration: AWS, GCP, Azure implementation, data warehouse design.

➡️ Process Automation: RPA implementation, workflow optimization, custom automation solutions.

➡️ dbt (Data Build Tool) Implementation: Data transformation, pipeline integration, scalable modeling.

✉️For business inquiring: jiejenn@LearnDataAnalysis.org

#datanalytics #dataengineering #dataengineer #gcp #python #azure #aws

Clean Up Project Files | dbt Tutorial
1:39
Месяц назад
Комментарии
@shockwavemasta
@shockwavemasta 42 минуты назад
Love it - keep up the great work
@darkfrozen1860
@darkfrozen1860 8 часов назад
This really helped me a lot Thanks since the HP doesn't give option to change fn key functions which is horrible and expected from cheap manufacturer like them. Wanna point out something that in my case the username wasn't was what's in the properties. I went to users directory and find my username there and then used it.
@fathimuhyi725
@fathimuhyi725 День назад
Thanks Man, can you tell me which action and permission required ?
@H4wk_2669
@H4wk_2669 2 дня назад
My pdf isn't editable pdf
@jiejenn
@jiejenn 2 дня назад
Then you need to make the PDF editable.
@bishnupaswan514
@bishnupaswan514 2 дня назад
Thank you ❤
@abrarhussain7540
@abrarhussain7540 2 дня назад
Very helpful and good learning
@abrarhussain7540
@abrarhussain7540 2 дня назад
Very helpful and good learning
@AB-yf7jz
@AB-yf7jz 2 дня назад
Thank you, this is awesome! Is there a way to get the username who submitted the post and if the post has a url link (for example, to another website)?
@jiejenn
@jiejenn 2 дня назад
For username info, you will have to use the official API.
@RajashekarBasarveni
@RajashekarBasarveni 2 дня назад
where is the option to pass the TABLE SCHEMA?
@helloworld-s7y
@helloworld-s7y 3 дня назад
Going through ChatGPT, documentation, Stackoverflow, none worked. Thanks so much for finally solving the issue step by step!
@abhiram8025
@abhiram8025 3 дня назад
I need get monday day when the start with first monday of each month then it fill current_month else current_month -1 end as sales_month
@al1rios
@al1rios 3 дня назад
Great work Jie!!!!
@jiejenn
@jiejenn 3 дня назад
Thanks!
@farzanarahman83
@farzanarahman83 3 дня назад
Thank you sooo much, this formula was exactly what I was looking for!!! <3
@yazanrisheh5127
@yazanrisheh5127 3 дня назад
Hey jie, could you do a video on how can we extract lat and long from google API using googles CID please?
@jiejenn
@jiejenn 3 дня назад
I will look into it.
@dev_apostle
@dev_apostle 4 дня назад
another excellent tutorial
@jiejenn
@jiejenn 4 дня назад
@@dev_apostle Thank you!
@molinaoctavio7849
@molinaoctavio7849 4 дня назад
I am getting data fron mysql, i can read just before to assign the nodel to the combobox
@molinaoctavio7849
@molinaoctavio7849 4 дня назад
Hot to assign this nodel to a qcombobox, (just 2 columna) pyqt6 or pysise6
@vikashmourya4881
@vikashmourya4881 4 дня назад
hi Jie i am getting error Failed to create service instance for places: [WinError 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond [WinError 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond None
@vikashmourya4881
@vikashmourya4881 4 дня назад
service is as nonetype object
@jiejenn
@jiejenn 4 дня назад
WinError is usually the issue with Google Cloud's server is temporarily down. Usually wait a minute or two and try again.
@marciomartins4111
@marciomartins4111 4 дня назад
thanks
@nmachinjemanze4506
@nmachinjemanze4506 5 дней назад
Download not working 😕 make a video for difficulty downloading adventureworks sample databases please
@jiejenn
@jiejenn 5 дней назад
It is working for me. Maybe the site was download earlier. Try download it again.
@EMO_Amarok
@EMO_Amarok 6 дней назад
Thank you so much
@wilmenls
@wilmenls 6 дней назад
how can i just send the e-mail without manually input the access token?
@RandomBitzzz
@RandomBitzzz 6 дней назад
This is the first example that I've actually been able to get running. One question... tools like GAM allow you to interact with a sheet as any Google Workspace user (without the need to give the service account permissions to the sheet) as part of the tool. Any idea how someone can replicate this?
@jiejenn
@jiejenn 6 дней назад
I haven't used GAM before, so can't really answer that quest.
@pon00050
@pon00050 6 дней назад
I am writing this comment after watching only the introduction part. There was Microsoft Query and, in more recent times, there is now the Power Query that one can use to run SQL queries by enabling query folding. Is there more to this tool that you show in the video?
@QuietLumina
@QuietLumina 7 дней назад
Fantastic, thanks so much!
@peterlohnes1
@peterlohnes1 7 дней назад
it doesnt work for me
@jiejenn
@jiejenn 7 дней назад
@@peterlohnes1 why not?
@Felipe-ib9cx
@Felipe-ib9cx 7 дней назад
Top quality tutorial
@itsmilliemy6170
@itsmilliemy6170 7 дней назад
Thank you so much.
@abdulazizkodirov5323
@abdulazizkodirov5323 7 дней назад
Can this be done with LinkedIn?
@jiejenn
@jiejenn 7 дней назад
Sure you can, but LinkedIn is just a job post hosting platform.
@abdulazizkodirov5323
@abdulazizkodirov5323 7 дней назад
This is cool! I would use ChatGPT API to answer the personal questions.
@617steve7
@617steve7 7 дней назад
Thank you!
@debasisdey7562
@debasisdey7562 8 дней назад
thanks for your inmormation sir .
@thomjz
@thomjz 8 дней назад
Can you explain to me why my code doesn't work? import sys from PyQt6.QtWidgets import QApplication, QWidget, QLineEdit, QPushButton, QTextEdit, QVBoxLayout from PyQt6.QtGui import QIcon class MyApp(QWidget): def __init__(self): super()._init_() self.setWindowTitle('Hello app') self.setWindowIcon(QIcon('maps.ico')) self.resize(500, 350) # width, height layout = QVBoxLayout() self.setLayout(layout) # widgets self.inputField = QLineEdit() button = QPushButton('&Say Hello', clicked=self.sayHello) button.clicked.connect(self.sayHello) self.output = QTextEdit() layout.addWidget(self.inputField) layout.addWidget(button) layout.addWidget(self.output) def sayHello(self): inputText = self.inputField.text() self.output.setText('Hello {0}'.format(inputText)) app = QApplication([]) app = QApplication(sys.argv) app.setStyleSheet(''' QWidget { font-size: 25px; } QPushButton { font-size: 20px; } ''') window = MyApp() window.show() app.exec()
@graxxarecords3456
@graxxarecords3456 8 дней назад
How to deal with the json file on production enviroment?
@محمدابراهيم-ك7و1ي
@محمدابراهيم-ك7و1ي 9 дней назад
Text join with Match can tell you the number of cell auto (i said can textjoin work with other forumuls and yes it can work if any formula if you use it true :))
@prashlovessamosa
@prashlovessamosa 9 дней назад
Great
@sercanyildirimtugcann
@sercanyildirimtugcann 9 дней назад
Dude, how can I apply this for unstructured documents too? Is there any resources related to this topic? Thx.
@jiejenn
@jiejenn 9 дней назад
Not familiar with unstructured documents. Can you show me an example?
@TheOneHong
@TheOneHong 10 дней назад
isn't colab just Jupiter?
@jiejenn
@jiejenn 10 дней назад
They shared many similar features, but they are not the same products.
@LordOfLiches
@LordOfLiches 10 дней назад
Thank you for this video! I am working on building a SQL portfolio so wanted to create some databases of my own that I can query and was constantly running into errors on the deployment step. Your walkthrough helped me get everything set up exactly as I needed. :)
@jiejenn
@jiejenn 10 дней назад
Glad to hear!
@damianalvarez5266
@damianalvarez5266 10 дней назад
Hello sir ,can you please make a video on how to speed up the data displayed in a QtableWidget when there are for example 5 columns and 1000 rows of data to display(it takes between 20 s or more to display all the information).
@EnderRobber101
@EnderRobber101 10 дней назад
Does this require a billed account now?
@jiejenn
@jiejenn 10 дней назад
Yes.
@shockwavemasta
@shockwavemasta 10 дней назад
Thanks for this helpful overview!
@jiejenn
@jiejenn 10 дней назад
Thank you for the comment!
@dipankarbose5933
@dipankarbose5933 11 дней назад
Promising .😊
@jiejenn
@jiejenn 10 дней назад
I have high hope. Been avoiding Python notebooks for 5 years now 😂
@mjacfardk
@mjacfardk 11 дней назад
❤ nice thank you for your help
@jiejenn
@jiejenn 11 дней назад
👍
@SundarRajendiran
@SundarRajendiran 11 дней назад
is it possible for Tavily search engine to search from specific target website? I understand Tavily find information from various sources. But can we make it to find the information from specific website?
@jiejenn
@jiejenn 11 дней назад
To be honest, I don't know the answer. You will have to check the official documentation.
@generalyoutubewatching5286
@generalyoutubewatching5286 11 дней назад
looking at the youtube generated closed capture is funny project = parcher
@AIwithChristopheAtten
@AIwithChristopheAtten 11 дней назад
Thanks for this video it helped me a lot. However, I want also to the set Filename, which is visualied when uploading a video manually on the right side between the video link and vidoe quality. Another information I am missing is the altered content. Is there any way to add those information?
@Christty-d9w
@Christty-d9w 11 дней назад
Is the speech feature still working on azure? Every time I go into create a token, it tells me to create an account. I am already logged in.
@Christty-d9w
@Christty-d9w 11 дней назад
Can people still create tokens. I keep trying to create a token key but it keeps asking me to create an account when I hit create. I am already logged into an account.
@ShelleyCurrie
@ShelleyCurrie 12 дней назад
Thank You, very helpful.