Join Ron Davis for an in-depth discussion in this video Data sources, part of Microsoft Business Intelligence Stack in Depth.
…So let's take a look at creating a tabular project and sourcing some data.…So I've got SQL Server Data Tools open, and I'm going to create a new project.…And it's going to be Analysis Services Tabular.…And if you'll notice, it's down here.…If I select Analysis Services, there's Tabular.…And we'll name this something clever demo.…I know, not very clever.…Demo sources.…Say OK.…And let that open.…Now it's looking for a workplace server.…
What it's asking me for…is an analysis services database that's running in tabular mode.…So, I'm going to enter the dot, which dot is resolved to local host.…It's the current one I'm on.…And the name of my tabular box is cleverly, Tabular.…That said, when you're actually doing this,…I highly suggest you name your first one Tabular.…So, I test because I cannot resist.…It worked.…And we'll say OK.…Now, SQL server data tools was tying in to the model.…
That is tying in to analysis services and it sees that's legal.…So it has a connection and we are in.…Now we need to grab some data, which is the point of this chapter.…
- Working with data sources and data views in SQL
- Understanding the star and snowflake database schemas
- Working with the SQL 2012 semantic model (aka tabular mode)
- Using Data Analysis Expressions (DAX)
- Using Excel Web Parts to connect to spreadsheets
- Building dashboards with key performance indicators (KPIs) and reports
- Understanding the Microsoft data-mining process
Skill Level Intermediate
Microsoft Business Intelligence Stack Fundamentalswith Ron Davis43m 39s Intermediate
1. The Traditional Multidimensional Model
2. The New Tabular Model
3. Basic Power Pivot
4. SharePoint Excel Services
5. Basic PerformancePoint
6. SharePoint Visio Services
7. Data Mining and Predictive Analytics
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.