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

 
 
 
 
 
 
Power BI
     
  COURSE ID   PBI
  DURATION   20 Hrs
  Course Fee   $800 + HST
  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.
  COURSE OUTLINE  

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
  SOFTWARE   POWER BI
  CONTACT INFORMATION5  

Brampton:199 Advance Blvd, Suite: 201, Brampton, ON, L6T 4N2
Mississauga: 1065 Canadian Place, Suite 201, Mississauga ON L4W 0C2
Scarborough: 2401 Eglinton Ave E, Suite 304, Scarborough(Eglinton & Kennedy) ON M1K 2M5
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

Effective implementation of a Business Intelligence (BI) program results in better business decisions and increased success in achieving goals. 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.