Category Archives for "Excel Data Intelligence"

0 Excel Data Intelligence and Visualization Ninja

In recent years most businesses have started to take business analysis to the next level by adopting various data visualization and analytics solutions, methodologies and technologies. Solutions like Tableau, PowerBI, SSRS, InetSoft and QlikView, to mention only a few, are widely used as data visualization tools.

However, many businesses struggle with these solutions because it either becomes costly or because they simply do not have the people with the necessary skills in-house to implement these solutions effectively.

From my own experience most of these products have impressive capabilities, however the learning curve is steep. You see companies send their employees out on a 2-5-day course to learn these tools hands-on. However, so much information is conveyed, and people need to digest it. They do some quick exercises based on ideal demo data and they get a certificate for successfully completing the course and once they return to their post at work, guess what? …

Continue reading

0 7 reasons why Excel is great for database data bulk editing

Excel spreadsheets facilitate the overall bigger picture of the data on hand, all in one familiar sheet, and gives the user “data situational awareness”. Therefore it is easier for the user to make data cleaning and standardizing easier because the user can consider all the data in the same context.

It enables the data project owner to share spreadsheets with other individuals, in different departments, to review and edit the data in familiar Excel within their specific area of focus and data knowledge, without having to be logged into a specific software program.

Enables separation of data cleanup work from specific software program user login sessions.

The Excel approach eliminates multiple GUI steps to view, edit or add data.

Excel makes it easier to do data batch validation before actually posting data back, or inserting new data into database.

The use of copies of an Excel file for before and after serves as a simple archiving and backup solution of original data and data revisions. It adds a lot of flexibility.

Makes it easy to copy data from source to destination databases.

Flexibility and versatility of Excel functions for ad hoc data sort, filter, find and replace, cut or copy and paste, Excel data validation features, the sky is the limit!