Analytics Help

Question by

Cobra25

1d ago

SQL Database Copy

Hello,

We have a few clients who use some custom apps on SQL at their locations. Now, we want to have these DB's replicate to say a Cloud server - so we can have full live copy there for some analytics we'd like to run on them. How can i get this done?

10 Comments

Hi experts,

I’m looking for any available open source BI Tool (Business Intelligent) which having features that is comparable to Microsoft Power BI. Anyone please suggest me one. Thanks.

Analytics

1 Comment

LVL 1

Question by

amigan_99

2d ago

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

3 Comments

In this article we have tried to give you a brief about what Tableau as a software can provide you or your Organization with. Alongside with those details, we have provided necessary information about CASE statements and also have seen the performance gain that we get over the usage of IF and ELSE s

0 Comments

Add Comment

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

LVL 4

Post by

Doug Walton

2017-10-03Edited

Here's an interesting analysis on all of the FCC comments submitted about Net Neutrality.

https://www.gravwell.io/blog/discovering-truth-through-lies-on-the-internet-fcc-comments-analyzed

A very small minority of comments are unique -- only 17.4% of the 22,152,276 total. The highest occurrence of a single comment was over 1 million.

Most comments were submitted in bulk and many come in batches with obviously incorrect information -- over 1,000,000 comments in July claimed to have a pornhub.com email address

Bot herders can be observed launching the bots -- there are submissions from people living in the state of "{STATE}" that happen minutes before a large number of comment submissions

...

One thing is certain about what we have found so far, though. The opinions of commenters using the organic website form submission and those whose comments were submitted in bulk or by bots differ wildly. This forces us to conclude that either the very act of going to the FCC comment site and providing a comment is only attractive to those of a certain political leaning, or that the bulk submission information is full of lies.

Discovering truth through lies on the internet - FCC comments analyzedThe Gravwell analytics team ingested all 22 million+ comments submitted to the FCC over the net neutrality issue and pulled out some interesting findings.

0 Comments

Add Comment

Question by

Scott N

2017-09-29

Identifying outliers in Excel

I have a database over 300,000 records long. Each record represents a different item. We have grouped similar items together utilizing a group ID number shown in the row label column of the attached file. Based on this group ID, I have a pivot table with over 57,000 rows. The first row shows the group ID number. The next row shows the item description and in the column to the right, the total for that description. The majority of the rows show a single description per group ID number. However, some have multiple descriptions that differ. Each group ID number section ends with a total line. (Sorry, this is how I received the data.) Is there some method I can utilize to identify the group ID numbers that have multiple entries? (formatting, formula, VBS???) I need to validate each item description to ensure it is accurate on the group ID's with multiple entries only. I am currently scrolling down the list and visually identifying each group with multiple descriptions. I greatly appreciate any assistance. thank you for your time.
EXEMPLAR1.xlsx

12 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

Hi all,

I need an idiots guide to tracking forwarded pages. I understand most of the concepts, but the analytics interface is mostly a mess to my eyes. Here are my intentions:

1) custom domain example.com , example.com/1 and example.com/2 exist
2) each independent URL forward to the same destination contoso.com (where tracking is up and running fine)
3) Be able to track and trace the traffic hitting example.com, example.com/1 and example.com/2

Tools at my disposal:

1) Full access to analytics on example.com and contoso.com
2) Full domain access at the registrar level
3) Webserver control for example.com (using plesk, have Wordpress installed to it right now in an attempt to make it easier for client to do some of the page creation, but can abandon in favour of custom php pages index.php, 1.php and 2.php for instance)

If there is a clear and concise document(s) already written, please link. When I go hunting, I find people with posts that tell half the story.

Cheers,

0 Comments

Concerto Cloud for Software Providers & ISVs

LVL 4

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Please provide me with the exact steps on how to setup a Google calendar within Windows Outlook 2016.

2 Comments

Question by

pepps11976

2017-09-06Solved

Sharepoint 2016 Business Intelligence

Hi All way back in the day I created my first SharePoint Intranet for the company I still work at, I used SQL and Performance Point Services and Visual to create a cube and display Company Data via the Dashboards using BI

I have since created a new SharePoint 2016 Farm and cannot see how to use performance point etc, I have installed via the admin panel but I do not know how to access it.

I need to brush up on my skills but any help would be much appreciated

2 Comments

Question by

oo7ml

2017-09-05Solved

Analytics

Hi,

We have a small SAAS platform which various companies use to sell basic products. Each company get's their own shop profile on our platform, which they can share and advertise via social media and other channels... so that customers can buy their products.

We would like to provide our customers with analytics to show where their hits and sales are coming from most. For example, if they share their profile by:

- Facebook
- Email
- Twitter

A - where do the majority of their views come from

B - where do the majority of sales come from

Is there any 3rd party software that we could integrate to do this OR should we look at building something from scratch?

Thank you in advance for your help.

7 Comments

Question by

nflynn85

2017-08-25

Implementing Google Analytics in SAS

Does anyone have experience integrating Google Analytics tracking code into a SAS Web Portal? It seems that SAS doesn't really have the granularity to tell me exactly what my users are doing on each portal page and how they are interacting with each. Was hoping someone out there has had a whack at this previously.

I've found this which works on version 9.4M4 http://blogs.sas.com/content/sasdummy/2017/04/14/using-sas-to-access-google-analytics-apis/

I have 9.3 M2 and would rather just have the data pipe directly in to GA instead of having it come back to SAS as shown in the previous blog post

Thanks in advance for any help you can provide

0 Comments

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

Is there any way to boost up my website by Web Analytics testing?

Analytics

1 Comment

I need to know how to do this.

The person who worked on the site prior to me installed a plugin called Monster Insights which is automatically used when I try to configure Google Analytics. It does not work. I presume I can deinstall the plugin.

Then how do I do it WITHOUT the plugin?

Thanks

23 Comments

Question by

Richard Korts

2017-08-16Solved

Sign Up for Google Analytics

I want to do this for a customer.

I know I can access their Google Account from my computer (I have the email & password), I don;t remember how to do that (or even access my own Google Account, I know I have one)

How do I do that?

Thanks

1 Comment

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

2 Comments

NFR key for Veeam Backup for Microsoft Office 365

LVL 1

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Can anyone provide the practical use of Excel's Consolidate and What-If Analysis? (It's under Data > Data Tools)

If you can provide a simple sample then it would be great!

Thank you.

3 Comments

What technology do you think is a fad that won’t last?

Found another one: Snapchat spectacles. Okay, I'll admit I wanted one but I would've probably used it for a day and gotten bored. Also, I don't even have Snapchat.

5 Comments

load previous comments (3)

Author Comment

by:Katrina Donegan2017-08-11

Yup! Overall, I just can't see the average consumer using these. This reminds me of Google Glass...remember these?

LVL 2

Expert Comment

by:Juana Villa2017-08-11

HAHAH!! I do remember those! At least the Snapchat ones are more fashionable ;)

Add Comment

Question by

awp2012

2017-08-10Solved

Tableau: Need formula for aging tickets

New to Tableau, looking for a formula to determine ticket age.

I'm used to using something like TODAY () - CreateDate to get the age of a ticket

Have tried this formula but it seems to be giving me just a sum or avg in the row and the data is not accurate. Also tried DATEDIFF.

How can I do this? Seems like it should be very simple.

1 Comment

LVL 3

Article by

Percona

2017-07-28

Multi-Threaded Slave Statistics

In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.

0 Comments

Add Comment

Please provide me with instructions on how to change a Google Calendar address from being private to being public within a corporate Gmail account (see the screenshot).

This setting needs to be changed so that Mac Outlook 2016 will be able to synchronize and display the Google calendar.

2 Comments

Our apps team uses Google Analytics to track one of our website for pattern of
usage/access & they requested for access to gmail to receive product tips, advice,
recommendations, training tips in gmail.

Q1:
As gmail is a data loss/leakage risk (as users can upload data to it), can Google
Analytics be configured to send emails/tips/recommendations instead to our
corporate Exchange email account instead?

I have no idea/inkling of how Google Analytics work.

Q2:
Is there any option in gmail to set auto-forwarding ie whenever new emails
arrive in gmail account, it's auto-forwarded to our corporate email? Any
tool to do this?

2 Comments

COURSE of the MONTH

Analytics

Related Topics

Analytics

Related Topics