Power BI for FP&A Professionals

Description:

Total Sessions - 4

Session Start Date  - 9 Feb

Session Timings - 2 PM

Session Mode - Live

• No Prior coding or business knowledge required
• Build Powerful Dashboards using Power BI to track all your KPIs
• Get Key Insights & Observations from your data
• Master Data Analysis & Visualization
• Perform Business Intelligence to grow any company
• Learn to Leverage Data that makes you the star performer of your team

Topics Covered

 Introduction to Power BI Desktop

• Installing and Running Power BI Desktop
• The Data Load Process
• The Power BI Desktop Window

 Discovering and Loading Data with Power BI Desktop

• Data Sources
• Loading Data
• Excel 

 Transforming Datasets

• Power BI Desktop Queries
• Editing Data After a Data Load
• Transforming Data Before Loading
• The Power BI Desktop Query Editor
• The Applied Steps List
• Dataset Shaping
• Renaming/Reordering/Removing Columns
• Removing Error Records
• Removing Duplicate
• Records Sorting Data
• Filtering Data

 Data Cleansing

• Changing Data Type
• Detecting Data Types

Designing a Power BI Desktop Data Model

• Data View and Relationship View
• Creating Relationships Manually & Automatically
• Cardinality- Many to One, One to One
• Deleting Relationships
• Managing Relationships

Text-Based Visualizations

• Power BI Desktop Dashboards 
• Tables
• Creating a Basic Table
• Creating a Matrix

Charts in Power BI Desktop

• A First Chart
• Basic Chart Types
• Column Charts
• Line Charts
• Pie Charts
• Essential Chart Adjustments

Filtering Data using Slicer

• Using Slicers
• Formatting Slicers
• Specifying Visual Interactions
• Choosing the Correct Approach to Interactive Data Selection

 Enhancing Reports

• Adding Text Boxes to Annotate a Report
• Modifying the Page Background Colour
• Organizing Visuals on the Page