Which body primarily oversees the coordination of the national intelligence effort?

The Office of the Director of National Intelligence (ODNI) is the entity primarily responsible for overseeing and coordinating the national intelligence effort in the United States. Established in response to the need for greater integration and collaboration among various intelligence agencies, the ODNI serves to ensure that intelligence activities align with national security objectives and to enhance the effectiveness of the United States' intelligence community.

The Director of National Intelligence leads this office and has the authority to manage and direct the execution of the national intelligence program, ensuring that information is shared across different agencies to provide a comprehensive view of threats and opportunities. This centralized approach helps to streamline processes, establish priorities, and improve overall intelligence-gathering efforts.

In contrast, the other bodies mentioned have different roles: the Department of Homeland Security focuses on domestic security issues; the Federal Bureau of Investigation is primarily concerned with federal law enforcement and domestic intelligence; and the National Security Council advises the President on national security and foreign policy matters but does not coordinate intelligence operations directly. The distinct role of ODNI in integrating intelligence functions makes it the correct answer for this question.