Join Ron Davis for an in-depth discussion in this video What you should know, part of Microsoft Business Intelligence Stack Essential Training.
Stack. This is not it. You should check out the Microsoft Business Intelligence Stack Fundamentals course. What you do need to know is an understanding of relational databases. I don't expect you to be a database administrator. What I do expect you to understand is such concepts as a foreign key, primary key. Business analytics. What I mean by business analytics is what you are trying to understand in your specific business.
It may be finance, it may be related to HR, and within HR perhaps you're looking at your existing employees. And see what trends or characteristics make those employees successful. Another thing is perhaps you're looking at web traffic, and you want to understand better what you do on your web presence. Or, you have both an online store and a physical store. And you want to understand the differences between those, and what opportunities you might have, using business intelligence and business analytics.
Good Excel skills. I don't expect you to be a guru of Excel. What I do hope is that you will feel comfortable with Excel. If you use it regularly in your business, that's good enough. If you don't, there are many good Excel courses on lynda.com, you can check those out. Visualizations in business. Visualizations is what we say today, instead of graphs and charts, et cetera. We have a course on lynda.com, Data Visualizations Fundamentals.
Which, if you don't feel comfortable with visualizations, you can go over to that and take a look at it.
- 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
Learning Microsoft Business Intelligence Stackwith Ron Davis43m 35s 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.