Data Management, ...
Follow
Find
937 views | +0 today
Your new post is loading...
Your new post is loading...
Rescooped by Oz du Soleil from FrankensTeam's Excel Collection
Scoop.it!

Valentine's day - tell your love with Excel :-)

Valentine's day - tell your love with Excel :-) | Data Management, Data Quality | Scoop.it
formule excel formattazione condizionale convalida formule matriciali

Via Kris
more...
Kris's curator insight, February 14, 2013 3:10 AM

Tell with a number! :-)

Rescooped by Oz du Soleil from Data Quality, Data Cleansing
Scoop.it!

Ten Reasons Why Your Data May Be Dirty | Data Integration Blog

Ten Reasons Why Your Data May Be Dirty | Data Integration Blog | Data Management, Data Quality | Scoop.it

 

Data Quality's importance can't be understated. Data Quality can only be taken as a central part of any organization's approach to data coming in and being produced by the organization's knowledge workers. This article gives a good overview of the ways in which an organization can fail to succeed in Data Quality.


Via Ralph Poole
more...
Fiona MacDonald's curator insight, October 18, 2013 9:40 AM

Yes, data quality is not taken as seriously as it may have once been. Probably because the ownership of the source data is more distributed among people, geographies and applications. Who or what can you hold accountable to poor data quality when the data has so many sources?

Rescooped by Oz du Soleil from FrankensTeam's Excel Collection
Scoop.it!

Facts about subtotal formula - visible and hidden cells - E90E50 fx

Facts about subtotal formula - visible and hidden cells - E90E50 fx | Data Management, Data Quality | Scoop.it
formule excel formattazione condizionale convalida formule matriciali

Via Kris
more...
Kris's curator insight, February 4, 2013 3:40 AM

Some things to remember when using SUBTOTAL formula.

Scooped by Oz du Soleil
Scoop.it!

AllAnalytics - Meta S. Brown - Better Writing for Data Analysts

AllAnalytics - Meta S. Brown - Better Writing for Data Analysts | Data Management, Data Quality | Scoop.it
Persuasive writing is a survival skill for data analysts.
more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Excel Dashboards for Simpler Data Entry & Analysis - Data Management | DataScopic

Excel Dashboards for Simpler Data Entry & Analysis - Data Management | DataScopic | Data Management, Data Quality | Scoop.it
Excel Dashboards are good visual summaries but there are 2 tangential benefits: they simplify data entry and ad hoc reporting.
more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

How can I make Excel display Roman numerals? - ComputerActive.co.uk

How can I make Excel display Roman numerals? - ComputerActive.co.uk | Data Management, Data Quality | Scoop.it
ComputerActive.co.uk
How can I make Excel display Roman numerals?
ComputerActive.co.uk
Q I read John Tanner's question about Excel date formats with interest.
more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Fundata Weather Forecast and Conditions - weather.com

Fundata Weather Forecast and Conditions - weather.com | Data Management, Data Quality | Scoop.it
Get today's forecast, maps and more from weather.com.
Oz du Soleil's insight:

I googled "fun data" and discovered a city in Romania. 

Tomorrow's forecast: 30F and snow.

more...
No comment yet.
Rescooped by Oz du Soleil from Social Networking Marketing Strategy
Scoop.it!

How to Avoid Personal Information Harvesting Online | Social Networking Marketing Stress Buster

How to Avoid Personal Information Harvesting Online | Social Networking Marketing Stress Buster | Data Management, Data Quality | Scoop.it
How to Avoid Personal Information Harvesting Online

Via Andrew Nathan
Oz du Soleil's insight:

This is getting harder to avoid as entities like Google and Gavatar tie our activity together.

 

This became an issue when I was running a nonprofit and posted a bourbon review on a bourbon website. Suddenly the photo of me and my contact info tied to the nonprofit showed up.

 

I hurried to take the review down and figure out how to untie the nonprofit as my default persona.

more...
Andrew Nathan's curator insight, January 16, 2013 4:47 PM

great guest post about avoiding personal information harvesting.

Rescooped by Oz du Soleil from FrankensTeam's Excel Collection
Scoop.it!

Collecting Application.International settings - E90E50

Collecting Application.International settings - E90E50 | Data Management, Data Quality | Scoop.it

The aim of our project is to collect and publish the list of regional settings used in different language Excel versions.


Via Kris
more...
No comment yet.
Rescooped by Oz du Soleil from FrankensTeam's Excel Collection
Scoop.it!

Collecting Application.International settings - E90E50

Collecting Application.International settings - E90E50 | Data Management, Data Quality | Scoop.it

The aim of our project is to collect and publish the list of regional settings used in different language Excel versions.


Via Kris
more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Six Must-know Tips on Marketing Data Quality that Every B2B Marketer Should Apply

Six Must-know Tips on Marketing Data Quality that Every B2B Marketer Should Apply | Data Management, Data Quality | Scoop.it

Regardless of whether you’re running a multi-channel campaign or a single-platform project, your marketing efforts’ success depends, to a large extent, on the quality of data at your disposal. Nowadays, more than ever, B2B marketers rely on data stored in such formats as a targeted cold calling list, email/mailing list, marketing/sales contact database, and sophisticated CRM database. Social media also has greatly contributed to the data supply and demand situation as business insights become increasingly tied to customers’, vendors’,employees’, and competitors’ information online.

 

However, despite the growing focus on data-drivenmarketing campaigns, a lot of companies are still struggling in terms of having sound data quality programs. According to Forrester, only 12% of companies base key business activities on intelligence provided by quality data. This leads to considerable inefficiencies which the Gartner Group estimates cost the average firm about $8.2 million each year.

 

While you may think that these figures may not be readily applicable to your marketing campaigns, the fact that poor data quality leads to wasted resources is reason enough for you to start considering (or reconsidering) your approach to marketing data quality. Here are six key tips to help you begin your evaluation:

1. Adopt a data management plan. Pull your company out of the 88% that haven’t yet seriously considered the need to systematically approach managing business and marketing-related data. Outline the set of specific procedures and guidelines you need to follow in order to ensure high data quality in your contact database, calling list, email list, and other marketing databanks from acquisition/development to maintenance/updating.2. Cleanse databases regularly. As much as 78% of B2B marketers say they update and clean up their database at most three times annually. However, superficial database cleansing can only take your marketing efficiency so far. A more thorough database cleanup approach requires analyzing the whole process of marketing data acquisition, storage/removal, and retrieval in order to find flaws in the system that cause deterioration of data quality.3. Involve both sales & marketing. When developing a strategy to address marketing data management issues, it’s more productive to actively involve both your marketing team and sales staff in the brainstorming process. There has to be some common grounds to work from when it comes to managing marketing databases. In this regard, the inputs from sales are just as important as those from marketing.4. Collaborate across departments. Aside from aligning marketing and sales in the data management process, there also has to be close collaboration between various departments, notably IT and those that handle supplier, employee, partner, and other company information. Oftentimes, marketing also relies on the quality of information from these internal sources.5. Consolidate data housing. Common data housing practices call for data to be incorporated only into the system where they originate or are typically used. With consolidation, data is made compatible and available to other systems in the company. Consolidation doesn’t contradict segmentation. In fact, it enhances calling list or email list segmentation by expanding the possible criteria set.6. Monitor relevant metrics. The analytics used to gauge data quality and its impact on the marketing campaign are as varied as the number of databases involved. In order to see past the blur of countless metrics, it’s best to match these with data sources and purposes and start from there.

 

At first glance, the above points may seem to require a lot of work. However, the payoff in terms of optimizing your marketing processes is worth more than the time and resources you put in.

Oz du Soleil's insight:

Great, detailed article. Marketers really need to pay attention to this. Marketers rely on data but often their data collection and data stewardship are lacking.

 

This is a good, detailed read.

 

more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Data quality issues get worse when ignored

Despite the growing number of companies that are investing in big data plans, approximately half of businesses do not have a clear data quality strategy, according to Information Management.
Oz du Soleil's insight:

I ged paid to clean up the big messes that have been ignored for a long time. But seriously, I would rather businesses avoid the consequenses of crap data. Not just paying for clean-up, there can be lawsuits, and just the embarassment of sending mail out to "Mr. Ann Williams."

 

2013 is the Year of Clean Data. Join the effort!

more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Microsoft's Excel Might Be The Most Dangerous Software On The Planet - Forbes

Microsoft's Excel Might Be The Most Dangerous Software On The Planet - Forbes | Data Management, Data Quality | Scoop.it
No, really, it's possible that Microsoft's Excel is the most dangerous software on the planet.
Oz du Soleil's insight:

Great article praising the strengths of Excel and warning about its strengths can also be weaknesses.

more...
No comment yet.
Rescooped by Oz du Soleil from Excel Easy
Scoop.it!

Excel Blog - Need to combine two chart types? Create a combo chart and add a second axis

Excel Blog - Need to combine two chart types? Create a combo chart and add a second axis | Data Management, Data Quality | Scoop.it
Need to combine two chart types? Create a combo chart and add a second axis: This post is brought to you by Robi... http://t.co/gnNqjIWy

Via Roger Fisher
more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Excel & the Clouds: Cirrus, Thunder & Mushroom | DataScopic

Excel & the Clouds: Cirrus, Thunder & Mushroom | DataScopic | Data Management, Data Quality | Scoop.it
Getting Excel embedded in a web page, living in the almighty cloud is a major challenge, and isn't necessarily a good idea. Let's discuss
Oz du Soleil's insight:

Think about this before bringing your buiness data and apps online. Your "cloud" could go from cirrus to mushroom in short order. I explore this via my research to bring Excel apps online.

 

The internet can be more collaborative, but a desktop app can be more stable. What do you think?

more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Excel Dashboard: 4 Quick Notes - Data Management Chicago | DataScopic

Excel Dashboard: 4 Quick Notes - Data Management Chicago | DataScopic | Data Management, Data Quality | Scoop.it
Excel dashboards and reports give us a peek inside massive data sets. Today we look at a summary of 9317 cells and some weaknesses in our dashboard.
Oz du Soleil's insight:

Quick glimpse into an Excel Dashboard. Is it clean and useful? Are there internal checks for trustworthiness? Are the graphics easy to interpret?

more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Reporting for Microsoft DynamicsStrengths and Weaknesses of Excel Web Services

Reporting for Microsoft DynamicsStrengths and Weaknesses of Excel Web Services | Data Management, Data Quality | Scoop.it
Excel Services in Microsoft SharePoint Server is a shared service that you can use to publish Microsoft Excel workbooks on SharePoint Server. We use Excel Web Services for BI4Dynamics On-Line Demo that is our experience.Strengths,Weaknesses,Features.
more...
Tim Cleveland - MBA's curator insight, August 21, 2013 10:21 PM

We use this feature of SharePoint on a regular basis to provide BI and reporting.  This is one of those features few people know about.  Data can be collected in SharePoint lists, exported to Excel, data connections are created automatically, and refreshing of the data is done through "refresh all".  This creates a 360 degree relationship between the source data, analysis, and display of the same information back into SharePoint.  Keep an eye on your server memory as low memory will cause loading issues.  

Scooped by Oz du Soleil
Scoop.it!

Fundata - Wikipedia, the free encyclopedia

Fundata (German: Fundatten; Hungarian: Fundáta) is a commune in Braşov County, Romania, in the historic region of Transylvania. It is composed of three villages: Fundata, Fundăţica (Kleinkertzberg; Kisfundáta) and Şirnea (Schirnen; Sirnea).

Surrounded by the Bucegi Mountains and the Piatra Craiului Mountains, Fundata's altitude of 1360 m makes it the highest commune in Romania. Şirnea was first attested in 1729, and Fundata in 1732.[2] It lies on the southern border of Braşov County, with Argeş County on the other side, in the middle of the Rucăr-Bran Pass, along European route E574. It is 42 km from Braşov and 26 km from Râşnov.[3] In August 1916, when troops from the Romanian Old Kingdom entered Austria-Hungary, the first village they took was Fundata, also capturing their first prisoners there and suffering their first battle death.[4]

A traditional lifestyle of herding sheep and cows is preserved, augmented by tourism. Indeed, Şirnea was declared the country's first tourist village in 1968. Aside from the mountainous scenery, attractions in Fundata include a wooden Romanian Orthodox church (1830) and one of stone (1939-1943); in Şirnea, there is a church from 1893-1894 as well as an ethnographic museum.[2] There is an annual festival held around July 20, feast of the prophet Elijah, called Nedeia Munţilor ("Mountain Celebration"). Originally a "feast of two countries" (Transylvania and Wallachia), it was revived in 1969, and features folklore displays as well as local cheeses and meats.[5][6]

Oz du Soleil's insight:

Well okay ... Fundata

more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Data Quality & User Overrides: Shut Up and Take My Money ...

Data Quality & User Overrides: Shut Up and Take My Money ... | Data Management, Data Quality | Scoop.it
Last Tuesday a data quality vendor put out a blog post Companies need to be educated on data quality that essentially said that companies need to be educated.
Oz du Soleil's insight:

Excellent article about Data Quality quickly diminishing based on some simple things that "someone" could have handled.

 

I think that Data Management is often something that falls through the cracks as we focus on what we're officially in charge of. Data Quality/Management is regularly assigned to no one. So, in Stephen's example: WHO was responsible for changing the zip code ... probably nobody. And sometimes it's a mystery as to who has the power to physicially make the change.

 

Folks, let's gt on top of our data and make Data Stewardship a priority.

more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Perfect Data and Other Data Quality Myths

Perfect Data and Other Data Quality Myths | Data Management, Data Quality | Scoop.it
We need to understand the variance between the data as it exists and its acceptability, not its perfection
Oz du Soleil's insight:

Data Quality is data that's fit for purpose.

more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Generate Data Using Excel: RAND & RANDBETWEEN - Chicago | DataScopic

Generate Data Using Excel: RAND & RANDBETWEEN - Chicago | DataScopic | Data Management, Data Quality | Scoop.it
Here is a behind-the-scenes peek at how to generate data to prep tutorials or test solutions for a client. We use: RAND, RANDBETWEEN & date formatting.
Oz du Soleil's insight:

Why create Dummy Data?

One HUGE reason: you need help with a formula, spreadsheet layout or a macro but your data set is too sensitive to email to someone to get help.

 

Generate a set of fake data and email that. The actual data doesn't matter. The solution, help and efficiency are what matter.

more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Industry standards are a waste of your time - Christopher S. Penn : Awaken Your Superhero

Industry standards are a waste of your time - Christopher S. Penn : Awaken Your Superhero | Data Management, Data Quality | Scoop.it
One of the most asked questions I get is about industry standards. "How do we compare for likes, retweets, email open rates, website visitors, and every other marketing metric versus industry standards?
Oz du Soleil's insight:

Good Data Management means knowing what works for your business. Industry standards may be a good place to start but when we get down to the nitty gritty, your data should be about you--not the industry and nothe competirors.

 

Chris Penn does and excellent job of explaining why.

more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

The Seven Habits of Highly Effective Data Quality » The Data Quality Chronicle

The Seven Habits of Highly Effective Data Quality » The Data Quality Chronicle | Data Management, Data Quality | Scoop.it
Oz du Soleil's insight:

2013: the Year of Clean Data

 

more...
No comment yet.
Scooped by Oz du Soleil
Scoop.it!

Data Governance & The Data Boss! - Data Management Chicago | DataScopic

Data Governance & The Data Boss! - Data Management Chicago | DataScopic | Data Management, Data Quality | Scoop.it
True Data Governance can only happen when there's a Data Boss monitoring the data quality, business rules and data reporting.
Oz du Soleil's insight:

Who is the Data Boss: That person with the greatest intimacy with a dataset and the consequences. The Data Boss is empowered to set and modify policies that impact data quality and data flow.

 

 

more...
No comment yet.