About the author
SearchDataManagement.com expert contributor William McKnight is the Senior Vice President, Information Management for Conversion Services International, Inc. (CSI), a premier leading provider of a new category of professional services focusing on strategic consulting, data warehousing, business intelligence and information technology management solutions. McKnight is an award-winning IT executive in data warehousing, has a monthly column in DM Review and frequently keynotes and speaks on the subjects of DW/BI internationally. He serves as a judge for industry awards and is an active DW practitioner. Browse the content below for business intelligence (BI) and data warehouse best practices and expert advice.
William McKnight regularly answers readers' questions in the SearchDataManagement.com Ask the Expert section. Ask him a question or browse other experts and their responses to data management questions.
Data warehousing advice and best practices
Data warehouse development: Four strategic steps
Learn the basics of data warehouse development in four strategic steps, from expert William McKnight.
Accessing data from different systems: When ERP isn't enough
When data is stored in different transactional systems, data access can be compromised -- and ERP systems may not be enough. Our expert has a suggestion for how to get a singular view of the data.
Data architect careers: The benefits of working at a System Integrator
Working as a data architect at a consultancy or System Integrator can be challenging, but has benefits. Find out the career value of working at a System Integrator, as advised by William McKnight.
Career growth of a software developer
Career growth depends on how well you do your job, who you work for and the cost of replacing and outsourcing what you do.
Information architect: Career path, skills and experience
Learn about the career path of an information architect, as well as what type of experience is optimal for career development.
Data warehousing tools for industry-specific data warehouses
Learn the most important things to consider when selecting a data warehousing tool for an industry-specific data warehouse project.
Responsibilities of the information architect
Learn the core responsibilities of the information architect beyond the scope of the business intelligence (BI) team.
Business intelligence and data warehousing team structure
Business intelligence and data warehousing teams are constructed differently, but most are placed within the IT department and include some basic, common roles.
Defining web business intelligence (WBI), data mining and data warehousing
William McKnight defines web intelligence (WI) -- often referred to as web business intelligence (WBI) -- and explains the differences between data mining and data warehousing.
Data warehousing jobs: Using your database administrator experience
Our business intelligence expert explains how to maximize your DBA experience to land a data warehousing job.
Data warehouse management and design
When planning a data warehouse design, remember that a data warehouse must be consistently reliable so users can count on it to make better business decisions.
Career change: From data analyst to data architect
Our expert recommends enhancing your skill set to include data analysis/modeling to be more valuable in the work force.
Data warehouse architect: Essential technical skills
A data warehouse architect must be adept in a variety of technical skills, including data access, ETL and data management.
The roles of data warehousing, data mining and OLAP in knowledge discovery
Learn about how data warehousing, data mining and OLAP play into knowledge discovery.
Data warehousing hardware requirements
Get expert advice on data warehousing hardware requirements.
Data modeling: Entity relationship (E-R) vs. dimensional data models
Whether to use entity relationship (E-R) data modeling or dimensional data modeling techniques depends on the situation, says data warehouse expert William McKnight.
Data warehousing: To consolidate financials or not?
Learn how a data warehouse can allow a company to provide consolidated financials that are fed by both automated systems and manual intervention.
Relational vs. dimensional data marts
If you have a single data warehouse/mart, then you will likely have both relational and dimensional structures in it, says William McKnight.
Star schema design for BI
A star schema design for BI involves more than you think. Before you design your star schema, read advice from data warehouse expert, William McKnight.
Tackling multilevel organizational structures in the data warehouse
Learn the dimension for multilevel organizational structres in a data warehouse.
Corporate Information Factory (CIF) and data warehousing frameworks
Our expert recommends a "bottom-up" data warehouse methodology as an alternative to CIF.
Data warehouses - for BI or operational systems data?
Data warehouses do more than just store the data, according to William McKnight.
Oracle Star Schema data warehouse design tips
Get advice on Oracle Star Schema data warehouse design.
Business intelligence advice and best practices
Business intelligence career through Web development
Learn why it's possible to start a business intelligence career through gaining Web development experience.
Business intelligence information management (BIIM) vs. BI
What is business intelligence information management (BIIM)? Learn what our expert says about business intelligence and information management.
How to transition to real-time business intelligence and data warehousing
Learn how real-time business intelligence (BI) impacts a data warehouse and get expert tips for making the transition to real-time BI.
Do you need managed reporting tools and business intelligence (BI) tools?
Learn if it's necessary to have both business intelligence (BI) tools and managed reporting tools.
Can data mining expertise help my career?
Learn if acquiring data mining expertise is a wise career move that will help you find a job.
Data mining in the healthcare industry
Learn the advantages of data mining in the healthcare industry, according to our analytics expert, William McKnight.
Business intelligence analyst career advice
Learn how to start a business intelligence analyst career and find out what industries are healthiest right now, according to BI expert William McKnight.
Data mining tools: Advantages and disadvantages of implementation
Learn the advantages and disadvantages of data mining tools and of implementing data mining technology.
Ways to begin a business intelligence career
Get advice on various ways to begin a business intelligence career -- including online education and conferences.
Business activity monitoring (BAM) software: How to choose and customize
Learn the best way to select or customize your business activity monitoring software -- which begins with analyzing your business requirements.
Enterprise search and business intelligence: What's in store
Find out what our expert has to say about the future of enterprise search and business intelligence.
Are business intelligence certifications worth it?
Are business intelligence certifications worth it? Get certification advice from our business intelligence expert, William McKnight.
Business intelligence security considerations
There are two main components to business intelligence security: access and profiling.
Business intelligence and data warehousing team structure
Business intelligence and data warehousing teams are constructed differently, but most are placed within the IT department and include some basic, common roles.
Data cleansing: The business impact of dirty data
Look at the business impact of leaving less-than-ideal data in place to help you determine what data should be cleansed.
Is data mining reliable?
Data mining does not stand alone on its own merits within an organization, expert William McKnight advises.
Business intelligence (BI) and corporate performance management (CPM): What's the deal?
Learn about the possible convergence of BI and CPM, as well as the potential role of enterprise search.
Locating 'lost' external tables in a schema
Forgot what you named your external tables and what directory they are in? Have no fear, our expert tells you how to locate them!
Business intelligence jobs: Where are they?
Looking for business intelligence jobs? Read William McKnight's insight into the business intelligence job market.
Defining web business intelligence (WBI), data mining and data warehousing
William McKnight defines web intelligence (WI) -- often referred to as web business intelligence (WBI) -- and explains the differences between data mining and data warehousing.
What effect will Enterprise Search have on BI?
Analytics expert William McKnight weighs the effects of enterprise search on BI in the on-demand world.
Business intelligence software: Business Objects vs. SAS, Ralph Kimball vs. Bill Inmon
Learn about the differences between Business Objects' business intelligence software and SAS, and the debate between the Ralph Kimball and Bill Inmon approaches.
Tips for establishing a BI advisory board at a large corporation
Get advice on how to establish a BI advisory committee at a large corporation.
Reporting capabilities: Microsoft SQL Server 2005 vs. Cognos ReportNet
Get expert advice about BI reporting capabilties in Microsoft SQL Server and Cognos.
Customer data mining advantages: Mining customer data through airline mileage programs
Customer data mining is everywhere. And there are advantages. Our expert discusses the benefits of mining customer data through airline mileage programs.
Choosing business intelligence reporting tools
Choosing the right business intelligence reporting tools takes time and thought. Read what our analytics expert recommends for selecting BI reporting tools.
Career change: From data analyst to data architect
Our expert recommends enhancing your skill set to include data analysis/modeling to be more valuable in the work force.
Addressing technology reporting and performance problems in non-profit organization
Get advice on technology reporting and performance issues.
Roles and responsibilities for newly established MIS unit
Read advice on sorting out the roles and responsibilities of a MIS unit.
What to budget for BI infrastructure costs
Before budgeting BI infrastructure costs, make sure to answer these important clarifying questions.
The roles of data warehousing, data mining and OLAP in knowledge discovery
Learn about how data warehousing, data mining and OLAP play into knowledge discovery.
Data warehousing: To consolidate financials or not?
Learn how a data warehouse can allow a company to provide consolidated financials that are fed by both automated systems and manual intervention.
Complying with Sarbanes Oxley Act with business intelligence
According to our expert, Sarbanes Oxley is probably not number one on the BI agenda.
Help with justification of BI investments
William McKnight explains how to calculate ROI to justify a BI investment.
Star schema design for BI
A star schema design for BI involves more than you think. Before you design your star schema, read advice from data analytics expert, William McKnight.
ROI for BI
Business intelligence is generating impressive returns in a variety of industries--especially customer-focused marketing.
How is BI different from CRM?
William McKnight explains that business intelligence is a broad category that includes many uses of data, one of which is in pursuit of a CRM strategy.
Structured vs. unstructured data
Get McKnight's insight into when the vendors are going to focus on unstructured data.
Business intelligence tools: Choosing the right BI product
There are loads of business intelligence tools out there on the market today. Our business intelligence expert provides some valuable resources for choosing the right BI product.
Data warehouses - for BI or operational systems data?
Data warehouses do more than just store the data, according to William McKnight.
Enterprise information vs. business intelligence portals
Many enterprise portals acknowledge the importance of BI and have plug-ins for BI tools.
The role of OLAP in the interpretation of data
McKnight explains how dimensional analysis and OLAP are somewhat synonymous methods of browsing data.
