Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

How does SAS Visual Analytics work?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

How does SAS Visual Analytics work?

[ Edited ]

I am interested in SAS visual analytics. How does this work?

 

1-you have to build a large table with all variables. All dashboards use this table.

 

2-you have to build a table for each dashboard.

 

3-Each dashboard can read from different tables at once

 

Thank you.


Accepted Solutions
Solution
‎06-03-2016 05:24 AM
Trusted Advisor
Posts: 1,319

Re: Thanks for your answer but I do not understand exactly wh...

Not exactly...

 

The filter Country=USA for table1 will only subset the data in table1. Creating a Country=USA on table2 means you are using the Country column from table2 will subset the data in table2 only. You have to create filters per table, even though the column may exist in each table. 

 

Hope this helps.

View solution in original post


All Replies
Trusted Advisor
Posts: 1,319

Re: How does sas work?

Hi Kimo,

 

Welcome to the SAS Visual Analytics community. To answer your questions:

1-you have to build a large table with all variables. All dashboards use this table.  

    Yes

 

2-you have to build a table for each dashboard.

    No you don't have to. You can create multiple dashboards from the 1 table

 

3-Each dashboard can read from different tables at once

    Yes

 

To get you started using SAS Visual Analytics, you will see a box titled "SAS Visual Analytics Starter Kit" at https://communities.sas.com/t5/SAS-Visual-Analytics/bd-p/sas_va - I suggest going through these links.

 

Also @ChrisHemedinger posted earlier this week some very SAS Visual Analytics on-demand webinars you may find helpful at

https://communities.sas.com/t5/SAS-Visual-Analytics/Column-Percentage-in-bar/m-p/274082#M4452

 

Kind Regards,

Michelle

Occasional Contributor
Posts: 5

Thanks for your answer but I do not understand exactly wh...

[ Edited ]


Thanks for your answer but I do not understand exactly what you mean.


You answer yes to the first question and the third but I think they are contradictory.


If SAS can work each dashboard with several tables at once why build a single large table that is very hard work and not very practical for drill down if the large table is the result of mergers with other tables.




Can it be for performance ?.




Thanks for your attention.
Frequent Contributor
Posts: 123

Re: Thanks for your answer but I do not understand exactly wh...

Just to clarify @MichelleHomes comments - you can do it however you like.  It is based on your individual report.

 

In some cases - it works better to have a report/dashboard that is based on a single table.  Perhaps you have multiple views of the data - for instance a treemap that shows the products by Batch Number.  Then another section that has a map showing where the batch numbers were distributed.

 

You can also have the data broken into smaller tables if it is more convenient for you or works better for you data.

 

 


Tricia Aanderud
Zencos Consulting
Twitter: @taanderud - Follow me!

Trusted Advisor
Posts: 1,319

Re: Thanks for your answer but I do not understand exactly wh...

Sorry if my answers appear contradictory and created any confusion.

 

You can create a large table or multiple tables and load them into memory. If you are replicating the data in the multiple tables, it is obviously taking up additional resources (and may affect performance) which is why you might consider using one large table. Also you may want to use one large table if you want to have interactions within and between your reports so the data can be filtered. The source and target tables must be the same for the filtering to work.

 

I suggest spending some time reading the documentation, watching videos/webinars/tutorials and perhaps attend SAS Visual Analytics training to gain a solid understanding with your data load/preparation and report creation.

 

Kind Regards,

Michelle

Occasional Contributor
Posts: 5

Re: Thanks for your answer but I do not understand exactly wh...

Posted in reply to MichelleHomes

Thank you for your time.

 

 

Kind Regards,

Trusted Advisor
Posts: 1,319

Re: Thanks for your answer but I do not understand exactly wh...

Thank you @kimo. Glad to help.

 

Kind Regards,

Michelle

Occasional Contributor
Posts: 5

Re: Thanks for your answer but I do not understand exactly wh...

Posted in reply to MichelleHomes

I have a new question:   "if you want to have interactions within and between your reports so the data can be filtered. The source and target tables must be the same for the filtering to work."

 

 

 

Is it not possible to put a general filter that filters all tables at once?. 

 

In other words put a filter that interact with all tables but each table serves to calculate indicators.

 

Trusted Advisor
Posts: 1,319

Re: Thanks for your answer but I do not understand exactly wh...

New questions should really be created as a new question so that the thread remains as the original question. Please keep this in mind in future.

 

Filters are data source specific for the data items involved. If you have multiple tables being used in a report the filters will be applied to only the tables where a filter definition has been applied. Essentially a filter is a where clause on the table. 

 

It isn't possible to have a filter that applies to all the tables "at once". If you require this, it is best to join the tables outside of SAS VA and load the combined table into memory.

 

Occasional Contributor
Posts: 5

Re: Thanks for your answer but I do not understand exactly wh...

Posted in reply to MichelleHomes

Thank you,

 

I think I understand. If I make the filter

 

Country = USA.


If I defined in table1 and table2 the filter. each table is then filtered by the filter USA

It is correct?


Thank you and sorry for the inconvenience.

Solution
‎06-03-2016 05:24 AM
Trusted Advisor
Posts: 1,319

Re: Thanks for your answer but I do not understand exactly wh...

Not exactly...

 

The filter Country=USA for table1 will only subset the data in table1. Creating a Country=USA on table2 means you are using the Country column from table2 will subset the data in table2 only. You have to create filters per table, even though the column may exist in each table. 

 

Hope this helps.

Occasional Contributor
Posts: 5

Re: Thanks for your answer but I do not understand exactly wh...

Posted in reply to MichelleHomes
Thank you, Is it not possible to create a dropdown menu on the dashboard to apply the filter on each table?
Trusted Advisor
Posts: 1,319

Re: Thanks for your answer but I do not understand exactly wh...

[ Edited ]

As previously stated a filter is a where clause for a specific table. I suggest you read the Working with Filters section in the SAS Visual Analytics User Guide and trying it out in your own environment http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n0t60h2we10v5pn192cle...

 

Kind Regards,

Michelle

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 12 replies
  • 553 views
  • 5 likes
  • 3 in conversation