ds-blog-icon.png

THE DATA DOWNLOAD

As a business intelligence consulting company, we pride ourselves on being able
to deliver on our projects as well as provide good quality content to our readers.

Webinar Q&A: SSAS for Tabular Cubes

Jan 22, 2018 11:38:10 AM   Greg Meehan

Topics: Tool Selection, Blog, Business Intelligence

View the Q&A discussion from our SSAS for Tabular Cubes webinar. The audience asked insightful questions, focusing on this Microsoft's modeling offering for Self-Service and Gold Standard reporting, and how this technology compares to others. 

SSAS_webinar.png

If you would like to view the entire webinar, continue to the research center under webinars.

PLAY WEBINAR

 

Read More

8 Steps to Successful Data Virtualization

Aug 25, 2017 10:01:00 AM   David Crolene

Topics: Blog, Data Virtualization, Data Governance, Master Data Management, Enterprise Data

By:  David Crolene, Vice President, Delivery

The verdict is in and Data Virtualization (DV) is here to stay.  This is driven by many factors such as the maturation of vendor technologies (e.g., heterogeneous join optimization, row level security, and high availability), increases in computing power, and a decrease in time end users are willing to wait for access to data. 

Read More

Data Warehouse Appliances

Jun 13, 2017 11:40:07 AM   Jerry Locke & Steve Dine

Topics: Blog, Business Intelligence, Cloud, Server Administration

Data Warehouse Appliances: Lessons from the Trenches


By Jerry Locke & Steve Dine

Over the past few years data warehouse (DW) appliances have become a viable option for business intelligence (BI) programs looking to load and process large data volumes as well as reducing query execution times. However, like most architectural decisions, there are many factors to consider when choosing to implement a DW appliance that aren’t usually highlighted during the sales presentation. This article will present some observations and lessons learned from a recent project in which we implemented a DW appliance for both the data warehouse and the data mart layers of the client architecture.

Read More

Tableau for the Enterprise?

Jun 9, 2017 11:21:42 AM   Datasource

Topics: Blog, Enterprise Data, Tableau

Steps for Using Tabeau

Tableau is a robust visualization tool capable of serving many roles in modern organizations. From data discovery to ad-hoc analysis to enterprise reporting, Tableau provides the functionality to give business users quick and useful access to their data. Report scheduling and Data Governance capabilities enhance this access and the quality of reporting. Many businesses now seek to utilize Tableau as an enterprise reporting tool, but they must take the necessary steps to be successful and ensure Tableau is the correct software choice for their needs.


Read More

Enhancing Your Enterprise Reporting Arsenal with MDX

May 10, 2017 10:44:45 AM   Datasource

Topics: Blog, Enterprise Data

 

By: Matt Caton, Senior BI Analyst, Datasource Consulting, LLC and Steve Dine, President, Datasource Consulting, LLC

Introduction

In the trenches, we constantly look for techniques to provide more efficient and effective reporting and analysis. For those that utilize cubes, multidimensional databases, or dimensionally-modeled relational (DMR) models, multi-dimensional expressions (MDX) can be leveraged for both solving complex report requirements and providing deeper insights to report consumers. 


Read More

"One Source of Truth": Common BI Terms Defined

Apr 11, 2017 10:22:07 AM   Datasource

Topics: Blog, Business Intelligence

By: Steven Dine, President of Datasource Consulting, LLC

 

I am always dismayed when reading articles and analyst reports that include a statistic of the percentage of Business Intelligence (BI) initiatives that fail or do not meet customer expectations. Most of those articles and reports go on to describe the now well-known reasons for why these types of initiatives fail, including lack of high-level sponsorship, poor data quality, low level of functional participation, unacceptable query response times, etc. What I never see mentioned, but often see in practice, is the incompatibility between the requirements and the implemented architecture in consultant-led initiatives.  How does this happen when nearly every consulting organization has a BI implementation methodology and experienced resources in implementing BI programs? While there are many causes, one often overlooked reason is the inconsistency in how BI consulting companies define the basic BI concepts. Many times the definitions depend on which consultant at the company you ask. I have yet to find these definitions posted on even the largest BI consultancy websites. 

Read More

Data Governance Challenges: Executing

Feb 24, 2017 2:30:43 PM   Datasource

Topics: Blog, Data Governance

Data Governance Implementation


By: Datasource

So far in this series on Data Governance, we’ve covered four critical elements including:

Data Governance Challenges: Understanding the Problem

Data Governance Challenges: Strategy

Data Governance Challenges: Organizing

Data Governance Challenges: Communicating

If you’ve missed any of these articles, feel free to follow the links above.

In this article, the final article in the series, we’ll cover your Data Governance Execution and Implementation plan. This is where the rubber truly hits the road. So, without further ado, let’s jump right into the fifth section on Data Governance – Data Governance Execution and Implementation Plan.

Read More

Data Governance Challenges: Communicating

Feb 24, 2017 2:30:23 PM   Datasource

Topics: Blog, Data Governance

Data Governance Communicating & Marketing


By: Datasource

A Data Governance Program is a long term project that will completely alter the way data is processed at your company.  Building momentum, gaining a following and showing successes will be critical for your long term success.  Therefore, it’s a good practice to work with the marketing team to develop a marketing plan for your Data Governance Program.

Listed below are four separate tips for communicating your Data Governance Program to the masses.

Read More

Data Governance Challenges: Organizing

Feb 24, 2017 2:29:59 PM   Datasource

Topics: Blog, Data Governance

Data Governance Organizing


By: Datasource

How visible is your Data Governance program?  Do you have the right levels of support to effectively drive your program?  Does everyone in the organization know what is transpiring around them?  Part four of our continuing series on Data Governance focuses on establishing the Data Governance Council and involving the right key players to help drive the Data Governance initiative.  Having the right key players on your team will help shine a spot light on the Data Governance program and sustain the momentum.

Data_Governance_Part_4.jpg

Read More

Data Governance Challenges: Strategy & Planning

Feb 24, 2017 2:29:39 PM   Datasource

Topics: Blog, Data Governance

Strategy & Planning


By: Datasource

Welcome to Part 3 in our multi-part series focused on Data Governance.  In our previous article titled Data Governance Challenges: Understanding the Problemwe focused heavily on how to identify pain points, ways to understand the business value, and how to improve the overall program focus.  In this article, we’ll continue with the next step for a Data Governance program and outline and developing the overall Data Governance strategy. This section will also cover one of the most pressing issues which is where to find the money for your Data Governance Program.

Read More