Ramesh Jeyaram, software development project manager at UNIS LUMIN (IT consulting services company, now a part of Softchoice), managed application project development for a professional sport association and facilitated its successful release in 2011. Ramesh was also a major decision maker in selecting Business Intelligence (BI) provider for data warehouse and analytical reporting solution. - Ramesh, [...]
You can accelerate SQL Server Analysis Services cube processing by adjusting two setting, without changing data architecture or other costly approaches. 1. Use Shared Memory protocol to optimize source data retrieval >1.5 times I came across this remarkable feature while reading SQL Server 2008 R2 Analysis Services Operations Guide. It’s applicable when your data warehouse [...]
Virtualization offers multiple benefits to production technological environments. But what virtualization means to you, individual software developers/consultants? To me, it allows to: – Prevent one application from impacting another, including times when upgrades or changes are made; – Duplicate a standard environment and speed up new system configuration; – Deploy different technologies on a single [...]
We all look for ways to optimize our performance in many areas. SQL or ETL development isn’t an exception as it involves numerous tasks daily. Remember the 80/20 rule For us, database and data warehouse developers, this rule is: 80% of the time we use “SELECT FROM table” query, and optimizing its call is very easy! SELECT [...]
How do you make sure business metadata your clients will be using for reports meet their needs? I generate an Excel spreadsheet with lists of measures and dimensions and their properties and present them to my clients for reconciliation. They review the definitions and suggest names that are more intuitive for the business. They also [...]
If you’re overwhelmed by the complexity of a business intelligence project, focus on five major activities that comprise it: Requirements gathering Dimensional modeling ETL and OLAP development User acceptance testing (UAT) support Production support Business Intelligence Roadmap cart highlights major BI tasks and their relative durations: As you can see from the chart, ETL and [...]
Aug 042011
If you’re deciding what edition of SQL Server to obtain for your business intelligence (BI) system, I suggest narrow your list down to the following 7 important features for BI. First, consider the costs of two products: Standard Edition – $7,499 per processor Enterprise Edition – $28,749 per processor By looking at the differences, many [...]
The following resources can help you decide what data analytics and reporting solution you need for your organization. What objectives can business intelligence help me achieve? Business Intelligence for the Strategy-Focused Organization Is Building a Data Warehouse the Right Solution for Your Business? Why Building a Data Warehouse Is Not the Right Solution Business Intelligence: [...]
Jul 252011
If you are starting in business intelligence development and would like to get a sense of scope and get familiar with basics, you can: Watch Business Intelligence Webinars provided by Pragmatic Works Get to know the Report Builder Learn How to communicate OLAP Cube Design Decisions to Clients
Twitter: @oklimova
LinkedIn: OlgaKlimova