Price: AED 2,500

Duration: 30 Hours

Timing: Flexible

Course Overview

Microsoft 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 our interactive and highly engaging BI training course helps candidates across departments communicate performance-related data in a visually understandable manner.

This course will help participants understand the fundamentals and uses of Power BI and to develop business intelligence workflow, and teach you how to connect and transform source data, build complex relational models, Analyze data with powerful DAX functions and design stunning, interactive dashboards from scratch.

Course Outline

PART 1 – CONNECT & TRANSFORM THE RAW DATA INTO POWER BI

  • Introduction to Microsoft Power BI
  • Types of Data Connectors
  • Basic Table Transformations
  • Text, Number & Date transformation tools
  • Index & Conditional Columns
  • Power Query Parameters
  • Invoke Custom Functions
  • Grouping, Aggregating, Pivoting & Unpivoting
  • Modifying, Merging & Appending Queries
  • Connecting to Folders and automate data loading
  • Change the structure of unorganized multiple data files into proper format and combined the data in to one file
  • Connecting to Website with Parameters
  • How to import data from SQL Database to Power BI
  • Defining Hierarchies & Categories
  • Connecting Data from Text files, Excel files, from Folders and Access Data Bases etc.
  • Automation of data loading procedures
  • How to add custom columns and columns from examples
  • Best Practices in Power Query Data transformation

 

PART 2 – BUILD A RELATIONAL DATA MODEL in MICROSOFT 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

PART 3 – USING DAX MEASURES AND CALCULATED COLUMNS

  • Intro to Data Analysis Expressions (DAX)
  • Calculated Columns vs. Measures
  • What is Evaluation Context
  • Row Context vs. Filter Context
  • Intro to Context Transition – Part 1
  • How to create your first measure
  • Implicit Measures Vs Explicit Measures
  • DAX Syntax & Operators
  • Basic Date & Time Intelligence Formulas
  • Logical & Conditional Statements
  • Text, Math & Stats Functions DAX Iterators (SUMX, AVERAGEX, MINX)
  • Context Transition with Iterators – Part 2
  • CALCULATE Function
  • What is Variables and How to use it
  • How to use Calculate and ALL & FILTER Functions
  • Context Transition in Filter – Part 3
  • SWITCH / SWITCH (TRUE) Function
  • How to calculate Percentage of Parent with ALL Function
  • ALL SELECTED / TOPN / SELECTEDVALUE
  • How to use HASONEVALUE to fix total issues
  • Handle Many to Many (MTM) relationships with virtual relationships using TREATAS function
  • How to Calculate Moving Average with DAX
  • Time Intelligence Functions SAMEPERIODLASTYEAR, DATEADD, YTD, MTD, QTD, DATESINPERIOD, PARRALLAL PERIOD
  • How to use DAX VARIABLES and simply complex DAX queries
  • DAX Best Practices

PART 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)
  • Tree maps, Lines, Areas & Gauges
  • Using Decomposition tree
  • Visual Interactions and Navigation tips
  • Advanced visualization tips and tricks
  • Using Bookmarks and Selection Pane
  • How to use Power BI Custom Visuals
  • Power BI AI (Artificial Intelligence) Visuals
  • Row Level Security and Publishing to Power BI Service
  • Editing Report interactions & Drill through Filters
  • Connect drill through filters to buttons
  • Using the power of Artificial Intelligence (AI) with Power BI
  • Data Visualization best practices as per IBCS standards (International Business Communication Standards)
  • Publish Report to Power BI Service
  • Share Reports with Colleagues
  • Create Report Dashboards

FOR WHOM?

  1. Finance & Accounting Professionals
  2. Financial & Business Analysts
  3. Market Research Analyst
  4. Investment Analysts
  5. HR Professionals
  6. Sales Professionals
  7. Financial Analysts
  8. Chief Financial Officers
  9. Budgeting and planning specialists
  10. Accountants
  11. Financial government officials
  12. Marketing officers
  13. Insurance specialists
  14. Credit analysts
  15. Engineers
  16. Treasury
  17. Chief Executive Officers
  18. Internal auditors
  19. Venture capitalists
  20. Corporate finance analysts
  21. Risk managers
  22. Investment bankers
  23. Strategic planners
  24. Trustees
  25. Compliance officers
  26. Management consultants
  27. Bank lending officers
  28. Compliance officers
  29. Management consultants
  30. Corporate Finance lawyers

PREREQUISITES

Student need to bring a Laptop which has Microsoft Power BI installed. Power BI is currently only compatible with PC/Windows (not available for Mac). https://powerbi.microsoft.com/en-us/get-started/

There are no prerequisites for this Power BI Course – it is open and accessible to all individuals that wish to enhance their knowledge of Microsoft Power BI.

KEY TAKEAWAYS

  1. Ability to work with huge separate databases
  2. Combine data from different sources
  3. Create visually appealing analytical models
  4. You will finally start to get value from the huge data available to your organization

Related Courses