Welcome to TED Learning!

  • 12-07, Binjai 8 Premium SOHO, No. 2 Lorong Binjai, 50450 Kuala Lumpur
  • Phone: +603-2742 1828
  • training@ted.com.my

Power BI Desktop - TED Learning

By tedadmin | March 14, 2018

Course Introduction 

This 2-day Fundamentals of Power BI Desktop training is for intermediate/advance Microsoft Excel users who want to get started with Power BI Desktop and implement Business Intelligence in their organization.

Power BI (including Power Query & Power Pivot) are the biggest Excel news items in the last 7 years. They give Excel users the power to draw information out of multiple sources, link it together and perform calculations on it that can then be sliced & diced any way you want.

This hands-on course is focused on real-world techniques utilising the amazing capabilities of Power BI. The course covers the core elements needed to get an understanding of what Power BI can do. You will use Power Query to extract and shape data and then load and build a complex Power Pivot Model from scratch, write DAX formulas and set up interactive reports.

Get more insights from your data, whether it’s stored on your computer or the cloud. Learn how to connect to and merge data with Power BI Desktop, the powerful data analysis and visualization software. In this course, you’ll learn how to connect various data sources, including Excel, Access, and web data sources, and search and transform the data with simple queries. 

Course Objectives ›

Participants will learn how to:

  1. Connect, import, shape, and transform data for business intelligence (BI)
  2. Visualize data and automate refresh of your reports
  3. Create dashboards based on reports in Power BI desktop and Excel
  4. Use natural language queries

Course Outline 

DAY 1
  1. Power BI Overview
  2. Differences between Excel Power BI / Power BI Desktop
  3. Installing and launching Power BI Desktop
  4. Connecting to Excel and CSV files
  5. Connecting to a database or web data
  6. Introduction to Power Query
  7. Connecting & Querying data
  8. Combining data from multiple sources
  9. Shaping Data in Power Query
DAY 2
  1. Introduction to Power Pivot
  2. Creating relationship between tables
  3. DAX functions
  4. Creating & Customising Visualisations
  5. Charts, Treemaps, Maps, Tables & Card Visualisations
  6. Create Reports and Dashboards
  7. Publishing to the Power BI cloud service
  8. Power BI Q&A Natural Language
 Register Now

.

.

.

.

.

FEEL FREE TO ENQUIRE ABOUT OUR RANGE OF TRAINING COURSES