Make analyzing heterogenous data easy!
These days it’s difficult to imagine an organization that doesn’t analyze operational data when making managerial decisions. In order to make reading the results of these analyses easier, they tend to focus on how the data is visualized. However, visualization is not the most important factor in determining the value of the results - the integrity and accuracy of the analyzed information are. An effective operational data collection, testing, and consolidation process (often referred to as ETL – Extraction, Transformation, Loading) is necessary for quality business analytics. In order to automate the process of preparing source data for analysis, we present Sales Data Loader.
Preparing Heterogenous Data for Analytics
Sales Data Loader is an ASP.NET 5 web application that can be installed on the Internet or on a Microsoft IIS server on a local network. It works with any version of Microsoft SQL Server supported by Microsoft, and all the user needs to access it is a web browser.
Sales Data Loader lets you use nothing more than Microsoft Excel files that your analysts are used to at every stage of the ETL process. You don’t need access to the SQL server or admin privileges. All users interact with the SQL server using the ETL loader web portal. Since the Sales Data Loader works with AD/Azure AD your users are automatically authorized. Their access level is determined based on membership in local groups on the Windows server that the portal’s IIS server is installed on. All changes to the loading and setup process are done by uploading and downloading Microsoft Excel files.