Microsoft Power BI
Our Power BI training course lets you master the Microsoft Power BI tool. We provide the best online training classes to help you learn Power BI architecture, Desktop, Service, Mobile Apps, Visualizations, Reports and deriving business insights. As part of this program, you will work on real-world projects.
KEY FEATURES
30 Hrs Instructor Led Training
Pay in 2 Installments
Certification & Job Assistance
Flexible Schedule
ONLINE TRAINING OBJECTIVES
- Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.
- 70% of leading companies say that analytics is integral to how they make decisions – IBM Survey
- A Senior Business Intelligence Analyst can earn $89,000 in the United States – Payscale.com
Today, all business enterprises and departments need extensive business insights, and Power BI puts the power in your hands. You can easily work with multiple sources of data, convert it into a report, graph or data visualization of your choice. By deploying Power BI, you get real-time insights and deploy it faster than any other BI tool available in the market. It is open source and highly intuitive and does not need technical knowledge or IT support. This training will prepare you for the top paying jobs in the market and help you grow your career at a rapid pace.
- Individuals looking for jobs as Business Analysts, Business Development Manager, etc.
- Statisticians aiming to implement their statistics skill to derive business insights
- Marketing, Finance, Sales, and other domain Professionals who need extensive business intelligence
- Get an in-depth understanding of Power BI and how it works in different scenarios
- Three vital components: Desktop, Service and Mobile apps
- Visualize and analyze data and derive insights from Excel spreadsheet or local database
- Create compelling reports and visualizations, derive real-time insights and deploy it on demand
- Create, share, collaborate and benefit from business information with purpose-built dashboards
- Get the work done without being a Business Intelligence professional
- Use Salesforce Data, Azure SQL Database and SQL server analysis tabular data
- Deploy content packs to work with Quick Books online and Adobe analytics
- Work on live projects on Power BI to get hands-on experience
Power BI Course Content
1.1 Introduction to Microsoft Power BI
1.2 The key features of Power BI workflow
1.3 Desktop application
1.4 BI service
1.5 File data sources
1.6 Sourcing data from web (OData, Azure)
1.7 Building dashboard
1.8 Data visualization
1.9 Publishing to cloud
1.10 DAX data computation
1.11 Row context
1.12 Filter context
1.13 Analytics Pane
1.14 Creating columns and measures
1.15 Data drill down and drill up
1.16 Creating tables
1.17 Binned tables
1.18 Data modeling and relationships
1.19 The Power BI components like Power View, Map, Query, Pivot
1.20 Power Q & A
1.21 Understanding advanced visualization
Hands-on Exercise –
- Demo of building a Power BI dashboard
- Source data from web
- Publish to cloud
- Create power tables
2.1 Learning about Power Query for self-service ETL functionalities
2.2 Introduction to data mashup
2.3 Working with Excel data
2.4 Learning about Power BI Personal Gateway
2.5 Extracting data from files, folders and databases
2.6 Working with Azure SQL database and database source
2.7 Connecting to Analysis Services
2.8 SaaS functionalities of Power BI
Hands-on Exercise –
- Connect to a database
- Import data from an excel file
- Connect to SQL Server
- Analysis Service
- Connect to Power Query
- Connect to SQL Azure
- Connect to Hadoop
3.1 Installing Power BI
3.2 The various requirements and configuration settings
3.3 The Power Query
3.4 Introduction to Query Editor
3.5 Data transformation – column, row, text, data type, adding & filling columns and number column, column formatting, transpose table, appending, splitting, formatting data, Pivot and UnPivot, Merge Join, relational operators, date, time calculations, working with M functions, lists, records, tables, data types, and generators
3.6 Filters & Slicers
3.7 Index and Conditional Columns
3.8 Summary Tables
3.9 Writing custom functions and error handling
3.10 M advanced data transformations
Hands-on Exercise –
- Install PowerBI Desktop and configure the settings
- Use Query editor
- Write a power query
- Transpose a table
4.1 Introduction to Power Pivot
4.2 Learning about the xVelocity engine
4.3 Advantages of Power Pivot
4.4 Various versions and relationships
4.5 Strongly typed datasets
4.6 Data Analysis Expressions
4.7 Measures, Calculated Members, Row, Filter & Evaluation Context, Context Interactions, Context over Relations, Schema Relations
4.8 Learning about Table, Information, Logical, Text, Iterator, Table, and Time Intelligence Functions
4.9 Cumulative Charts, Calculated Tables, ranking and rank over groups
4.10 Power Pivot advanced functionalities
4.11 Date and time functions
4.12 DAX advanced features
4.13 Embedding Power Pivot in Power BI Desktop
Hands-on Exercise –
- Create a Power Pivot Apply filters
- Use advanced functionalities like date and time functions
- Embed Power Pivot in Power BI Desktop
- Create DAX queries for calculate column, tables and measures
5.1 Deep dive into Power BI data visualization
5.2 Understanding Power View and Power Map
5.3 Power BI Desktop visualization
5.4 Formatting and customizing visuals
5.5 Visualization interaction
5.6 SandDance visualization
5.7 Deploying Power View on SharePoint and Excel
5.8 Top down and bottom up analytics
5.9 Comparing volume and value-based analytics
5.10 Working with Power View to create Reports, Charts, Scorecards, and other visually rich formats
5.11 Categorizing, filtering and sorting data using Power View
5.12 Hierarchies
5.13 Mastering the best practices
5.14 Custom Visualization
5.15 Authenticate a Power BI web application
5.16 Embedding dashboards in applications
Hands-on Exercise –
- Create a Power View and a Power Map
- Format and customize visuals
- Deploy Power View on SharePoint and Excel
- Implement top-down and bottom-up analytics
- Create Power View reports, Charts, Scorecards
- Add a custom visual to report
- Authenticate a Power BI web application
- Embed dashboards in applications
- Categorize, filter and sort data using Power View
- Create hierarchies
- Use date hierarchies
- Use business hierarchies
- Resolve hierarchy issues
6.1 Introduction to Power Q & A
6.2 Intuitive tool to answer tough queries using natural language
6.3 Getting answers in the form of charts, graphs and data discovery methodologies
6.4 Ad hoc analytics building
6.5 Power Q & A best practices
6.6 Integrating with SaaS applications
Hands-on Exercise –
- Write queries using natural language
- Get answers in the form of charts, graphs
- Build ad hoc analytics
- Pin a tile and a range to dashboard
7.1 Getting to understand the Power BI Desktop
7.2 Aggregating data from multiple data sources
7.3 How Power Query works in Power BI Desktop environment
7.4 Learning about data modeling and data relationships
7.5 Deploying data gateways
7.6 Scheduling data refresh
7.7 Managing groups and row level security, datasets, reports and dashboards
7.8 Working with calculated measures
7.9 Power Pivot on Power BI Desktop ecosystem
7.10 Mastering data visualization
7.11 Power View on Power BI Desktop
7.12 Creating real world solutions using Power BI
Hands-on Exercise –
- Configure security for dashboard Deploy data gateways
- Aggregate data from multiple data sources
- Schedule data refresh
- Manage groups and row level security, datasets, reports and dashboards
- Work with calculated measures
8.1 Analyzing Data with Power BI
Frequently asked questions
The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.
In case you are not able to attend any lecture, you can view the recorded session of the class in Icronix . To make things better for you, we also provide the facility to attend the missed session in any other live batch.
The trainer is a certified consultant and has significant amount of experience in working with the technology.
Yes, we accept payments in two installments.
If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.