Stack Overflow
Stack Overflow

Questions tagged [bi-tool]

Business Intelligence Tools to build the queries within seconds using a drag-and-drop interface without any SQL skills

Business Intelligence Tools to build the queries within seconds using a drag-and-drop interface without any SQL skills

27 questions
2
votes
1 answer

Zeppelin over Superset

I have been using zeppelin for a couple of years, now superset is gaining more attention for better Visualization features etc. so I am trying to understand exact differences and also help if someone is looking to select a BI tool. I have listed a…
scoder
  • 2,451
  • 4
  • 30
  • 70
1
vote
0 answers

Problems with publishing Dashboards in Tableau Public

While going through Google Data Analytics Certification I have come across the Tableau. Particularly, I am using Tableau Public (Free Web Version). The problem is, I could not save dashboards I have created do to the 'Couldn’t save workbook Tableau…
Patrick Palm
  • 11
  • 1
1
vote
0 answers

All the Data elements are not visible in tableau

I am using Tableau public 2021.3 and I have attached multiple CSV files as connections in the tableau. The problem that I am facing is that I am able to view that there are for example 20 rows in the given data table but the same 20 rows are not…
Nikhil Sharma
  • 11
  • 4
1
vote
1 answer

How to querying on build sisense elastic cube?

I am new in Sisense tool. I have created elastic cube in Sisense and built this cube successfully. Now the elastic cube result does not match the source database result. So is there any way to execute a query on Sisense built elastic cube to…
NP007
  • 659
  • 8
  • 21
1
vote
1 answer

Talend DB to JSON OutPut file

I am stuck in one job of Talend. I am using Talend for migrating the DB fields into a JSON file. I am successfully able to do the job but the JSON format which I am getting is an array format, not the customized format like address fields are not…
Nitesh Kumar
  • 875
  • 4
  • 20
  • 39
1
vote
1 answer

Not able to get condition operators in EasyQuery

I was exploring EasyQuery for our db requirements. i downloaded the trial version and in samples i replaced my datamodel created using EasyQuery itself. but when i run the sample project in condition panel where there is text to choose condition…
Radhi
  • 6,289
  • 15
  • 47
  • 68
0
votes
0 answers

What is the best way to aggregate granular data in PostgreSQL database for the data analysis?

Please help us with ideas for the following case. Our startup e-commerce solution currently serves about 5,000 online shops, and the number is growing. Each shop sells several hundred unique products (let's say the mean is 300). The daily sales data…
DSSC
  • 1
0
votes
0 answers

create row level security in quicksight if the user belongs to a particular department

Lets say I have a dataset named Reports like this: department_name account_id Security 1 Marketing 2 and I have users in my organization that are divided into departments, I want to be able to show only the departments in the…
qabootar
  • 25
  • 6
0
votes
2 answers

How to create row level security on AWS Quicksight Authors

In our business case we want to implement row level security for our authors. Our customers would have the author access to the Analysis page. They can create their visualization and publish the dashboards. Our parquet files are stored in S3 and…
RCode
  • 99
  • 2
  • 2
  • 13
0
votes
1 answer

Is it possible to use OBIEE's Client tools for OAS and vice versa?

We have recently installed OAS on our test server. Our production on the other hand currently runs OBIEE 12.2.1.4. Both of them rely on the same database and connections are same. I have uploaded an rpd file that is being used in OBIEE 12 into OAS.…
Sherzodbek
  • 170
  • 1
  • 20
0
votes
1 answer

What are the parameters which effect on speed of Power BI

Which parameters affects most on executing query using PowerBI? What is important on server side? Do HDD disks slows very much and choosing SSD is much better? Is any standards that mysql DB should fulfill to to make Power Bi run faster? Is there…
Mateusz P
  • 211
  • 1
  • 3
  • 12
0
votes
1 answer

How do I add a custom login and logout page in my Tableau Server on-prem?

I am having the scenario for tableau server as follows: I want to have a custom login/logout page. Logging to my custom page, I want to use either trusted auth or SSO and bypass the tableau server login screen. This step theoretically seems…
spn_1234
  • 1
0
votes
1 answer

Filtering pivot table in Sisense with negation

I'm trying to implement a simple filter in Sisense, but I can't figure it out. My data is stored in a PostgresQL DB. A minimal example looks something like this: CREATE TABLE fact_table ( first_name text, salary integer ); INSERT INTO…
ahanf
  • 59
  • 1
  • 7
0
votes
1 answer

How to use in Tableau, excel averageif function

Create a function that does excatly what averageif function does in Microsoft Excel Even if some workarounds can be done to replicate the function, they don't work in all cases (e.g. it is not possible to replicate it "dynamically" like when…
Manish Shukla
  • 1
0
votes
1 answer

Grouping dates in Big query

I've been trying to write a query on big query to get the difference between two times (Created at and resolved at) and get the average of it grouped by day. This is the query I wrote: SELECT avg(datetime_diff(datetime(stats.resolved_at),…
Bhavana
  • 1
1
2