Articles having tag: BI

5 Business Intelligence Suites

5 Business Intelligence Suites: Pricing takes a bit of work to nail down; it pays to talk to the nice salespeople and let them help you sort it all out. All of these BI suites have free software downloads, and free community support. All of them offer multiple...

Busting 10 Myths About Hadoop

By Alex Popescu

Busting 10 Myths About Hadoop:Philip Russomclarifiessome myths about Hadoop and MapReduce circulating inside the BI community: Hadoop consists of multiple products. Hadoop is open source but available from vendors, too. Hadoop is an ecosystem, not a single...

Review: OfficeWriter v8

As a BI consultant specializing in SSRS, I have had lots of frustrations and hard times because of Excel. Every now and then, I have some or other business user coming up to me and asking for some feature which is there in Excel but not in SSRS. If you...

SSIS Tutorial - Getting started with SSIS - Part 8: Creating parameterized SSIS packages - Sudeep Raj

Now that we have learnt how to create a simple SSIS Package, let us see how we can make it adaptive. What I mean by adaptive is, how we can maintain the package with minimal changes in the future. Before we talk about how we handle this, let us talk about the...

Everything is Big Data Now... But Don't let yourself fooled by buzzwords

By Alex Popescu

Peter Collingridge for Jenn Webb inBook marketing is broken. Big data can fix iton O'Reilly Radar\xa0: But when you're in a much faster-paced world, with the industry moving toward being consumer- rather than trade-facing, and with a fragmented...

Hadoop, HBase and R: Will Open Source Software Challenge BI & Analytics Software Vendors?

By Alex Popescu

Hadoop, HBase and R: Will Open Source Software Challenge BI & Analytics Software Vendors?:Harish Kotadia: Predictive Analytics has been billed as the next big thing for almost fifteen years, but hasn't gained mass acceptance so far the way ERP and CRM...

#0129 - SQL Server – SSMS – Tutorial – Part 04 – Introduction to Database Diagramming (L100)

For those who have worked in Enterprise environments, documentation is of utmost importance. Documentation can be in the form of a text-based document, or a graphical document (in the form of a diagram). A data dictionary is a centralized repository of...

Using SSAS formatting in SSRS

Christmas time is one of my most favourite times of the year \u2013 the time when you can just lay back, relax, enjoy some quality time with your family and catch up with your old friends. While this Christmas time has been a little hectic for me considering...

SSRS & SSAS #62 – Create a data source on Report Server for an Analysis Services database

The team I recently moved into had never had a data source created on their report server for an Analysis Services source. A co-worker helped me got a data source created with Microsoft SLQ Server Analysis Services as the Data Source Type. For credentials...

SSIS - Delete files from specified folder using File System Task in SQL Server

We know all the various methods to delete the particular or all files from the specified folder using some of the methods like xpdeletefile , Ole Automation Procedures and with xp_cmdshell command line utility which we used for the old files archive...