logo-mini

Financial Dashboard

Financial Dashboard in Power BI - Dec 2021

Course Duration & Payment Details

Days: Monday, Wednesday & Friday
Timing: 08:00 to 10:00pm
Duration: 18 hours
Starting from: Monday, 06 December 2021
Last date of registration: Wednesday, 01 December 2021

Actual Fee: 18000/-  | Early bird discount: 9000/-
How to Pay: Online Payment
Bank: Habib Bank Limited (26 street, Badar Commercial, DHA Karachi)
Title: Irfan
Account No: 0011557900292501 | PK02HABB0011557900292501

Training Highlights

Data Visualization in Power BI Desktop

  • Visualization Best Practices
  • Which Chart is the Best?
  • Basic Charts
  • Interaction of Visuals
  • Color Formatting
  • Setting Sort Order
  • Tooltips
  • Slicers & Timeline Slicers
  • Cross Filtering and Highlighting
  • Visual, Page, and Report Level Filters
  • Hierarchies
  • Line Chart
  • Table and Matrix with Conditional Formatting
  • Multiple levels of filters
  • Using custom slicers
  • Inserting shapes, images, and text boxes
  • Drill Down
  • Hyperlink & Bookmark

Query Editor

  • Base structures in Power Query
  • Query Editor in Details
  • Get Data from Excel

Power Query Syntax

  • Data Types in Power Query
  • Transformation Steps
  • Query Operations; Duplicate, and Reference
  • Managing Queries in Groups

Combine Queries

  • Merge, Joining queries
  • Append, creating a big list

Transformations

  • Column Operations
  • Row Operations
  • Filtering
  • Sorting
  • Group By
  • Transpose
  • Pivot, Unpivot
  • Split
  • Merge (Concatenate)

Power Query Formula Language: M

  • What is M? and the importance of learning M
  • M Syntax
  • Basic examples of M

Power BI desktop – data modeling

  • Introduction to relationship view navigation
  • Understanding data modeling concepts
  • Creating and editing relationships
  • Why is a data model more efficient?
  • Relationship-based on multiple Columns
  • Principles of Database Normalization
  • Cardinality: Many-to-One & One-to-One
  • Understanding how LEFT, RIGHT, INNER, and OUTER joins work
  • Cross Filter Direction & Many-to-Many
  • Understanding Active Properties
  • M-Language vs DAX (Data Analysis Expressions)
  • Understanding the CALENDAR Function
  • Managing Active vs. Inactive Relationships

Working with DAX Functions

  • Introduction to DAX
  • Syntax of DAX
  • Understanding calculated columns and measures
  • Why is a measure more efficient than a column?
  • Creating calculated columns
  • Measures in PowerPivot
  • Implicit and explicit measures
  • Understanding filter context
  • Measure referencing
  • Editing / Deleting measures
  • Logical Operations

Working with DAX Functions

  • SUM, SUMX, SUMMARIZE, MIN, MINX, MAX, MAXX, COUNT, AVERAGE, AVERAGEX, UNION, SAMEPERIODLASTYEAR, YTD, QTD, MTD, DATEADD, CALCULATE, FILTER, IF, SELECTEDVALUE, DIVIDE, FORMAT, ABS, TREATAS, SWITCH, VALUES, BLANK, COUNTROWS

Working with Variable and Comments

What-If- Analysis

  • New Parameter

Power BI service

  • Logging in and understanding navigation
  • What are workspaces?
  • Difference between datasets, workbooks, reports, and dashboards
  • Publishing data to web

Power BI Service – Dashboards

  • Viewing reports & dashboards
  • Sharing reports & dashboards

Integration

  • Power BI and PowerPoint