We help IT Professionals succeed at work.

Analytics

506

Solutions

781

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.

Hi All,

I have a report that have been created a long time ago in Cognos 8, then migrated to Cognos 10, then now in Cognos 11.
It is working perfectly fine in Cognos 10, and the validation of this report gives only a warning "XQE-WRN-0018 The dimensionInfo in V5 query has been deprecated. The query will be planned regardless of dimensionInfo.". Warning I've never been able to solve, and that is not blocking for Cognos 10.

Now in Cognos 11. when trying to validate, the only message I get is "RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0001 Internal error. The query could not be planned by the Query Service: java.lang.NullPointerException ".
I have checked all queries: they are all working when using "view tabular data". No errors, some data are displayed, etc...

Does anybody know how to solve this?
Any help, advice, etc.. will be appreciated...
Thanks!
Vinc
0
I got a request to see the analytics of the trouble tickets over the last year.  What would be the best reports to show this? Meeting at 1:00 central time!
Any help would be most appreciated!
0
SAP BI 4.1 - WEBI
This has one data source - a derived Universe for CA Service Desk Manager.

I am trying to add a variable to a report.  This is to check if a field is null.  If it is, return one value; if not, return another.
NOTE:  This issue occurs with ALL functions which have parenthesis - NOT just "isNull()".

Steps to Reproduce:

1.  Open WEBI.
2.  Open an existing report or create a new one where results return at least two fields, one of which may have NULL values.
3.  Create a new variable.(example)
-- Name:  vFirstGroup
-- Qualification:  Dimension
-- Formula:  
      =If isNull([First_Field]) Then [Second_Field] Else [First_Field]
a.  Validate the formula.  Results:  The formula is correct.
b.  Select OK to save the variable.  Results:  Error
    ///////////////////////////////////
Web Intelligence
There is no opening parenthesis after function "isNull" at position 11 (IES 10060)
   ////////////////////////////

The on-line documentation for "IES 10060" says to add the missing parenthesis.  That is not the case here.

This does not occur if creating a variable which does not include functions with parentheses.  For example, this works:
  = If [First_Field] = 0 Then [First_Field] Else [Second_Field]

Thanks in advance.

'Breeze
0
I'm looking into an issue regarding ecommerce data no longer flowing to Analytics.  I'm not really sure what the issue is but am wondering if an Expert can tell by the markup?
https://filingassistllc(DOT)com
0
Is there a new site for Skype Analytics? The only one I had in my bookmarks isn't working any more:

https://adminportal.services.skypeforbusiness.com/analytics

This site can’t be reached

Also - is MS Teams call quality data captured in Skype Analytics? It appears to get into MS Call Quality tool. But there's no drill-in there.
0
Hello I am trying to create an Excel that would display a summary of values in graphics like a dash board, how can I go about it?  Are there add-ons or VBA or other apps that is design for this?  Thank you.
0
I have given out 10 Excel for filling out forecast numbers, expected expenses, expected sales, etc and want to merges these 10 Excel to one.  Is there a tool for this or Excel has this capability?  What is the way to get this working?
0
Hello in a conversation the subject of data analytics arose, companies worldwide are spending more on data analytics.   Can some expert give me example of what is data analytics and possible tools or apps that can be used?
0
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?
0
I'm trying to set-up a P.O.C. for Video Tracking in Adobe Analytics. If you look at page 58, item #5 in the attached PDF. You'll see the following:

To quickly verify that the Heartbeat library was successfully imported, instantiate the
ADB.va.MediaHeartbeatConfig class.

I'm lost? I thought JavaScript didn't have classes? I know functions can simulate classes. Not sure what I'm supposed to do?  Any ideas?

 media.pdf

Thanks!
0
Hi

I have a dataset with around 70 million rows of data with around 30 columns - each viz takes some 4 mins to load - is it better to use a data extract to optimize performance?
Regards
0
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.
0
I have a raw data that I am to analyse under tableau software.
The data basically is a sales data. and it is very straightforward.
Date,Reference,sales rep,customer,customer channel,customer area,,item,item type ,item description,qty,unit price,discount,net price.
one of the questions that is asked is to identify for a specific product, who are the customers that never purchased from this item within a specific period of time.
They need it interactive so that they can "play around" with it.
Any idea how I can achieve this ?
Thanks
0
Kylin not getting started

here is the below error which I'm getting


kafka dependency is /opt/apache-kylin-2.2.0-bin/lib/kafka-clients-1.0.0.jar
Retrieving Spark dependency...
Error: Could not find or load main class exists
ERROR: Unknown error. Please check full log.
0
I have searched the Internet for days now trying to determine what happens when an affiliate link is 301 Redirected via cPanel.  The main question is that I want to know how the Google Indexing of the Domain and link will show if it is an Amazon affiliate link. Can someone help me to understand this process? I have gone to forums and did days worth of Google Search.
0
I really need a little intelligence on profitable niches to start a blog.  I have gone through hundreds of niches high and low competition. I want to go where the money is right now and in the future. I want to start a little blog to run solo.  Can you help me? I really and tired of the get rich schemes and affiliate marketers selling crap. I want to get to the people. I am starting from the ground zero.
0
I have Aliexpress affiliate website where I am getting most of my traffic from Search.

(http://aliexpressions.com)
(www.essmen.com)  

The sites have been around for about 45 days.  

I have placed links on Twitter, Reddit, Google Plus, Facebook and Instagram for traffic. And, I have completed the Google Analytics and Google Console.

I submitted the websites to other search engines a few days ago.

I placed the sites on Hotjar, the free version.

I am looking to get more "free" traffic!

I was told that it is best to let the website's index in Google for about six months.

I am going to send out press releases.  

I need some good ideas for more traffic. Can you help me?  I am a newbie.  Thanks in advance.

***Note I tried to put one of my Affiliate Website on Outbrain. I was told that my websites are not a good fit for their Native Ad.***
0
Would like to assess the data analytics solution in terms of security/risk for service below
(which uses Cloud):

"AAA Solutions, a local- based data and analytics consultancy, provides Information Management and Analytics support to our clients. Our seasoned practitioners bring established tried and trusted models developed through years of practical hands-on implementation and successful project delivery of Data Warehouse, Business Intelligence & Analytics systems. We apply an optimum mix of descriptive, diagnostic, predictive and prescriptive methods to drive business value, cost efficiencies and manage risk.
    To establish the Forecasting & Analytics System (FAS) integrating with the top-of-the-line Business Intelligence system and automation of the external variable extraction process to streamline analytics workflow.
    Data Source is using Qlik N-printing;
    Data Integration & Transaction svcs is using MS SSIS;
    Data Marts layer is by MS SQL 2017;
    Power BI is by O365;
    our on-prem AD sync to O365 AD"

Can only currently think in terms of encryption of data in transit, at rest & at endpoint.
What about data integrity (ConnectDirect did checksumming), cloud security (esp this one)?

I like MS SQL 2017 (as MS SQL 2016 only offers DB encryption in Enterprise Edition) offers
DB encryption even for the non-Enterprise edition
0
Hello Experts,

I would like to start a consultancy providing Data Analytics for industries using technology's like Azure Data Factory, Azure Streaming Analytics, PowerBI, Azure IoT.

I would like to find similar like minded individuals.

I would be happy to inject financial investment if needed.

Can someone let me know where the places to go to meet with like minded people?

Thanks

Carlton
0
I have completed a 301 Redirect via cPanel using my affiliate link.  I have two questions.  

How to do I get my website ranked on Google?  I have added the website to Google Analytics.  One problem is that I was unable to verify it via Search Console.

And, the second question is how do I advertise since it is showing up as Spam to the Search Engines and Social Media websites?
1
I got an error in the Google Search Console stating "URL not in property."  Now, I have added my website to Google Search Console and verified it.  I do not have any stats in my Google Search Console other than the sitemmap info but in my Google Analytics I have data.  Can someone help me with this error?
URL.png
Search-Console.png
0
I need assistance with updating my google conversion tracking please as they have changed the tags.

This is the tracking code before my head tag...

(function(d,e,j,h,f,c,b){d.GoogleAnalyticsObject=f;d[f]=d[f]||function(){(d[f].q=d[f].q||[]).push(arguments)},d[f].l=1*new Date();c=e.createElement(j),b=e.getElementsByTagName(j)[0];c.async=1;c.src=h;b.parentNode.insertBefore(c,b)})(window,document,"script","https://www.google-analytics.com/analytics.js","ga");ga("create","UA-6620915-45","auto");ga("send","pageview");

Open in new window


On form success I previous used this code below for the conversion event tracking...

ga('send', 'event', { eventCategory: 'contact', eventAction: 'submit', eventLabel: 'hardware'});

Open in new window


This is the info that google sent me: https://support.google.com/google-ads/answer/7548399

Can you please show me what my code should now be?
0
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,
I have Pivot table in Qlikview and I need to show subtotal for each region, but am not getting total column in chart.
kindly help me here.
Note: In expression I used "Only" function ex: Only(Sales)
0
How to Detect Traffic From China language hu-hu (reported in google analytics) and divert to a not available in your region page

I notice traffic with language hu-hu in my google analytics with a high bounce rate.

What is the best way of detecting traffic from China -   with language hu-hu?

I have a cold fusion 2016 site.  Thank you
0

Analytics

506

Solutions

781

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.