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.
PROJECT BASED POWERBI TRAINING FOR DATA ANALYSIS
Power BI Online Training with Job Support
Duration of Training : 32 hrs
Batch type : Weekdays/Weekends
Mode of Training : Classroom/Online/Corporate Training
Power Bi Training & Certification in Pune
Highly Experienced Trainer with 10+ yrs Exp. in Industry
Realtime Projects, Scenarios & Assignments
- 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 CONTENT
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
Related Combo Programs :
SQL + Informatica + Power BI
SQL + Informatica + Tableau
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.
