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
Search our website
We also send out useful tips in a monthly email newsletter ...
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.
This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources. |
You can also load data into SSAS tabular from the following other sources (not covered in this tutorial):
Format | Notes |
---|---|
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 |
---|
Some other pages relevant to the above blogs include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2023. All Rights Reserved.