Paul Bosetti Strategy and Analytics

Analytics and Business Intelligence

One of your companies most valuable resources is the information locked away within your systems. I can help you quickly and accurately develop insights into your operations by exploring customer segmentation, product analysis, inventory rationalization, receivable and payable intelligence, sales trends, and much more.

Businesses today are exploding with data.  Data repositories are siloed throughout corporations. Some companies have built competitive advantages on their ability to collect, cleanse and analyze data, you can too.  I can help you transform the technology of data analysis in your company from a support tool into a strategic weapon.  Contact me to learn more.

Analytics & BI

Look beyond your own internal data when conducting detailed Analysis or using a Business Intelligence dashboard. Many companies too narrowly focus on internalizing their analysis and often do not include external forces which impact their operations.   Examples of external forces to aligning your information with are:

  • Competitor products
  • Supplier influences
  • Pricing indexes
  • Substitute products

Business Intelligence dashboards were once considered a luxury and only available to companies that had operating budgets to support large investments. Intelligence and Analysis are no longer luxuries, but necessities required to help you understand how your internal operations compare to and are affected by external forces and allow you to add information as a strategic weapon to your arsenal.  New technologies for BI and Analysis and are now within reach of anyone for a fraction of the investment that was once required. Data and information are exploding at a neck braking pace and if used properly can add a strategic weapon to your arsenal.

What information do you need – There are many straight forward steps to properly set up a BI and Analysis process for your company.  First you need to determine what information you need and then explore possible sources of that information. Ask yourself, what I expect to achieve through this endeavor. You also need to determine the interrelation between your data that will allow for efficient and straight forward analysis. The interrelationship between data can be achieved by a process known as dimensioning your data sources. For instance, your product part numbers would be in your sales files, and invoice files; you can link your product codes up to product classes and then relate your product classes to your sales budgets to easily explore relationships within you systems.

How will you explore your information – What tools will you use to explore your data and act upon it?  How will you disseminate your findings so the proper people can quickly act upon it?  In the beginning keep it straight forward and do not over complicate the process of dissemination.

Where will the information come from and go – You must make sure the data is cleansed and will provide you with intelligent information you require.  Then create a repository for you information, this could be as simple as an excel spreadsheet, a small access database, or even as complicated as a large SQL database.  Start small to achieve quick home runs and then build out your strategy, this will allow you to not only start with a modes investment of time and money and then build upon your success through time.  Do not start with a massive project that tries to link everything together, but begin with a strategy with the end in mind.  Large complicated projects have a higher failure rate than a more focused approach.

When and how often will you update your information – Information can become stagnant;  make sure a process is set up to allow for easy updates to your data.  Keep the end in mind, but continuously revisit your BI and analysis strategy to ensure the processes and stake holders are properly aligned.

There have been many books written around BI, Data Warehousing, and Analysis.  If you combine a solid product such as Tableau, with the visual presentation skills defined by Stephen Few, and a solid warehousing process developed by Ralph Kimball the end result will be nothing short of success.   These steps shown above are just a sampling of the efforts you must go through, but with a solid understanding of the 4 elements defined above you will be able to define your own BI and analysis strategy.  If you need help or require additional information please contact me.


Free Tools

Explore these free tools which hopefully will make your life a little easier.