Qlik Sense Business Analyst Practice Exam

The correct option for creating an office floor plan that effectively shows employee density is leveraging a KML file with floor plan shapes, office movements, and employee locations. KML (Keyhole Markup Language) is specifically designed for representing geographic data in a format that can include points, lines, and polygons. This capability allows for a detailed depiction of an office layout, including the spatial relationship between different areas within the office, as well as the dynamic movements and placements of employees.

With KML, it’s possible to visualize not just where employees are located at any given moment but also how that changes over time, which is crucial for understanding employee density in relation to the layout of the office. This dynamic spatial visualization provides valuable insights that are fundamental for effective space management and planning within an office environment.

The other options, while they may contain relevant data, are not as suited for this specific purpose. Excel files, while useful for tabular data, lack the geospatial capabilities of KML. CSV files provide structured data but do not inherently represent geographical features, making them less effective for visualizing office layouts. A PDF with a static floor plan does not allow for interactivity or dynamic representation of data regarding employee movements and densities.