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 ,  Windows Azure  (Platform). Soft
Read more

How to Write an Effective Design Document

-
Image
How to Write an Effective Design Document Why write a design document? A design document is a way for you to communicate to others what your design decisions are and why your decisions are good decisions. Don’t worry if your design is not UML compliant and don’t worry if you didn’t use a special modeling tool to create it. The biggest factor that determines if your design document is good is whether or not it clearly explains your intentions. This presents a problem, however. In order to convey design decisions, you have to consider the audience that you are writing for. A peer developer will understand why a well-crafted class abstraction is a good design, however your manager will probably not. Because your peer developers and your manager have different concepts of what makes a design good, there is a need for two design documents; one for peer developers and one for managers. Each document serves a different and equally valuable purpose as you begin your project development. I
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://encosia.co
Read more