Analytics

486

Solutions

746

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.

Share tech news, updates, or what's on your mind.

Sign up to Post

Getting ready to upgrade to SAP BusinessObjects Business Intelligence 4.  What built-in tools (add-ons) are available that are an absolute must-have?
0
PMI ACP® Project Management
LVL 13
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

Hi,
I am trying to install Power BI Desktop on my Windows 10 Desktop.
I click on the installer file
I select Next
Then I get the message displayed below.
I select no
and I get the last screen and nothing happens.
Any guidance appreciated.
Thanks
power BI issue
0
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.
0
Hello all, I have been asked to re-brand and create a brand new website for a company that is currently unhappy with their site and the lack of traffic it brings.  Here is the situation, they want a new hosting company to host their new site, using the same domain, using Wordpress.  I understand how to create the new site using Wordpress and implementing Google Analytics, but I have never migrated a site from one host to another host.  Also, their existing site was not created with Wordpress CMS.  So my real question becomes, how would I migrate their website from the existing host to Bluehost Wordpress CMS?  Or is it possible to leave the old site on the old host and create the new one on Bluehost Wordpress and then effectively cut over from one host to the new host?  I would assume you know what I am asking now and I apologize for my lack of knowledge and experience with this situation.  Thank you very much!  Please let me know if you need more information from me.
0
Dear Experts
We are likely to get the power BI implementation project for this we have to hire the resources,  the customer will provide various data sources and we have to implement for this  what resources should we have to hire.
 I am not sure power BI developers alone can handle this hence I am thinking that we may require technical architect who can map the requirement to the power BI technology platform and prepares the functional specs and  tech specs document so that Power BI developers can use this document and develop. Please suggest is my understanding is correct and if found incorrect please help met to identify the right resource is it Project Manager/Solution architect/Technical architect who can fit this role and what experience they should be having. Please suggest.
0
Hello:

Below is a screenshot of a very simple Dashboard that I created in Power BI Desktop.  When I uploaded this to powerbi.com, I created a bar chart afterward.

When I pinned that bar chart to the Dashboard, I could not move it onto page 1.  Instead, to see the added bar chart, I have to scroll down.  This is shown in the second attached screenshot.

Anyway, not being able to drag the chart onto page 1 does not make for a very nice looking presentation.

In Power BI Desktop, how do I shrink the size of page 1 so that I can add charts, graphs, KPIs, or whatever I want later in powerbi.com?

Thank you!

John

Power BI ScreenshotPower-BI-Dot-Com.PNG
0
There are 2 questions

1) data analytics addin shows active under file - options - Addis’s but doesn’t show up in toolbar under data in excel

I unchecked and checked add in but still doesn’t show

We have active directory group policy applied but don’t know what to disable or enable under excel 2016 when going to edit the policy

Any suggestions if I need to check trust center settings or protected view settings to be edited

2) my ceo is trying to open excel file and from excel trying to send as an attachment when he does this step it attaches in outlook

But then god knows why before sending he wants to open again and the problem starts ex el file doesn’t open

Vice versa if he opens outlook first and then attaches 3xcel file it opens right away

Any thoughts
1
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.
0
Hi:

I really hate that someone has made it very difficult to create or edit a SQL Reporting Services (SSRS) Report.  In the old days, when I worked with SSRS everyday, I simply used the Business Intelligence Development Studio (BIDS).

Now, you cannot find anything like BIDS in the newer versions of SSRS.  I hate Report Builder and refuse to use it.

Last week, I followed instructions found online and installed Visual Studio Tools.  And, I asked the IT department to reboot the SQL box late at night.  This was all in an effort to find the latest equivalent of BIDS.

But, I cannot find this.

What in the world do I use and how do I find it?

Please help!  I can't believe that this tool has been buried, in the newer version of SSRS.  

Thank you!  Much appreciated!

John
0
Hi all,

After creating a CAFE list within Excel, we are assigning an excel "named range" in order to reference the "Cognos" list in VLOOKUP, HLOOKUP functions etc.
From what we can see, the named range gets lost (disappears) after pressing the "Refresh all data" button.

Is it the expected behavior? Is there a workaround? This does not happen when using Cognos for MS Office but the functionality there is different too (no exploration module). Obviously, without being able to use formulas like VLOOKUP functions in combination with Excel Ranges (which are dynamic and not static), the power of the module is very much limited.
In Cognos for MS Office, we can refer to the "identifier" of the Cognos list inserted in the report in order to create functions in Excel, and it does not get lost when refreshing.

Any help welcome …
Thanks!

Vinc
0
Starting with Angular 5
LVL 13
Starting with Angular 5

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

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.
0
How is the best way to find out if your site is performing poorly on Mobile browsers.  I have a caching plugin and there response is to ignore Google Pagespeed even though my page is showing a 68.
https://gyazo.com/0d8a95a07655c3335385271b26c82d8b

Can this value be ignored or is it affecting my Google ranking?

If it is, what can I present to this caching s/w company they are wrong?
0
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
Ensure you’re charging the right price for your IT
Ensure you’re charging the right price for your IT

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!

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

Analytics

486

Solutions

746

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.