Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
    data driven insights
    How Data-Driven Insights Are Addressing Gaps in Patient Communication and Equity
    8 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: No Shortcuts: Focus on DW/BI Architecture and Processes, then Think about the Tools
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
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
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

IBM today announced a partnership with TD Bank Financial Group…
The Softer Side of Risk Management Means Fewer Analytics
Market Research in 3-D! – For Market Research, Social Networks Is to 2009 as what the Online Survey was in 1998
The recession is fostering interest in BI software, which helps…
Connecting Data Governance to Business Outcomes That Matter



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
Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

data analytics and truck accident claims
How Data Analytics Reduces Truck Accidents and Speeds Up Claims
Analytics Big Data Exclusive
predictive analytics for interior designers
Interior Designers Boost Profits with Predictive Analytics
Analytics Exclusive Predictive Analytics
big data and cybercrime
Stopping Lateral Movement in a Data-Heavy, Edge-First World
Big Data Exclusive
AI and data mining
What the Rise of AI Web Scrapers Means for Data Teams
Artificial Intelligence Big Data Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

etl for data-driven businesses
Big Data

Understanding ETL Tools as a Data-Centric Organization

8 Min Read

#25: Here’s a thought…

7 Min Read

Tools and those who enable their misuse

7 Min Read

Data Integration: Hand-coding Using ETL Tools Part 2

5 Min Read

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

ai chatbot
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
Chatbots
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?