POWER BI

POWER BI Course Overview

Online Guru Technologies’s Power BI training running with industry experts  according to industry requirements and demands.

This training helps you crack the interview and clear the certification as well.

Here you will get all class videos lifetime access.

Even after completion of course 24/7 support is provided for clearing interviews and certification.

By the end of the course a separate class is scheduled for interview questions and answers.

Online Guru Technologies will provide a platform to work for real time projects.

CHAPTER 1 : INTRODUCTION TO POWER BI (Free Demo)

  • Introduction to Power BI – Need, Imprtance
  • Power BI – Advantages and Scalable Options
  • History – Power View, Power Query, Power Pivot
  • Power BI Data Source Library and DW Files
  • Cloud Colloboration and Usage Scope
  • Business Analyst Tools, MS Cloud Tools
  • Power BI Installation and Cloud Account
  • Power BI Cloud and Power BI Service
  • Power BI Architecture and Data Access
  • OnPremise Data Acces and Microsoft On Drive
  • Power BI Desktop – Instalation, Usage
  • Sample Reports and Visualization Controls
  • Power BI Cloud Account Configuration
  • Understanding Desktop & Mobile Editions
  • Report Rendering Options and End User Access
  • Power View and Power Map. Power BI Licenses
  • Course Plan – Power BI Online Training

CHAPTER 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
  • 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

CHAPTER 3 : 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
  • Sparse, Flashy Rows, Condensed Table Reports. Focus Mode
  • Totals Computations, Background. Boders Properties
  • Column Headers, Column Formatting, Value Properties
  • Conditional Formatting Options – Color Scale
  • Page Level Filters and Report Level Filters
  • Visual-Level Filters and Format Options
  • Report Fields, Formats and Analytics
  • Page-Level Filters and Column Formatting, Filters
  • Background Properties, Borders and Lock Aspect

CHAPTER 4 : 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
  • Line and stacked column charts
  • Waterfall chart, scatter chart, pie chart
  • Field properties: axis, legend, value, tooltip
  • Field properties: color saturation, filters types
  • Formats: legend, axis, data labels, plot area
  • Data labels: precision, position, text options
  • Data labels: visibility, color and display units
  • Analytics: constant line, position, labels
  • Working with waterfall charts and default values
  • Modifying legends and visual filters – options
  • Map reports: working with map reports
  • Hierarchies: grouping multiple report fields
  • Hierarchy levels and usages in visualizations
  • Preordered attribute collection – advantages
  • Using field hierarchies with chart reports
  • Advanced query mode @ connection settings – options
  • Direct import and in-memory loads, advantages

CHAPTER 5 : HIERARCHIES and DRILLDOWN REPORTS

  • Hierarchies and Drilldown Options
  • Hierarchy Levels and Drill Modes – Usage
  • Drill-thru Options with Tree Map and Pie Chart
  • Higher Levels and Next Level Navigation Options
  • Aggregates with Bottom/Up Navigations. Rules
  • Multi Field Aggregations and Hierarchies in Power BI
  • DRILLDOWN, SHOWNEXTLEVEL, EXPANDTONEXTLEVEL
  • SEE DATA and SEE RECORDS Options. Differences
  • Toggle Options with Tabular Data. Filters
  • Drilldown Buttons and Mouse Hover Options @ Visuals
  • Dependant Aggregations, Independant Aggregations
  • Automated Records Selection with Tabular Data
  • Report Parameters : Creation and Data Type
  • Available Values and Default values. Member Values
  • Parameters for Column Data and Table / Query Filters
  • Parameters Creation – Query Mode, UI Option
  • Linking Parameters to Query Columns – Options
  • Edit Query Options and Parameter Manage Entries
  • Connection Parameters and Dynamic Data Sources
  • Synonyms – Creation and Usage Options

CHAPTER 6 : POWER QUERY & M LANGUAGE – Part 1

  • Understanding Power Query Editor – Options
  • Power BI Interface and Query / Dataset Edits
  • Working with Empty Tables and Load / Edits
  • Empty Table Names and Header Row Promotions
  • Undo Headers Options. Blank Columns Detection
  • Data Imports and Query Marking in Query Editor
  • JSON Files & Binary Formats with Power Query
  • JavaScript Object Notation – Usage with M Lang.
  • Applied Steps and Usage Options. Revert Options
  • creating Query Groups and Query References. Usage
  • Query Rename, Load Enable and Data Refresh Options
  • Combine Queries – Merge Join and Anti-Join Options
  • Combine Queries – Union and Union All as New Dataset
  • M Language : NestedJoin and JoinKind Functions
  • REPLACE, REMOVE ROWS, REMOVE COL, BLANK – M Lang
  • Column Splits and FilledUp / FilledDown Options
  • Query Hide and Change Type Options. Code Generation

CHAPTER 7 : POWER QUERY & M LANGUAGE – Part 2

  • Invoke Function and Freezing Columns
  • Creating Reference Tables and Queries
  • Detection and Removal of Query Datasets
  • Custom Columns with Power Query
  • Power Query Expressions and Usage
  • Blank Queries and Enumuration Value Generation
  • M Language Sematics and Syntax. Tranform Types
  • .ELSE Conditions, TransformColumn() Types
  • RemoveColumns(), SplitColumns(),ReplaceValue()
  • Distinct Options and GROUP BY Options
  • Group(), Table.Sort() with Type Conversions
  • PIVOT Operation and Table.Pivot(). List Functions
  • Using Parameters with M Language (Power Query Editor)
  • Advanced Query Editor and Parameter Scripts
  • List Generation and Table Conversion Options
  • Aggregations using PowerQuery & Usage in Reports
  • Report Generation using Web Pages & HTML Tables
  • Reports from Page collection with Power Query
  • Aggregate and Evaluate Options with M Language
  • Creating high-density reports, ArcGIS Maps, ESRI Files
  • Generating QR Codes for Reports
  • Table Bars and Drill Thru Filters

Online Guru Technologies conducting free Power BI demo Classes with Industry experts for clarifying doubts and knowing about course, for attending free demo session Click on the “Schedule Free Demo Session” and Fill the form. Our representative will call you back and they will fix demo session timings according to your convent timings

The Demo sessions are conducting every day 1 Hour Session, the demo session conducting by real-time working professionals.

Call us on +91 - 9886508358

Training class hours – 45


All classes recorded videos


Lifetime access videos


Project classes hours – 10


Everyday support

Related Courses

POWER BI DEMO SESSIONS

7:00 AM-10:00AM - MON TO FRI


7:00 AM-10:00AM - SAT & SUN


CONTACT US


×
WhatsApp chat