Training: Power BI – 3 Days

-
Training: Power BI – 3 Days
Prerequisites: Strong querying skills with SQL Server or any other databases is desired. Maintaining Databases.
(It Is mandatory to accomplish the training prerequisite conditions before nominating for the session)
The Power BI Service
·         Introducing Self-service Business Intelligence
·         Understanding Organizational BI
  • Understanding Self-service BI
  • Getting Started with Power BI Service
·         Signing Up for Power BI
·         Understanding the Power BI Portal
  • Understanding Power BI Content Items
  • Understanding Datasets
·         About Reports
  • About Dashboards
  • Connecting to Data
Components of Power BI
  • Various Components
  • Power Query
  • Power Pivot
  • Power View
  • Power Map
Data Sources (Getting Data)
  • Files
  • Databases
  • Cloud
  • Folders
  • Web source
  • Analysis Service and etc.
Data Transformation (Power Query)
  • Installation, Requirements, and Configuration
·         Power Query Introduction
·         Query Editor
  • Data Type
  • Adding Column
·         Text Transformations
  • Number Column Calculations
  • Date and Time Calculations
Data Modeling (Power Pivot)
  • Power Pivot xVelocity engine basics and concepts
  • Different versions of Power Pivot
  • Relationships in Power Pivot
  • Best practices
Introduction to DAX
  • Calculated Members
  • Row Context vs Set Context
  • Advanced calculations using Calculate functions
·         Time Functions
Power Pivot embedded in Power BI Desktop
  • Data Visualization (Power View, Power Map, Power BI Desktop)
  • Data Visualization Best Practices
  • Power BI Desktop Visualization
  • Custom Visuals in Power BI Desktop
  • Formatting Visuals in Power BI Desktop
Power View for Excel
  • Charts, scorecards, and other visualization items in Power View
·         Visualization with Power Map
Power BI Desktop
  • Power BI Desktop Introduction
  • Getting data from different data sources
  • Modelling data, and relationships
·         Creating calculated measures
·         Power Pivot difference in Power BI Desktop
·         Visualizing data in Power BI Desktop
Power BI Mobile
  • Getting Started with Power BI Mobile
·         Viewing Dashboards
  • Viewing Reports

Comments

Post a Comment

Popular posts from this blog

Cloud Computing in simple

-
Cloud Computing =   Infrastructure as a Service (IaaS) + Platform as a Service (PaaS) + Software as a Service (SaaS) Cloud computing, also known as Cloud Technology, Cloud Applications or Cloud-based services. Cloud Computing is the practice of using a network of remote servers hosted on the internet to store, manage and process data, rather than a local server or a personal computer. Examples of cloud-based services include customer self-scheduling, data storage, online payment, and accounting software Different Type of Clouds Infrastructure as a Service (IaaS)  – Allows users with the services like Virtual servers, Virtual storage, Physical Database, Virtual Network, Physical Network. E.g. Google Storage ,  IBM Cloud Computing ,  Nimbus Platform as a Service (PaaS)  – Provides computational resources via a platform upon which applications and services can be developed and hosted. E.g. Databases, Data Stores,  Force.com ,  Google App Engine ,...
Read more

Bookmark

-
Good Blog about Architecture & design Patterns:   http://martinfowler.com/bliki/ http://www.sharepoint-videos.com/ http://go.cloudshare.com/Linkedin_ProPlus_SharePoint.html A Technical Q/A site: http://www.bookmarkresource.com http://blog.krisvandermast.­ com/ASPNET20PageLifeCycle.aspx http://blogs.vertigosoftware.­ com/shannonf/archive/2005/08/­ 07/1355.aspx http://john-sheehan.com/blog/­ net-cheat-sheets/ http://www.eggheadcafe.com/­ articles/20051227.asp http://duartes.org/gustavo/­ articles/Asp.net-Runtime-­ Cheat-Sheet-HttpRequest-­ HttpRuntime.aspx http://www.addedbytes.com/­ cheat-sheets/javascript-cheat- ­sheet/ http://www.antsmagazine.com/­ 2009/04/100-useful-cheat-­ sheets-for-web-designers-­ developers/ Nice link abt .Net 3.5: http://www.simple-talk.com/ dotnet/.net-framework/.net-3. 5-language-enhancements/ nice articles about JQuery. http://encosia.com/2008/05/29/ using-jquery-to-directly-call- aspnet-ajax-page-methods/ http://encosi...
Read more

How to manage expectations

-
  How to manage expectations Selecting transcript lines in this section will navigate to timestamp in the video - You're probably juggling multiple projects already.  And if you're like, most of us,  your boss keeps throwing new ones at you.  How can you keep up and do a good job  and manage your supervisor's expectations?  As with many things in life,  the majority of problems can be avoided  with a detailed conversation upstream,  Well before any actual deadlines.  The first step is making a comprehensive list  of the projects you're working on,  and rank ordering them,  based on your understanding of priorities.  You then want to set up a meeting with your boss,  where you can confer and ask if your understanding  of their relative importance matches hers.  The last thing you want to do is waste time,  pushing hard on the 10th priority  when number one is languishing.  You have limited...
Read more