557 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
A tutorial showing how to import data from Excel, Access and many other sources
Part five of a five-part series of blogs
You can import data into tabular models from virtually any data source, as shown by this tutorial.
You can also load data into SSAS tabular from the following other sources (not covered in this tutorial):
|Azure DataMarket||Link to data held in Microsoft's cloud-based services, by subscribing to a data feed of interest.|
|SQL Server Parallel Data Warehouse||When your database is seriously large you can accommodate it in a SQL Server PDW, and import data from there into your tabular model.|
|SharePoint||There is no specific data source for importing from SharePoint; instead, just choose one of the standard formats shown above, but provide a complete path to your report, workbook or PowerPivot model. If your data is in a SharePoint list, you can export this as a data feed and import this data feed into your model.|
|Data feeds||You can link to atom data feeds from the Internet and from other sources which support the Open Data Protocol (using files with extension .atomsvc).|
|Other databases||Link to Oracle, Teradata, Sybase, Informix and DB2 in a similar way to linking to SQL Server.|
|OLEDB / ODBC||Link to virtually any data source using these generic formats.|
One of the great strengths of the tabular model is that you can combine tables based on almost any data source, and treat them equally within your model (without needing to know where they came from).
And with those words of wisdom, I've reached the end of this particular blog.
|Parts of this blog|
25 Aytoun Street