Why learn Business Intelligence?

  • Businesses have goals and questions. To answer the questions and to track performance against goals, they need to gether data, analyze it and to determine what course of action need to take to reach to their goal. Business Intelligence helps to make better and more informed business decisions.

This course includes:

  • Four hours on-demand videos.

  • 15 downloadable resources

  • Twelve months unlimited

  • Certificate of completion - 8 CPD cred

What you 'II learn

  • How to connect to various data sources and perform data cleansing

  • Use of DAX -Data Analysis expressions to create powerful data models.

  • Create be-spoke reports and fully interactive and stunning visuals.

  • How to share reports on Power BI Services and create data insights.

  • Create hierarchies and answer questions with data drilldwon facility.

  • Write questions in natural language and get instant answers.

  • Who should attend

    Anyone who need to analyze large datasets to support business decision making.

  • Prerequisites

    Basic knowledge of Microsoft Excel.w

  • Requirements

    Microsoft Power BI should be installed. A business or school email address.

Course curriculum

  • 1

    Introduction

    • What is Power BI?
  • 2

    Installation of Power BI

    • Power BI Installation
  • 3

    Power BI Desktop

    • Import and Transform Data

    • Import Data from CSV files

    • Import Data from Excel Files

    • Import Data from a Database File

    • Data Relationships

    • Creating your first report

    • Time Intelligence in Power BI

    • Optimizing Data Models for Reporting

    • How to create and maintain hierarchies

    • How to create a data table on the fly

    • Line and Bar Chart

    • Analytics Pane

    • Visual, Page and Report level Filters

    • Export Data and Spot Light a Visual

    • Table Styles and Conditional Formatting

    • Card, Guage visual and Dynamic Dashboards

    • Page View and Page Size

    • Visual Relationships

    • Bookmark and Slide Show
  • 4

    Power BI Services

    • Power BI Services

    • How to create a dahsboard in Power BI Services

    • Quick Insights

    • Add Tiles in a Dashboard

    • Phone View

    • Power BI Q & A

    • Featured Questions

    • Export Data
  • 5

    Power BI Mobile

    • Power BI Mobile