{"id":2,"date":"2023-02-21T15:37:10","date_gmt":"2023-02-21T15:37:10","guid":{"rendered":"https:\/\/tekbere.ie\/?page_id=2"},"modified":"2024-03-27T16:40:39","modified_gmt":"2024-03-27T16:40:39","slug":"sample-page","status":"publish","type":"page","link":"https:\/\/tekbere.ie\/","title":{"rendered":"About us"},"content":{"rendered":"<p><strong>Where is your data now?<\/strong><\/p>\n<ul>\n<li>Microsoft SQL server database<\/li>\n<li>MySQL or some other database<\/li>\n<li>Excel sheets<\/li>\n<li>CSV files<\/li>\n<\/ul>\n<p><strong>What reports do you need?<\/strong><\/p>\n<ul>\n<li>Purchases\/Sales<\/li>\n<li>Stock Control<\/li>\n<li>Quality<\/li>\n<li>Energy usage<\/li>\n<li>Automation Data<\/li>\n<\/ul>\n<p><strong>How can we help?<\/strong><\/p>\n<ul>\n<li>Setup data connections between excel sheets and databases<\/li>\n<li>Create advanced pivot tables<\/li>\n<li>Build queries and stored procedures in SQL for data analysis<\/li>\n<li>Build SSRS reports and automatically email them to managers on a schedule<\/li>\n<li>Build SSIS projects to extract, transform and load data from multiple sources<\/li>\n<li>Build SSAS cubes for self service reporting<\/li>\n<li>Setup Microsoft Power BI and build dashboards and reports<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Microsoft SQL Server Standard Edition comes with three powerful tools to help businesses manage their data.\u00a0<\/strong><\/p>\n<ol>\n<li><strong>SSRS:<\/strong> SQL SERVER REPORTING SERVICES: Commonly used by small businesses to automate reporting.<\/li>\n<li><strong>SSIS:<\/strong> SQL SERVER INTEGRATION SERVICES: This is a powerful data manipulation tool rarely used by small businesses<\/li>\n<li><strong>SSAS:<\/strong> 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 &#8216;live&#8217; database,\u00a0 and , allow staff to create their own custom reports.<\/li>\n<\/ol>\n<p><strong>Microsoft Excel has powerful Pivot Tables and Graphs to help managers make sense of large tables of data<\/strong><\/p>\n<ol>\n<li>Pivot tables are not used by many small companies who do not realise their power<\/li>\n<li>Pivot tables do require some training and set up but will make your excel users much more productive<\/li>\n<li>Pivot Tables Summarise your data<\/li>\n<li>Graph your data and easily visualise trends and outliers<\/li>\n<\/ol>\n<p><strong>Power BI<\/strong><\/p>\n<ol>\n<li>Setup is much more advanced than excel pivot tables<\/li>\n<li>Best used where large complex datasets need shared management and reporting dashboards<\/li>\n<li>The free licence is of very limited use and one would be better off focusing on Excel<\/li>\n<li>Small organisations will have to purchase a Pro licence for each user costing about \u20ac120 per user per annum<\/li>\n<li>Microsoft are developing Power Bi and updating it&#8217;s features regularly<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ol>&#8220;&gt;<\/ol>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"template-frontpage.php","meta":{"footnotes":""},"class_list":["post-2","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/tekbere.ie\/index.php?rest_route=\/wp\/v2\/pages\/2","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tekbere.ie\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tekbere.ie\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tekbere.ie\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tekbere.ie\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2"}],"version-history":[{"count":11,"href":"https:\/\/tekbere.ie\/index.php?rest_route=\/wp\/v2\/pages\/2\/revisions"}],"predecessor-version":[{"id":88,"href":"https:\/\/tekbere.ie\/index.php?rest_route=\/wp\/v2\/pages\/2\/revisions\/88"}],"wp:attachment":[{"href":"https:\/\/tekbere.ie\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}