+91 72087 69880 info@landdedutech.com
Follow us:
POWER BI

Power BI Duration : 12Hrs

Module 1 : INTRODUCTION TO POWER BI

  • Power BI – Advantages and Scalable Options
  • Power BI Data Source Library and DW Files
  • Cloud Colloboration and Usage Scope
  • Power BI Installation and Cloud Account
  • Power BI Cloud and Power BI Service
  • Power BI Architecture and Data Access

Module 2 : CREATING POWER BI REPORTS, AUTO FILTERS

  • Report Design with Legacy & .DAT Files
  • Report Design with Databse Tables
  • Understanding Power BI Report Designer
  • Report Canvas, Report Pages: Creation, Renames
  • Report Visuals, Fields and UI Options
  • Experimenting Visual Interactions, Advantages
  • Reports with Multiple Pages and Advantages
  • Pages with Multiple Visualizations. Data Access
  • PUBLISH Options and Report Verification in Cloud
  • “GET DATA” Options and Report Fields, Filters
  • Report View Options: Full, Fit Page, Width Scale

Module 3: Report Design using Databases & Queries

  • Query Settings and Data Preloads
  • Navigation Options and Report Refresh
  • Stacked bar chart, Stacked column chart
  • Clustered bar chart, Clustered column chart
  • Adding Report Titles. Report Format Options
  • Focus Mode, Explore and Export Settings

 

Module 4 : REPORT VISUALIZATIONS and PROPERTIES

  • Power BI Design: Canvas, Visualizations and Fileds
  • Import Data Options with Power BI Model, Advantages
  • Direct Query Options and Real-time (LIVE) Data Access
  • Data Fields and Filters with Visualizations
  • Visualization Filters, Page Filters, Report Filters
  • Conditional Filters and Clearing. Testing Sets
  • Creating Customised Tables with Power BI Editor
  • General Properties, Sizing, Dimensions, and Positions
  • Alternate Text and Tiles. Header (Column, Row) Properties
  • Grid Properties (Vertical, Horizontal) and Styles
  • Table Styles & Alternate Row Colors – Static, Dynamic

Module 5: CHART AND MAP REPORT PROPERTIES

  • chart report types and properties
  • stacked bar chart, stacked column chart
  • clustered bar chart, clustered column chart
  • 100% stacked bar chart, 100% stacked column chart
  • line charts, area charts, stacked area charts
  • line and stacked row charts, Data Labels: Visibility, Color and Display Units

Module 6 : DAX EXPRESSIONS

  • Purpose of Data Analysis Expresssions (DAX)
  • Scope of Usage with DAX. Usabilty Options
  • DAX Context : Row Context and Filter Context
  • DAX Entities : Calculated Columns and Measures
  • DAX Data Types : Numeric, Boolean, Variant, Currency
  • Datetime Data Tye with DAX. Comparison with Excel
  • DAX Operators & Symbols. Usage. Operator Priority
  • Parenthesis, Comparison, Arthmetic, Text, Logic
  • DAX Functions and Types: Table Valued Functions