POWER BI
Overview
Power BI can unify all of your organization’s data, whether in the cloud or on-premises. Using the Power BI gateways, you can connect SQL Server databases, Analysis Services models, and many other data sources to your same dashboards in Power BI. It connects users to a broad range of data through easy-to-use dashboards, interactive reports, and compelling visualizations that bring data to life.
Microsoft Power BI has been replaced with a far more powerful version which covers Power BI Desktop, Power BI Pro which combines Power BI Services, and Mobile into a formidable business intelligence and analytics package.
Prerequisites
- Basic knowledge of Microsoft Windows operations systems and its core functionality
- Working knowledge of business data and its relations
Audience
- Students
- Business and Financial Analytics
- Database Administrator
- Data Analyst
- IT Professionals
Course Contents
Module 1
Introducing to Power BI and Its Components
Introduction to Power BI: What is Power BI?
Power BI Desktop: The First Experience
Power BI Website: You’ll Need Just a Web Browser
Introduction to Power BI Components: Power Query, Power Pivot, Power View and Power Map.
Module 2
Connecting to data sources (Databases, CSV & XLS files)
What is Power Query: Introduction to Data Mash-Up Engine of Power BI
Get Started with Power Query: Movies Data Mash-Up
Power BI Get Data From Excel: Everything You Need to Know
Definitive Guide to Power BI Personal Gateway
File Sources
Folder as a Source
Database Sources
Analysis Services Connection
Software as A Source
Module 3
Data Transformation through Power Query
Installation, Requirements, and Configuration
Different versions of Power Query
Power Query Introduction
Query Editor
Transformation GUI
Row Transformations
Column Transformations
Data Type
Adding Column
Text Transformations
Number Column Calculations
Date and Time Calculations
Data types, Lists, Records, and tables in M
Writing Custom Functions
Error handling
Advanced Data Transformations with M
Module 4
Data Visualizations & Modeling
Charts, Scorecards, and other visualization items in Power View Sorting, Filtering, copying, pasting and categorization with Power View Modelling data, and relationships
Creating calculated measures
Power Pivot difference
Visualizing data
Power View difference Custom Visuals Power View for SharePoint
Power View for Excel
Data visualization with Map
Power BI Report Server
Module 5
Sharing and Deployment dashboards
Office 365 Power BI embedded in applications Deployment of files into Power BI websiteDeployment of files into Power BI On Premises
Deployment of files into Power BI On CloudShare Dashboard with Mobile apps for Power BI on Apple and AndroidPower View for SharePoint
Module 6
Managing Security to access data and Administration
Office 365 Administration
Building dashboards in Power BI website
Configuration roles and administration on Power BI website