Power BI Training
Power BI Course
The top Power BI training institute in Hyderabad, Hike Letter, provides thorough instructor-led online and self-paced video-based training on Power BI. This 20-hour program is tailored to Power BI 10.0 (and newer) features and assists in obtaining the Microsoft Certified: Power BI Data Analyst Associate (Exam PL-300) certification. The training will revolve around five real-world industry use cases and projects, preparing you for interviews and positioning you as an ideal candidate for Power BI Analyst and Data Warehouse Expert roles.
About your Microsoft Power BI Certification Training Course
Power BI Skills Covered
Desktop Layout
Data Transformation
DAX Commands
Charts and Page Layout
Reports and Dashboards
Advanced Analytics
Instructor-led Microsoft Power BI live online Training Schedule
| MAY 16 | WeekEnd | SAT & SUN (5.5 Weeks) | 07:00 AM to 10:00 AM (IST) ORIENTATION CLASS | |
| MAY 18 | iuwegu | MON – FRI (15 Days) | 07:00 AM to 09:00 AM (IST) CLASS 1 | |
| OCT 07th | WeekEnd | SAT & SUN (5 Weeks) | 08:30 PM to 11:30 PM (IST) CLASS 1 | |
| OCT 09th | iuwegu | MON – FRI (15 Days) | 08:30 PM to 10:30 PM (IST) CLASS 1 |
| MAY 16 WeekEnd | SAT & SUN (5.5 Weeks) 07:00 AM to 10:00 AM (IST) ORIENTATION CLASS | |
| MAY 18 | MON – FRI (15 Days) 07:00 AM to 09:00 AM (IST) CLASS 1 | |
| MAY 07th WeekEnd | SAT & SUN (5 Weeks) 08:30 PM to 11:30 PM (IST) CLASS 1 | |
| MAY 09th | MON – FRI (15 Days) 08:30 PM to 10:30 PM (IST) CLASS 1 |
Price 17,795 16,015
Online Self Learning Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You’ll learn through videos, PPTs and complete assignments, projects and other activities designed to enhance learning outcomes, all at times that are most convenient to you.
Starts at
Talk to our training advisor
Power BI Course Content
Hike Letter offers an extensive program that centers on maximizing the value of organizational data assets, data repositories, and data processes, whether they are located on-premise or in the cloud, through the use of Power BI. Our curriculum covers crucial topics for practical applications in the business intelligence (BI) industry, such as developing scalable data models and creating visualizations and reports to derive valuable insights from data. To enhance your learning experience, we provide a variety of learning materials, hands-on exercises, and dedicated lab sessions that allow you to practice and master the skills acquired during the Power BI training.
Power BI Course Syllabus
Curriculum Designed by Experts
Topics:
- Introduction to Business Intelligence
- Self-Service Business Intelligence (SSBI)
- Introduction to Power BI
- Traditional BI vs. Power BI
- Power BI vs. Tableau vs. QlikView
- Uses of Power BI
- The Flow of Work in Power BI
- Working with Power BI
- Basic Components of Power BI
- Comparison of Power BI Version
- Introduction to Building Blocks of Power BI
- Data model and importance of Data Modeling
Hands-on:
- Installation of Power BI
Skills You will Learn:
- Concepts of Business Intelligence
- Power BI installation
Topics:
- Data Sources in Power BI Desktop
- Loading Data in Power BI Desktop
- Views in Power BI Desktop
- Query Editor In Power BI
- Transform, Clean, Shape, and Model Data
- Manage Data Relationship
- Editing a Relationship
- Cross Filter Direction
- Saving Workfile
- Measures
Hands-on:
- Data Cleaning using Power BI query editor
- Creating Measures
- Transform, Clean, Shape, and Model Data for further analysis
Skills You will Learn:
- Data transformation using the query editor
- Shaping data with measures
- Managing Data Relationships
Topics:
- Introduction to DAX
- Importance of DAX
- Data Types in DAX
- DAX Calculation Types
- Steps to Create Calculated Columns
- Measures in DAX
- DAX Syntax
- DAX Functions
- DAX Operators
- DAX Tables and Filtering
Hands-on:
- Creating Calculated Columns and Measures
- Performing Data Analysis using DAX
Skills You will Learn:
- Data Analysis using DAX
- Creating Calculated Measures and Columns
Topics:
- Introduction to Visuals In Power BI
- Visualization Charts in Power BI
- Matrixes and Tables
- Slicers and Map Visualizations
- Gauges and Single Number Cards
- Modifying Colors in Charts And Visuals
- Shapes, Text Boxes, and Images
- Custom Visuals
- Page Layout and Formatting
- Bookmarks and Selection Pane
- KPI Visuals
- Z-order
- Grouping and Bining
Hands-on:
- Creating different visuals
- Creating cards, measures, KPI, reference line, and slicers
Skills You will Learn:
- Visuals in Power BI
- Report creation
- Visuals modification
- Z-order and KPI in visuals
Topics:
- Introduction to Power BI Service
- Creating a Dashboard
- Quick Insights in Power BI
- Configuring a Dashboard
- Power BI Q&A
- Ask Questions about your Data
- Power BI Embedded
- Bookmarks and buttons
Hands-on:
- Creating reports and dashboard
- Publishing reports on Power BI Service
- Using Power BI Service for operations on reports
Skills You will Learn:
- Report and dashboard creation
- Designing stories with dashboards
Topics:
- Data Sources Supported in Power BI
- Exploring Live Connections to Data Sources
- Connecting Directly to SQL Azure
- Connecting Directly to SQL Server Analysis Services/My SQL
- Import Power View and Power Pivot
- Data Gateways
- Direct Query vs. Import Connectivity modes
- Connecting Power BI in Excel
Hands-on:
- Setting Up On-Premise Data Gateway
- Connecting Power BI with SQL Server Database
- Connecting Reports on Power BI Service with Local Data Files
Skills You will Learn:
- On-Premise Data Gateway
- Connecting Power BI with Databases
- Connecting Power BI Service with Local Data Sources
Topics:
- What is Power BI Report Server?
- Key Features of Report Server
- The architecture of the Report Server
- Limitations of Report Server
- Power BI Report Server vs. Power BI Service
- Acquiring and Installing Power BI Report Server
- What is a Web Portal?
- Paginated Reports
- Row Level Security
Hands-on:
- Setting Up Power BI Report Server
- Using Power BI Report Server for Publishing Reports
- Implementing Row Level Security
Skills You will Learn:
- Power BI Report Server
- Publishing reports on Report Server
Topics:
- Brief concepts about R
- R Programming Concepts
- Create R Scripts for BI
- Python Programming
- Python Scripts in BI
- Python integration with Power BI
Hands-on:
- Demonstrate connecting R and Python in Power BI
- Using R and Python for data analysis
Skills You will Learn:
- Data cleaning and transformation
- Python and R scripts
- Power BI integration
Topics:
- Use Parameters
- Create a data flow
- Introduction to Anomaly Detection
- Introduction to Smart Narrative
- Introduction to Sensitivity labels in Power BI
- Deployment Pipeline
Hands-on:
- Connecting with Power BI service
- Creating dataflow
- Creating scorecard
Skills You will Learn:
- Data flow creation
- Anomalies detection
- Smart Narrative implementation
Topics:
- Power BI Service
- Row Level Security
- Visuals and Charts
- Power BI Desktop
- Handling Workspaces
Hands-on:
- Analyze store data
- Draw conclusions from visuals created
Skills You will Learn:
- Sales Reports creation
- Interactive Dashboards creation
Free Career Counselling
We are happy to help you 24/7
Other Courses
PMP training
This PMP training is hands-on and gives you extensive knowledge of basic and advanced project management concepts.
Pharmaceutical Training
Hike Letter offer a wide range of highly praised and respected classroom and online training courses
Power BI Training
Learn new skills with Microsoft Power BI training. Our hands-on guided learning approach helps you learn & meet your goals.
Realistic experience with real time project scenarios
saad
Task and assignments during the sessions
saad
