Analytics Questions

Hi I am relatively new to SQL, so please forgive the basic nature of the question

I have a table (called Opportunities) with a number of fields including
Country
Sales Stage
Amount

The sales stage contains a value "Stage 1" , "Stage 2", "Stage 3", "Stage 4"

What I want to do is create a new table (Called StageAmounts) with the following fields

Country, "Stage 1", "Stage 2", "Stage 3", "Stage 4"

However not all the country and stage combinations will have an amount, it will not be 0 the data will just not exist in the Opportunities Table

Therefore how can i create the StageAmounts Table, with a fully populated dataset with 0's (or blanks) where there is no corresponding data in the Opportunities table.

Many thanks for any assistance

Steve

4 Comments

Having trouble parsing JSON data in Azure Stream analytics for PowerBI, My device message data is passed to my IOT hub through an MQTT server in JSON format, the message data gets sent in with the following format.

{
  "body": {
    "timestamp": 1551731885318,
    "values": [
      {
        "id": "Channel2.Device1.Rtag1",
        "v": 26738,
        "q": true,
        "t": 1551731884050
      }
    ]
  },
  "applicationProperties": {
    "topic": ""
  }
}

Open in new window

My Azure Stream Analytics query currently just uses a wildcard to scan this message, and routes each message directly to powerBI unchanged.

[{"body":{"timestamp":1551726708054,"values":[{"id":"Channel2.Device1.Rtag1","v":25520,"q":1,"t":1551726704055}]},"applicationProperties":{"topic":""}}]

The problem, is when this gets passed to PowerBI, if I chart Timestamp/Value, then each timestamped datapoint on the chart will be valueless, as the corresponding value is "array".

I need to edit my query to pass the "v":25520, along to power BI rather than the entire array.

I understand the JSON hierarchy, but am new to SQL and am not sure how to pass the different values within my device message as separate properties that can be selected in PowerBI

0 Comments

We have a form on a site that displays a thank you page to the user when the form sends successfully. The thank you page contains Google Analytics and Google Ads tracking code, which logs a conversion when the code in fired by the thank you page. Now the client requires the form post to their third party CRM. How would can we use our thank you page to continue to post to Google Analytics when the form is posting to a url we don't control for processing?

6 Comments

I use 3 to 4 websites to verify IP addresses and I keep receiving comflicting information as to knowing where a specific IP originates when doing security analytics. Is there a trustworthy website for this?

5 Comments

I have an applications portal that generates charts and I am looking for a visualization software that is top notch, integrates well, but won't break the bank...

Power BI
Pentaho
Jaspersoft
Zoho Analytics

Has anyone found a really good write up on comparisons?

4 Comments

I have an interesting request to build or advise on an expert system, now known more commonly as a KBS or Knowledge Based System.

The reason is that this team are encountering many examples of same or similar problems, where they spend a lot of time re-inventing similar solutions. Ideally, they need a database that can intelligently and [semi]automatically connect the dots between hundreds of similar problems and solutions; in other words, an inference engine connected to a database.

Criteria
1. Search results need a trust raking for the likelihood of a correct solution.
2. New information (problems and solutions) must be easy for a technician to enter, and in a structured format.
3. Database must be both machine and human readable.
4. Must be OS agnostic (web based).

So far, I have found a lot of technical and conceptual papers on this subject, but I haven't found a ready to use application. :(
FYI, here is an interesting document from AAAI: https://www.aaai.org/Papers/IAAI/2005/IAAI05-014.pdf

Questions?
1. Can this be accomplished, as an add-on, with the tools we already own?
2. What KBS systems are available that are either open-source, free, or relatively inexpensive?

We currently use Confluence, Confluence Questions, Jira, Bitbucket, Freshworks Freshservice, and Slack. I have reviewed many of the plugins available and none seem to offer KBS-like functionality. :(

Google Search?
Search results seem to be help desk …

3 Comments

requirement is calculate -Top 1% records for every location.

How to Calculate Percentile 99 for Each group at summary level in Webi report:
this below function is working fine at detail report but not working at summary report
percentile var = Percentile([CT Wait Days];0.99) In Report
Flag = =If [C Wait Days] > [percentile var]Then 1 Else 0
its working fine in detail report with percentile 99 and flag every record 1 or 0 based on output of the percentile.

please advise!
cust1_0123.xlsx

0 Comments

Dear Experts
At present we are using CRM application which is hosted on premise and it is mainly used for handling the support cases, automated email alerts and to store all the case related data, repair and maintenance data ( all data are imported only , ie, operational users will not use instead all these to be imported ) and tool is only used for reporting and analytics purpose only . Now that for other business process where the operational users will use in every stage hence the need for technology solution in additional to above mainly on following business process and solution to be deployed on premises only.
1.       complete material movement tracking and capture the activities involved and automated email notifications and if the delay escalation rules .
2.      Service, repair and maintenance
3.      Warehouse/logistics management
4.      Inventory management
5.      Invoice management/HRMS/Vendor bills/salary # this is optional mainly 1 to 4 is important
We cannot go for cloud solutions the solution to hosted on premise. Please suggest the ERP application that can be best suited for above should we have to evaluate Microsoft dynamics ERP AX , SAP or any other where it to be used for operational and also for reporting and analytics . please suggest the best suited ERP or other solutions. Thanks in advance.

5 Comments

Cognos 11.0.12 Multiple Search on Data in a Cube MDX- Are there Wildcards for this?

Are there wildcards to search data in a multidimensional cube? I can easily search for 1 record by entering my item #, but are there wild cards for searching a multidimensional cube?

Wildcards - for example - 1234%, 1435%
Search-are-there-wildcards.docx

0 Comments

Im using STPivot to design pivot tables and i want to let a user only access to files and save or edit those cube files,

I want to know if is posible to open the browse files when a user enter to the user console?

i tried the CST plugin but i only be abre to make it work for CDF so far.

regards

0 Comments

I have a Google Ads client

His Analytics reports 7000 users per month, coming from a campaign bout the clics are zero. The cllcs are real because he gets business.

I understand that Analytics and Google Ads clics don't necessatily match boy 0 clics and 7000 users. Can't figure it out

The question is how can Analytics report 7000 users (with many differebt keywords) coming from a Google Ads Campaign campaign that reports no clics.

1 Comment

We are setting up Log Analytics in Azure and are trying to monitor for specified services if they go into a stopped state. My issue is that I'm not seeing all of the EventID records for event 7036 in Log Analytics. If I use the following query:

Event
| where (EventID ==7036)
| where Computer == "xxxx.yyy.com"

I see entries for some services but not all. Example I see entries for "The WMI Performance Adapter service entered the running state. " but none for "The Print Spooler service entered the stopped state." when the following entry is in the Event log on the actual VM.

Log Name: System
Source: Service Control Manager
Date: 12/7/2018 2:28:39 PM
Event ID: 7036
Task Category: None
Level: Information
Keywords: Classic
User: N/A
Computer: xxxx.yyyy.com
Description:
The Print Spooler service entered the stopped state.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
<EventID Qualifiers="16384">7036</EventID>
<Version>0</Version>
<Level>4</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x8080000000000000</Keywords>
<TimeCreated SystemTime="2018-12-07T20:28:39.267645100Z" />
<EventRecordID>122417</EventRecordID>
<Correlation />
<Execution ProcessID="664" …

0 Comments

I am a jack of all trades master of none admin....We are using G-Suite within Google Admin to peel off some marketing CRM email accounts for analytics and our MX records are pointed at their DNS. I am using Office 365 Administration Microsoft EOP and running a hybrid environment with mostly On Prem Exchange 2013 mailboxes. My problem is that my SPF and DMARC are not setup the way Microsoft says is best practice and we are getting spoofed addresses bypassing EOP into our domain because supposedly the MX is not pointed 1st or only to mail.protection.domain. I am trying to accommodate everyone but not sure how to make sure we are protected 1st before our gmail using CRM marketing side.

1 Comment

I'm having a database with 20 tables with huge records.

I want to just map to a good open source data analytics tool to get various reports and take actions based on the same.

I want to customize the UI to include few fields and operations.

Could someone suggest a good tool which satisfies this?

Analytics

3 Comments

LVL 1

Question by

Jack McKenzie

2018-11-28

Complex Event Processing

Is there a good definition of Complex Event Processing? I.e. what a system does to qualify as a CEP system? Please provide a better definition than "event processing of composite events". I understand what events and composite events are, and I don't understand the difference between CEP and other stream processing tools. What's the difference? Why do users want CEP for their algorithmic trading?

0 Comments

Is there any to have Skype for Business show you all the Poor Quality calls for a given time period?
MS Call Quality Dashboard appears to show you the number and percent of bad calls for a building
or region. But it does not show you any details about those calls - who the users were, the phone
numbers, the date/time, the MOS scores, the jitter etc. If I go to Skype Analytics I can search on user
ID and then scroll through the calls for that individual user. But in order to find a pattern for poor
quality I need better search. Barring that - is there any way to export Skype Analytics data or data
from MS CQD?

2 Comments

I have a relatively new company in the UK and it's a technology business that offers custom software services, big data services, and analytics services. I am quite new to marketing. Where should I add the company to make it connected with the UK and US markets?

The answer may include any classifieds or other places where to add the company. It may also be any process (for example LinkedIn prospecting) to reach out to individual companies.

2 Comments

Why do companies purchase a product known as Complex Event Processor (TIBCO Streambase CEP, IBM Infosphere CEP) or download Open Source (Siddhi, Esper)?

I understand why companies use real-time analytics in general to make sense of real-time data streams, but I don't understand why CEP.

"Complex event processing (CEP) uses patterns to detect composite events in streams of tuples."
CEP also joins many streams and finds patterns among the whole.

But I don't get it why use CEP and not Spark? Is there any use case you can explain this on?

0 Comments

An international website that runs with Multilanguage interfaces except Arabic. Digital marketing is handled by a third-party. If we wish to create the Arabic site as completely separate website hosted somewhere else, what are the pros and cons in terms of digital marketing?

2 Comments

Starting with Angular 5

LVL 13

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

I need to pull creative file names through a UTM using DCM as the trafficking platform. Is there anyway to do this on the DCM side or Google Analytics side?

1 Comment

Are there any tools other than Microsoft Call Quality Dashboard and Skype Analytics for measuring Skype call quality? Audio? Conerence calls? Video? We are mostly a Cisco network. There are shortcomings in the MCQ dashboard that have not been addressed since we adopted it.

0 Comments

how to create a google analytics segment?

2 Comments

I have a large data (about 44,000 entries) with 10 variables and one outcome. I am trying to figure out a model that can predict the outcome (it is a true/false outcome). So far nothing can predict the outcome more accurately than 65%.
What am I doing wrong?
The outcome is whether the company car needs maintenance (true/false).
The variables are the ID number of person leasing the car, the age of the person leasing the car, starting odometer, ending odometer, starting time, ending time, area the car is being used and car model.
So far the best model that works is the average velocity and end odometer combined but it is not more than 65% accurate in predicting true.
The following variables have no predictive value: age, area, car model, time of day, day of the week

2 Comments

I have a .htaccess file that forces the website to go to https://mysite.com

So no matter how you type it, http://www, www, or whatever configuration it will always take the user to https://mysite.com

I am getting this message when going into Google analytics. Does this have to do with the fact that I have 2 domains in google console? What is the best thing to do regarding this message?

Property YourSite is receiving data from redundant hostnames. Some of the redundant hostnames are:

yoursite.com
www.yoursite.com

Redundant hostnames are counted as separate rows in reports, so hits that are going to the same page on your site from different hostnames will be split into multiple rows. With data split across multiple rows, traffic to specific pages will appear lower than it actually is.

To avoid this problem, consider setting up a 301 redirect from one of your redundant hostnames to the other, or create a search-and-replace filter that strips "www." from hostnames.

Google Tag Assistant Recordings can help you verify that your redirect is setup correctly, or that your filter is working as intended.

2 Comments

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

Analytics

0 Comments

Analytics

Related Topics

Analytics

Related Topics