Bounces, Entries and Bounce Rate metrics aren't available in Data Warehouse. These metrics are available in Site catalyst, Analysis Workspace, Ad hoc, Report Builder. So how do we calculate these metrics from Data Warehouse.
Note: There is no clear formula available to evaluate such metrics, however you may try the below approach. It may not produce the same results when pulled from Site Catalyst ,Analysis Workspace, Ad hoc, Report Builder.
A Bounce is counted when Path Length * Clicks to Page = 1
An Entry is counted when Clicks to Page = 1
Bounce Rate = Bounces / Entries
Path length ,Clicks to Page are standard dimensions in data warehouse. Clicks to Page metric is calculated at hit level, while Path length is calculated at visit level.
You may pull the columns Visitor ID, Visit Number, clicks to Page , Path length from Data Warehouse.
If for a combination of Visitor ID and Visit Number, clicks to Page > 1, then do not increment bounce.
If for a combination of Visitor ID and Visit Number, clicks to Page * Page length = 1, then increment Bounce count.