Entries by Optimus Information

Infographic – The Modern Data Warehouse Framework

Check our latest infographic, The Modern Data Warehouse Framework! As organizations are collecting and processing increasing amounts of data from a growing number data sources, data systems must evolve to keep up. In order to make the best data-driven decision possible, you need to reimagine the way you look at data warehousing. We took a […]

Three Trends Influencing the Rise of Application Development on Microsoft Azure

In today’s always-on, data driven world, organizations will either disrupt, or be disrupted. For those that choose the former, a fast application development cycle is critical for success. This is why companies are turning to Azure for application development. Azure can help cut costs and reduce development wait and integration time. Additionally, the flexibility of […]

Testing in an Interconnected World: Event Recap

How to test applications as they become increasingly universal In case you missed it, the latest instalment of the Optimus Breakfast Series went off Tuesday morning, June 13th, 2017. The event brought together three of the top software testing executives from Vancouver’s leading companies to talk software testing and the complexities they face in our […]

Power BI for Mobile: Take Your Data on the Road

One area where the Power BI software stack really shines is the mobile space. The Power BI product line includes three apps: one for iOS, Windows Phone and Android. These apps allow you to take anything you can generate in Power BI and make it readily available to any stakeholder with a mobile phone or […]

Data Analytics in the Cloud: Where to Start?

Where should you start when doing data analytics in the cloud? An enterprise-wide data analytics system pulling data from multiple sources, correlating and presenting results in relevant, insightful visualizations to enable prompt, informed decisions is the dream of many organizations. Those in the lead already reap the benefits of faster, high-accuracy, proactive decisions that data analytics […]

Cloud Data Warehousing with Azure SQL

If you are running an on-premise data analytics stack on Microsoft’s SQL Server, but running into maintenance, cost and scaling issues, you can consider moving your data system to a cloud-based database service such as Azure SQL Database. Especially for your first data analytics stack, Azure SQL Database provides low startup costs with the ability to easily expand […]

Announcing Transform 2016 – A data analytics breakfast event

Optimus is excited to bring you Transform 2016 on Oct. 20th 2016! Transform 2016 will bring three executives from leading Vancouver organizations to talk about how they are using data analytics to grow and transform their business. Learn how they used analytics to uncover the story their data is telling, the problems that it uncovered and how […]

SSIS Best Practices

What are the SSIS Best Practices? SSIS represents a complete rewrite of its early predecessor Data Transformation Services. Usability, parallelism and performance have all been vastly improved over the years resulting in an SQL Server component aimed at high-volume, high-performance ETL applications. Here are several additional tuning steps that can further increase SSIS performance for […]

Power BI vs QlikView

What are the key difference between Power BI and QlikView? In the world of business intelligence, putting the right tools in the hands of the right people is critical to success. Two of the most popular tools in the industry today are Microsoft Power BI and QlikView. Both provide modeling capabilities and allow you to […]