POWER BI

The Analytics segment is a fast changing domain in the IT industry and needs to be in pace with the current trends. At Radical we ensure to keep in pace with the top 3 Analytical tools in the market as per the Gartner study so that the niche availability of resources remain under your belt and the opportunities to explore the BI world remains open at any point of time.

2567 Satisfied Learners
One time class room registraion to click here Fee 1000/-

Online training batch schedules:

Mode Day/Duration Start Date End Date ₹ Price Book Seat
Online 8 Weeks, 1 Day 03/01/2018 28/02/2018 ₹ 15000.00 Enroll Now

Best Training in Power BI

Highly Experienced Trainers from Industry

Projects + Realtime Scenarios+ Assignments

Pre-Requisite coverage:

  • Introduction to Business Intelligence
  • Understanding Table structure and schema modelling
  • Introduction to Basic SQL
  • Concepts of Analysis (Trend Analysis,What-if, As is, predictive)
  • Data Aggregations ,groupings and drill downs

Course Syllabus

Data Transformations:

  • Introduction to Power BI Desktop
  • Changing Locale
  • Connecting to a Database
  • Basic Transformations
  • Managing Query Groups
  • Splitting Columns, Changing Data Types, Working with Dates
  • Removing and Reordering Columns
  • Conditional Columns
  • Merge Queries
  • Query Dependency View
  • Transforming Less Structured Data
  • Query Parameters

Data Modelling:

  • Managing Data Relationships
  • Creating Calculated Columns
  • Optimizing Models for Reporting
  • Creating Calculated Measures
  • Creating and Managing Hierarchies
  • Using Calculated Tables
  • Time Intelligence
  • Include and Exclude features
  • Grouping and Binning

Visualizing your Data:

  • Introduction to charts: Pie, Tree map, Combo charts, Map Visualizations, Scatter plot, Table, Matrix, Gauge, Card, Shapes, Textboxes, Images and KPI
  • Filter (Including TopN), Date Slicer
  • Coloring Charts
  • Page Layout, Positioning, Aligning, Sorting Visuals and Formatting
  • Visual Relationship
  • Custom Hierarchies

Working with PBI Service:

  • Overview of Dashboards and Service
  • Uploading to Power BI Service
  • Configuring a Dashboard
  • Dashboard Settings
  • In-Focus Mode
  • Pinning a Live Page
  • Custom URL and Title
  • Export to CSV and Excel
  • Power BI Notifications
  • Publishing to Web

Working with Excel:

  • Importing Excel Data using Simple Table
  • Connecting to Excel Workbook on OneDrive for Business
  • Pinning Excel Tables or Visuals

Organization Packs, Security and Groups:

  • Creating a Group
  • Creating, Using and Editing a Content Pack
  • Row Level Security
  • Data Classification
  • Creating and Using Custom Visuals

Power BI being just a 2 year old technology does not has a certification as of yet. Going forward depending on the customer base and implementation they plan to launch their certification. But after the course you will be in a good shape to do the ELT and designer certification by knowing the insights of PowerBI.

The trainer has 10+ years of experience into Business Intelligence blended with Data Analytics and real time BI implementations of Banking,Retail and Pharma domain which implement BI on a very high scale. Along with the industrial experience he carries a suite of different use cases in the industry and their solutions as a part of the training. The past candidates have successfully been able to grasp the tool after being taught and keep receiving solutions for existing problems in the Real time experience and bond shared by the trainer.

Radical believes in giving Quality to their candidates by gelling up the real time industry experience shared by the trainers. We believe in taking the tour of the technology to a deep level assuming that it provides value in the long rum to its students and they keep up a good bond with the institute and the trainer in their long journey. Swift responses to queries, Alternate solutions to problems and real time use cases of business makes it unique as a training institute.

The next path after PowerBI would be to gradually implementing it in the domain of information design and bring all your excel driven analytics over the dashboards of PBI. Gradually with Microsoft investing into NLP you will be able to code DAX and integrate with ‘R’ to create your story telling reports and dashboards.

Our Courses

Drop A Query