Data Analytics with Power BI

by Ted Learning Claim Listing

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 more advance Power Query techniques to extract and shape data and then load and build a co

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Ted Learning Logo

img Duration

2 Days

Course Details

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 more advance Power Query techniques to extract and shape data and then load and build a complex Power Pivot Model, and write more complex DAX formulas and set up interactive reports or Dashboards.

 

What Will I Learn From This Course? 

  • Import, Shape, And Transform Data For Business Intelligence (bi). 

  • Create Data Models & Perform More Advance Calculations With Daxs. 

  • Create And Visualize Data Over A Period Of Time With Time Intelligence Functions. 

  • Create Awesome Dashboards Based On Reports In Power Bi Desktop. 

 

Pre-requisites:

Participants must have some basic knowledge in Power BI desktop, basic working knowledge in Excel Power Query & Power Pivot. Advance Excel users with good knowledge of functions & formulas and Pivot tables may also attend.

 

Module: Creating Awesome Dashboards:

  • a. Synchronize data across pages.

  • b. Drilling down to a more focus report.

  • c. Enhancing visuals with more contextual information.

  • d. Enhancing reports with conditional formatting

 

Module: Segmenting Data in Reports & Defining Parameters:

  • a. Customised categorising of data.

  • b. Aggregating data based on values found in the underlying data.

  • c. Define parameters for flexibility in data loading.

  • d. Creating report templates.

 

Module: Date Dimension in Power BI:

  • a. Pros & Cons using built using built in date tables.

  • b. Creating custom date tables with Power Query.

  • c. Creating custom date tables with DAXS.

  • d. Shaping Data in Power Query

 

Module: Data Analysis Expressions (DAXS) Language:

  • a. Performing calculations with Columns & Measures.

  • b. RELATED, DIVIDED, DISTINCTCOUNT functions.

  • c. Understanding Row Context and Filter Context

  • d. SUMX, CALCULATE, FILTER, ALL functions.

  • e. Grouping data with DAXS.

  • f. Making DAXS more readable.

 

Module: Time Intelligence Functions:

  • a. Functions that return a single date.

  • b. Functions that return a table of dates.

  • c. Functions that evaluate expressions over a time period.

 

Module: Relationships in Power BI:

  • a. How relationships works.

  • b. Both-Directional Relationship in Power BI.

  • c. Using DAXS to simulate the Both-Directional Relationship.

 

Module: Power BI Tricks – Automated Reports:

  • a. Building A Dynamic Date Table.

  • b. Filtering Pages Dynamically.

  • c. Filtering Visuals Dynamically.

  • d. Dynamic Titles.

  • Kuala Lumpur Branch

    12-07, Binjai 8 Premium SOHO, Kuala Lumpur
  • Teacher's Name
  • Julian
  • Teacher's Experience
  • Academic Qualifications Diploma in Accountancy ACCA (Association of Chartered Certified Accountants), UK Professional Certifications Pembangunan Sumber Manusia Berhad (PSMB) Certified Trainer Microsoft Certified Trainer (MCT) Julian specialises in conducting MS Excel application courses & seminars for various companies, local & multinationals. He teaches practical on-the-job experience, which translates to real-life exercises for participants’ benefit. Julian conducts various IT courses using Word Processors, Spread sheet, Database, Multimedia & Programming applications
  • Gender
  • Male
  • Teacher's Nationality
  • N/A

Check out more Power BI courses in Malaysia

International College of Management and Sports - ICMS Logo

Advanced Big Data Analytics (HCIA)

The Advanced Big Data Analytics (HCIA) Program is offered by the International College of Management and Sports (ICMS).

by International College of Management and Sports - ICMS [Claim Listing ]
SIRIM Academy Logo

Big Data Analytics

In today’s digital economy, data can be found everywhere. But how much of these data are actually useful and valuable? Predictive analytics help organizations derives values from data by utilizing different tools and techniques.

by SIRIM Academy [Claim Listing ]
Progress Link Training & Consultancy Sdn Bhd Logo

Analysing Data With Microsoft Power BI

Analysing Data with Microsoft Power BI training is offered by Progress Link Training & Consultancy Sdn Bhd. Our approach to training and development is rooted in systematic methodology.

by Progress Link Training & Consultancy Sdn Bhd [Claim Listing ]
Educ8 Technology Logo

Big Data

Big Data is a word processing program designed for everyday use. Having the basic skills to use this program is a minimum requirement for new hires in most businesses.

by Educ8 Technology [Claim Listing ]
Pahang Skills Development Centre Logo

Microsoft Power BI Workshop

Power BI is an interactive data visualization and reporting platform software with a primary focus on business intelligence that is used by businesses professionals. You will learn the concept of Power BI in handling big data. Analyze and visualize data to make it more interactive and interesting. ...

by Pahang Skills Development Centre [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy