TRAINING

Enroll Now

Microsoft POWER BI Training

Power BI is a powerful cloud-based suite of business analytics tools that make it easy to combine data from multiple sources, analyze and visualize information and share insights.

This course features easy drag and drop report authoring for advanced insights, and online web dashboards that update automatically and can be shared within seconds.

You begin by learning about architecture and components of Power BI along with Power Query and Power Pivot. You will learn about Data Visualization with Power BI Desktop, Power View and Power Map. Along with the process of visualization, you will learn about Power BI Q&A and how the users can discover, explore and visualize their own enterprise. You will be introduced to the Power BI Administration for deployment of files and building dashboards in the Power BI.

United Global Soft brings you a comprehensive Power BI training course that is a perfect introduction for you into the world of BI. You will learn the basics of Power BI such as the Power BI desktop, and how to connect to data using Power BI desktop. Our expert trainers will then familiarize you with the rich components that drive this tool such as Modelling, Visualizations, exploring data with the dashboard, working with Excel, publishing and sharing data and the DAX functionality. Enrol for the Power BI course now and master the powerful capabilities of BI. Moreover, you will get access to the reference materials after registering.

What you will learn from our Training:

1. About BI and how it will transform data and business
2. About the Power BI desktop and managing and utilizing data with it
3. Connecting data from different sources and data modelling with Power BI desktop
4. How to custom create data visualizations and style reports for lucid data representation
5. The working of Power BI and Excel
6. How to share and collaborate with data with Power BI
7. Power BI Data Analysis Expression(DAX), and its functions

Prerequisites

Participants are expected to have an understanding of how data works and how it can contribute to building a business to attend the Power BI training classes.

Microsoft Power BI Course Outline

Introduction to Power BI

• What is Power BI?
• The Power BI service
• Power BI Report Server
• Power BI Desktop
• Reports and Dashboards
• Datasets
• Row-Level Security
• Content Packs
• Natural Language Queries

Data Sources

• Connecting to Files
• Importing Excel Files
• Publishing to Power BI from Excel
• Updating Files in Power BI
• Data Refresh
• The Power BI Data Model
• Managing Data Relationships
• Optimising the Model for Reporting
• Hierarchies
• SQL Servers
• Other Data Sources
• R Script Data Connector
• Configuring Data for Q& A
• Creating Content Packs
• Creating a Group

Shaping and Combining Data

• The Query Editor
• Applied Steps
• Advanced Editor
• Shaping Data
• Formatting Data
• Transforming Data
• Combining Data
• Merging Data

Modelling Data

• What are Relationships?
• Viewing Relationships
• Creating Relationships
• Cardinality
• Cross Filter Direction
• What is DAX?
• Syntax
• Functions
• Context
• Calculated Columns
• Calculated Tables
• Measures

Interactive Data Visualisations

• Power BI Reports: Page Layout and Formatting
• Multiple Visualisations
• Creating Charts
• Using Geographic Data
• Histograms
• Power BI Admin Portal
• Service Settings
• Desktop Settings
• Dashboard and Report Settings