Analyzing Data with Microsoft Power BI
|
8 ratings

Analyzing Data with Microsoft Power BI

by Elegant Professional & Management Development Training

1,425 AED

(VAT inclusive)

Analyzing Data with Microsoft Power BI

1,425 AED

(VAT inclusive)

when:
Flexible Dates
where:
Dubai - Al Barsha
level:
Beginner
Validity Period: All sessions are valid for 90 days upon booking
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 quickly becoming the world’s most powerful self-service business intelligence platform, and an absolutely essential tool for Finance and Business Data professionals.

Microsoft Power BI transforms company data into rich visuals that facilitate new ways of thinking about and organizing data so that users can focus on what's important to achieving business goals.
The user-friendly Power BI reporting application has been designed to help users, of all experiential levels, produce insightful data analysis - hence this interactive and highly engaging BI training course helps candidates across departments communicate performance-related data in a visually understandable manner.

This 22-hour (11 sessions x 2 hours per session) course will help participants understand the fundamentals and uses of Power BI and to develop business intelligence workflow. You'll also learn how to connect and transform source data, build complex relational models, analyze data with powerful DAX functions and design stunning, interactive dashboards from scratch.

For whom is this course for?

  • Finance & Accounting Professionals
  • Financial & Business Analysts
  • Market Research Analyst
  • Investment Analysts
  • HR Professionals
  • Sales Professionals

Course Outline

In this course, you'll be playing the role of Lead Analyst for Adventure Works Cycles, a global manufacturing company. Your mission? Design and deliver a professional-quality, end-to-end business intelligence solution, armed only with a handful of raw CSV files.

Objective #1: Connect & Transform the Raw Data into Power BI

  • Intro to the Query Editor
  • Types of Data Connectors
  • Basic Table Transformations
  • Text, Number & Date Tools
  • Index & Conditional Columns
  • Grouping, Aggregating, Pivoting & Unpivoting
  • Modifying, Merging & Appending Queries
  • Connecting to Folders
  • Defining Hierarchies & Categories
  • Connecting Data from Text files, Excel files, from Folders and Access Data Bases, etc.

Objective #2: Build a Relational Data Model Power BI

  • Intro to Database Normalization
  • Data ("Fact") Tables vs. Lookup ("Dimension") Tables
  • Creating Table Relationships
  • "Star" vs. "Snowflake" Schemas
  • Active vs. Inactive Relationships
  • Filter Context & Cardinality
  • Connecting Multiple Data Tables
  • Hiding Fields from Report View
  • Data Modeling Best Practices

Objective #3: Add Calculated Fields with DAX

  • Intro to Data Analysis Expressions (DAX)
  • Calculated Columns vs. Measures
  • Row Context vs. Filter Context
  • DAX Syntax & Operators
  • Basic Date & Time Intelligence Formulas
  • Logical & Conditional Statements
  • Text, Math & Stats Functions
  • CALCULATE, ALL & FILTER Functions
  • DAX Iterators (SUMX, AVERAGEX)
  • DAX Best Practices

Objective #4: Design Interactive Reports

  • Intro to the Power BI Report View
  • Adding Objects & Basic Charts
  • Formatting & Filtering Options
  • Slicers, Timelines, Cards & KPIs
  • Map Visuals (Basic, Fill, ArcGIS)
  • Treemaps, Lines, Areas & Gauges
  • Editing Report interactions & Drill through Filters

Read more

Skill Level:

Beginner

Materials:

* Participant needs to bring a Laptop which has Microsoft Power BI installed. Power BI is currently only compatible with PC/Windows (not available for Mac)

Validity Period:

All sessions are valid for 90 days upon booking

Age Requirements:

18 and older

Additional Info:

*Participants will receive a Certificate upon completion of the course
* Participants will receive the Elegant Training Centre Microsoft Power BI Manual

Location:

Al Attar Business Centre, 6th Floor, #620
Sheikh Zayed Road
Beside ibis Hotel, Near Sharaf DG Metro Station
Al Barsha
Dubai

Register for the class
Schedule
# Sessions
Price
Click here for schedule information

Each session takes 2 hours

After booking this class you will be contacted by the instructor to set your schedule as per your availability.

Instructor's working hours
SunMonTueWedThuFriSat
3:00PM
To
7:00PM
Share this class:

Reviews
|
8 ratings

Verónica Tejero
Wed, 29 Jan 2020, 1:56PM
Tamila Abdulaeva
Thu, 3 Oct 2019, 11:46PM
"It was a great start to my graphic design adventure. The staff is very helpful and always there to guide you with whatever you need. Thanks to my teacher I finally know where and how graphic design starts. Thanks a lot again ELEGANT TRAINING!"
Maha Amer
Tue, 3 Dec 2019, 2:51PM
Show More

Categories