About Course :
This course aims at providing deep and comprehensive training on this powerful business analytical tool. Microsoft Power BI Training covers every element and aspect of using, managing and operating this tool. This course is planned keeping in mind the market challenges so that candidates after completion of this course are prepared well to use this tool confidently. You will be provided with all the necessary tools and kits that will help you understand and use this tool better. You will be provided with sample tools and data that will help you practice and master your skills on this tool.
Module of Training
LIVE ONLINE TRAINING
- Live presentation of theory, demonstration of tool, features & tasks
- We are connecting Online via Goto Meeting
- Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern.
CORPORATE TRAINING
- Learn as per day-wise & customized schedule with discussions & lab exercises included
- One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes
- World-class learning material & case studies for the course
- Completely customizable course content & schedule as per convenience
- Certification guidance provided if necessary
Curriculum
Power BI –Â Complete Package
1. Introduction
- Introduction to Power BI
- Components of Power BI
- Installing Power BI Desktop
- Various Options in Power BI Desktop
2. Working with Different Sources (Excel, SQL Server, OData Feed etc.)
- Import
- Direct Query
- Import vs Direct Query
- Limitations of Direct Query
- Query Editor
- Working with Power Query
- Relationships (1:1, 1: Many, Many:1)
3. Reports Development
- Reports Development in Power BI
- Working with Different Visuals
- Formatting Options in Reports
- Working with Filters
- Custom Visuals
4. Power BI Service
- Overview of Power BI Service
- Publishing the Reports
- Dashboards
- Gateways
- Enterprise vs Personal Gateway
- WorkSpaces
- Content Packs
- Apps
- Security
- Schedule Data Refresh
- Power BI Premium
5. SSAS Tabular
- SSAS Tabular Overview
- Install and Configure SSAS Tabular
- Building a Tabular Model
- SSAS Tabular as Source
- Live Connections
- Deploy & Processing in Tabular
- SQL Server Agent
- Schedule Processing of Model
6. Data Analysis Expressions (DAX)
- Introduction to DAX
- Calculated Columns
- Measures
- Calculated Columns vs Measures
- Variables
- Table Functions
- Evaluation Contexts
- Calculate
- Time Intelligence in DAX
- Frequently Used DAX functions in Real-time
- Calendar Functions
7. Advanced/ Other Power BI Concepts
- Parameters
- Drill Through
- Bookmarks
- Row-level Security
- Dynamic Measures
- Dynamic Axis in Charts
- Dynamic Filters
- Power BI Template file
- Wallpapers
- Themes
- Q&A
- Editing the Themes
- Power BI Updates
We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.
Benefits of Certificate
Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.
We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from yashteck. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.