Introduction To Building PowerPivot Datasource

Creating PowerPivot data sources As I have demonstrated there are a lot of things about PowerBI to get excited about. One of these is Microsoft’s adaption of the technology xVelocity. The true power behind PowerPivot is the xVelocity in-memory analytics engine. Why XVelocity is...

Introduction to PowerView Creating Calculations

Creating Calculations Now that you have a solid understanding of creating some basic PowerView dashboards. You are ready to extend the model with custom calculations. In this next demonstration, I will introduces the Data Analysis Expressions (DAX) language and explains how to...

Introduction to PowerView Maps

Adding Maps For those that have experience with the Map capabilities in SQL Reporting Services, you know Microsoft defiantly had a lot of room for improvement. With PowerBI, Power Map greatly increases the mapping visualizations at your disposal. It can produce visualizations by...

Introduction to Adding Images in PowerView Dashboards

Using Images in PowerView Images give your dashboards a professional look and provide more ease of use. PowerView allows you to use images in about every possible way. One of the most effective usages of images in PowerView is with the Card object. In the last section you saw how...

Introduction to PowerView Creating KPIs by Melvin Black

Creating KPIs KPIs are a staple of many dashboards and provide a great way to quickly see trends and spot areas that need further analysis. One of the nice features about KPIs in PowerBI when it comes to creating KPIs that it allows you enhance existing measures and not create a...

Introduction to PowerView by Melvin Black

Introduction to PowerView Microsoft has been a leader in the Business Intelligence (BI) space. With SQL Server and Excel having been on the market for over 20 years it has always had a presence in data management. Today, one of the new initiatives in BI is self-service BI.  I...

Introduction to Power View

Watch the video demonstration of creating simple Power View report using Power Pivot model. Power View is a very easy to use dashboarding tool that is part of Excel 2013. Using power view, business users can leverage self-service business intelligence. Power View is generally...

Calculated Columns and Calculated Fields in Power Pivot

Watch the video demonstration of how to create calculated columns and fields in Power Pivot. For any newbie there is always a confusion between calculated columns and calculated fields and when to write what. Note: Calculated fields are also referred as Measures in BI terminology...

Import Data Table to Power Pivot

Watch the video demonstration to add data to Power Pivot. PowerPivot can import data from multiple source like Access, SQL Server, Oracle, Sybase Informix, DB2, Teradata, Flat file, Excel and OData feed.  The process to import data table is similar.  Following are the high level...

Introduction to Power Pivot in Excel 2013

Watch the introduction video of Power Pivot in Excel 2013. Power Pivot add-in for Excel 2010/2013 is used to perform powerful data analysis, self-service business intelligence within the familiar framework of Excel on your desktop. Using Power Pivot you can import data from...
12
Send