Entries by Optimus Information

Power BI for Office 365

How can you integrate Power BI for Office 365? If you’re like many folks in today’s business world, there’s a good chance you’re already using Microsoft’s Office 365 software suite. You may even already feel like you have a fairly data-centric approach to using Office, especially if your company is a heavy Excel user. Putting […]

Steps to Getting Good BI Requirements

What are the steps needed to get good BI requirements? Half the battle for many projects is getting started. BI projects are no different in that respect. A critical phase in realizing your BI project vision is developing thorough project requirements in clear, crisp, implementable and measurable terms. The temptation is to rush this phase, […]

How SSIS Fits into an ETL Process

MicrosoftSQL Server Integration Services – SSIS – is a common solution for many organizations’ data management requirements with regard to their Business Intelligence systems. Specifically, SSIS and SQL Server together streamline Extract, Transform and Load – ETL – operations on data warehouses. The process is essential to providing efficient, accessible data flows to BI system […]

BI: Difference Between Cloud and On-premise

What are the differences between Cloud and On-premise? The model for how companies acquire and field software for business intelligence purposes has changed dramatically in the last five years. One major factor driving this change has been the emergence of cloud-based computing options and software as a service. Modern operations are increasingly comfortable having large […]

Best Practices for Successful Business Intelligence

Few, if any, companies doubt a successful Business Intelligence value to their internal and customer-facing operations and the crucial role it plays in making accurate, lightning-fast tactical and strategic decisions that affect the business’ competitive position. The difficult bit is ensuring that Business Intelligence’s deployment in your company is fetching the best data, crunching it […]

What is Business Intelligence?

What is Business Intelligence? Modern companies are compiling a huge amount of data on a daily basis. Answering the question of what to do with all this information is the domain of business intelligence. BI covers a large range of functions within a firm; including everything from database compilation to the creation of presentation materials. […]

Tactical Outsourcing vs Strategic Outsourcing

The term outsourcing scares people for various reasons, but there is no reason that it should. Outsourcing is very effective for certain situations, especially when developing software solutions. For a company to grow its internal IT department, it must search for a qualified candidate and go through the long process of interviewing, hiring, and training […]