Have a general question concerning Perfect, find below contact details our team will help you.
Welcome to TED Learning!
“Power BI is a suite of business analytics tools to analyze data and share insights.
From Data to Awesome Dashboards!”
(Course duration – 2 days)
Introduction
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 power BI desktop 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.
What you will learn in Power BI Desktop Course
Connect, import, shape, and transform data for business intelligence (BI)
| power BI desktop course |
Visualize data and automate refresh of your reports
Create dashboards based on reports in Power BI desktop and Excel
Use natural language queries
-
TED Learning Sdn Bhd
12-07 Binjai 8 Premium SOHO
No. 2 Lorong Binjai
50450 Kuala Lumpur
-
03-2742 1828
-
training@ted.com.my
Caption 1
Caption 2
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 Course, 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.
What Will I Learn From This Course?
Visualize
After completing the course, students will know how to Connect, import, shape, and transform data for business intelligence (BI)
Student also will be expose on how to Visualize data and automate refresh the reports
Awesome Report
After completing the course, students will know how to create dashboards based on reports in Power BI desktop and Excel
Students also will be thought to use natural language queries in MS Power BI.
Topics Included
- Power BI Overview
- Differences between Excel Power BI / Power BI Desktop
- Installing and launching Power BI Desktop
- Connecting to Excel and CSV files
- Connecting to a database or web data
- Introduction to Power Query
- Connecting & Querying data
- Combining data from multiple sources
- Shaping Data in Power Query
- Introduction to Power Pivot
- Creating relationship between tables
- DAX functions
- Creating & Customising Visualisations
- Charts, Treemaps, Maps, Tables & Card Visualisations
- Create Reports and Dashboards
- Publishing to the Power BI cloud service
- Power BI Q&A Natural Language
Pre-requisites
Participants must have intermediate to advance knowledge in Excel. Having hands on experience with Pivot tables, functions such as SUMIF, VLOOKUP & IF and Excel’s commands such as Filtering, Text to Columns and sub totals.
TED Learning also offers
Qlik Sense Training
and
Tableau Training
in Malaysia.
Feel Free To Inquire About Our Power BI Training Course
Previous client that we have conducted training with
The Coffee Bean & Tea Leaf Malaysia
Swis Resources Sdn Bhd
Cypark Resources Berhad