About
Describing himself as a recovering CPA, Ben Taub served as an accountant and auditor…
Articles by Benjamin
Contributions
-
How do you design a data warehouse schema that supports both OLAP and OLTP queries?
I think the question is relatively bogus. The whole point of a data warehouse is that OLTP can't support intense reporting and a data warehouse can't really support OLTP. The data warehouse was originally defined as an integrated, subject oriented, non volatile, time variant collection of data in support of management decisions. I've always felt that data warehouses are really intended to overcome a shortness of computing power. If you could build a machine with infinite power, all your systems would run on that one machine and, in fact, you'd only have one, integrated system. But, because that power doesn't exist, you have to split the job of running the company from the job of analyzing it. Thus, you have a separate system for each.
Activity
-
Shared Office Space in Ann Arbor - We've got some extra space in our office (near Liberty, between State and Main) that we're finally getting around…
Shared Office Space in Ann Arbor - We've got some extra space in our office (near Liberty, between State and Main) that we're finally getting around…
Liked by Benjamin Taub
-
Shared Office Space in Ann Arbor - We've got some extra space in our office (near Liberty, between State and Main) that we're finally getting around…
Shared Office Space in Ann Arbor - We've got some extra space in our office (near Liberty, between State and Main) that we're finally getting around…
Posted by Benjamin Taub
-
Thank you to Balboa Park Online Collaborative for the wonderful opportunity to share Golden Record with your community.
Thank you to Balboa Park Online Collaborative for the wonderful opportunity to share Golden Record with your community.
Liked by Benjamin Taub
Experience
Education
-
University of Michigan - Stephen M. Ross School of Business
-
Activities and Societies: Beta Gamma Sigma, University Consulting Group, Teaching Assistant (Introductory Financial Accounting, Graduate Level Financial Statement Analysis)
-
-
Activities and Societies: Alpha Epsilon Pi Fraternity
-
-
Activities and Societies: Sailing, Crew
-
-
Licenses & Certifications
Publications
-
The Intelligent Decision
www.gocfi.com
Using Business Intelligence to make proactive facilities management decisions
Other authorsSee publication -
Oracle8 Data Warehousing (Oracle Press Series)
McGraw-Hill Osborne Media
Your Expert Guide to Building and Launching Your Data Warehouse
Data warehousing -- large-scale data storage and analysis -- is among the most important areas of enterprise computing today. Master data warehousing with the book officially authorized by Oracle Corporation, the leading provider of data warehousing solutions to Fortune 1000 companies.
Written by a solid team of Oracle and data warehousing experts -- Oracle8 Data Warehousing is your tactical guide to every important…Your Expert Guide to Building and Launching Your Data Warehouse
Data warehousing -- large-scale data storage and analysis -- is among the most important areas of enterprise computing today. Master data warehousing with the book officially authorized by Oracle Corporation, the leading provider of data warehousing solutions to Fortune 1000 companies.
Written by a solid team of Oracle and data warehousing experts -- Oracle8 Data Warehousing is your tactical guide to every important facet of data warehousing with Oracle8. Whether you are a database administrator, an information technology manager, or a data warehouse team member, you'll find this book loaded with valuable advice on planning, building, rolling out, and maintaining your data warehouse for optimal performance.
This book will help you to:
Understand the Oracle Express Server data warehousing solution. Investigate the physical components of a data warehouse including table size, expansion, disk stripping, and table partitioning Build an effective warehousing team and gain real-world insight into the business rationale that secures essential management buy-in Optimize the Oracle8 server for decision support. Make critical technical decisions such as choosing RAID technology, running the cost-based optimizer, as well as using read-only table space and warehouse refresh mechanisms Convert a legacy database system into an Oracle datawarehouse. Ga -
Oracle 8i Data Warehousing
Oracle Press / McGraw Hill
The official Oracle book on how to build data warehouses in Oracle
-
SQL Server 7 Data Warehousing
Osborne / McGraw Hill
One of the first guides to building data warehouses in SQL Server!
Projects
-
Business Intelligence & Data Warehouse Assessment - Specialty P&C Insurer
Worked with senior IT managers and business staff to assess and identify sources of weakness in the organization's analytic capabilities. Assessment revealed issues in areas including data warehouse design, BI tool selection, project methodologies and overall IT architecture governance.
-
Enterprise Data Architecture Plan Development - Regional P&C Insurer
Developed data architecture plan that addressed future data and reporting needs in light of trends such as the rise of Hadoop and the position of data warehouse appliances.
-
Business Intelligence & Data Warehouse Assessment - Regional P&C Insurer
Worked with senior IT management and interviewed senior business staff to assess the design and value of this insurer's data warehouse and BI infrastructure. Project revealed a well-designed data warehouse but a lack of tools and processes by which users could access it.
This insurer has since embarked on efforts to implement and deliver self service reporting capabilities across the organization. -
Data Governance Program Planning and Design - Regional P&C Insurer
Worked with this insurer's data manager to develop and implement an effective, yet not overly burdensome, data governance program.
This program's effectiveness was proven when VP-level reporting issues arose around the definition and use of specific data elements. -
Development of HIPAA-Compliant, Web-Based Pharmaceutical Data Analysis System
Designed a solution and then supervised QlikView development staff in the creation of a web-based system to provide data to researchers and marketers in a HIPAA-compliant fashion.
The ultimate beneficiaries of this project are sufferers of a rare genetic condition. Without treatment, these individuals can experience difficulty performing everyday tasks, difficulty breathing, increased incidence of disease and, ultimately, decreased lifespans. While not curable, this condition is…Designed a solution and then supervised QlikView development staff in the creation of a web-based system to provide data to researchers and marketers in a HIPAA-compliant fashion.
The ultimate beneficiaries of this project are sufferers of a rare genetic condition. Without treatment, these individuals can experience difficulty performing everyday tasks, difficulty breathing, increased incidence of disease and, ultimately, decreased lifespans. While not curable, this condition is treatable.
To better serve this population, a group of three interested parties realized that sharing data could allow researchers to discover facts hidden in their separate data sets. The parties included a multinational pharmaceutical company that manufactures a treatment, the specialty pharmacy that distributes the treatment, and a patient service organization that works with sufferers to manage their conditions and improve their quality of life. -
Data Mart Assessment - Quasi Governmental Electric Power Company
In this project, users of a newly released electricity distribution data mart expressed concerns about the usability and design of this new system. Our analysis corroborated their concerns. Our findings tied the design issues to avoidable shortcomings in corporate data warehouse standards and skill sets.
Working from this report the organization has embarked on an enterprise-data warehousing strategy planning effort. -
Medical Data Integration to Support Medicare Meaningful Use Compliance
Oversaw project for a group of remote radiology specialists to integrate data from multiple sources and populate a new EMR / EHR system.
Completion of this effort positioned this company to realize millions of dollars in benefits available under the federal government's meaningful use regulations.
Recommendations received
1 person has recommended Benjamin
Join now to viewMore activity by Benjamin
-
Here are the data skills our clients requested most often this year.
Here are the data skills our clients requested most often this year.
Shared by Benjamin Taub
-
Charlotte Bruell is making a list, and she's checking it twice. ✔️ ✔️ Our lead recruiter tallied up the most requested data skills from the roles we…
Charlotte Bruell is making a list, and she's checking it twice. ✔️ ✔️ Our lead recruiter tallied up the most requested data skills from the roles we…
Liked by Benjamin Taub
-
Bundle up and join us for Winter Break! ❄️ Throughout Winter Break at the Museum from Dec. 21 through Jan. 5, join us for the final days of our…
Bundle up and join us for Winter Break! ❄️ Throughout Winter Break at the Museum from Dec. 21 through Jan. 5, join us for the final days of our…
Liked by Benjamin Taub
-
We are in search of a NetSuite consultant. Our client specifically requires a consultant or firm well-versed in NetSuite to offer support, assist in…
We are in search of a NetSuite consultant. Our client specifically requires a consultant or firm well-versed in NetSuite to offer support, assist in…
Posted by Benjamin Taub
-
We're looking forward to being a guest presenter for Balboa Park Online Collaborative's webinar series in December. We'll showcase how the evolution…
We're looking forward to being a guest presenter for Balboa Park Online Collaborative's webinar series in December. We'll showcase how the evolution…
Liked by Benjamin Taub
-
If you're giving a talk this week, remember... 👇 1. Less is more 🤐 2. Showing > telling 🪄 3. Embrace your quirks 🤪 (All credits for this post to…
If you're giving a talk this week, remember... 👇 1. Less is more 🤐 2. Showing > telling 🪄 3. Embrace your quirks 🤪 (All credits for this post to…
Liked by Benjamin Taub
Other similar profiles
Explore collaborative articles
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
Explore MoreOthers named Benjamin Taub in United States
-
Benjamin Taub
-
Benjamin Taub
Student at University of Michigan - Stephen M. Ross School of Business
-
Benjamin Taub
Building Substitute Teacher and Current Childhood Education Graduate Student
-
Lucas Benjamin Taub
12 others named Benjamin Taub in United States are on LinkedIn
See others named Benjamin Taub