• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
11/26/2018 11/28/2019
  • VLT
Live Online
10/29/2018 10/31/2018
  • VLT
Live Online
11/14/2018 11/16/2018
  • VLT
  • GTR
Live Online

About the Course 

The primary motivation behind the course is to give understudies a decent comprehension of information examination with Power BI. The course incorporates making perceptions, the Power BI Service, and the Power BI Mobile App. 

Audience Profile

The course will probably be gone to by SQL Server report makers who are keen on elective strategies for showing information. 

At Course Completion

In the wake of finishing this course, understudies will have the capacity to: 

  • Perform Power BI desktop information change. 
  • Portray Power BI desktop displaying. 
  • Make a Power BI desktop representation. 
  • Actualize the Power BI benefit. 
  • Portray how to interface with Excel information. 
  • Portray how to team up with Power BI information. 
  • Interface specifically to information stores. 
  • Portray the Power BI engineer API. 
  • Portray the Power BI versatile application. 

Module 1: Introduction to Self-Service BI Solutions 

Presents business knowledge (BI) and how to self-present with BI. 

Lessons 

  • Prologue to business knowledge 
  • Prologue to information investigation 
  • Prologue to information perception 
  • Diagram of self-benefit BI 
  • Contemplations for self-benefit BI 
  • Microsoft instruments for self-benefit BI 

Lab : Exploring an Enterprise BI arrangement 

  • Survey reports 
  • Making a Power BI report 
  • Making a Power BI dashboard 

In the wake of finishing this module, understudies will have the capacity to: 

  • Portray the patterns in BI 
  • Portray the procedure of information investigation in Power BI. 
  • Utilize the key perceptions in Power BI. 
  • Portray the method of reasoning for self-benefit BI. 
  • Depict contemplations for self-benefit BI. 
  • See how you can utilize Microsoft items to actualize a BI arrangement. 

Module 2: Introducing Power BI 

This module presents Power BI desktop, and investigates the components that empower the quick creation and distribution of advanced information perceptions. 

Lessons 

  • Power BI 
  • The Power BI benefit 

Lab : Creating a Power BI dashboard 

  • Associating with Power BI information 
  • Make a Power BI dashboard 

Subsequent to finishing this module, understudies will have the capacity to: 

  • Create reports utilizing the Power BI Desktop application. 
  • Utilize report things to make dashboards on the Power BI gateway. 
  • Comprehend the parts of the Power BI benefit including authorizing and inhabitant administration. 

Module 3: Power BI 

Toward the finish of this module understudies will have the capacity to clarify the reason and favorable circumstances of utilizing Power BI. 

Lessons 

  • Utilizing Excel as an information hotspot for Power BI 
  • The Power BI information show 
  • Utilizing databases as an information hotspot for Power BI 
  • The Power BI benefit 

Lab : Importing information into Power BI 

  • Bringing in Excel documents into Power BI 
  • Survey reports from Excel documents 

In the wake of finishing this module, understudies will have the capacity to: 

  • Depict the information model and know how to improve information inside the model. 
  • Interface with Excel documents and import information 
  • Use on-premises and cloud Microsoft SQL Server databases as an information source, alongside the R content information connector 
  • Exploit the elements of the Power BI benefit by utilizing Q&A to make inquiries in common question dialect, and make content packs and gatherings. 

Module 4: Shaping and Combining Data 

With Power BI desktop you can shape and join information with effective, buil-in instruments. This module presents the devices that are accessible for setting up your information, and changing it into a frame prepared for announcing. 

Lessons 

  • Power BI desktop inquiries 
  • Molding information 
  • Consolidating information 

Lab : Shaping and consolidating information 

  • Shape control BI information 
  • Consolidate Power BI information 

In the wake of finishing this module, understudies will have the capacity to: 

  • Play out a scope of inquiry altering abilities in Power BI 
  • Shape information, utilizing arranging and changes. 
  • Consolidate information together from tables in your dataset. 

Module 5: Modeling information 

20778: Analyzing Data with Power BI module portrays how to shape and improve information. 

Lessons 

  • Connections 
  • DAX inquiries 
  • Figurings and measures 

Lab : Modeling Data 

  • Make connections 
  • Figurings 

In the wake of finishing this module, understudies will have the capacity to: 

  • Portray connections between information tables. 
  • Comprehend the DAX punctuation, and utilize DAX capacities to improve your dataset. 
  • Make figured sections, computed tables and measures. 

Module 6: Interactive Data Visualizations 

20778: Analyzing Data with Power BI module portrays how to make and oversee intelligent information representations. 

Lessons 

  • Making Power BI reports 
  • Dealing with a Power BI arrangement 

Lab : Creating a Power BI report 

  • Interfacing with Power BI information 
  • Building Power BI reports 
  • Making a Power BI dashboard 

In the wake of finishing this module, understudies will have the capacity to: 

  • Utilize Power Bi desktop to make intelligent information perceptions. 
  • Deal with a power BI arrangement. 

Module 7: Direct Connectivity 

20778: Analyzing Data with Power BI module portrays different availability choices utilizing Power BI. 

Lessons 

  • Cloud information 
  • Associating with investigation administrations 

Lab : Direct Connectivity 

  • Coordinate availability from Power BI desktop 
  • Coordinate availability from the Power BI benefit 

Subsequent to finishing this module, understudies will have the capacity to: 

  • Utilize Power BI guide availability to get to information in Azure SQL information stockroom, notwithstanding huge information sources, for example, Hadoop 
  • Utilize Power BI with SQL Server Analysis Services information, including Analysis administrations modles running in multidimentional mode. 

Module 8: Developer API 

20778: Analyzing Data with Power BI 

module portrays the designer API inside Power BI. 

Lessons 

  • The designer API 
  • Custom visuals 

Lab : Using the designer API 

  • Utilizing custom visuals 

In the wake of finishing this module, understudies will have the capacity to: 

  • Portray the designer API. 
  • Utilize the designer API to make custom visuals. 

Module 9: Power BI portable app

20778: Analyzing Data with Power BI module portrays the Power BI versatile app.

Lessons 

  • The Power BI portable application 
  • Utilizing the Power BI portable application 
  • Power BI implanted 

In the wake of finishing this module, understudies will have the capacity to: 

  • Portray the Power BI versatile application. 
  • Download and utilize the Power BI portable application. 
  • Portray Power BI installed and when you would need to utilize it.

Before going to this course, understudies must have: 

  • Astounding learning of social databases and detailing. 
  • Some essential learning of information stockroom pattern topology (counting star and snowflake diagrams). 
  • Some introduction to fundamental programming builds, (for example, circling and spreading). 
  • A consciousness of key business needs, for example, income, benefit, and monetary bookkeeping is attractive. 
  • Commonality with Microsoft Office applications – especially Excel.

Awards