I love your content, especially the recent episode on sentiment analysis with Python. I wanted to suggest a future project idea: integrating Power BI with R Studio for time series and sentiment analysis in marketing. It would be amazing to see how these tools can work together for more dynamic insights. Would you consider sharing such a project on LinkedIn? I think it would be valuable for the community, and I’d love to see more people discover your work. Thanks for considering this!
Hello Brandon! Thank you for watching and the kind words! I am very happy to hear you enjoyed it. That is a great suggestion! I will note it down among some ideas I have. I think that I will moe onto another segment next though. Any suggestions? I haven't thought about mixing Power BI / R yet in one project, but time series analysis is something that I have on the block. Thank you again for watching! Ali
@@aliahmad1987 hi, after writing this code: def fetch_data_from_sql(): # define the connection string with parameters for the database connection conn_str = ( "Driver={SQL Server};" "DESKTOP-C4U90UN\SQLEXPRESS;" "Database=PortfolioProject_MarketingAnalytics;" "Trusted_Connection=yes;" ) error message is conn_str is not defined.
pandas.errors.DatabaseError: Execution failed on sql 'SELECT ReviewID, CustomerID, ProductID, ReviewDate, Rating, ReviewText FROM fact_customer_reviews': ('42S02', "[42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'fact_customer_reviews'. (208) (SQLExecDirectW)") i am getting this error in python
Hi, I would check the object name (as the error points out) first? It should have the same nam e in the database as in the Script to be able to fetch it through SQL. Ali
I love your content, especially the recent episode on sentiment analysis with Python. I wanted to suggest a future project idea: integrating Power BI with R Studio for time series and sentiment analysis in marketing. It would be amazing to see how these tools can work together for more dynamic insights.
Would you consider sharing such a project on LinkedIn? I think it would be valuable for the community, and I’d love to see more people discover your work.
Thanks for considering this!
Hello Brandon!
Thank you for watching and the kind words! I am very happy to hear you enjoyed it.
That is a great suggestion! I will note it down among some ideas I have. I think that I will moe onto another segment next though. Any suggestions?
I haven't thought about mixing Power BI / R yet in one project, but time series analysis is something that I have on the block.
Thank you again for watching!
Ali
Nice. Keep up the good work. Looking forward to the next episodes.
Thank you!
Out on Wednesday 👍🏽. Will be moving into Power BI then, which I think a lot will enjoy.
Have a great weekend and thanks for watching!
Ali
Hi, thanks for this. My python is saying Query not defined. And I have already defined Query
Hi,
I am bit unsure here. Where are you getting this error? In Python when you are executing it or?
@@aliahmad1987 hi,
after writing this code: def fetch_data_from_sql():
# define the connection string with parameters for the database connection
conn_str = (
"Driver={SQL Server};"
"DESKTOP-C4U90UN\SQLEXPRESS;"
"Database=PortfolioProject_MarketingAnalytics;"
"Trusted_Connection=yes;"
)
error message is conn_str is not defined.
pandas.errors.DatabaseError: Execution failed on sql 'SELECT ReviewID, CustomerID, ProductID, ReviewDate, Rating, ReviewText FROM fact_customer_reviews': ('42S02', "[42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'fact_customer_reviews'. (208) (SQLExecDirectW)")
i am getting this error in python
Hi,
I would check the object name (as the error points out) first? It should have the same nam e in the database as in the Script to be able to fetch it through SQL.
Ali