Financial Dashboard
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
