Techtalks: Data Science
About Data Science
How to use an existing machine learning model with Azure Machine Learning?
asked May 6, 2023
I have a Keras ML model .h5 file that I would like to publish as a web service. This model was created in Databricks. I want to use Azure ML for this purpose. I am following the steps given in this Azure documentation.
One of the prerequisites is to have "Azure Machine Learning SDK". All these topics are discussed in the Ai ml Certification.
My question is how to install "Azure Machine Learning SDK" in my Azure ml workspace. Do I need to type the commands in the Cloud Shell?
Any pointers would be helpful. Thanks.
Tableau error connecting to local MySQL db
asked Oct 7, 2022
Windows Server 2008 Tableau Desktop 7.0 Local MySQL database using Xampp
When attempting to connect to a localhost MySQL database server using the native MySQL data connection in Tableau Desktop, I'm getting the following error:
"The connection to the data source might have been lost. Communication with the Tableau Protocol Server process was lost.
Unable to connect to the server "localhost". Check that the server is running and that you have access privileges to the requested database. Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database."
When using "Other Databases (ODBC)" in Tableau, I am able to connect and return data. However, I would prefer to use the MySQL connection to avoid the limitations of the Other Databases connection.
I created a specific username in phpmyadmin as well as tried using the root username and password and the same error was returned. I created a user DSN in odbcad32.exe and attempted using multiple versions of the MySQL ODBC driver (3.5, 5.2.7, 5.3.4).
Does anyone have any ideas of what might be causing the error? Really appreciate any help.
Tableau error notation in brackets meaning
answered Sep 12, 2023
In Tableau, the notation "[62:33]" in the error message is used to indicate the specific location within your Custom SQL Query where the error occurred. It provides a way to pinpoint the line and character position in your query where Tableau encountered a problem. Here's how to interpret it:
-
62: This number represents the line number in your Custom SQL Query where the error occurred. In this case, the error is on line 62 of your query.
-
33: This number represents the character position within line 62 where the error was encountered. It indicates that the issue occurred 33 characters into line 62.
So, in your specific error message, Tableau is telling you that there's an issue related to the "Field1" name being ambiguous, and it's located at line 62, character position 33 in your Custom SQL Query.
To track down the error and resolve it, you'll want to go to line 62 in your SQL query and review the code around character position 33. The ambiguity in the "Field1" name likely means that Tableau is having trouble determining which table or data source "Field1" is referring to within your query. You might need to provide more specific table aliases or adjust your query to make it unambiguous.
Python Code Error
answered Oct 17, 2022
Hy Guys,
CCSP Course
With the help of this CCSP online training certification course, develop your knowledge of cloud security architecture, design, applications, and operations. You will get step-by-step instructions and a comprehensive lesson plan that is simple to follow covering every aspect of the CCSP, which will help you further your career in the expanding sector of cloud security.
What is the cost of RPA certification?
answered Sep 14, 2023
The cost of Robotic Process Automation (RPA) certification can vary widely depending on several factors, including the certification provider, the level of certification, and your location. Here are some general guidelines:
- Certification Provider: Different organizations and vendors offer RPA certifications. Some of the popular ones include UiPath, Blue Prism, Automation Anywhere, and Microsoft. Each of these providers may have their own pricing structure for certification exams and training materials.
- Certification Level: RPA certifications often come in different levels, such as beginner, intermediate, and advanced. The cost of certification may increase with the level of expertise being tested. For example, an entry-level certification might be less expensive than an advanced certification.
- Training Materials: In addition to the exam fee, you may need to invest in training materials, courses, and study resources to prepare for the certification. These additional costs can vary depending on the provider and your chosen method of study.
- Location: The cost of certification exams can also vary by region. Some regions may have lower or higher exam fees based on local market conditions.
- Promotions and Discounts: Some certification providers offer promotions, discounts, or bundle deals that can reduce the overall cost of certification.
To get the most accurate and up-to-date information on the cost of RPA certification, it's recommended to visit the official website of the certification provider you're interested in or contact their customer support. They will provide you with specific pricing details for the certification program you wish to pursue. Additionally, you can check if there are any community colleges, universities, or online platforms that offer RPA courses and certification at a lower cost compared to vendor-specific certifications.
How much training data is required for machine learning?
asked Nov 12, 2021
Is it possible to use unsupervised learning for labeled data?
asked Oct 29, 2021
What is data profiling in ETL?
answered May 7, 2023
Hello
Thanks Zaid md,
Data profiling in ETL is the process of analyzing and assessing the quality and structure of source data before it is loaded into a data warehouse or repository. The purpose is to identify potential data quality issues, define rules and transformations, and ensure the accuracy, completeness, and consistency of the data. By performing data profiling, organizations can make informed business decisions and improve the overall quality of their data. salesforce field service lightning certification
Is there any free open source image recognition API?
answered Aug 24, 2023
Yes, there are several free and open source image recognition APIs available:
Clarifai - An open source image and video recognition API. It has a generous free tier.
Amazon Rekognition - Amazon's image and video analysis service. Has a free tier that offers 5,000 transactions per month.
Microsoft Computer Vision - Provides image analysis and description. The free tier offers 5,000 transactions per month.
Google Cloud Vision API - Google's image recognition service. The free tier offers 1,000 requests per month.
OpenCV - A popular computer vision and machine learning software library. Can be used to build custom image recognition models and applications.
Tensorflow/Keras - Deep learning frameworks that can be used with transfer learning to build image classifiers. Free to use and open source.
IBM Watson Visual Recognition - IBM's visual recognition service. The free tier offers 50 API calls per month.
Alteryx Computer Vision - A library of computer vision tools for tasks like object detection, image classification etc. Open source.
DeepDetect - A framework for deep learning microservices including image recognition. Free for non-commercial use.
Cloudsight - Provides image recognition via a REST API. The free tier allows 1,000 API calls per month.
So in summary, Clarifai, Amazon Rekognition, OpenCV and libraries like Tensorflow offer the most full-featured free open source options.
What is the difference between OLAP database and relational database?
answered Mar 18, 2022
Relational Database (RDBMS)
- RDBMS is a DBMS that enables the organization of aggregated data.
- Relational DBMS is the most widely used database like Oracle, SQL Server. It is characterized by handling data in tables with basic keys that make it possible to identify the rows in each table separately. And an external key that allows you to associate the table with other tables.
OLAP (Online Analytical Processing)
- OLAP is a collection of software tools that provide information to business decision-makers.
- OLAP usually works on a standardized database to facilitate OLAP, not OLTP. These databases are often referred to as data warehouses.
- You can check the comparison and key differences between OLAP vs OLTP here