By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics in sports industry
    Here’s How Data Analytics In Sports Is Changing The Game
    6 Min Read
    data analytics on nursing career
    Advances in Data Analytics Are Rapidly Transforming Nursing
    8 Min Read
    data analytics reveals the benefits of MBA
    Data Analytics Technology Proves Benefits of an MBA
    9 Min Read
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: No Shortcuts: Focus on DW/BI Architecture and Processes, then Think about the Tools
Share
Notification Show More
Latest News
big data mac performance
Data-Driven Tips to Optimize the Speed of Macs
News
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
Artificial Intelligence
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Warehousing > No Shortcuts: Focus on DW/BI Architecture and Processes, then Think about the Tools
Business IntelligenceData Warehousing

No Shortcuts: Focus on DW/BI Architecture and Processes, then Think about the Tools

RickSherman
Last updated: 2009/12/18 at 2:02 PM
RickSherman
4 Min Read
SHARE

No_shortcut A common problem from an IT perspective is the perception that BI is just about learning how to use the tools such as databases, ETL, reporting and online analytical processing (OLAP).  You use a carpenter to build your house, but you need an architect to design it. Simply knowing how to mechanically use the tools does not help you in designing the database(s), ETL loads or dashboards.

This problem is especially pronounced when the BI or ETL tool is free because it is either bundled with other software such as a database or distributed as open source software (OSS). Often project teams are frustrated with these free tools and the project fails. But those are just symptoms. The real problem is that the team didn’t read the instructions.

The first issue is often that members of the IT staff teach themselves how to use the tools. Just as “he who is his own lawyer has a fool for a client,” an IT person who has never done BI or ETL can only teach herself the mechanics (the what) of the tools but not the how. A self-taught developer inevitably tries to use the tool as she would if she were hand-coding… big mistake.

The second and bigger issue, the project team …

More Read

etl for data-driven businesses

Understanding ETL Tools as a Data-Centric Organization

Tools and those who enable their misuse
ETL tools: Don’t Forget About the Little Dogs
#25: Here’s a thought…
Data Integration: Hand-coding Using ETL Tools Part 2



No_shortcut A common problem from an IT perspective is the perception that BI is just about learning how to use the tools such as databases, ETL, reporting and online analytical processing (OLAP).  You use a carpenter to build your house, but you need an architect to design it. Simply knowing how to mechanically use the tools does not help you in designing the database(s), ETL loads or dashboards.

This problem is especially pronounced when the BI or ETL tool is free because it is either bundled with other software such as a database or distributed as open source software (OSS). Often project teams are frustrated with these free tools and the project fails. But those are just symptoms. The real problem is that the team didn’t read the instructions.

The first issue is often that members of the IT staff teach themselves how to use the tools. Just as “he who is his own lawyer has a fool for a client,” an IT person who has never done BI or ETL can only teach herself the mechanics (the what) of the tools but not the how. A self-taught developer inevitably tries to use the tool as she would if she were hand-coding… big mistake.

The second and bigger issue, the project team and their sponsor figure that free tools mean no investment is necessary, so they never get trained in the concepts. Data warehousing is complicated; you have to understand why you build warehouses, how you design them and what the processes are to load, cleanse and access them.

(For more on this series, see No Shortcuts: Read the BI/DW Instructions and Ask for Directions.)


Link to original post

TAGGED: etl tools
RickSherman December 18, 2009
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

big data mac performance
Data-Driven Tips to Optimize the Speed of Macs
News
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
3 Ways AI Has Helped Marketers and Creative Professionals Streamline Workflows
Artificial Intelligence
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

etl for data-driven businesses
Big Data

Understanding ETL Tools as a Data-Centric Organization

8 Min Read

Tools and those who enable their misuse

7 Min Read

ETL tools: Don’t Forget About the Little Dogs

6 Min Read

#25: Here’s a thought…

7 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data
AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?