Power BI is quickly becoming the world’s most powerful self-service business intelligence platform, & 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.
Module 1:
USING DAX MEASURES AND CALCULATED COLUMNS ADVANCED
• Date & Time Intelligence Formulas
• Logical & Conditional Statements
• Text, Math & Stats Functions
• CALCULATE Function
• Context Transition with CALCULATE
• How to use Calculate and ALL & FILTER Functions
• SWITCH / SWITCH (TRUE) Function
• How to calculate Percentage of Parent with ALL Function
• ALL SELECTED / TOPN / SELECTEDVALUE
• How to use ALLEXCEPT Function
• DAX Iterators (SUMX, AVERAGEX, MINX, MAXX)
• What is CONCATENATEX
• Name of bestselling product with CONCATENATEX
• How to use RANKX Function
• Use VALUES to get distinct values from a column or Table
• Uses of SELECTEDVALUE function
Module 2:
DESIGN INTERACTIVE REPORTS
• Adding Objects & Charts
• Formatting & Filtering Options
• Slicers, Timelines, Cards & KPIs, Map Visuals
• (Basic, Fill, ArcGIS),
• Tree maps, Lines, Areas & Gauges
• Using Decomposition tree, Key Influencer Visual and Q&A with
• Power BI
• Visual Interactions and Navigation tips
• Advanced visualization tips and tricks
Module 3
POWER BI SERVICE
• Introduction to Power BI Service
• How to use and create Workspaces in Power BI
• Reports Vs Dashboards
• Creating Dashboards in Power BI
• How to use Analyze in Excel Feature
• Share reports with Colleagues
• Export Power BI reports to Power point and PDF.
• Intro to Data Gateways and Schedules Refreshes
Pre-Requisites
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).
Visit https://powerbi.microsoft.com/en-us/get-started/ for software.
There are no prerequisites for this Power BI Course - it is open and accessible to all individuals that wish to enhance their knowledge of Power BI.
