Data analysis, Visualizations, and Transformations

Don’t limit yourself to the current way you look at your data. Get an outside perspective and some help creating new and interesting views into your data.

The outcome of many data projects is data analysis. Even the software that supports the day to day workflow of individuals will eventually be analyzed. It’s important to optimize the initial data around the collection and active use of the data to support the users. However, you can always then take that data and optimize it for analysis and correlation with other data.

Formulas and data manipulation processes can be created that look at your existing data and break it down or combine different data sets to produce new data that can be provided to utilities for visualizations or other types of analysis. Formulas with complicated logic and data aggregations can be created to produce new datasets. Procedures can be created to move data around and structure it so it’s easy for anyone to view or manipulate.

There are many different tools to help you analyze your data. When it comes to analyzing data, people use the tools they are comfortable with. A good database person will empower them by providing the data in a format the analyst can easily utilize. Many people these days want their data extracted into a nice grid format so they can put the data in Excel and use PowerPivot or even just the regular charting and analysis tools that are so easy to use within Excel. Other people need those reports online and with the latest data.

Check out a couple of data transformation narratives: