Business Intelligence $($BI$)$:

Please answer the following questions in detail with explanation clearly for every question.

$1.$Briefly describe and explain six different types of visuals that you can find in Power BI$.$ This would include stating the name of the visual, what the unique feature of the visual is and the different ways data can be added to the visual and what this means in terms of it being used in the visual. Note that for this exercise, the various

versions of the same visual $($e$.$g$.$ the multiple types of bar charts$)$ are considered a single visual

$2.$Compare and contrast three common features and three different features of graph databases, document databases and relational databases. Provide an example of each type of database and suggest when each type of database may be the most appropriate to use.

$3.$Write the command required, once connected to a MongoDB instance using Mongo Shell, to create two collections named personCollection and productCollection. The personCollection should have two documents: one that contains a name of $$Example Person$,$ an age of $66$ and a retired flag of True and a second one with a name of $$Other Person$,$ an age of $21$ and an industry of $$Sales$.$ The productCollection should have two documents: one that contains a product name of $$Widget$$ and a price of $213\mathrm{.}45$ and a second with a product name of $$Donut$$ and a price of $12\mathrm{.}45$ with a GST flag of True.

$4.$Assuming that you do not need to change the API from Polygon to the backup one at tris.id$.$au$($A sample database$),$ describe in enough detail to be unambiguous the steps required to connect to$,$ process and visualise the data