Finding and Exploring Data

“Those who can’t find the data are doomed to recreate it.” That may not be quite the quote we all remember but it describes a common situation in organizations with increasing amounts of data in a range of formats. If no one can find an existing data set – how can they be expected to […]

Read More

Financial Reporting data engineering principles

Financial reporting is a critical function for almost every organization. A small number of documents must accurately represent a financial picture of that organization. Over the last twenty years Perkins Consulting has worked on financial reporting with clients of all sizes and industries. We believe that by following a core set of principles in storing […]

Read More

Five best practices for Power BI data engineering

After working extensively with Power BI here are some of our best practices for data engineering in order to get the most from the application. These practices are intended to make creating and maintaining a Power BI environment as efficient and effective as possible. Think carefully about where you do data transformations or calculations. Are […]

Read More

Power BI licensing analysis

With announcements made in early May 2017 Microsoft is changing the licensing picture for Power BI considerably. As a Microsoft Power BI and Data Analytics partner we wanted to provide an early analysis of the impacts. In our webinar last fall we pointed out many of the unique aspects of the Power BI service and […]

Read More

Getting the reporting and analytics engine humming

Organizations are often investing in areas that don’t do much to improve the efficiency or effectiveness of their reporting and analytics efforts. The assumption has been that working actively with Business Intelligence (BI) tools in report development is where the bulk of the effort occurs. Therefore investing heavily in the latest report and analysis development tools would seem to […]

Read More

Data for everyone!

Sharing data with large numbers of external users is generally difficult and expensive. Many organizations would like to share more regularly updated data and invite more collaboration with large groups of people who are not their employees. Customers Vendors or suppliers Members of a not for profit organization Part-time or contract employees The public This […]

Read More

Finding the data you need

Ever lose your car keys? I don’t mean really lose, I mean lose somewhere in your home. You know they are there and you will find them eventually, but not after a frustrating and time consuming search. You try to back track your last memory of the keys, ransacking your home, and mentally kicking yourself […]

Read More

The easiest and most truthful business data

In going about our everyday work lives we all throw off data just like a cloud of dust. When we swipe our badge to enter our office, send an email or pick up the phone we leave a data record. Looking at this data at an individual level isn’t very useful. Does knowing that Sally […]

Read More

The Goddess of Data

When I interviewed the goddess of data it was obvious she had a lot of talents. She understood data structures, databases, programming, reporting tools and more. She understood the business and was a great communicator. Everyone knew her and she could often point someone to the right data set with a thirty-second hallway conversation. Everyone […]

Read More

Forecasting Sales for $10 per Month

The price and capability of analytics and statistical tools has changed dramatically in the last few years. An excellent example is a predictive model to forecast sales for a multi-location, multi-department retailer. A few years ago this would have required thousands of dollars of software and high-end hardware. Now the open-source R statistical language can […]

Read More