Techtalks: Data Science

About Data Science

Data is no longer a trend or a buzzword, it’s a part of the growth strategy for every business. Machine Learning, Artificial Intelligence, Business Intelligence, Big Data – these tools help us analyze the past, understand the present, and look into the future with unmatched accuracy. Join the Techtalks community to explore these possibilities, find answers to your questions, and share your experience with others.

What is data profiling in ETL?

2.4 Kviews
image placeholder
Steve Diaz, Software Developer at Walmart

answered  May 7, 2023


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

image placeholder
Jack son000

answered  Jun 1, 2023

Firstly, choose the right longboard for your needs. Consider factors such as board length, flexibility, and wheel hardness. Longer boards provide stability and control, while shorter ones offer more agility. Softer wheels are ideal for a smoother ride, while harder wheels are better for tricks and sliding

Python Code Error

1.1 Kviews
image placeholder
James Harry, Digital Trainer at igmGuru

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.

image placeholder
Zaid md

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
image placeholder
Vivek Garg

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.

In Addition, I learn from Tableau certification course.
Thank you in advance.
image placeholder
Vivek Garg

asked  Sep 28, 2022

In Tableau I received the following error message:

The Google BigQuery service was unable to compile the query. Name Field1 is ambiguous inside Custom SQL Query at [62:33]

My BQ Query seems to work fine in BQ, but when copy paste in Tableau the above error shows. In order for me to track the error, I want to understand the error message.

What does [62:33] refer to? My query is only 47 lines of code, so I can't really seem to grasp the meaning of this notation...

In Addition, I learn from tableau online training.
Thank you in advance.
image placeholder

asked  Apr 4, 2022

image placeholder

asked  Nov 12, 2021

image placeholder

asked  Oct 29, 2021

image placeholder

asked  Jun 14, 2021