Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Tuesday... 01-11-2016
Search Course Here




Live Chat
Support
Microsoft Power BI online training

Microsoft Power BI



overview


Microsoft Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A). You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.

prerequisties

  • Attendees should have a knowledge of Excel.

Duration

Online
  • It is a 20 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 5 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.

course content

  • What is Microsoft Power BI
    • Understanding the Power BI environment
    • Creating a Micrsoft Power BI Account
    • Installing Power BI Desktop
  • Exploring Power BI Desktop
    • Working with the Fields and Visualisation Panes
    • Using Report View to create visualisations
    • Using Data View to sort and Format data
  • Understanding Data Sources in Power BI Desktop
    • Importing a variety of data sources into Power BI Desktop
    • Connecting to Excel Workbooks, Access Databases, CSV Files and other data locations.
  • Creating a Data Model in Power BI desktop
    • Understanding the Data Model
    • Using Relationship View
    • Creating Many-to-One relationships
    • Understanding Filter propagation
  • Visualisations Workshop using Power BI Desktop
    • Adding visualisation to the Report Canvas
    • Understanding and controlling interactions between visualisations
    • Using Drill Down and Drill Through on visualisations
    • Creating and using Heirarchies
    • Importing custom visualisations
    • (Course attendees can practice creating and designing a variety of the many interactive visalisations available in Power BI)
  • Introduction to DAX in Power BI Desktop
    • Exploring the importance of custom calculation within the Data Model
    • Creating Calculated Columns & Measures
    • Understanding Evaluation Context
    • Using CountRows and DistinctCount Functions
    • Advanced DAX functions: SUMX and CALCULATE
    • Time Intelligence Functionsject system integration, ps-cd (fi-ca) integration, funds management integration)
  • Using Queries in Power BI Desktop
    • Understanding the role of Queries in data import
    • Understanding Extract, Transform & Load (ETL)
    • Exploring a variety of data transformations
    • Working with Applied Steps
    • Creating and using Query Parameters
  • Publishing to Power BI Service
    • Publish your Report to PowerBI.com
    • Creating Dashboards
    • Using Quick Insights
    • Using Q & A for interactive data searching.
  • Importing Data into Power BI Service
    • Connecting to a variety of Cloud-based data sources, including OneDrive, Google Analytics, Azure SQL Databases and Websites.
    • Using Excel's Power Pivot Data Model in Power BI Service
  • Using Excel, importing data from a variety of sources into Power Pivot
    • Creating a Power Pivot Data Model in Excel
    • Importing a Power Pivot data Model into Power BI Service
    • Creating a variety of visualisations in Power BI Service using Power Pivot data.
  • Sharing your Dashboards & Content Packs
    • How to share your interactive Power BI Dashboards with people both inside and outside your organisation.
    • Sharing using Power BI, Web, PowerPoint and others
    • Creating and Managing Content Packs
  • Data Refresh
    • Manually refreshing data
    • Installing and using the Personal Gateway
    • Installing and using the Enterprise Gateway
    • Creating a Scheduled Refresh
  • Using Power BI on Mobile Devices
    • Understanding the mobile clients
    • Tablet Clients, Windows 10, Ipad and Android
    • Differences between Iphone, Ipdad and Android clients

Videos

Microsoft Power BI Videos will be updated Soon
To Watch More Videos Click Here

Flash News


AngularJS New Batch Start From 09th OCT & 10th OCT.


Hadoop Dev New Batch Start From 10th OCT & 11th OCT.


IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.


Informatica Dev New Batch Start From 12th OCT & 13th OCT.


Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT
.

Tableau New Batch Start From 16th OCT & 17th OCT

PUBLIC DEMO

(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

(2) SAP MII Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings