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

Hi All,

We are looking for an analytics product to report on our usage of our on-premises Mitel VoIP system and Skype for Business Online. Can anyone recommend a product?
Reporting for Skype for Business Online is the priority, but we will likely need both in the future.
We are a medium sized charity and so our budget is limited.

Cheers, Ian
Should you be charging more for IT Services?
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Hi Experts

My client has Google Analysts for 2 primary domains, and I have a custom carts in other sub domains.

How do I go about and send purchase info to Google Analytics? Do I need to setup the Product IDs within Google? And, is this even possible considering I'm using sub domains.

The intention is to keep the existing code.
Dear Experts
We are looking for on premise application for warehouse management the application should have capability to develop work-flows and ability to trigger automatic email alert , we are not into mass production we mainly receive the items, unpack and see if documents are missing and if so escalate to the concerned to have good reporting engine and analytics. Please suggest. thanks in advance.
Dear Experts
We are evaluating right fit product for our business processes and we found Microsoft Dynamics NAV (which is going to be business central) is right fit. We cannot keep our data in cloud and understood Dynamics NAV has on premise deployment option. Now the challenge it has become essential to have advanced analytics reporting and dashboards for which Power BI is one of the  option,  understood power BI has on premise deployment option think we have to go for Power BI Reporting server and at this moment I am not clear about licensing the advanced analytics requirement is for 15 users only.
 If we go for on premise power BI deployment, will the installed power BI application on each of the end user systems OR power BI reporting server which is behind my firewall will it send our data which is residing in on premise server to external/internet server for processing and showing up analytics/dashboards, Our requirement is code and data to be processed and rendered within the applications behind my firewall. we cannot allow our data outside our network. Please suggest.
Also if Microsoft power BI cannot work without connecting to their servers then please suggest any BI software which can suit my requirement. Thanks in advance, this is most critical decision that we have to take, please suggest.
Hi all,

I have a report that was created a long time ago in Cognos 8, then migrated in 10 and now in C11.
In this report, there was a query with "Override dimension info" = Yes. If I remember correctly, this was necessary in the past due to the fact that the query is based on native SQL and used for a graph.
Now, when validating the report in Cognos Analytics, I get the warning "XQE-WRN-0018 The dimensionInfo in V5 query has been deprecated. The query will be planned regardless of dimensionInfo.", even if the report is running fine.
What should I do there? What is the impact of this warning? Performance?
This is the error log when I run spotfire automation file in scheduler.  Can someone help me resolve it please.

Info;19-06-19 08:47:35.463;3216;Program;Starting application using command line 'O:\Engineering\OA_RTA\RTA Area Projects\dian Hills\Spotfire.Dxp.Automation.ClientJobSender.exe.config"http://SpotfireServer:8080/ O:\Engineering\OA_RTA\RTA Area Projects\dian Hills\SF_export.XML'
Error;19-06-19 08:47:35.463;3216;Console;Unsupported URL scheme 'file' for server url.
Error;19-06-19 08:47:35.479;3216;Console;Incorrect parameters to the application.
Info;19-06-19 08:47:35.479;3216;Console;Usage:
Info;19-06-19 08:47:35.479;3216;Console;Spotfire.Dxp.Automation.ClientJobSender <serverUrl> <jobFilePath> [async]
Info;19-06-19 08:47:35.479;3216;Console;
Info;19-06-19 08:47:35.495;3216;Console;Example:
Info;19-06-19 08:47:35.495;3216;Console;Spotfire.Dxp.Automation.ClientJobSender "http://SpotfireServer:8080/" "C:\Path\jobfile.xml"
Info;19-06-19 08:47:35.495;3216;Console;
Info;19-06-19 08:47:35.495;3216;Console;Asynchronous example, do not wait for the result of the job execution, exits immediately with code 0:
Info;19-06-19 08:47:35.510;3216;Console;Spotfire.Dxp.Automation.ClientJobSender "http://SpotfireServer:8080/" "C:\Path\jobfile.xml" async
Info;19-06-19 08:47:35.510;3216;Console;
Info;19-06-19 08:47:35.510;3216;Console;To encrypt the password in the configuration file run the following command:
Info;19-06-19 …

I need to develop python code using cm_client . We have 15 clusters on different cloudera managers . I have to develop one script that collects all information from different cloudera manager . How it is possible ? Please let me know .

At least give me syntax how to connect one cloudera manager one after another .

I want to access my raw data  email event opens connected to google analytics

I have embedded the event tag in the email with a cid=customerdatabase_id

Is this possible using Google Analytics API.... if so how?
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
Sales Stage

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

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.


Current Query
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
Learn Ruby Fundamentals
LVL 13
Learn Ruby Fundamentals

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

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?
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?
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
Zoho Analytics

Has anyone found a really good write up on comparisons?
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.

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:

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 …
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%
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.

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

| where (EventID ==7036)
| where Computer == ""

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
The Print Spooler service entered the stopped state.
Event Xml:
<Event xmlns="">
    <Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
    <EventID Qualifiers="16384">7036</EventID>
    <TimeCreated SystemTime="2018-12-07T20:28:39.267645100Z" />
    <Correlation />
    <Execution ProcessID="664" …
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 I am trying to accommodate everyone but not sure how to make sure we are protected 1st before our gmail using CRM marketing side.
Why Diversity in Tech Matters
LVL 13
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

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






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.