Course Curriculum

Microsoft Power BI Course Content

Module 1 - Power BI Complete Introduction

• Power BIIntroduction
• Data Visualization,Reporting
• Business Intelligence(BI), Traditional BI, Self-ServicedBI
• Cloud Based BI, On PremiseBI
• Power BIProducts
• Power BI Desktop (Power Query, Power Pivot, PowerView)
• Flow of Work in Power BIDesktop

Module 2 - PBI Desktop Installation, PBI Desktop & Service Overview

• Power BI Desktop Installation
• Building Blocks of PowerBI
• Datasets, Visualizations, Reports, Dashboards,Tiles
• Power BI Desktop User Interface
• Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab,Canvas
• Overview of Power Query / Query Editor – Extract, Transform & LoadData
• Connecting to Data Sources, Establish connection to the Excelsource
• Importing Data into Power BI or QueryEditor
• Transforming the Data using PowerQuery
• Model the Data using Power Pivot – Relationship / ModelView
• Visualizing the Data using Power View and Power Maps – ReportView
• Saving the visuals or reports

Module 3 –Power Query

• Introduction to Power Query – Extract, Transform & Load
• Datatypes and filters in Power Query
• Inbuilt column transformations
• Inbuilt row transformations
• Combine queries (append queries & merge queries)
• Merge queries / Join queries
•  

Module 4 –Power Pivot

• Power BI data modeling – relationship view
• Enhancing the Data Model – DAX
• DAX functions categories
• DAX date & time functions
• DAX text functions
• DAX Logical functions
• DAX math and statistical functions
• DAX filter functions
• DAX time intelligence functions

Module 5 –Power View

• Report View / power view
• Filters in Power View
• Grouping, Binning & sorting
• Hierarchies and drill-down reports
• Power BI visualizations
• Visuals for filtering
• Visualizing categorical data
• Visualizing trend data
• Visualizing KPI data
• Visualizing Tabular Data, Geographical Data

Module 6 - Power BI Service

• Power BI Service Introduction, Power BI CloudArchitecture
• Creating Power BI Service Account, SIGN IN to Power BI ServiceAccount
• Publishing Reports to the Power BI service, Import / Getting the Report to PBI Service
• My Workspace / App WorkspacesTabs
• DATASETS, WORKBOOKS, DATAFLOWS, REPORTS,DASHBOARDS
• Working with Datasets, Creating Reports in Cloud using PublishedDatasets
• Power BI Datasets Live Connection usingDesktop
• Working with Workbooks, working with Reports, SharingReports

Module 7 - Dashboards Development

• Creating Dashboards
• Pin Visuals and Pin LIVE Report Pages toDashboard
• Advantages of Dashboards
• Interacting withDashboards
• Adding Tiles toDashboards
• Web Content, Image, Text Box,Video
• Formatting Dashboard
• Sharing Dashboard

Module 8 - Data Gateways

• Introduction to Data Gateways
• How Data Gateways work
• Connect to an on premise Data Source by using a DataGateway
• Download Data Gateway
• Installing a Data Gateway
• Types of Gateways

Module 9 - Collaboration in Power BI using App Workspace

• Introduction to AppWorkspaces
• Create an AppWorkspace
• Add Members to App Workspace toCollaborate
• App Workspace Access
• Admin, Member, Contributor,viewer

Module 10 - Sharing Power BI Content using Apps and Content Packs

• Introduction toApp
• Publish anApp
• Update a PublishedApp
• Manage Content inApp
• Include in App, Exclude inApp
• SharingApp
• Entire Organization, Specific individuals orgroup
• Un publishing anApp
• Content Pack Introduction
• Create Content Pack
• Sharing ContentPacks
• Specific Groups, My EntireOrganization
• Selecting the Content / Items to Publish orShare

Module 11 - Row Level Security in Power BI

• Introduction to Row Level Security
• Row Level Security (RLS) with DAX
• Manage Roles, Creating Roles, Testing Roles
• Adding Members to Roles in Power BI Service
• Dynamic Row Level Security
• Creating Users Table and Adding to the Model
• Capturing users using User Name () or UserPrincipalName () DAXFunctions

Module 12 - ADD ON

• Real-time Project Explanation
• Resume Preparation
• Interview Questions Discussions
• Mock Interviews
• Day to Day Tasks
• Trouble Shooting

Exam & Certification

• Once you complete this master’s program, you will receive the course completion certificate by ICIT

ICIT Course Completion Certificate will be awarded upon the completion of the project work (after the expert review) and upon scoring at least 50% marks in the quiz. ICIT certification is well recognized in top  MNCs .

Who should attend?

• Business Analysts
• Business Intelligence Manager
• Statisticians and Analysts
• Data Scientists
• Project Manager

FAQ's

1. What is the Microsoft Power BI service?

The Power BI service is a cloud-based business analytics service that enables anyone to visualize and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of cloud-based and on-premises data through easy-to-use dashboards, interactive reports, and compelling visualizations that bring data to life.

2. What is the Microsoft Power BI service for consumers?

The way you interact with Power BI will depend on your job role. As an end user or consumer, you are the person who receives content (dashboards, reports, and apps) from colleagues. You work in the online or mobile version of Power BI, which is called the Power BI service, reviewing and interacting with this content, to make business decisions.

3. What's the difference between Power BI Pro and Power BI Premium?

Power BI Pro is an individual user license that allows access to all content and capabilities in the Power BI service. You can even share content and collaborate with other Pro users. Only Pro users can publish content to workspaces, share dashboards, and subscribe to dashboards and reports. This type of license is typically assigned to Power BI report designers, developers, and administrators.

Power BI Premium provides dedicated capacity to deliver more consistent performance. It also supports larger data volumes in Power BI. For individual users, Premium enables widespread distribution of content by Pro users and it doesn't require per-user Pro licenses for recipients viewing the content. This means that consumers can collaborate with colleagues and view and interact with dashboards, reports, and apps that have been shared with them.

4. What is Power BI Desktop?

Power BI Desktop is a free application you can install right on your own computer. Power BI Desktop works cohesively with the Power BI service. Data scientists, report designers, admins, and developers work with Power BI Desktop to produce reports and make them available to the Power BI service consumers, like you.

5. Does Power BI support mobile devices?

Yes. Power BI has native apps for Android phones and tablets, iOS devices, and Windows 10 devices. Download one of the Power BI mobile apps from its respective store:

• Apple App Store
• Google Play
• Windows Store

6. What do I need to install to use Power BI?

To use the Power BI service for free, you just need a Web browser and email.

You can download the Power BI mobile apps from their respective stores, also for free:

• App Store
• Google Play
• Windows Store