Web Analytics supplants Business Intelligence?

Post written by Wade W., BI Consultant at Ideaca. Read more about BI on his blog: Pragmatic Business Intelligence. 

In reading industry material, I recently came across a statement that can only be, in my opinion, the product of tunnel vision. It was one of the most short-sighted and fundamentally erroneous statements I have seen in some time. Analytics

“At the 2005 Emetrics Summit in London, Bob Chatham from Forrester Research described what it means to be the key. He told the assemblage that we are the leaders of tomorrow – and he wasn’t just preaching to the choir to curry favor – he made sense. Chatham told us that “web analytics” would eventually be subsumed into business intelligence, thereby changing the game. Instead of giant data warehouses being sifted in hopes of finding patterns, it would be the likes of us web analysts in charge.” (Jim Sterne, Target Marketing of Santa Barbara, edited by Erika Lindroth, The Weather Channel Interactive, Inc.)

I agree that web analytics will be (and is starting to be) subsumed into BI. However, I question the sentiment that “giant data warehouses [are] being sifted in hopes of finding patterns” and that Web Analytics would “change the game.” Is Web Analytics really going to revolutionize the art of Business Intelligence so significantly? The implication in this quote is that somehow traditional Business Intelligence is somehow inferior to Web Analytics.

I think this is an excellent example of what happens when someone seen as a leader in a field becomes too engrossed in what he is evangelizing…he becomes blind to the bigger picture.

The fact is that Web Analytics, though impressive in its power to aggregate user behaviour and use this to optimize website profitability, it is by nature a limited field. You are able to track user behaviour – generally anonymous at that – through a single customer-facing channel. Web Analytics is Business Intelligence, that only leverages a single source.

“Giant Data Warehouses,” however, are repositories of cross-organizational data, in most cases that extracted from up to hundreds of disparate data sources – Legacy systems, ERPs, CRM systems, finance, operations, HR, desktop apps, web services, external sources – and loaded into a database of a very specific architectural design optimized to return query results on the huge amounts of data very quickly.

Further, this data will certainly have different meanings across and organization – what does “Customer” mean? How do we define this? Part of the process is to work closely with the business to define common business definitions of business entities…so all that data of all that depth and breadth and richness is (should be….) based on common meanings that have been agreed to by key stakeholders. We can mine the data to identify unknown customer segments. We can do Predictive Modeling. Starting with a business mentality, there is the potential to leverage some powerful Business Intelligence.

But I do agree that Web-sourced data represents a substantial opportunity. We can take those Web-specific data sources that power our Web Analytics Apps, and add that to the existing Data Warehouse, passing through the same business rules to ensure heterogeneous data has a single meaning. Now we are talking organization wide, multi-source Business Intellligence.  Plug BI’s powerful analytical tools into our database, and with some targeted, business-driven KPI’s, and we have another, very powerful means of driving profitability

Web Analytics could be said to be proportionally less expensive than traditional BI – same basic cost range for the analytics tool, but less demand for investment in multiple software licenses from different vendors (possibly), less complex data massage (or not…) and shorter time to implement.  And that in itself is a strong argument in favour of Web Analytics – reduced time to market.  However, you won’t have the spectrum of information you have in a well-implemented Data Warehouse.

I believe that Web Analytics is a complement to BI. It can be integrated into a dashboard, or can stand alone to guide developers and webmasters to optimize content. It does have an effect on our database architecture – we must adapt the design of the database to integrate web data. But does it “change the game”? No – it  makes it more interesting. And as a Business Intelligence professional, I welcome another tool that will add value to my service offering and to my clients.

Wade Walker

How Technology Changes Us: Canada In 10 Years

Post written by Niaz T., Senior Solution Architect / SAP BW Consultant at Ideaca. Read more about SAP HANA on her blog: Discover In-memory Technology.

The theme of the Ideaca Blogging Network for the month of August is a very interesting subject. Certainly, technology changes the way we do things on a daily basis. Not only in Canada, but also globally. There could be some specific cases in Canada, such as Green technology to combat climate change. However, most of the technology changes impact us globally, specially in more advanced countries.

The first thing that it comes to my mind is technology will enable us to convert Zettaflood (10 to the 21st bits, or a thousand exabytes) of data in to meaningful information which we are very dependent. Like it or not, business intelligence already has an increasingly important part of our life. The challenge will be how to deal with the explosion of data coming from all types of gadgets and smart technologies because value-based intelligent information helps us to get things faster, better and easier. The speed of rising adoption of cloud, mobile, real-time applications and social technologies and exponential data growth is a big challenge of staying current.

How technology solves this challenge? Some of the biggest improvements have been around networking. We will be able to move more data faster from many sources and applications to where is needed. We won’t have any restriction in terms of capacity, scalability and processing speed. Organizations will be able to leverage the three “V’s”, volume, variety and velocity, of data to augment the value of data for their decision making. Powerful in-memory technology such as SAP HANA enable us to design complex predicative and preventative models for all type of data from structured and unstructured like audio and video files. Next generation of data visualization and intelligent reporting tools empower users to slice and dice information any way it is demanded. We will be able to tell stories with data by connecting millions of data points to get a bigger picture. Big data will change our world and it will blow our mind by providing us tons of opportunities. It will make our word smaller and we will be all connected.

I believe in the next 10 years, another significant change will be human and machines interaction. It seems that human interaction, communication and relationships will be more efficient, faster and stronger through smart technologies. Also, we will be able to have better understanding of machine behaviors and machines will have a better understanding of ours. Ideally humans and machines will work alongside each other and hopefully not replacing human with machines. Although there are ongoing developments and opportunities to replace human with machines, it’s required to consider all potentials dangers and associated risks.

Personally, I’m very excited to see how technology will enable us to access information easily, increase our potential and creativity, improve our lifestyle and promise of longevity, and improve communication and social networking. On the other hand, I believe we need to keep things in balance with respect to human identity and our social behavior. For example, neuroscientists are concerned about how modern technology is making us not use our brains to their full potentials. Based on the evidence, loneliness and depression is increasing and people are less happy in modern society. It’s been observed that the newer generation—equipped with all kinds of smart technology—is less effective in terms of communication skills and human interaction.

The bottom line is we use technology to change the world to suit us better. The important thing is to control it so it doesn’t destroy human intelligence and social interaction. For instance, it would be great to get a relaxing massage after a long day by a smart robot that has already taken care of the house chores. However, nothing will replace a nice face to face conversation with your favorite person or a warm friendly hug to someone you care about. I don’t think we could ever replace our human connection with human-robot connection.

Is Big Data Only About…Big Data?

Post written by Wade W., BI Consultant at Ideaca. Read more about BI on his blog: Pragmatic Business Intelligence.  

If nothing else, IT is all about buzzwords, and “Big Data” is one of the new arrivals to the party.
It is, however, a descriptive one. “Big Data” evokes images of enormous relational databases, providing analytical (or operational) reporting.

Big Data is not only about size however. Rather, it refers to attributes of the data that together challenge the constraints of a business need or system to respond to it. Those attributes can include any or all of attributes such as size/volume (of data), speed (of generation), and number and variety of systems or applications that simultaneously generate data. Another thing that is unique about Big Data is how it varies in structure. Elements of “structure” would include the diversity of its generation (eg. Social media, video, images, manual text, automatically generated data, such as a weather forecast, etc), information interconnectedness and interactivity.

I heard somewhere a thumbnail statistic that 80% of data in companies is unstructured or semi-structured. Just to clarify the meanings of those terms, an unstructured data artifact would be a document, an email, a video or audio clip. A semi-structured data artifact would include data that does not conform to the norms of structured data but contains markers or tags that enforce some kind of loose (or not so loose) structure. XML documents would be an example of semi-structured data.  Tagged documents in a Knowledge Management system would also fit into this definition.

Structured data is what we would find in any database – a Data Model has been defined and the data is physically arranged within this model into tables. The data in these tables is described with metadata (i.e. data types (such as “character”) and the maximum length of that data (number of bytes)).

The methods of data creation are multiplying and the velocity of its creation are increasing. And that, in itself is a complicating factor. Some analysts (IDC, for example), predict that the Digital Universe -  that is, the world’s data – will increase by 50x by 2020. There will be in the same period, a growing shortage of storage, which will drive investment in the cloud as both individuals and corporations look for scalable, ubiquitously accessible, lower-cost and environmental data storage options. In addition, the same study predicts that of all that data, unstructured data, especially video, will account for 90% of that data.

There is also an important historical dimension to Big Data. For decades, companies have been hoarding structured, semi-structured and unstructured data in hopes of one day being able to extract value from it at some point in the future.

A large percentage of all this data will come with a wrapper of automatically generated Metadata – that is, (as indicated above), data about (or that describes) that data. A practical example could be the generation of a data artifact coming wrapped with metadata from those GPS enabled, media rich, socially linked mobile devices we all carry with us that transparently capture location, GPS coordinates, time, weather conditions and a plethora of other data elements when you click that holiday photo with your mobile phone. IDC predicts that such metadata is growing twice as fast as data.

It is clear from the last three paragraphs that Big Data describes explosive growth in data and metadata and an equally explosive opportunity to capture, tame and corral that data to extract value from it.

So the case has been made that we have a lot of data today and we will have even way more tomorrow, but should your organization be investing in Big Data today?

In a sense, probably you already are. Enterprise Business Intelligence environments lay a solid foundation for the next phase of Big Data. EBI is an earlier iteration of Big Data and, married to tools such as Hadoop and NoSQL databases for example, enable a natural evolutionary growth curve to your mastery of your information ecosystem.

Big Data has a requirement for a new way of thinking, new tools, clustered commodity hardware and probably, substantial investment. It comes down to your business, and if there is a clear value-based case to present that data to your company’s brainpower. The actual needs for this will be radically different depending on your industry. Oil and Gas may be interested in leveraging real time alerts in wellhead data or analyzing petabyte seismic datasets.  Packaged Goods multinationals may be interested in monitoring and engaging advocates, detractors and influencers across multiple Social Media platforms, mining and understanding sentiment and identifying problem areas in real time in order to identify opportunity or identify and avert potential brand-damaging events. Financial institutions may be interested in monitoring international money traffic to identify fraud or illegal activity. Government entities may mine extremist forums, or other unstructured data traffic to identify national threats.

Big Data can serve these needs in real time, enabling rapid (or even automated) response to flagged events. Whether it is a fit for your organization today would be determined through viewing your industry and business through a critical lens on your current Information Intelligence maturity, a strategic assessment of the data and information assets currently owned or available to your organization, and a prioritization of potential initiatives. How much data you harness and convert into information should be a key outcome required from this exercise. The opportunities are legion, but initiatives should have clear objectives and success metrics understood prior to a project kickoff.
Whether it is today or tomorrow, Big Data is becoming mainstream through necessity. Whether that is a road your organization wants, or needs to drive today, is something all medium and large organizations should be considering now.

What are your thoughts on Big Data? Is your organization currently considering Big Data as a strategic imitative or Proof of Concept?

Just Imagine...

Post written by Chris S., BI Consultant at Ideaca. Read more about BI on his blog: The Outspoken Data Guy.

For quite some time I have been imagining what the possibilities of Big Data might be. I am certainly no expert in the area but being the data guy that I am, I often wonder what might be able to be done with data that may be being collected at any point in time. Face it, we are so connected now that our every move generates some form of data and often multiple pieces of it.

For example, if a marketer wanted to know everything about Chris Sorensen in a given day, chances are that most of that data is logged somewhere. What time I leave my house is available via my cell phone, my driving directions and speed are also available there as well. When I sit on the train I surf the web, send emails and organize my task list, all of these actions generate recorded data. What time I log into work, how often I am active on my computer and what I am do all day long is logged. Where I shop, what I buy (if I have a rewards card) is all tracked. My Facebook views, tweets all contain things that could be used to build a personality model of myself and my habits.

It is not really that big of stretch to think that this data could be used in one gigantic model to predict my next move and perhaps even entice me to make a different one. Maybe instead of stopping at Home Depot to get my painting supplies, an app could suggest the best place for me to go based on what I am doing. Sound like a stretch? Not really…Think about the labor that gold miners went through just to get a few stones. Now gigantic machinery does the same thing. The same thing is happening with Big Data where machines are able to gather information from a variety of sources and store large volumes of it in order to form predictive models. We are only at the tip of the iceberg but just imagine what the possibilities might be

Sliced or Shaved? Avoiding spreading your BI team too thin

 Post written by Chris S., BI Consultant at Ideaca. Read more about BI on his blog: The Outspoken Data Guy.

As a consultant with a background in Agile, I often get questions about how Agile can be used to solve certain problems that people are having with their Business Intelligence Programs.

I recently sat with a client to listen to some of the issues that they are currently having with their BI program. One of the biggest issues that this client is facing is what I would classify as a simple supply and demand problem. Basically their team of around 8 people cannot keep up with the demands of developing and sustaining their BI/DW environment in what is a large organization. The main question for me was could Agile help solve this problem. In my experience, Agile cannot solve the problem directly but it can be used to highlight the root cause.

This is a very common problem that BI programs face. It is the fact that teams are often small relative to the size of an organization and are also too small to manage the tasks that they need to perform to grow and maintain a BI portfolio. And in certain circumstances it is compounded by the fact that teams are often staffed with the wrong skills sets needed to grow and manage a BI offering.

So how can Agile help?

With proper tracking and monitoring of what the team does on a daily basis, teams can begin to gather data on what types of work the team is doing on a daily basis. What we often find is that at a certain point new development will stop coming from small teams charged with both the development and sustainment of a program as they cannot keep up with both. The ironic thing is that most BI managers have no real data to back this up. So taking advantage of some of the rigor around agile in terms of tracking what is done on a daily basis and how slowly new work burns down, one can begin to understand and report better on how time is spent and in fact how little time is available to delivering new functionality.

Social Analytics meet Business Intelligence

 Post written by Wade W., BI Consultant at Ideaca. Read more about BI on his blog: Pragmatic Business Intelligence.

If your company is a well-known brand, somebody, somewhere is publicly talking about it. Right now. It may be on your own Social channels, in an Internet forum, a blog or other user-generated content site. Social Media Monitoring, which put simply is keeping a constant eye on Social sites including Twitter, Facebook and hundreds of other platforms to monitor what is being said about your brand, has become a necessity for most large organizations, and it is an art and a science to manage this well.  Manage it badly, and you can have a catastrophic image issue (i.e. the 2010 Nestle Palm Oil debacle on Nestle’s own  Facebook page).  Handle it well, and you can cement a solid relationship with existing clients and convert new clients to your brand (i.e. HP’s little-known but truly brilliant efforts to provide temporary replacement HP hardware to certain individual users on social platforms complaining of broken computers).

From a commercial aspect, companies are increasingly looking at Social Media to contribute to driving revenue, largely through lofty concepts such as “engagement” and “conversion.” Social is unique in not only the speed of the communication, but also the intimate nature of content.  In addition, and importantly, what companies must understand is that in the Social realm, the customer controls the conversation. The implication here is a fundamental paradigm shift for Customer Relationship Management and Marketing, to understand the customer on a personal level, and to handle – with great sensitivity – both the positive and negative sentiment expressed on Social platforms.

(Social) Business Intelligence
A growing and compelling new flavor of Business Intelligence is attempting to tap into the unstructured content on social platforms and attempt to structure that data into a format that can be analyzed and mined using new methods such as Sentiment Analysis, which measures the aggregate sentiment across user posted content. Social Business Intelligence uniquely sits in the convergence of Knowledge Management, Social Media Monitoring, Collaboration, Social Networking, Analytics , Customer Relationship Management (CRM) and Business Intelligence (BI).

Social Business Intelligence is at a unique convergence point between several key technologies.

First, there is an important roadblock to get out of the way. Today there are a selection of tools to do everything I am discussing below in one way or another.  With a simple sentence I have rendered technology irrelevant for the purposes of this blog. So let’s focus on what Social BI is, how it is done and what it means because that is what is important to business.

I’m not really a catch-word kind of guy, but this is Big Data in its truest form. There are thousands of platforms and sites, of course, but if we only talk about  the current Big Guys (Facebook, Twitter and Foursquare for example), this would add up to billions or trillions of conversation segments over a given  (even conservative) time horizon. To put this in context: that customer data warehouse you have built over all these years probably doesn’t come close…

Social Business Intelligence offers both Internal and External Opportunity
There are both internal and external opportunities to be realized through Social Media Business Intelligence, and many tools are evolving to support these, some even going so far as to adopt a “Facebook-like” or “Twitter-like” interface, mimicking social interaction and Social Networking site features.

Social Business Intelligence applied internally to an organization could be termed Social Collaboration. For example, certain tools might feature collaborative review where colleagues can ask questions and link those answers to specific reports, or collaboratively comment and markup objects such as Business Intelligence ad-hoc analytics,  graphs or reports. This functionality to comment in real time on powerful business intelligence (even if it is only based on Traditional data sources that exclude Social Media data) has the potential to add value to interpretation of the reports that companies produce and use today to base key decisions upon, thereby potentially improving decisions made from today’s Decision Support Systems. Many traditional software vendors already have adopted such functionality.

Of course, where Social Business Intelligence as a disruptive technology becomes particularly interesting is when we start gathering and analyzing that unstructured user-generated content, or even more compelling, when we combine it with our existing “traditional” Enterprise Analytics environments. This empowers organizations to produce new innovative products that target user segments more accurately and respond better to customer support or relationship development opportunities. The value of Social Business Intelligence is not really “about” the frequency of words and phrases users post on social platforms. The value is in segmenting, categorizing, mining and understanding the aggregate of the users’ behavior, and the sentiment of those posts across products, segments and channels.

Social Media has its own unique segments, which include Employees, Partners, Influencers, Detractors and Advocates. We can analyze social network traffic, understand and identify our segments, and tailor personalized/semi-personalized interaction to individuals or one of these segments,  flagging key comments, monitoring Likes, +1’s, trending subjects and use of hashtags, enabling rapid and targeted response to user comments to avert public relations crisis, measure success of our Social Marketing programs or capitalize on new opportunities.

It’s all about the conversation. And you don’t control it.
Again, companies need to understand that the customer controls the conversation. However, the tools exist that can arrange and present structured knowledge from unstructured noise, providing key information input to areas such as Marketing and Manufacturing to be responsive and agile, acting on data that correlates highly to real-life fact.

At its root, Social Media is about the conversation. This implies new requirements for how to manage our link to the customer, and how to most effectively target and market to them. Increasingly, consumers are mistrustful of the marketing messages and advertising. They are more likely to find more relevance and see more value in the reviews and purchasing of their friends and peers.

Social Business Intelligence in Practice
I thought to finish, I would provide two examples that support the claim that through mining user-generated content, we can correlate with very high level of confidence, to known and validated facts.

Google Flu Trends
An example of single-source user generated content analysis is  Google Flu Trends.  Google has been analyzing aggregated web search terms to see if it is possible to correlate geographic frequency of user search terms on Google’s search engine to real data on flu epidemics.

While I recognize this is not Social Media  per se, this example is very relevant to the argument that user-generated content can be tied to sentiment and can also be used as a predictor for future events, when we clearly understand and define the objective, then identify and measure indicators supporting that objective.

Google’s site http://www.google.org/flutrends/ca/#CA provides up-to-current-day results to allow tracking of current and developing flu incidents and epidemics. In addition, on this site there are historical graphs over a multi-year period for regions around the globe that prove, using known, validated historical data, that reality and future events can indisputably be predicted by user-generated content.

United Nations Global Pulse.
Between 2009 and 2011, the United Nations and SAS studied how Social Media and other user-generated content from public internet sources such as blogs, Internet forums, and news published in Ireland and the US could be correlated to validated statistics and leveraged as a compliment and an qualitative indicator of real-life events.

For Global Pulse, the focus was on employment status. To summarize from the document found at http://www.sas.com/resources/asset/un-global-pulse.pdf,  the UN identified keywords indicating changes in employment status (i.e.”fired”), level of anxiety (i.e.  “depressed”) or economic indicators (i.e. loss of housing or auto repossession, cancellation of vacations) in order to  monitor sentiment.  The results were astonishing. The analysis of sentiment allowed them to predict  increases in unemployment as much as four months in advance of an uptick in unemployment claims with a 90-95% level of confidence. Further, they were able to predict precisely, again with a 90-95% confidence, how long after an uptick in unemployment that there would be an increase in clear economic indicators in the form of talk of loss of, or negative changes to housing, changes of transport method or cancellation of travel plans.

These two examples underscore that user-generated content in the social realm represents a new and potentially highly accurate source of knowledge when tied to clearly defined objectives and supporting metrics (leveraging appropriate keywords). Indeed, Social Media Business Intelligence has the potential  to facilitate very personal customer understanding and when backed by a well defined strategy, to strengthen the relationship with our customer, avert PR disasters and increase customer engagement and conversion.

What are your thoughts? Is the world ready for Social Business Intelligence? Has your company thought about imposing order and structure to the chaos that is Social Media user-generated Content?

The data has the answers

Post written by Evan Hu, Co-founder of Ideaca. View his blog here: evanhu.wordpress.com

In a 2001 research report by META Group, Doug Laney laid the seeds of Big Data and defined data growth challenges and opportunities in a “3Vs” model. The elements of this 3Vs model include volume (the sheer, massive amount of data or the “Big” in Big Data), velocity (speed of data processed) and variety (breadth of data types and sources). Roger Magoulas of O’Reilly media popularized the term “Big Data” in 2005 by describing these challenges and opportunities. Presently Gartner defines Big Data as “high-volume, high-velocity and high-variety information assets that demand cost-effective, innovative forms of information processing for enhanced insight and decision making.” Most recently IBM has added a fourth “V,” Veracity, as an “indication of data integrity and the ability for an organization to trust the data and be able to confidently use it to make crucial decisions.”

The volume of data being created in our world today is exploding exponentially. McKinsey’s 2012 paper “Big data: The next frontier for innovation, competition, and productivity” noted that:

• to buy a disk drive that can store all of the world’s music costs $600
• there were 5 billion mobile phones in use in 2010
• over 30 billion pieces of content shared on Facebook every month
• the projected growth in global data generated per year is 40% vs. a 5% growth in global IT spending
• 235 terabytes data was collected by the US Library of Congress by April 2011
• 15 out of 17 sectors in the United States have more data stored per company than the US Library of Congress

IBM has estimated that “Every day, we create 2.5 quintillion bytes (5 Exabyte) of data — so much that 90% of the data in the world today has been created in the last two years alone." In their book “Big Data, A Revolution That Will Transform How We Live, Work, And Think,” Viktor Mayer-Schonberger and Kenneth Cukier state that “In 2013 the amount of stored information in the world is estimated to be around 1,200 Exabytes, of which less than 2 percent is non-digital.” They describe an Exabyte of data if placed on CD-ROMs and stacked up, they would stretch to the moon in five separate piles.

This sheer volume of data presents huge challenges. For time-sensitive processes such as fraud detection, a quick response is critical. How does one find the signal in all that noise? The variety of both structured and unstructured data is ever expanding in forms: numeric file, text documents, audio, video, etc. And last, in a world where 1 in 3 business leaders lack trust in the information they use to make decisions, data veracity is a barrier to taking action.

The solution lays ever more inexpensive and accessible processing power and the nascent science of machine learning. While Abraham Kaplan (1964) principle of the drunkard’s search holds true: “There is the story of a drunkard, searching under a lamp for his house key, which he dropped some distance away. Asked why he didn’t look where he dropped it, he replied ‘It’s lighter here!’” A massive dataset that all has the same bias as a small dataset will only give you a more precise validate of a flawed answer, we are still in early days. Big Data is the opportunity to unlock answers to previously unanswerable questions and to uncover insights unseen. With it are new dangers as the NSA warrantless surveillance controversy clearly exposes.

I have had the privilege of listening to Clayton Christensen speak several times. In particular he has one common through line that stuck with me and forever embedded itself in my consciousness. “I don’t have an opinion. But I have a theory, and I think my theory has an opinion.” I believe the same for Big Data. The data has an opinion, the data has the answers.

Comparing AX 2012 Reporting with Standard SSRS

I have been a Business Intelligence (BI) consultant for a couple of years, and I have worked with the whole suite of Microsoft BI products:  Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS).  Dynamics AX 2012; however, was an alien entity to me.  When I was asked to do reporting in Dynamics AX, I thought that since this is a Microsoft product that uses SSRS and a SQL Server database, this should be a pretty standard task based on my experience.  While I was correct from a front-end design point of view, actually getting the data to the report was quite a different task.

The first noticeable difference is the setup.  AX 2012 uses Visual Studio 2010 as opposed to Business Intelligence Development Studio (BIDS) to setup its reports.  BIDS leverages Visual Studio 2008 to launch and run SSRS and you make all of your connections, data sets and parameters directly in the report designer.  Visual Studio 2010 uses a tree view to manage all your data sets and parameters.  These objects must be added, modified or refreshed in the tree to translate over to the report designer. Changes can be made in report designer like in BIDS but they will not translate back to the tree and the changes will not stick.  BIDS creates an RDL file that can be reopened and edited.  With Dynamics AX 2012, everything is stored in the AOT and brought to the local machine by using temporary folders.

An Introduction to PerformancePoint Services Part 1 of 2: OLAP Design

An Introduction to PerformancePoint Services Part 1 of 2: OLAP Design

Introduction

SQL Server Analysis Services (SSAS) and PerformancePoint Services are tools in the Microsoft BI stack used for displaying data. Analysis Services allows analysts to investigate data quickly and dynamically without IT having to write queries. PerformancePoint Services displays high level Key Performance Indicators (KPIs) to executives to be viewed at a glance. These tools leverage the data warehouse to users who may not have technical expertise.

The first part of my two part article will focus on the creation of an Online Analytical Processing (OLAP) cube as well overview of what is required for the delivery of the solution as a whole. The second part will focus on the aesthetic side of displaying data via the dashboard.

What is required?

In order to get a PerformancePoint dashboard up and running off an Analysis Services Cube (using a relational database instead of a cube is an option but the advantages of using a cube include: faster aggregation of measure values, hierarchies of members, and KPIs) a cube will need to be created. SharePoint 2010 is required in order to create a dashboard using Dashboard Designer. Creating a Business Intelligence site in SharePoint will allow for the download of the Dashboard Designer and the ability to deploy the web parts created in the designer to the SharePoint site. Having SharePoint is also a great way to expose Business Intelligence to users; whether it is reports, PowerPivot models, or complicated Excel files. These components of business intelligence all would benefit by being viewed by analysts.

Ideaca Wins Business Intelligence Partner of the Year at 2012 Microsoft Partner Network IMPACT Awards!

 

Ideaca has been selected as the winner in the Business Intelligence Partner of the Year category at the 2012 Microsoft Partner Network IMPACT Awards! Ideaca was also named a finalist in the Dynamics ERP Partner of the Year category. We are extremely excited for this win and cannot wait to continue to compete next year! For more details read here: http://bit.ly/W9TP7P

 

For more finalist read here: http://goo.gl/cFk11

 

Follow @Ideaca

IDC Executive Brief

The Current reality of Analytics in Large Canadian Enterprises: IDC Canada Maturity Model

How do you measure up?

July 2012

Sponsored by Ideaca

Adapted from Canadian Business Analytics Landscape, 2012, by Nigel Wallis  

IDC #CA0ECA12

In 2011, more than a trillion gigabytes of information was created and replicated globally, which means it grew by a factor of nine in just five years. Being able to deal with this onslaught and successfully deliver the right information to the right people at the right time is a competitive business advantage. That's why the market for analytics software is bigger than one might imagine. In Canada, organizations spent $923 million in 2011, 12% more than the previous year. IDC anticipates that by 2015 the Canadian analytics market will be north of $1,200 million, meaning the analytics sector is growing much faster than the software market as a whole.

In spring of 2012, IDC surveyed 100 business and 100 IT leaders from Canadian firms with $100 million or more in revenue. IDC spoke with director, VP, and C-level executives to better understand how businesses were integrating analytics into their competitive strategies.

IDC Canada Business Analytics Maturity Model

In order to better understand how analytics is moving from hype to reality, IDC developed a maturity model from the data in the study. Our aim was to identify which cultural and technological choices and decisions determine analytical competency.

To Download a copy of the entire Executive Brief please click here.



Follow @Ideaca

2012 Canadian BI Maturity Results from IDC

Next week, Ideaca will once again be travelling across the country to bring IT Directors, CIOs and the like, all together for another one of our National Executive Series Events!

Presenters Richard Hines from Ideaca in the West, and Brian Lee from Ideaca in the East, will be bringing you the latest results in Canadian BI Maturity Research. Be the first in line to benchmark your company against the Canadian landscape.

Canadian companies from coast to coast participated in a survey conducted by IDC designed to extract information on where organizations sit currently, and how they should move forward on the BI Maturity model.

When you’re investing in BI, what research are you falling back on to make your decision? We’ve got all the answers you need to help you make the right ones.

Register NOW to attend a complimentary breakfast session in a city near you to hear the results before they are released to the rest of the country.
 
Follow @Ideaca

Hang up on the past...dial into mobility NOW!

Last Wednesday evening in Waterloo, Ontario, Ideaca hosted a cocktail event "Mobility...Canada's most overlooked priority & why it is crucial to business success!".

This event focused on the urgent need for Canadian businesses to step up their initiaves in creating a mobile platform for both their employees and for their customers.

Brad Blaskavitch, Sales Director at Ideaca, touched on the many ways a company can develop different mobile strategies to better their customers experience, as well as satisfying the everchanging needs of their employees.

Christa Nesbitt, Sales Director at Ideaca,  also wowed the audience with a few demos showcasing submitting expenses on the go, tracking store productivity and sales in real-time and a virtual tracking program to discover and maintain issues in the field.

If you missed out on this event, it will be hosted again in Fall 2012 in Toronto, Calgary, Edmonton and Vancouver. Stay up-to-date for event details in your city!

Follow @Ideaca

Ideaca Renews Multiple Microsoft Gold Competencies in the Microsoft Partner Network

We have renewed our gold competencies in Business Intelligence (BI), Enterprise Resource Planning (ERP), Portals and Collaboration and Customer Relationship Management (CRM) as well as silver competencies in Virtualization, Web Development, Application Integration and Data Platform.

"These Microsoft competencies showcase our expertise and commitment in today’s technology market and demonstrates our deep knowledge of Microsoft and its products,” said Mike Alkier, Managing Partner, Ideaca.  “Our plan is to accelerate our customers’ success by serving as advisors for their business technology needs.”

“By achieving a portfolio of competencies, partners demonstrate deep expertise and consistent capability on the latest Microsoft technology,” said Jon Roskill, corporate vice president, Worldwide Partner Group at Microsoft Corp. “These partners show true commitment to meeting customer technology needs today and into the future.”

Check out the full story here.
 

Follow @Ideaca

Corporate Mobile Application Strategy

In the March/April edition of Exchange Magazine, Ideaca's Brad Blaskavitch wrote an article around creating a Corporate Mobile Application Strategy for your business.

In this article Brad outlines five essential technology components for a successful mobile strategy:

1. Mobile Devices: Smartphones and new generation tablets are more powerful and capable than ever before, and keep evolving at a rapid rate. Their power allows for more advanced applications. The ability to store data when network connectivity is lost, has been critical to corporate mobile application initiatives.

2. Mobile Applications & Platforms: Previously, organizations delayed investment in mobility for fear of tying themselves to a single hardware vendor, causing paralysis. Today's mobile computing platforms and development tools have advanced to the point that device OS/manufacturer is no longer significantly relevant. Mobile applications can be developed once to run on Android, Apple iOS and Blackberry.

3. Network/Carrier Infrastructure: Wireless telecom companies have made tremendous investments to improve the speeds of data transfer and expand their geographic coverage. We have seen the transition from 2G to 4G networks. These improvements allow mobile applications to have more capability and perform at acceptable speeds.

4. Corporate Technology: Many companies have invested heavily in corporate systems and line of business applications to improve operational efficiencies in administrative functions, systems such as Enterprise Resource Planning, Financial, Customer Relationship Management and Business Intelligence. Organizations now have the key internal infrastructure to support a true corporate mobility strategy and extend these capabilities to their mobile workers in an integrated solution.

5. Cloud Computing: While many will argue that it isn't a core requirement, cloud computing has allowed many organizations to scale their technology footprint without incurring the significant capital costs of a more traditional on-premise hardware strategy. The ability to scale up or down the computing power of an organization, eliminating hardware and IT resource constraints, has freed up capital and IT resources to focus on value add solutions to increasing the organizations competitiveness.

For the rest of the article, click the link below to check it out on page 32-33. http://www.exchangemagazine.com/currentissue/ExchangeVol29No4/

Follow @Ideaca

Budgeting & Planning for Strategic Leadership

National Executive Series: 

Budgeting & Planning for Strategic Leadership

Photo from 02/28/12 - Waterloo Event - Ideaca

Ideaca completed its first stop on the 2012 National Executive Series event tour: Budgeting & Planning for Strategic Leadership, yesterday in Waterloo, Ontario. This series is designed for senior finance leaders to connect and engage in the changing landscape of corporate finance and discuss new strategies for success in an increasingly competitive market. This event was originally sponsored by the Toronto Board of Trade as an offering to its 500+ partners, and has since been transformed into a national tour to accommodate the overwhelming demand for information on this critical topic.

Presenter Brad Blaskavitch said of yesterday's Waterloo event, 

"What a fantastic group of senior finance leaders - It was exciting to help provide them with ideas on budgeting, planning and forecasting as a catalyst for leading strategic change. I'm really looking forward to the next few stops on this tour, and connecting with business leaders from around the country."

Ideaca still has four more upcoming complimentary events and has limited spots open for those who still wish to register. Our next presentations are in Toronto, Edmonton, Vancouver & Calgary. Please visit  http://goo.gl/UX2mD  for more information on the National Executive Series, or to register today. We look forward to seeing you out at an upcoming event near you!

   

Follow @Ideaca

When the Forecast Calls for Clouds

 

Is cloud computing right for your company? Inc. posted an article on the different ways you can use Cloud Computing, and how making the switch could benefit your company. Check out the article link below and tell us how your company benefits from the "cloud".

When the Forecast Calls for Clouds.

Follow @Ideaca

BI and Analytics Top Technology Priority for CIOs in 2012

Gartner's recent worldwide survey to over 2000 CIOs conducted in the fourth quarter of 2011, noted that analytics/business intelligence was the top-ranked technology priority for 2012. Gartner notes that "CIOs are combining analytics with other technologies to create new capabilities" and that increasing enterprise growth is their top priority. 
 
Some questions to keep in mind as investments in BI and analytics continue to grow in 2012:

• How can we manage Operational and Enterprise BI initiatives without impacting the business user community?
• Can we embrace BI-in-a-box and maintain the integrity of one version of the truth?
• What does the future of BI hold for information integrity and decision making accountability?

Follow @Ideaca