WHY POWER BI?

Power BI helps Business Analysis, Business Intelligence Manager, Statisticians & Analysts, Project Managers and Data scientists to visualize and share insights from their organizations’ data.

It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information from technology staff or database administrator.

Power BI provides cloud-based BI services - known as Power BI Services, along with a desktop-based interface - called Power BI desktop. It offers Data modelling capabilities, including data preparation, data discovery and interactive dashboards.

Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc., Brillio and over 45,000 MNCs across 185 countries use Power BI. These are a few of the reasons why Microsoft Power BI Training comes in handy.

WORKSHOP GOALS

Microsoft Power BI Training is designed to make you a Certified Power BI Practitioner. After completing this Microsoft Power BI Training course, you should be able to:

• Work with Power BI, Power Pivot, Power View
• Work with Power BI Desktop and Power Query
• Use common DAX
• Work with Power BI Q&A and Data insights
• Create real-time dashboards
• Publish reports/dashboards and share them with others
• In-class projects

WHO SHOULD ATTEND?

• Head of supply chain
• Head Business planning and developing
• Head of Financial Planning and Analysis
• Head of sales and Marketing
• Head of IT
• Business Analysts
• Project Managers
• Finance
• Market Analysts
• Reporting Managers
• Data Analysts

COURSE OUTLINE AND INTRODUCTION OF POWER BI:

This module will introduce you to Power BI, its Building Blocks and the various fundamental concepts of Power BI.

Topics:

• Overview of BI concepts
• Why we need BI?
• Introduction to SSBI
• SSBI Tools
• Why Power BI?
• What is the Power BI?
• Building Blocks of Power BI
• Getting started with Power BI Desktop

Hands-On:

• Explore Power BI Desktop
• First Report on Power BI Desktop

This module will introduce you to Power BI Desktop, extract data from various sources and establish connections with Power BI Desktop, perform Transformation operations on data and know the Role of Query Editor in Power BI.

Topics:

• Power BI Desktop
• Extracting data from various sources
• Workspaces in Power BI
• Data Transformation
• Measures and Calculated Columns
• Query Editor

Hands-On:

• Import Data
• Data Transformation
• Using Query Editor

This module will help you understand the relationships between data tables, and you will learn the following - DAX Calculation Types, DAX Functions for Advanced Calculations, Time Intelligence Functions, Variables in DAX expressions and Table Relationships in DAX

Topics:

• Modelling Data
• Manage Data Relationship
• Optimize Data Models
• What is DAX?
• Data Types in DAX
• Calculation Types
• DAX Functions
• Measures in DAX

Hands-On:

• Create relationships
• Calculated Columns
• Data Types in DAX
• Explore DAX Functions such as Aggregation, Counting, Logical, Information, Text
• Creating a Calculated Measure
• Time Intelligence Functions

This module will help you understand the benefits of Data Visualization, Best Practices of Data Visualization, Power BI Desktop Visualization, Custom Visuals in Power BI, Formatting Visuals and create Charts and other Visualization items in Power View

Hands-On Topics:

• How to use Visual in Power BI?
• Charts in Power BI
• Matrixes and tables
• Slicers
• Map Visualizations
• Gauges and Single Number Cards
• What Are Custom Visuals?
• Data Binding

This module covers Power BI Q&A which is currently available as part of the Power BI for Office 365 Preview. You will also learn about Dashboards, Reports, Tiles Quick Insights and Power Publisher.

Topics:

• Why Dashboard?
• Dashboard vs Reports
• Creating Dashboards
• Configuring a Dashboard: Dashboard Tiles, Pinning Tiles
• Power BI Q&A
• Quick Insights in Power BI

Hands-On:

• Explore Power BI Q&A
• Creating a Dashboard
• Pinning a Tile to a Dashboard
• Run Quick Insights on a Dataset
• Pin a range to a Dashboard
• Connect to Power BI Data in Excel

Download