From SQL server to SQL Server Analysis Service Multidimentional Cube

Article is a bit old, but the fundamentals still apply for SQL Server Data Tools 2012

https://www.simple-talk.com/sql/reporting-services/five-basic-steps-for-implementing-an-analysis-services-database/