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)

by:
when:
Sat, 1 Oct 2022 8:30AM + 3 dates
(see timings & price options)
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
Schedule
# Sessions
Price
Click here for schedule information
This course consists of multiple sessions, view schedule for sessions below:
Saturday
1 OCT
8:30AM - 2:30PM
Saturday
8 OCT
8:30AM - 2:30PM
Saturday
15 OCT
8:30AM - 2:30PM
Saturday
22 OCT
8:30AM - 2:30PM
Share this class:

Categories