[av_one_full first min_height=\’\’ vertical_alignment=\’av-align-top\’ space=\’\’ row_boxshadow_color=\’\’ row_boxshadow_width=\’10\’ custom_margin=\’aviaTBcustom_margin\’ margin=\’0px\’ margin_sync=\’true\’ mobile_breaking=\’\’ border=\’\’ border_color=\’\’ radius=\’0px\’ radius_sync=\’true\’ padding=\’0px\’ padding_sync=\’true\’ column_boxshadow_color=\’\’ column_boxshadow_width=\’10\’ background=\’bg_color\’ background_color=\’\’ background_gradient_color1=\’\’ background_gradient_color2=\’\’ background_gradient_direction=\’vertical\’ src=\’\’ attachment=\’\’ attachment_size=\’\’ background_position=\’top left\’ background_repeat=\’no-repeat\’ highlight_size=\’1.1\’ animation=\’\’ link=\’\’ linktarget=\’\’ link_hover=\’\’ title_attr=\’\’ alt_attr=\’\’ mobile_display=\’\’ id=\’\’ custom_class=\’\’ aria_label=\’\’ av_uid=\’av-1vrra\’]

[av_heading heading=\’AppCan Data Warehouse\’ tag=\’h1\’ link=\’\’ link_target=\’\’ style=\’blockquote modern-quote\’ size=\’\’ subheading_active=\’\’ subheading_size=\’\’ margin=\’5px\’ padding=\’10\’ icon_padding=\’10\’ color=\’custom-color-heading\’ custom_font=\’\’ icon_color=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’\’ icon_size=\’\’ custom_class=\’\’ id=\’\’ admin_preview_bg=\’\’ av-desktop-hide=\’\’ av-medium-hide=\’\’ av-small-hide=\’\’ av-mini-hide=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ av_uid=\’av-1x6u23\’][/av_heading]

[av_hr class=\’custom\’ icon_select=\’no\’ icon=\’ue808\’ font=\’entypo-fontello\’ position=\’center\’ shadow=\’no-shadow\’ height=\’50\’ custom_border=\’av-border-thin\’ custom_width=\’100%\’ custom_margin_top=\’10px\’ custom_margin_bottom=\’10px\’ custom_border_color=\’\’ custom_icon_color=\’\’ id=\’\’ custom_class=\’\’ av_uid=\’av-3fbm\’ admin_preview_bg=\’\’]

[/av_one_full][av_one_full first min_height=\’\’ vertical_alignment=\’av-align-top\’ space=\’\’ row_boxshadow_color=\’\’ row_boxshadow_width=\’10\’ custom_margin=\’aviaTBcustom_margin\’ margin=\’0px,20px\’ mobile_breaking=\’\’ border=\’\’ border_color=\’\’ radius=\’0px\’ radius_sync=\’true\’ padding=\’0px\’ padding_sync=\’true\’ column_boxshadow_color=\’\’ column_boxshadow_width=\’10\’ background=\’bg_color\’ background_color=\’\’ background_gradient_color1=\’\’ background_gradient_color2=\’\’ background_gradient_direction=\’vertical\’ src=\’\’ attachment=\’\’ attachment_size=\’\’ background_position=\’top left\’ background_repeat=\’no-repeat\’ highlight_size=\’1.1\’ animation=\’\’ link=\’\’ linktarget=\’\’ link_hover=\’\’ title_attr=\’\’ alt_attr=\’\’ mobile_display=\’\’ id=\’\’ custom_class=\’\’ aria_label=\’\’ av_uid=\’av-1vrra\’]

[av_heading heading=\’Connections\’ tag=\’h4\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ icon_size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ color=\’custom-color-heading\’ custom_font=\’\’ icon_color=\’\’ margin=\’5px\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-knyu7mtb\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[av_toggle_container faq_markup=\’\’ initial=\’0\’ mode=\’accordion\’ sort=\’\’ styling=\’\’ colors=\’\’ font_color=\’\’ background_color=\’\’ border_color=\’\’ colors_current=\’\’ font_color_current=\’\’ background_current=\’\’ background_color_current=\’\’ background_gradient_current_color1=\’\’ background_gradient_current_color2=\’\’ background_gradient_current_direction=\’vertical\’ hover_colors=\’\’ hover_background_color=\’\’ hover_font_color=\’\’ alb_description=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-knyu6g1l\’ sc_version=\’1.0\’]
[av_toggle title=\’Connecting Microsoft PowerBI\’ tags=\’\’ custom_id=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-1trtj1\’ sc_version=\’1.0\’]
You can connect PowerBI to the Data Warehouse as follows:

• Select \’Import data from SQL Server\’

• Enter the Server & Database details as supplied.

• In \’Database\’, enter the supplied \’User name\’ & \’Password\’.  Then select \’Connect\’.

• After successfully connection, you can now write your Power BI Reports.

[/av_toggle]
[av_toggle title=\’Connecting Microsoft Excel \’ tags=\’\’ custom_id=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-knyu6fhd\’ sc_version=\’1.0\’]
You can connect Excel to the Data Warehouse as follows:

• In Excel, under the \’Data\’ tab, select \’Get Data\’ > \’From Database\’ > \’From SQL Server Database\’

• Enter the Server & Database details as supplied.

• In \’Database\’, enter the supplied \’User name\’ & \’Password\’.  Then select \’Connect\’.

• After successfully connection, you can now write your Power BI Reports.

[/av_toggle]
[/av_toggle_container]

[/av_one_full]