BI Insight

SEPTEMBER 21, 2014

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.

130

130

ElegantJ BI

SEPTEMBER 19, 2014

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!

Data Visualization 130

Data Visualization Visualization Planning Business Intelligence 130

Domo

SEPTEMBER 30, 2014

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

Big Data 52

Big Data Business Intelligence Business Intelligence Digital 52

IAG Consulting

SEPTEMBER 15, 2014

This past week, The Project Management Institute released results of a study on one of our favorite topics – the importance of requirements. PMI’s Pulse of the Profession® In-Depth Report on Requirements Management will hopefully serve as a wakeup call and provide some strong justification to the many organizations who are searching for solutions to project and performance improvement.

Business Analysis 40

Business Analysis Business Analysis Project Management Agile 40

Advertiser: Paycor

Structured interview questions are a valuable tool for reducing bias in hiring. They help: Ensure all candidates are asked the same questions in the same way Level the playing field so all candidates have a fair chance of being successful Improve credibility, reliability, and validity Download the guide to get the most out of your interview questions!

ElegantJ BI

SEPTEMBER 19, 2014

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

Data Visualization 130

Data Visualization Visualization Planning Business Intelligence 130

ElegantJ BI

SEPTEMBER 17, 2014

There is no doubt that your customers want personalized, responsive, targeted service. You can provide that with business intelligence and analysis that ensures you can support your customers. Article Source: [link].

Business Intelligence 130

Business Intelligence Business Intelligence 130

ElegantJ BI

SEPTEMBER 15, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence Monitoring Retail 130

ElegantJ BI

SEPTEMBER 15, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence Monitoring Retail 130

ElegantJ BI

SEPTEMBER 15, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence Monitoring Retail 130

Advertisement

Explore our free guide to Valutico, the platform that revolutionizes automated report generation, offers access to 1 million M&A transactions, enables quick benchmarking, and streamlines the entire valuation process. With Valutico, you gain access to: 30-Minute Valuations: Rapidly producing accurate results. 3TB of Financial Data: The expansive data you need at your fingertips.

ElegantJ BI

SEPTEMBER 11, 2014

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.

130

130

ElegantJ BI

SEPTEMBER 11, 2014

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.

130

130

ElegantJ BI

SEPTEMBER 11, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence 130

ElegantJ BI

SEPTEMBER 11, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence 130

Advertiser: ZoomInfo

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

Innovation

ElegantJ BI

SEPTEMBER 10, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence Monitoring Planning 130

ElegantJ BI

SEPTEMBER 10, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence Monitoring Planning 130

ElegantJ BI

SEPTEMBER 10, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence Monitoring Planning 130

ElegantJ BI

SEPTEMBER 9, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence 130

Advertisement

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

ElegantJ BI

SEPTEMBER 9, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence 130

ElegantJ BI

SEPTEMBER 9, 2014

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

Business Intelligence 130

Business Intelligence Business Intelligence 130

BI Insight

SEPTEMBER 7, 2014

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.

130

130

ElegantJ BI

SEPTEMBER 3, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence Planning Data Mining 130

Advertiser: MoEngage

Use data to turn one-off holiday shoppers into repeat buyers and effortlessly drive more sales throughout the year. Our guide will give you an in-depth understanding of what triggers your customers to buy and breaks down campaign examples from leading B2C brands.

ElegantJ BI

SEPTEMBER 3, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence Planning Data Mining 130

ElegantJ BI

SEPTEMBER 2, 2014

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.

Business Intelligence 130

Business Intelligence Business Intelligence Monitoring Planning 130

ElegantJ BI

SEPTEMBER 1, 2014

Many businesses look at Business Intelligence (BI) as a standalone solution that provides information to help the company better its business results. But, business intelligence serves another very important purpose. Take a step back and look at BI in a different way and you will find that a business intelligence solution can encourage and improve collaboration among team members and employees.

Business Intelligence 130

Business Intelligence Business Intelligence Big Data 130

ElegantJ BI

SEPTEMBER 1, 2014

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!

Business Intelligence 130

Business Intelligence Business Intelligence 130

Advertisement

This article focuses on my experience starting as a customer service representative and working myself up to become a lead analyst in my organization. I did not start with many special skills or talents but I wanted to reflect on what did help me.