Online Class: Data Analysis and Visualization with Power BI Course (4 Days)

Online Class: Data Analysis and Visualization with Power BI Course (4 Days)

by MindCypress

2,435 AED

(VAT inclusive)

Online Class: Data Analysis and Visualization with Power BI Course (4 Days)

2,435 AED

(VAT inclusive)

when:
To be announced soon
where:
Online Class
level:
All Levels
Cancellation Policy: 48 hours prior to course start with full refund
We offer a best price guarantee for our classes. If you get a better price, let us know & we'll give you a free AED 100 voucher.
Description:

Power BI is a business intelligence platform introduced by Microsoft in 2011. The self-service tool is used by non-technical business owners for aggregating, analyzing, visualizing, and sharing data. Since the tool has been gaining popularity over the years, it has become a need to understand the subject thoroughly and implement the same. This 4-day Power BI course acts as a guide for those who want to learn and grow.

Course Outline:

  • Introduction:
    • Overview of Microsoft Excel’s PowerPivot
    • Importing data from various sources I.E. Excel, text, SQL server, etc.
    • Creating star schema and data models using relationships
    • Understanding evaluation context, row context
    • Creating calculated columns, comparing with measures
    • Creating auto calendars, comparing period over period growth
    • Ranking over a measure, building KPIs
    • Creating hierarchies, grouping data, dynamic drill-downs
    • Building flexible reports using cube formulas in power pivot
    • Creating on-the-fly formulas using variables
    • Creating disconnected tables, slicers, and virtual relationships
  • Data Management:
    • Overview of Microsoft Excel’s PowerPivot
    • Using DAX studio for querying and creating custom tables
    • Creating dimension tables from fact tables using power query
    • Visualizing data using power view, power maps, Power BI
    • Creating dashboards using custom visuals in Power BI
    • Cleaning, transforming, and reshaping data using power query
    • Combining multiple sources of data and consolidating using power query
    • Un-pivoting with multiple merged column headers
    • Creating dimension tables using fact tables
  • Working with Time Intelligence Functions:
    • Dynamic top product analysis
    • Least performance areas
    • Customer analysis
    • ABC analysis
    • Time patterns I.E. Period over period growth
    • Drill-downs at parent-child levels
    • Dynamic segmentation
    • Bulk sales
    • Moving averages

Skill Level:

All Levels

Materials:

All materials will be provided

Cancellation Policy:

48 hours prior to course start with full refund

Age Requirements:

18 and older

Additional Info:

  • Participants must have some Microsoft Excel knowledge

  • Upon completion, you will receive a certificate of competence from MindCypress which is recognized globally 

Location:

via Video calling app
Anywhere in
Dubai

Register for the class

Sorry, this class isn't available at the moment. Drop your email and be the first to know when it comes back!

Share this class:

Categories