Experts Exchange connects you with the people and services you need so you can get back to work.

AnalyticsSponsored by Jamf Now

443

Solutions

Content

675

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.

Custom Google Analytics Report

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 Comments

Question by

tike55

2018-06-01Private

SSRS tools

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)>

4 Comments

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

Analytics

0 Comments

LVL 11

Question by

mohammadzahid

2018-05-15

Cognos list repeating issue

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

1 Comment

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 Comments

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 Comments

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

3 Comments

Question by

Janna Myers

2018-02-14

How do I fix Error 739?

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 Comments

Question by

Andrew Son

2018-02-13

Is data science are mandatory?

Can anyone tell what is the difference between data analytics and data science?

1 Comment

Cloud Class® Course: Ruby Fundamentals

LVL 12

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Question by

pradumb29

2018-02-12

Stack Pass/Fail in Graphana

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 Comments

Question by

steva

2018-02-08

Fixing "(not set)"

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

2 Comments

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

1 Comment

LVL 1

Question by

amigan_99

2017-10-18

Microsoft Skype MOS Score

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

4 Comments

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 Comments

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?

2 Comments

Question by

oo7ml

2017-09-14

Tracking People Clicking In

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.

1 Comment

LVL 1

Question by

damola1

2017-08-24

Human Resource Solution

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--

3 Comments

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

5 Comments

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 Comments

LVL 1

Question by

Satish Kumar G N

2017-06-23

Where can i Learn Data Science & R or SAS?

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

3 Comments

LVL 9

Question by

the_b1ackfox

2017-04-11

PowerBI graphs on a website

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 Comments

Hi,
I need to analyse database and know how many records by fields and percentage of it or percentage of records vs blank.
Important thinhs, this db has one table with 250 fields.

I started with PowerPivot, I then jumped on PowerBi and I just heard that tableau was easier and more accessible for business at the end.
Im a bit lost. What would you reckon ?
Thanks a lotfor your help

1 Comment

I am using IP camera and getting images based on the alarm. I have a question on this,

Can we mark assets area and do the image analytics with the reference image and find missing assets.

This is only to deduct missing asset (like missing ups, intercom, notebook)

- We can keep a master image consider as a template with all the assets
- Whenever changes happen like replacing, missing marked items - need to mark the missing items in red color and need to alert the administrator.

0 Comments

This may be easy.
I have one worksheet that shows total quantity of sales.
Then I have another worksheet that shows total quantity of sales and is filtered based on the filter franchise.

On my dashboard I have both.
On the filtered worksheet I have total quantity of sales for the filter franchise.

Worksheet 1 Name: ES - TOP LEVEL KPIs
Worksheet 2 Name: ES - FRANCHISE BUBBLE

My calculated field on both worksheets is SUM(Sell out Quantity).

Ultimately I want to total:
SUM(Sell out Quantity) from ES - FRANCHISE BUBBLE /Total SUM(Sell out Quantity) ES - TOP LEVEL KPIs = % of Total Quantity
117,193 / 1,579,040 = 7%

I want to add a % of total in my tool tip.
Due to the filter I am unable to get an accurate calculation.

Is there an easy way to do this?

Analytics

1 Comment

First
Prev
1
2
Next
Last

AnalyticsSponsored by Jamf Now

443

Solutions

Content

675

Contributors

AnalyticsSponsored by Jamf Now

Related Topics

AnalyticsSponsored by Jamf Now

Related Topics