Analytics

449

Solutions

685

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

Hello,

I am trying to create a Tableau Line chart for the users to interactively select the measure based on the parameter selection.  Please see attached is the sample data.

I want to show the trend of discrepancy based on the report_date for each table. The "measure" should be interactive based on the parameter selection. There are 4 different measures in the attachment and based on each measure, I want the line chart to change.

I am a newbie to Tableau so please help. Thank you so much
dq_daily.xls
0
Get Cisco Certified in IT Security
Get Cisco Certified in IT Security

There’s a high demand for IT security experts and network administrators who can safeguard the data that individuals, corporations, and governments rely on every day. Pursue your B.S. in Network Operations and Security and gain the credentials you need for this high-growth field.

I am trying to schedule refresh my data source in tableau online and I am getting a connection failure error. I talked with Tableau support to see if it's anything I did wrong in tableau but they said it's SQL Server issue. I can connect to SQL server using Windows Authentication and create reports and can publish them . when i publish them the server name is coming as localhost. So, I tried to do SQL Server Authentication and used username: sa and password and logged in Tableau Desktop and published the data source but the scheduling doesn't work and gives me an error of connection failure again. So i tried looking at the connections in tableau online. Tried localhost, username sa and when i press test connection it gives an error couldn't found the server.
0
Hi Experts,

I am debugging a share point web parts and I get run time errors for last a few days (I did''t see these errors at the beginning. ) and I have no idea where they are coming from.
I checked master pages and I couldn't find script that calls google analytics.

Exception was thrown at line 24, column 671 in https://www.google-analytics.com/analytics.js
0x800a01ad - JavaScript runtime error: Automation server can't create object
Exception was thrown at line 24, column 778 in https://www.google-analytics.com/analytics.js
0x800a01ad - JavaScript runtime error: Automation server can't create object
Exception was thrown at line 24, column 927 in https://www.google-analytics.com/analytics.js
0x800a01ad - JavaScript runtime error: Automation server can't create object
Exception was thrown at line 15, column 232 in https://www.google-analytics.com/analytics.js
0x800a138f - JavaScript runtime error: Unable to get property 'getRandomValues' of undefined or null reference
Exception was thrown at line 15, column 232 in https://www.google-analytics.com/analytics.js
0x800a138f - JavaScript runtime error: Unable to get property 'getRandomValues' of undefined or null reference
Exception was thrown at line 1649, column 1 in eval code
0x800a138f - JavaScript runtime error: Unable to get property 'Resources' of undefined or null reference
Exception was thrown at line 1649, column 1 in eval code
0x800a138f - JavaScript runtime error: Unable to get property 'Resources'…
0
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
hi,

what kind of OLTP and OLAP solution MySQL has ?

please share URL.
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
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
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
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
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
Introducing Cloud Class® training courses
LVL 12
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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
My Google Analytics  Site Content |  Landing Pages report shows a row with (not set).  See attached file.  Does anyone know what is generating these?

Thank you.
not_set.jpg
0
I have start date of an agreement and their total sale. I’m trying to build a report to show 1st year and show their count. Like if the agreement started in 2012 it is it’s first year and if it is started in 2015 it is its first year. Can some one help me how to write that formula ?? Thank you
0
Normally I've seen MOS scores on a 1 to 5 point scale. But in Skype for Business Call Analytics they're expressed a decimal. e.g.

Average network degradation 0.009717 MOS

What are they saying? Is that a 4.93 MOS score?
ScrnGrab2671-171018-17.21.jpg
0
I work for a organization with a large website. I have been asked to provide the following stats from 2016 about the website:

  • total number of web pages on our website
  • total number of page linked to a newsletter

Regarding bullet number two: A friend suggested that I use Campaigns to track pages being linked to newsletters, which I assume would mean creating a different campaign for every newsletter link. I can do that going forward in 2018, but that doesn't help me find the stats for 2016.


Can I retrieve the 2016 stats for both bullets from GA and how would I do so? If it can not be retrieved from GA, please offer suggestions on how I may find this information.
0
I would like to have better analytics of call quality over time. Is there any way to have a server at each site and run a nailed up simulated call between the two and gather metrics like loss, jitter, MOS, latency etc etc? Anything from MS? Other?
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,

I have built a small wordpress widget that floats in the bottom right hand corner of my client's website(s), so that their users can click it to make a payment to them... which simply redirects the user to my payment platform / website where my customer has an account.

FLOW - widget sits on clientwebsite.com and when they click it, the customer is brought to mysplink.com/abc (their payment profile on splink)

QUESTION
I need to be able to track how many users land on mysplink.com from a widget that sits on another site.

I was thinking of using something like mysplink.com/abc/ref=widget-abc and then i can view that in Google Analytics?

01 - would this approach be the best way to do this?

02 - any other advice on approaches would be greatly appreciated

Thank you in advance for your help.
0
So, am a small business. but I need to better help my employees achieve in line with our overall and departmental vision.

Everything has been documented in the designs here: https://www.dropbox.com/sh/tg6gasx0xmv4o0w/AAB-h65qfbw-sQEx6h8f_xzOa?dl=0

But a recap is basically:

Can I get a solution or multiple solutions where task can be prioritized and managed in line with the goal of the department.

1. Work flow

https://www.dropbox.com/sh/tg6gasx0xmv4o0w/AAByCa6YswAXB0wu2wX3O71Ya/My%20daily%20tasks%20DASHBOARD%20my%20daily%20tasks.psd?dl=0

2. Organisational chart

https://www.dropbox.com/sh/tg6gasx0xmv4o0w/AAACjdDmKhO0eeUPFPJPQytwa/My%20daily%20tasks%20DASHBOARD%20department%20Chart.psd?dl=0--
0
HI All,

I am looking for Tableau interview questions and certification material. Looking for some good learning resources and get certified as earliest. Please share interview material and certification stuff. Greatly appreciated

Thanks
0
I'm working on an ad campaign management app. There's a feature there advertisers can assign caps for campaign based on spending or conversions in daily, monthly or lifetime basis and there would be multiple caps per ad campaign. As soon as one campaign reaches the 80% we will send notification to all publishes and once caps are reached we have to stop the campaign immediately. We're receiving thousands of event per second. Currently what i'm doing is querying reporting table every second but it's quite inefficient and sometimes campaigns already exceeded the caps when I detect it. So my question is;

What're the existing efficient programmatic or architectural solution's in industry to handle these kind of situations?
0
Hello All Experts,
I am a student enthusiast in learning "Data Analytics" , which is the best platform to learn for FREE?
I want to Learn 'Data Science (Statistics)' & 'SAS/R' from scratch?
Any videos? Any websites? Any Blogs?

Thanks,

Regards,
Satish Kumar G N
0
Can anyone describe their experience with embedding powerBI visualzations into a website?  I want to have client specific visualizations that show up when they log into the website.  (Probably using HTML5)  Thoughts?  What concerns me most was the description from the powerBI website about publishing to the cloud.  It is imperative that only the client can see their graphs...


Thank you,

Fox
0

Analytics

449

Solutions

685

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.