Home  |  About Us  |  Careers |  Resources  |  Client List  |  Sitemap  |  Contact Us

Call: 416-623-9493 or 905-497-8717

Toll Free: 1-866-955-4526
E-mail: info@globalerp.ca

Software Quality Assurance Training Business Analysis Training SAP Training BI Development Microsoft BI Training PMP Training Tableau Training Informatica Training JAVA Training MICROSOFT .NET Training Power BI Training Big Data & Hadoop Training Scrum Training DevOps Training Cyber Security ORACLE Admin Training

  DURATION   20 Hrs
  Course Fee   $800
  DELIVERY METHOD   CLASSROOM, ONLINE- Please contact us for Schedule or for Demo class
  COURSE OVERVIEW   The course will give you the practical knowledge on BI Development and how these TABLEAU help in developing a robust end-to-end BI solution
  AUDIENCE   Knowledge/Experience with SQL, DATABASES or DATA WAREHOUSE Concepts
  PREREQUISITES   The pre-requisite for this Training is basic understanding of RDBMS, SQL.
  COURSE OBJECTIVES   In this BI training course, you will learn how to identify the maturity level of your BI solution, and articulate critical elements of your solution to maximize your organizations business opportunities. The facilitator will work with you through a case study in this hands-on training and you will be able to re-apply the template as soon as you are back at work.

Introducing Power BI

  • Explain Power BI Desktop
  • Power BI Desktop – Installation
  • Data Sources and Connections
  • Connect to Data In Power BI Desktop
  • Creating Datasets from Data Models and Data Files
  • Getting Started with Power BI
  • Using Quick Insights to Explore a Dataset
  • Viewing Reports
  • Exploring a Dashboard
  • History of Power BI 

Getting Data

  • Databases
  • Files
  • Web and Other Sources
  • Azure and Software as a Service
  • Manual Entry 

Transforming Data

  • Query Editor in Power BI
  • Renaming Queries
  • Combining Queries: Append
  • Fixing Metadata
  • Filtering Rows
  • Eliminating Columns
  • Combining Queries: Merge
  • Adding a Column 

Modeling Data for Analysis

  • Creating Relationships
  • Defining New Columns
  • Performing a Look up to a Related Table
  • Translating a Value

Enhancing the Data Model

  • Defining Hierarchies
  • Configuring Properties
  • Defining New Measures

Data Visualization

  • Reports in Power BI
  • Adding Visuals (Charts, Maps etc)
  • Filtering
  • Slicer Filtering
  • Setting Properties
  • Drilling Within a Hierarchy
  • Custom Visualization in Power BI
  • R Visuals in Power BI 

Introduction to Power BI Q&A and Data Insights

  • Power BI Q&A
  • Dashboard
  • Dashboard vs Reports
  • Creating a Dashboard
  • Dashboard Tiles
  • Pinning Tiles
  • Quick Insights with Power BI

Refreshing Data

  • Refreshing Data
  • Publishing Datasets
  • Refreshing Imported Data

Power BI Integration and Administration

  • Data Gateways – Personal and Enterprise
  • Content packs
  • Power BI Report Server

Brampton:199 Advance Blvd, Suite: 201, Brampton, ON, L6T 4N2
Mississauga: 1065 Canadian Place, Suite 201, Mississauga ON L4W 0C2
Toronto: 5635 Yonge St. Unit 215, North York (Finch Subway) ON M2M 3S9
Montreal: 279 Rue Sherbrooke O, Unit# 209,Montreal, QC H2X 1Y2 PH: +1-514-664-3900

Phone: +1 416-623-9493 or +1 905-497-8717
E-mail: training@globalerp.ca