Trucking and logistics companies often build custom reports with off-the-shelf tools such as Crystal Reports or spreadsheets that pull in data from operations or accounting databases. The more advanced spreadsheet users can change the presentation of data with pivot tables, but they are still limited by this static, one-dimensional reporting platform.
Furthermore, what good is a customized report that was built for a specific purpose when, two weeks later, the business environment changes? New problems require a platform that lets you ask new questions and get immediate answers.
Business intelligence (BI) can provide the missing link to this reporting dilemma. BI can provide businesses with quick, responsive, and intuitive research tools. The technology lets you view and analyze data across an enterprise in multiple perspectives and dimensions.
To apply the latest BI tools to the trucking industry, Don Prentice recently developed a new service offering for McLeod Software called the Business Intelligence Framework. At McLeod Software’s headquarters in Birmingham, Ala., Prentice will begin teaching a three-day, hands-on class for clients – including “non-techies,” starting the week of November 3, 2008.
The class teaches McLeod Software clients how to use the Microsoft Business Intelligence Toolset and SQL Server 2005 to synergize data from all of their information systems, not just the McLeod products they use.
“We want to give clients the ability to observe their data from different perspectives to ensure that they are making good and profitable decisions,”says Prentice, database administrator for McLeod Software.
Attendees will learn how to build the integration necessary to pull data from the McLeod product suite and any other OBDC-compliant data sources into one or more “data marts.” A data mart is a separate database that contains pre-processed information from multiple data sources. Companies create data marts specifically for different user groups in their organization, such as finance or operations.
