September, 2014

article thumbnail

The Need for Big Data-Fueled Marketing BI

Domo

Data exhaust. Cyber shadow. Digital footprint. Turns out our passionate embrace of all these interconnected digital devices is leaving a kind of transactional trail that, in the aggregate, has come to be known as Big Data. We are creating enormous quantities of the stuff, and modern organizations are increasingly eager to poke around in it. Consider, for example, Google CEO Eric Schmidt’s claim that every two days we modern humans create as much information as did all our ancestors combined; or

article thumbnail

Dynamically Passing Parameters to a SQL Stored Procedure from PowerPivot Using VBA

BI Insight

In this post I express an easy way to refresh a PowerPivot model dynamically based on SQL Server Stored Procedures. Let’s start with SQL Server Management Studio (SSMS) 2012 and use Adventure Works 2012 database. Run the following script to see the results in SSMS: exec [dbo].[uspGetBillOfMaterials] 727, ‘2009-01-02’ First parameter: Start Product ID … Continue reading Dynamically Passing Parameters to a SQL Stored Procedure from PowerPivot Using VBA.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Why just SEE your data when you can DISCOVER its meaning?

Elegant BI

This article talks about the ways in which a business can plan for and achieve data visualization but it is Deep Dive Analytics and supporting tools that will help you to mine the nuggets in your data and truly experience an ‘ah hah’ moment! Article Source: [link].

IT 52
article thumbnail

What Do Your References Say About You?

Better Buys

'Ever wish you knew what people are saying about you behind closed doors? When it comes to your personal life – maybe. But in your professional life? If it can make the difference between getting that new job or big promotion, then definitely. When it comes to these kinds of job-related opinions from others, we […].

article thumbnail

Prepare Now: 2025s Must-Know Trends For Product And Data Leaders

Speaker: Jay Allardyce, Deepak Vittal, and Terrence Sheflin

As we look ahead to 2025, business intelligence and data analytics are set to play pivotal roles in shaping success. Organizations are already starting to face a host of transformative trends as the year comes to a close, including the integration of AI in data analytics, an increased emphasis on real-time data insights, and the growing importance of user experience in BI solutions.

article thumbnail

Top CEOs Are Still in the Dark on Social Media

Domo

Long gone are the days when CEOs could hide behind their office doors. Employees and customers are beginning to expect the chief executive to lead the way when it comes to brand awareness and visibility. When CEOs are active on social media it sends a clear message to their employees that they are committed to strengthening the company’s brand. A recent Weber Shandwick study found that of those surveyed, 81 percent said social CEOs make better leaders, 82 percent were more likely to trust a CEO

More Trending

article thumbnail

Love Sales Conversion and Numbered Lists? This Article is For You!

Elegant BI

People love numbered lists! The internet is chock full of articles, blogs and forums regaling us with numbered lists of important business factors and ways to beat the competition. With titles like, ‘The Five Best Ways to Attract New Customers’, ‘The Ten Most Important Things a Business Manager Should Know’ , the lists are apparently endless.

Sales 52
article thumbnail

Nuts to Site Traffic! BI, KPIs and SMM Give You the Power of Conversion!

Elegant BI

I’ll just come right out and say it! All key performance indicators (KPIs) that are meant to drive performance (and all KPIs should do just that) must be linked to goal conversion. If they are not, then your metrics are meaningless or you are measuring the wrong thing! Whether you are talking about a click-through-rate (CTR), or unique visitors or the number of followers or time spent on a page or site, it all boils down to conversion goals.

KPI 52
article thumbnail

(More) Secrets of the Data-Driven CMO

Domo

If data were water, then many marketers are trying to drink from a fire hydrant. Even within the marketing department alone, there’s an impossible amount of information for one person to keep track of day in and day out. Here are two more secrets, pull from our executive brief “ 7 Secrets of the Data-Driven CMO ,” that will help you get the data you need without drowning from an information overload: Secret #1: Manage by Exception Some CMOs feel like they should be looking at every number in eve

article thumbnail

Get Rid of the Mud and the Snails and Get Results with Integrated BI

Elegant BI

Information can move at the speed of light or at a snail’s pace within an organization, and that information can be as crystal-clear as a mountain stream or as muddy as a country field after a rainstorm. The quality and speed of your data depends greatly on the business intelligence solution you choose and the decisions you make regarding deployment, training and implementation.

article thumbnail

Gain a Competitive Edge With This Scenario Planning Toolkit

In a world where uncertainty and change are constant, scenario planning empowers companies with the agility and competitive edge needed to thrive. Download the toolkit to fortify your business strategy , set up your competitive positioning , and ensure your company is poised to respond to any future scenario.

article thumbnail

India Natural Gas Studies Energy Requirements

Elegant BI

Business Intelligence forecasting and predictive analysis is crucial to this type of business and can effectively and accurately predict patterns and trends, as well as the need for new infrastructure, demand growth, etc. Article Source: [link].

article thumbnail

Resolving Format Cells Change after Refreshing Data Sources in Power Query

BI Insight

In this post I want to share my experience with refreshing data in Power Query and the way it affects loaded data to an Excel worksheet. I was loading sales data from SQL Server and I noticed that there is no easy way to define a 1000 separator in Power Query. So I decided to … Continue reading Resolving Format Cells Change after Refreshing Data Sources in Power Query.

Sales 52
article thumbnail

Two Top Challenges for Every Retail COO (And How to Fix Them)

Domo

This blog post is an extraction from the report Conquering Retail’s 6 Biggest Cross-Channel Challenges , available for free here. Retailers have an unending supply of potential software solutions built to solve business problems—especially for operations and supply chain. But managing all the disparate “solutions” can become a serious problem.

Retail 52
article thumbnail

What Your Finance Reports Should Learn from Mint

Domo

Everyone understands finance will never stray from spreadsheets and its hard data, number-crunching roots. And they never should. But for some executives receiving reports from finance, a spreadsheet in their email inbox incites a specific type of dread. And too often, if a report is boring and overwhelming, it won’t be read—and that makes it next to useless.

Finance 52
article thumbnail

Are Your Impact Comms Resonating With Stakeholders?

Whether your organization is at the start of its sustainability and impact journey or years into it, many brands share a common concern: the uncertainty of whether they are sending stakeholders mixed messages. Creating content that speaks to your audience's “love language” can be a tricky dance. But, worry not! 3BL has put together tips to ensure that your content not only finds its rhythm but also resonates with your target audiences.

article thumbnail

How Can a Business Accurately Plan for the Future of Business Intelligence When Needs Change Every Day?

Elegant BI

It used to be that a corporation or enterprise could dictate software and technology solutions and expect users and team members to fall in line. Whether the solution was user-friendly or supportive of an end-user’s role, the employee had no say in adopting and embracing the software and using it for everyday business analysis. Today, users play a very important role in informing the direction technology will take within an organization.

article thumbnail

Grow up! BI is a MUST!

Elegant BI

If your business is not using Business Intelligence to understand the market, customers and competition you are already behind! Click Here: [link].

article thumbnail

Dynamically Passing Parameters to a SQL Stored Procedure from PowerPivot Using VBA

BI Insight

In this post I express an easy way to refresh a PowerPivot model dynamically based on SQL Server Stored Procedures. Let’s start with SQL Server Management Studio (SSMS) 2012 and use Adventure Works 2012 database. Run the following script to see the results in SSMS: exec [dbo].[uspGetBillOfMaterials] 727, ‘2009-01-02’ First parameter: Start Product ID … Continue reading Dynamically Passing Parameters to a SQL Stored Procedure from PowerPivot Using VBA.

article thumbnail

BI and CRM – You’re Speaking Our Language

Elegant BI

Consultant David Loshen recently talked to SearchBusinessAnalytics about using BI to improve CRM. He said that self-service BI tools can “have a positive impact for business users — and businesses. A better understanding of customer behavior “can lead to more profitable or less risky business practices.” That makes a lot of sense to us!

article thumbnail

7 Strategies to Gather (and Actually Use) Competitive Intel from Employees

Leaders in competitive intel know that the employees who interact with customers and prospects every day hold valuable competitive insights that could help win sales. But they don’t have a good plan or system to gather, organize, and share these insights with the stakeholders who need them. In this eBook, we outline 7 strategies to make it easier to build and scale an employee sharing program that will drive competitive advantage.

article thumbnail

What’s the Buzz? Social Media and Business Intelligence Do Mix!

Elegant BI

Many organizations are struggling to find meaning in the social media market and to determine the value of social media marketing to customers. In fact, the enterprise that utilizes a business intelligence (BI) solution to slice and dice unstructured data from social network conversations, comments and activities can glean a lot of insight and make better business decisions regarding how and when to market to social media customers and to determine the success of its integrated internet marketin

article thumbnail

Picking the Right KPIs for Content Marketing Takes Thought

Elegant BI

It is important to measure – but you have to measure the right things. Metrics must ultimately tell the tale of business success or failure and drive you to stay the course or alter your path. Article Source: [link].

article thumbnail

The Story of Mr. Singh- Part Two: Business Intelligence Drives BPO (and Mr. Singh) Into the Future

Elegant BI

When last we saw Mr. Singh in (The Story of Mr. Singh – Part One: BPO Project Success Driven by Business Intelligence) , he had been transformed from an overwhelmed team leader to a hero. With the help of his friend, Raghav (an IT pro who worked in the same building) and a sophisticated, intuitive business intelligence solution, Mr. Singh helped his company to sign a lucrative contract with a client and managed to get himself a promotion in the bargain.

article thumbnail

Resolving Format Cells Change after Refreshing Data Sources in Power Query

BI Insight

In this post I want to share my experience with refreshing data in Power Query and the way it affects loaded data to an Excel worksheet. I was loading sales data from SQL Server and I noticed that there is no easy way to define a 1000 separator in Power Query. So I decided to … Continue reading Resolving Format Cells Change after Refreshing Data Sources in Power Query.

Sales 40
article thumbnail

How to Stay Competitive in the Evolving State of Martech

Marketing technology is essential for B2B marketers to stay competitive in a rapidly changing digital landscape — and with 53% of marketers experiencing legacy technology issues and limitations, they’re researching innovations to expand and refine their technology stacks. To help practitioners keep up with the rapidly evolving martech landscape, this special report will discuss: How practitioners are integrating technologies and systems to encourage information-sharing between departments and pr

article thumbnail

The Story of Mr. Singh – Part One: BPO Project Success Driven by Business Intelligence

Elegant BI

The coffee urn was nearly empty and the team was still knee-deep in problems. Mr. Singh was trying to export data from his CRM solution and other systems into an excel spreadsheet to create a report that would offer analytical insight into the performance of his team and its members. Mr. Singh was the leader of the largest team working on an all-important business process outsourcing (BPO) project, and he was in desperate need of concise, clear information.

article thumbnail

Don’t Chase Social Media Bot Phantoms! Use Business Intelligence to Focus on Real Customers/Markets

Elegant BI

Have you noticed that it is getting harder to tell the difference between human beings and bots? Bots are getting smarter and more sophisticated, and because they simulate human behavior, it is getting harder to tell the difference between bots and human beings. To complicate issues further, there are service providers who offer ‘pay-for-followers’ services to make it look like your business social media page has more fans and followers, e.g.

article thumbnail

BI Has Indeed Evolved

Elegant BI

Today’s users are more sophisticated and demand more personalized, affordable, integrated BI. The evolution of BI continues and you need to be part of it! Article Source: [link].

article thumbnail

Three Reasons to Explore Social Media Marketing Using Business Intelligence

Elegant BI

Today, the reach of social media is worldwide and crosses all generations. Every business analyst agrees that an enterprise has to include social media and internet marketing in its strategy, but the experts are still arguing over the possibility of measuring the success of marketing and sales strategies. Every enterprise understands the need to measure and manage results, and therefore some businesses are hesitant to dive into the deep end of the social media pool.

article thumbnail

Maximize Productivity and Simplify IT Management with Conversational AI

ChatGPT has dominated boardroom conversations for months now. From drafting a stock trading program, to creating a SQL query to model data, there are practically no limits to the applications of the AI language model assistant. At ManageEngine, we have been working on our own AI-assistant, Zia. Zia is a fully-trained analytics assistant that can perform a range of functions such as creating and adding reports to dashboards, providing conversational support to data analysis, insight discovery, bu