Business intelligence brickset
This presentation is the property of its rightful owner.
Sponsored Links
1 / 10

Business Intelligence BrickSet PowerPoint PPT Presentation


  • 69 Views
  • Uploaded on
  • Presentation posted in: General

Business Intelligence BrickSet. João Lopes SQLArgonauts.com @ SQLSniper. What ?. What. Business intelligence (BI) is the ability of an organization to collect, maintain, and organize data. This produces large amounts of information that can help develop new opportunities.

Download Presentation

Business Intelligence BrickSet

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Business intelligence brickset

Business Intelligence BrickSet

João Lopes

SQLArgonauts.com

@SQLSniper


Business intelligence brickset

What ?


Business intelligence brickset

What

Business intelligence (BI) is the ability of an organization to collect, maintain, and organize data.

This produces large amounts of information that can help develop new opportunities.

Identifying these opportunities, and implementing an effective strategy, can provide a competitive market advantage and long-term stability.

http://en.wikipedia.org/wiki/Business_intelligence


Business intelligence brickset

What

  • I work on Business Intelligence

    • ???

    • I understand the business and design dimensional models

      • ???

        • I create reports that show number and graphs

        • ???

  • I just work with tables on Excel


Business intelligence brickset

How ?


Business intelligence brickset

How

Data

Information

Knowledge


Business intelligence brickset

How

  • Data Extraction Using Tools and Frameworks

    • Just copying snapshots from sources inside my private staging area

  • Information Through Dimensional Modeling

    • ER model built around business concepts not 3rd Normal Form rules

  • Delivering Knowledge to End-users

    • Showing reports no request with quality data (or unique)


Business intelligence brickset

WHY ?


Business intelligence brickset

Why

  • The world of data is changing

    • 80% unstructured, 10x increase 5/y, N/devices person, data markets

  • New set of answers

    • Brand social feeling, optimize using data mashups, predict future

  • Same old needs (but in faster cycles)

    • Know our business, survive competition, make (better) decisions!


Business intelligence brickset

Why

+ Focused on business knowledge (not technology)

+ Not only the software package, also influencing people

+ Every project is a distinct challenge (even in the same business)

- Not for everyone, it needs strong commitment (long term)

- Technology range ? ] index fill range, big data, color palette [

- No easy ways to learn business concepts (beside clients)

So it really means a lot of knowledge to gather (and keep) … but it returns a nice payback €€+ 


  • Login