Datameer Blog

Tag: FAQ

SQL FAQ Feat

How to use the command line to import SQL files in MySQL?

4 Easy Steps to Import a SQL file in MySQL Below is the screenshot of importing create_tables.sql SQL file located at “D:\” drive in “sakila” Database. Open MySQL Command Line Insert the user name and the password mysql > use your_database; mysql > source file_path_with_file_name.sql   Now that you’ve learned how to import a SQL […]

  • SQL FAQs
  • December 16, 2018
Tableau Questions

How to create the cumulative view bar chart in Tableau?

To calculate the cumulative total, you do not need to write measures or Calculating Columns; for this, Tableau has quick measures. Add a measure to the graph. Then right-click on the measure as shown in the image. Select Running Total in Quick Measures That is how to create the cumulative view bar chart in Tableau […]

  • Tableau FAQs
  • December 13, 2018
Tableau Questions

In Tableau, how do I use DATEDIFF to calculate number of days when there are null values in the data?

DATEDIFF is a powerful feature that is often used in Tableau. DATEDIFF includes three required parameters (date level, start date, and end date). We can also use DATEDIFF in conjunction with an IF or CASE function. Here we are considering one such case: IF NOT ISNULL([DueDate]) THEN DATEDIFF( ‘day’, [DueDate], [StartDate]) ELSE 0 END IF […]

  • Tableau FAQs
  • December 13, 2018
Tableau Questions

Is there a way to merge or append Excel data files into one set in order to analyze the data in Tableau?

To Append excel data in Tableau, use the Union function. This is available when using Excel files as a source. Next, we will look at this step by step: After adding the Excel file to Tableau, you need to double click on the file as shown in the image: Then a window will appear in […]

  • Tableau FAQs
  • December 13, 2018
Tableau Questions

How to insert a simple text box into a Tableau worksheet?

Adding text to the worksheet is not possible as it is used in most cases on the Dashboard. Ultimately, a result is expected in which there is a visual element displaying arbitrary text. To implement this, you can perform the following steps: If you already have a developed dashboard and you need to add arbitrary […]

  • Tableau FAQs
  • December 13, 2018
Tableau Questions

How do I locate the source data files used in the Tableau Global Superstore Sales example?

Tableau Global Superstore To locate source data files in the Tableau Global Superstore sales, in the Tableau Connect pane, under Saved Data Sources, click Sample – Superstore to connect to the sample data set. Your Tableau screen will look something like this: In Datameer Spotlight, you can access data for your Tableau dashboards that you never could before, […]

  • Tableau FAQs
  • December 13, 2018

Instant Access To Our Free Library Of Resources

Discover the Top ETL and Data Integration Platforms

Comparison_of_Leading_ETL_And_Data_Integration_Platforms

Featured Blog Posts

Five Critical Success Factors To Migrate Data to Snowflake
Five Critical Success Factors To Migrate Data t...

You’ve decided to modernize your data and analytics stack and migrate analytics workloads to the ...

  • John Morrell
  • May 10, 2021
ETL++
ETL++: Reinvigorating the Data Integration Market

(This article first appeared on Medium on April 6, 2021.) The definition of “++” means incrementa...

  • John Morrell
  • April 12, 2021
Spectrum ETL
Disrupting the no-code cloud ELT market: Datame...

More than just loading Data: Datameer launches Datameer Spectrum ETL++ to disrupt the no-code clo...

  • Press Release
  • February 9, 2021
READ ALL