Showing posts sorted by date for query business intelligence. Sort by relevance Show all posts
Showing posts sorted by date for query business intelligence. Sort by relevance Show all posts

Friday, May 02, 2014

Defining Business Intelligence 3.0

Lachlan James of SmartData Collective poses the following rhetorical questions about the emergence and nature of Business Intelligence 3.0:
So what exactly is Business Intelligence 3.0? Is it a mass of meaningless marketing messages, a collection of multiple BI advancements, or does it represent a single technological shift that many have misconstrued?
Read More

What I find interesting is the apparent trend from "tool-centricity," through "web-centricity," toward "app-centricity." The figure below is instructive.

[click image to expand]

Source: James, L (2014, April 11), Defining Business Intelligence 3.0, SmartData Collective.

Related Posts

Tuesday, April 08, 2014

Business Intelligence and the Analytics Leader

A succinct and instructive Venn diagram describing the business intelligence space, including the central (and essential) role of the analytics leader.

[click image to enlarge]

Related Posts

Tuesday, December 03, 2013

Tabular versus Multidimensional Modeling

According to Microsoft TechNet (2012), the distinction between tabular versus multidimensional modeling is operationally significant for analysts:
Multidimensional modeling, introduced with SQL Server 7.0 OLAP Services and continuing through SQL Server 2012 Analysis Services, enables BI professionals to create sophisticated multidimensional cubes using traditional online analytical processing (OLAP).

Tabular modeling, introduced with PowerPivot for Microsoft Excel 2010, provides self-service data modelling capabilities to business and data analysts. The tabular modeling experience is more accessible to these users, many who have spent years working with data in desktop productivity tools like Excel and Microsoft Access. In SQL Server 2012, tabular modeling has been extended to enable BI professionals to create tabular models in Analysis Services or to import a tabular model from PowerPivot into Analysis Services. Note that a PowerPivot model cannot be imported into an Analysis Services multidimensional model.
Read More

[click to expand]

Business intelligence (BI) analysts who have not yet done so will want to become conversant about PowerPivot for Excel, PowerPivot for SharePoint Services, Analysis Services Tabular, and Analysis Services Multidimensional. Follow the link below to learn more.

Source: Raja, N (2012, May 3). Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services. Microsoft TechNet.

Related Posts

Thursday, October 31, 2013

Mandatory Reading for Business Intelligence (BI) Professionals

Every business intelligence (BI) professional on the planet should make BusinessIntelligence.com their home page. Follow the link below to learn more.


Related Posts

Saturday, August 03, 2013

Taming Big Data: The Emergence of Self-Service Business Intelligence (BI)

The infographic below created by IBM (2013) seeks to clarify key differences between so-called "small data" and "big data." The migration of data analytics from relational databases to in-memory systems is a vital step toward self-service production of business intelligence (BI)

[Click image to expand]

The migration of data from relational databases to in-memory database systems is good news for business intelligence (BI) analysts. Said another way, the era of self-service BI production has finally arrived.

Source: Taming Big Data: Small Data vs Big Data, Huffington Post.

Related Posts

Wednesday, May 15, 2013

Business Intelligence (BI) versus Data Science

David Smith at Revolutions (2013) compares business intelligence (BI) with data science as follows:


Read More

The discipline of analytics is constantly evolving, or so it seems...

Source: Smith, D (2013, May 15), Statistics vs Data Science vs BI, Revolutions.

Related Posts

Thursday, January 31, 2013

Big Data Means Big Testing

According to Scott Brinker in Search Engine Land (2013, January 30):
Big data is opening the door to the executive suite for a more hybrid analytical-creative method. The questions big data raises... have an answer.... The answer is big testing.... Big testing is about making a big deal about testing from the top down, fostering a culture of experimentation.... This last point will probably be the most challenging, as culture is not something that changes quickly. Executives need to make a conscious effort to encourage real testing — starting with the acknowledgement that good experiments prove or disprove hypotheses.... Big data is like fuel. Big testing will be the engine that turns it into forward momentum.
Read More


The emergence of "big data" elevates and expands the role of advanced analytics, including hypothesis testing. Information age decision-makers are increasingly beholden to the business intelligence that big data stores can yield, which means acknowledging and fostering an interdisciplinary approach between information technology, advanced analytics, and business processes as synergistic drivers for improved enterprise decision-making in the 21st century. Big data means big testing!

Source: Brinker, S (2013, January 30), Why Big Testing Will Be Bigger Than Big Data, Search Engine Land.

Related Posts

Thursday, September 20, 2012

What Employers Look for in a Data Scientist



My editorial comment to this video is to observe that the case is still out as to the difference between a "data scientist" and a "business intelligence analyst." Said another way, the guidance provided above for aspiring data scientists applies equally to aspiring business intelligence analysts as well.

Related Posts

Thursday, June 07, 2012

Business Intelligence Process Integration via Knime

The business intelligence (BI) production path integrates data access, transformation, analysis, visualization, and exploitation into a unified process. Knime (Konstanz Information Miner) is a professional open-source software package that integrates all of these functions onto a single platform. According to the Knime website:
Knime, pronounced [naim], is a modern data analytics platform that allows you to perform sophisticated statistics and data mining on your data to analyze trends and predict potential results. Its visual workbench combines data access, data transformation, initial investigation, powerful predictive analytics and visualization. Knime also provides the ability to develop reports based on your information or automate the application of new insight back into production systems.
Knime is supported by an expanding number of third-party extensions that enable interfacing with Excel (Microsoft), R (Project R), BIRT (Eclipse), WEKA (University of Waikato), and more. Expand the graphic below to see how Knime integrates various functions and processes via its discrete process simulation features.


Knime Function Nodes [click to enlarge]

Follow the link below to learn more about Knime and its powerful BI production features for enterprise.

Knime

Related Posts

Tuesday, May 22, 2012

The State of Business Intelligence (BI) Platforms

According to Gartner (2012):
Business intelligence (BI) platforms enable all types of users — from IT staff to consultants to business users — to build applications that help organizations learn about and understand their business. Gartner defines a BI platform as a software platform that delivers the 14 capabilities listed below. These capabilities are organized into three categories of functionality: integration, information delivery and analysis. Information delivery is the core focus of most BI projects today, but we are seeing an increased interest in deployments of analysis to discover new insights, and in integration to implement those insights.
Read More


Oracle and MicroStrategy have taken the lead from Microsoft since 2011.

Source: Hagerty, J, Sallam, R L, & Richardson, J (2012, February 6), Magic Quadrant for Business Intelligence Platforms, Gartner.

Related Posts

Thursday, May 17, 2012

Knime for Business Intelligence

For business analysts and firms seeking to expand their skills and capabilities from localized analytics into the broader realm of business intelligence processes and solutions, check out Knime. According to Knime's website:
Knime (Konstanz Information Miner) is a user-friendly and comprehensive open-source data integration, processing, analysis, and exploration platform. From day one, Knime has been developed using rigorous software engineering practices and is used by professionals in both industry and academia in over 60 countries.
Knime delivers robust features that encompass the full spectrum of business intelligence production requirements, including tools for: a) integrating multi-source data via open database connectivity (ODBC) and real-time processes; b) diverse analytic tools for data mining such as clustering, decision trees, rule induction, neural networks, association rules, scoring, meta-analysis, and more; and c) state-of-the-art presentation tools that easily integrate with existing ad-hoc reporting, automated dashboard, and systems actuation platforms. Knime is also actively supported by third-party extensions that integate Knime with R (Project R), Excel (Microsoft), and other widely-used integration, analytics, and presentation platforms.


Knime is the missing application that analysts have long-sought to enable self-service production of business intelligence. Anyone seeking to understand and manage the entire business intelligence production process will find Knime to be didactically useful.

Follow the link below to learn more.

Knime

Related Posts

Sunday, March 11, 2012

NodeXL: Open-Source Network Graphing for Excel

Introducing NodeXL, an open-source template for Excel (Microsoft) 2007 and 2010 that makes it easy to explore network graphs. With NodeXL, you can enter a network edge list in a worksheet, click a button and see your graph, all in the familiar environment of the Excel window. Follow the link below to download a copy and learn more.

NodeXL Download Page


The business intelligence tools for Excel just keep getting better. The NodeXL project is sponsored by the Social Media Research Foundation, a group of researchers dedicated to creating open tools, generating and hosting open data, and supporting open scholarship related to social media.

Related Posts

Sunday, February 12, 2012

Self-Service Business Intelligence and Analytics Means Just That

The mantra of "self-service" is now reaching a crescendo in the business intelligence and analytics community. Jorgen Heizenberg of CapGemini acknowledges budget constraints in the current economy make self-service business analytics an enterprise imperative. However, he cautions that security monitoring by information technology (IT) departments is still required.
The current state of our economy is also impacting IT budgets. That’s a fact that nobody can deny. At the same time the need for relevant information has increased considerably. Organizations are more and more focusing on their customer and need supporting data. That is another fact. As a result IT is reconsidering its position (back to the core?) whilst the business is waiting for the much needed report or analysis. This need for faster time to information and less IT involvement has given rise to something that is often called Business or Self Service Reporting (SSR). Traditionally BI reports are created by the IT department. SSR allows business users to do this for themselves using end user oriented query and reporting tools.
Read More

Jorgen Heizenberg

From where I sit, the supervisory involvement of IT in the production of business intelligence and analytics is abating, though security monitoring will continue. However, the commoditization of IT means that budget-constraints will limit IT's capacity to manage business analytics projects directly. Moreover, the demand for analytics itself is expanding at a rate that IT cannot now contend with internally given existing or diminishing resources. Self-service business analytics are the future, which means that IT's involvement in producing business intelligence and analytics will flag with time.

Source: Heizenberg, J (2012, January 18), Self Service Reporting Good! Traditional BI Bad?, CapGemini.

Related Posts

Friday, February 10, 2012

Analytics: Hotter Than Ever

Timo Elliott is predicting that 2012 will be the year that analytics takes the lead as a business driver in today's economy:
The real trend this year is not the technology. It’s about helping business people make better decisions, and actually change the way companies do business. Analytics has always been about transforming business, but the recent huge changes in analytic technology have created interesting new opportunities for business innovation....

In particular, companies want better visibility about what’s going on in their market, and increased organizational agility in order to be able to deal with change fast. It’s like driving in the fog without a map – in order to survive, you should invest in better visibility, brakes, and steering to be able to spot and avoid fast-moving objects looming out of the fog.

Analytics provides these capabilities: business intelligence to peer into the road ahead, risk-management to provide fast alerts to new obstacles, and flexible financial planning systems to help swerve around them....

Many companies are going beyond "just" improving their existing analytic capabilities, using analytics in new ways to change the way they do business. Instead of analytics being something that is used to monitor and eventually improve a business process, analytics is becoming a more fundamental part of the business process itself.
Read More

Timo Elliott

Let's face it, analytics are hotter than ever, especially in today's competitive economy.

Source: Elliott, T (2012, February 10), 2012: The Year Analytics Means Business, Business Analytics.

Related Posts

Monday, January 30, 2012

Charles Seife: On Mathematical Deception

Prof Charles Seife cautions vigilance in the face of what he describes as "the dark arts of mathematical deception."



I regret that good people continue to be bamboozled and victimized by numerical charlatans who prey upon our society. The newest approach to mathematical deception is through distorted visualizations and graphics. Ironically, many of the "dashboard" solutions that are in current use in enterprise have never been tested for validity or reliability. Consumers of quantitative intelligence would be wise to look well beyond the numbers and graphics into the sources of data and confidence testing that was used in support of analytical conclusions.

As a business intelligence and quantitative professional, I am constantly detecting subtle to blatant methodological violations in the literature. In particular, government research is not immune to these violations. When in doubt, be certain to consult with an independent analytics professional before relying upon any reports and evidence required for major decisions that entail potential catastrophic loss of assets, life, or freedom. Remember that the marketplace, hospitals, and courtrooms are still very dangerous places.

Related Posts