Analytics

445

Solutions

677

Contributors

Analytics is the discovery and communication of meaningful patterns in data. Especially valuable in areas rich with recorded information, analytics relies on the simultaneous application of statistics, computer programming and operations research to quantify performance. Specifically, areas within analytics include predictive analytics, prescriptive analytics, enterprise decision management, retail analytics, store assortment and stock-keeping unit optimization, marketing optimization and marketing mix modeling, web analytics, sales force sizing and optimization, price and promotion modeling, predictive science, credit risk analysis, and fraud analytics.

Share tech news, updates, or what's on your mind.

Sign up to Post

Referencing this topic:  https://community.tableau.com/message/746162#746162

 1) I want to take it a step further and hide the relative dates (Start and End date Parameters).
OR
2) Can I populate the start and end date parameters based on my selection?
 
For example:
Past Month would display 6/1/18 in the start date and 6/30/18 in the end date.

YTD would display 1/1/18 in the start date and 7/12/18 in the end date, etc

 

If that is not possible then I just want to be able to hide the start and end date parameters unless I choose CUSTOM.

 

--------------------------------------------------------------------------------------------

Here is the case statement for the drop-down Date Filter:

CASE [Select Range]

WHEN "Most Recent Date" THEN

    //Sunday

    IIF (DATEPART('weekday',TODAY()) = 1,(IF DATEADD('day',-3,TODAY()) = [Date] THEN "Keep" Else "Drop" END),

    //Monday

    IIF (DATEPART('weekday',TODAY()) = 2,(IF DATEADD('day',-4,TODAY()) = [Date] THEN "Keep" Else "Drop" END),

    //All other days

    IIF (DATEADD('day',-2,TODAY()) = [Date],"Keep","Drop")))

WHEN "Past Week" THEN

    IF DATEPART('weekday',TODAY()) = 2 THEN

    (IF (DATEPART('week',[Date]) = DATEPART('week',TODAY())-1 OR (DATEPART('week',TODAY()) <= 1 AND DATEPART('week',[Date]) = 1)) AND DATEPART('weekday',[Date]) < 6 AND DATEPART('weekday',[Date]) > 1 AND [Date] > DATEADD('day',-365,TODAY()) THEN "Keep" END)

    ELSE

    IF …
0
Ultimate Tool Kit for Technology Solution Provider
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Hi, I checked this page in Google's new url tool:
https://www  dot magickitchen.com/meal-delivery/

It says:  Indexed, not submitted in sitemap. But I checked the sitemap section, and it's using the one I submitted, in the root, sitemap.xml.
And if you go to that sitemap and search the URL, it's there.

Can anyone explain that to me? WHy would it say not submitted in sitemap when it's clearly there and has been since March? Thanks.
0
Maintaining an effective business website is a complex task, seeing as how efficiency might be interpreted in different ways. Here are top five techniques and methods to maintain an effective business website.
0
hi,

what kind of OLTP and OLAP solution MySQL has ?

please share URL.
0
I've been tasked to "install an ODBC connector on our Timeslips 2018 Firebird database" so that the new analytics vendor can "access the raw data for analysis".  I'm happy to do this if it is a valid operation, BUT I have no clue how to do it.  Any articles, videos, contacts or guidance is greatly appreciated.  I assume the ODBC connector/driver/utility would need to be installed on the server computer where the Timeslips database resides.  Besides that, I am at a loss.  Is this a common and simple operation OR am I just going to be beyond my depth?  If so, who to contact?
0
15+ years ago we ran Webposition Gold software with a list of 100+ keywords that automatically reported results from all the engines like the below so you could easily see how your ranking was trending, but Webposition Gold was blocked (http://www.aimclearblog.com/2007/06/11/google-makes-it-official-webposition-gold-is-dead/) since Google/etc wanted to start selling their own Analytic Reporting services

What software do you recommend now so I can find out what rank each one of my 100+ keywords currently have like the attached shows ?

I am OK with using Google Analytics/etc if that will work

1
0
I'm trying to create a custom Google Analytics custom report that shows the following by date range: Organic Search, Direct Traffic, Referral, Social, Email, PPC and also somewhere in the report show the PPC spend.  

Let me know if this is possible and how to do it.  I've not used custom reports much.
0
I have created a query/agent job and I want to turn it into a ssrs report where the user can select parameters from drop down menus.

My question is, what tool should I choose to create my first report of this kind?  It seems like all 3 below will work, (different means to the same end) I just want to pick a good one as a starter.

1) Native tools on report server url?
2) SSDT?
3)1.BIDS ( Business Intelligence Development Studio 2010)>
0
Hi,  would like to seek all your expertise to recommend a free open source tools that can become clustering on Survey data,   the enterprise tools like SPSS, SAS etc are overkill as our data are less than 1-2K, and what we need to do is chunk all the verbatim questions, comments or forum threads into topics,  sub-categories, categories

I had tried Lexalytics in the past still not what we want for end users (general casual user),    as most of the time we will be inputting our own lexicon and feed to this tools,  so the default taxonomy, lexicon library may not be accurate after the 1st run

best that this tool is on premises (without internet connection)

Thank you all
0
Need some sql that will get the min on a column and return the entire row without using a subquery or a group by... basically an analytic sql statement that doesn't require as subquery to return the lowest column row data based upon a particular column. Like a group by but not using a group by or a subquery.

thanks
0
The IT Degree for Career Advancement
The IT Degree for Career Advancement

Earn your B.S. in Network Operations and Security and become a network and IT security expert. This WGU degree program curriculum was designed with tech-savvy, self-motivated students in mind – allowing you to use your technical expertise, to address real-world business problems.

hi,


What Business intelligence and report solution DB2 offer ?
0
Cognos 10, Oracle database. Situation is that a list inside a table is repeating itself and I'm looking for a way to not have it repeated. Is there an option in the properties page that might need enable or disable to resolve this issue. Please see attached image.

Thanks
Capture.JPG
0
Content
The list of reasons why every serious business out there needs a content marketing strategy goes on. In this day and age, people are searching for content more than ever. Establish yourself as a trusted provider of content and it will reward you for years to come.
1
How do we add Google Analytics to Wordpress?
0
We have a client that wants to start getting involved in social network having presence in Tweeter, Facebook, LinkedIn, Instagram and Pinterest.  Not only posting its business “news” or “new product” but articles of interest that come upon on a daily bases or even re-post articules or contents from other business partners, etc.

Besides the fact the client wants to know what  is the best way to start, one concern is posting data.  That  is comments, pictures, etc.  

We want to know how to go about posting an issue through all these social networks.  

For example, we found an artificial intelligence topic interesting and wanted to post it.  We download the article, download some images, prepare it and posted to Facebook.  How do the user go about  to modify contents prior posting to all Tweeter Facebook LinkedIn Instagram Pinterest? Or is there a way that the user can creat a “template” and then post them to all?
0
Has anyone used the Netscaler content switching to have information from an internal server get published on an external hosted ERP Website?
Basically I am trying to take an internal Tableau Server to Netsuite.
0
If I want to pursue a career as a Data Analyst and I have limited data analysis skills in addition to SQL, Python, HTML, CSS and Microsoft Office Suite experience, are there any certifications I could take to bolster my credentials as a Data Analyst?
1
Error with debugging with firefox

https://bitcoin.seminario.com.mx/video2.php

This is the code:

<!DOCTYPE html>
<html lang="en">
<head>

<!-- Global site tag (gtag.js) - Google Analytics -->
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-112384334-1"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'UA-112384334-1');
</script>


</head>
<body>

</body>

</html>

Chrome debugging tools show no errors but firefox returns in the console

unreachable code after return statement js:69:1092

Chrome shows no errors.

Any ideas?
0
Can I visit a web page that has analytics  (not in my server) and have my visit not be counted in google analytics?
0
The Lifecycle Approach to Managing Security Policy
The Lifecycle Approach to Managing Security Policy

Managing application connectivity and security policies can be achieved more effectively when following a framework that automates repeatable processes and ensures that the right activities are performed in the right order.

Hello,

I have a client who has 60 hospital clients throughout the US. They are looking to grow but we want to see what attributes these 60 clients might have in common as compared to all of the other hospitals around the US. We'll have access to all kinds of volume, demographic, and other financial information to use in this comparison. What would be the best tool to have the system try to suggest where there might be a disproportionate amount of hospitals that have xyz characteristic in the 60 existing clients as compared to the rest of the US? I have access to IBM Cognos, Tableau and even a free trial of Watson. I just would rather not go through all 200 characteristics of all potential hospital clients one by one manually in order to stumble into one that might be a key attribute we can use to target other similar clients for sales efforts.

Thanks!
0
Hello All,

Hope someone clarify the error I have in my STIDF data plot.
I'm reading through related questions but no solution fixed my error.

I'm working on STIDF  and I want to use stplot and spplot but it seems spplot is not suitable for STIDF.

When I use stplot I always get this error:

    Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels,  :
      factor level [2] is duplicated

Here's how my data in STIDR data type looks:

           Lat         Long       sp.ID       time                                 endTime              TimeIndex     Speed    Station_ID    
    41.71268  -87.64341    1      2017-07-01 00:00:00   2017-07-01 18:00:00       1                    86           2
    41.47268  -87.35281    2      2017-07-01 00:00:00   2017-07-01 18:00:00       1                    35           5
    41.71268  -87.64341    3      2017-07-01 01:00:00   2017-07-01 18:01:00       2                    43           2
    41.47268  -87.35281    4      2017-07-01 01:00:00   2017-07-01 18:01:00       2                    55           5

I think it's related to my ID variable but I have duplicated station ID because I have hourly reading for each location , so ID will be repeated in my dataset.

I tried this code but I still have the error message,

 STIDF_jour$Station_ID <- factor(STIDF_jour $Station_ID, levels = rev(unique(STIDF_jour $Station_ID)), ordered=TRUE)
0
Hi

I have below scenario and need help to address this issues. What would be your approach to solve this problem in bullet points or brief summary like  what is your assumptions,explain your analysis approach and chosen analytics techniques, expected output results, what recommendations do you suggest,do you see limitations

1. How would you assess the impact of weather on consumer spend last winter?

2. How would you determine if a specific block in your neighborhood is suitable for a new grocery store?

3. Bank XYZ has created a new credit card product, how would you determine the targeting strategy?

4. Bank XYZ  has observed declining credit card sales volumes in their core markets. How would diagnose the cause and what potential remediation’s may be put in place (if any)

5.  Credit Card company recently announced a new partnership with a key tech company. How would you quantify the per customer incremental value of this partnership?

Thanks
0
How do I troubleshoot a website to determine why I have pages causing Error 739 instances. This began on Dec. 1, and I was just notified by Google Analytics, saying there is something in some of my pages cannot be indexed for some reason. No instructions are included as to how to fix it.
0
Can anyone tell what is the difference between data analytics and data science?
0
Hi All,
 I am using Graphana on Elasticsearch to show % pass/fail in weekly reports, I can get Pass/Fail  from the Pie chart but not in Stacked bar graph ..
Is there any plugin which i can use to get the pass fail percentage in Bar Graph.

Thanks,
0

Analytics

445

Solutions

677

Contributors

Analytics is the discovery and communication of meaningful patterns in data. Especially valuable in areas rich with recorded information, analytics relies on the simultaneous application of statistics, computer programming and operations research to quantify performance. Specifically, areas within analytics include predictive analytics, prescriptive analytics, enterprise decision management, retail analytics, store assortment and stock-keeping unit optimization, marketing optimization and marketing mix modeling, web analytics, sales force sizing and optimization, price and promotion modeling, predictive science, credit risk analysis, and fraud analytics.