In my journey of learning Data Warehouse, I kept learning about DAX, I tried to find some useful DAX commands that can help you day by day. The commands that worked out are: SUMX, SUM IF FILTER RANKX ALL I used a Portuguese reference to learn about it, so […]Read More
Post Tagged with: "PowerPivot"
An important step when you are learning Data Warehouse is connecting to external database. You can import data from many data sources, including relational databases, multidimensional sources, data feeds, and text files. The real power of this broad data-source support is that you can import data from multiple data sources in Power […]Read More
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 important Before Microsoft’s introduction of xVelocity […]Read More
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 steps. Create a data connection […]Read More
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 different source like RDBMS, data feeds, spread-sheets, […]Read More
Watch the video demonstration of how to enable Power Pivot and Power View in Excel 2013. Power Pivot in Excel 2013 Add-in enable you to perform powerful data analysis using familiar interface of Excel from virtually any data source. Users can create their own reports, perform analysis and decision making. Power […]Read More