Where is your data now?
- Microsoft SQL server database
- MySQL or some other database
- Excel sheets
- CSV files
What reports do you need?
- Purchases/Sales
- Stock Control
- Quality
- Energy usage
- Automation Data
How can we help?
- Setup data connections between excel sheets and databases
- Create advanced pivot tables
- Build queries and stored procedures in SQL for data analysis
- Build SSRS reports and automatically email them to managers on a schedule
- Build SSIS projects to extract, transform and load data from multiple sources
- Build SSAS cubes for self service reporting
- Setup Microsoft Power BI and build dashboards and reports
Microsoft SQL Server Standard Edition comes with three powerful tools to help businesses manage their data.
- SSRS: SQL SERVER REPORTING SERVICES: Commonly used by small businesses to automate reporting.
- SSIS: SQL SERVER INTEGRATION SERVICES: This is a powerful data manipulation tool rarely used by small businesses
- SSAS: SQL SERVER ANALYSIS SERVICES: This is another feature of SQL ignored by small business data providers, it can help reduce the load and increase the speed of your ‘live’ database, and , allow staff to create their own custom reports.
Microsoft Excel has powerful Pivot Tables and Graphs to help managers make sense of large tables of data
- Pivot tables are not used by many small companies who do not realise their power
- Pivot tables do require some training and set up but will make your excel users much more productive
- Pivot Tables Summarise your data
- Graph your data and easily visualise trends and outliers
Power BI
- Setup is much more advanced than excel pivot tables
- Best used where large complex datasets need shared management and reporting dashboards
- The free licence is of very limited use and one would be better off focusing on Excel
- Small organisations will have to purchase a Pro licence for each user costing about €120 per user per annum
- Microsoft are developing Power Bi and updating it’s features regularly
- “>