Everyone who uses data needs to know about Power BI. It can be used to so easily to visualise your data.
You can easily create Reports, Graphs, Charts and Map visuals.
Yet so few people know about it. Its one of the best products Microsoft have produced and its not expensive. Its easy to use and there are a lot of free training videos to help you learn.
In my example below its as simple as:-
1. Choose Visual
2. Choose data Table/Field
3. Select which records to show
Power BI Visual Example of Data
You can create a Report or a dashboard with one or lots of visuals. There are 4 in the photo below, namely a Graph, Chart, Map and Table. They all interact with each other so when you choose say a product type on the table, the Maps and Graphs automatically refresh to show data for just that product.
Power BI can connect to a number of database sources, including Microsoft SQL Server.
We highly recomend you look at this short 3 miniute video.
Read our report below about how you could save time, money and hassle by automating your spreadsheets.
Spreadsheet vs Database
Backing up SQL Server database/s.
SQL server databases installed on an in-house server are normally open 24/7. Because of this you need a backup tool that will back up the open database files. This is because a generic backup program will just ignore open files.
You can back up your database files by writing an SQL Query. However, if this is beyond your normal skill set, you can ask a database specialist such as Computerisation Ltd to this for you. Alternatively, you can choose from a number of tools that will back up your database/s properly.
Tools such as: –
Microsoft Management Studio: Will allow you to make complete or incremental backups by selecting the database then choosing a few menu options. Please note however that the free of charge ‘Express’ editions do not have the functionality to automate and schedule backups. Management Studio will create a backup copy file of the database. This file should then be copied to a safe location outside of the server. Click here for further information.
SQLBackupandFTP: Is a sensibly priced 3rd part program with an easy set up wizard. It will allow you to create scheduled backups. These will then be automatically compressed and optionally copied to a cloud server or FTP site. Click here For further information.
Many on-line backup services have an SQL server add-in to their client. However this may be a chargeable extra.
Personal Data Security
On May 25th 2018, the rules for holding personal data changed. The ICO (Information Commissioners Office) can now enforce tough new regulations. Personal data needs to be secure, up to date and fit for purpose.
Organisations and companies who fail to take action to guarantee data security, will risk substantial penalties and loss of reputation. Holding your personal data in a compliant database can be the most secure way of committing to the change in rules. Thereby demonstrating to the ICO when required, that you have plans and procedures in place to minimise any data breach.
Here at Computerisation Limited, we can help you manage your GDPR compliance processes.
If you are within a 50 mile radius of Cardiff, you are eligible for a free consultation with a member of our friendly team.
Call us today on 02920 712 664 or email Business.firstname.lastname@example.org for assistance. Alternatively click on the link below
Spreadsheets are easy to use but they are not the best tool for storing data.
Are you storing your company data in spreadsheets? Many businesses do. However they’re not always the answer and more often the problem!
Used appropriately, spreadsheets can play an important part in running a business. However, because they are easy to use, many companies use them as databases at the expense of efficiency.
Using a database like Microsoft SQL Server instead, has many advantages including:-
- Easier to share information – therefore saving time and money
- Faster & more reliable Data entry – reducing errors
- More efficient – freeing time for more productive use
- Less duplication – less room for error
- Better capacity – easy management of large volumes of data
- Enhanced security – peace of mind
- Easier reporting – all the information you need in one secure place
Spreadsheets – A big Hidden Cost
Many businesses are unaware of the hidden cost of spreadsheets. Moreover a bespoke database system with automated processing and management reports can provide the required information for a fraction of the cost.
For further information, and our white paper – click here