Data Management, ...
Follow
Find tag "datascopic"
885 views | +2 today
Your new post is loading...
Your new post is loading...
Scooped by Oz du Soleil
Scoop.it!

The Importance of Keeping Spreadsheet Data In One Place

(NOTE: the features in this video are not available to Mac users or PC users with Excel 2003 or 2007) A common blunder in spreadsheet development is the sepa...
Oz du Soleil's insight:

this video is primarily about the benefits of keeping your data in one place. However, you also get to see many Excel functions and features used together to build a simple dashboard and do some analysis. You'll see:

 

VLOOKUP

Tables

Pivot Chart

SUMIFS

Pivot Tables

Slicers

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

Nonprofit Fundraising: Tracking the Details - Excel & Data Training Chicago | DataScopic

Nonprofit Fundraising: Tracking the Details - Excel & Data Training Chicago | DataScopic | Data Management, Data Quality | Scoop.it
Let's look at data that we can track to determine the success of nonprofit fundraising activities. What can we learn about our constituents and our efforts?
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!

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!

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!

Holy [expletive!]: Embedded Excel Dashboard with ExcelWebApp - Excel & Data Training Chicago | DataScopic

Holy [expletive!]: Embedded Excel Dashboard with ExcelWebApp - Excel & Data Training Chicago | DataScopic | Data Management, Data Quality | Scoop.it
Today's shocker! Through ExcelWebApp a dashboard can be embedded in a web page with the interactivity of slicers and pivot charts. Come over and play!
Oz du Soleil's insight:

OMG! An interactive Excel dashboard embedded in a webpage. Imagine the possibilities!

 

Self-serve reports that people can crunch without having access to the source data. And no subscription to pay or worry that some 3rd-party app isn't going to play nice with Excel.

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

What Does It Cost To Clean My Data? (Capturing Cerberus) - Excel & Data Training Chicago | DataScopic

What Does It Cost To Clean My Data? (Capturing Cerberus) - Excel & Data Training Chicago | DataScopic | Data Management, Data Quality | Scoop.it
Our data's a mess! What's the cost of data cleansing? A lot! And few people are both skilled at it and want to do it. It's like Kidnapping Cerberus.
Oz du Soleil's insight:

Data cleaning is expensive and akin to capturing Cerberus. It's best--especially for small businesses to practice good Data Management before they're face with the expense of a massive data clean-up.

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!

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.