Master Microsoft BI tools like SQL Server and Excel in this course, designed to enhance your business analysis and reporting skills effectively.
This course introduces you to Microsoft BI tools, helping you to use SQL Server and Excel for business analysis. It includes video training, hands-on exercises, and a bonus ebook to enhance your learning experience.
Leveraging Microsoft SQL Server Integration, Analysis, and Reporting Services with Excel and Sharepoint
Microsoft Office 2010 and SQL Server 2008 R2 bring the power of Microsoft's enterprise Business Intelligence (BI) tools to the vast Microsoft Office market. If you are just starting to get a handle on Microsoft BI tools, this course provides you with the just the right amount of information to perform basic business analysis and reporting. You'll explore the components and related tools that comprise the Microsoft BI toolset as well as the new BI features of Office 2010. After a basic primer on BI and data modeling, the expert team of authors provides you with step-by-step lessons in the videos and ebook on how to use SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Excel BI (including PowerPivot), and SharePoint. When you’re done, you’ll be able to create dashboards, visualizations, and reports to enhance your business’s understanding of your data. With more than 8 hours of video training arranged into more than 35 bite-sized lessons, this is the perfect way to get up to speed on Microsoft’s complete suite of BI tools.
As a bonus, we’re including the complete ebook for a second ebook Professional Microsoft SQL Server 2012 Integration Services. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. The authors present you with a new set of SISS best practices, based on years of real-world experience and it includes case studies and tutorial examples to illustrate advanced concepts and techniques. You’ll also want to have the free AdventureWorks and AdventureWorksDW databases installed. You can find the versions of these databases we used for Professional Microsoft SQL Server 2012 Integration Service on the Wrox website at http://www.wrox.com/go/SQLServer2012DataSets. Please note that we have removed the version number from the database names. If you already have a versioned database like the AdventureWorks2008R2 database though, this will work for the purposes of the demo.
Visit www.wrox.com and www.wiley.com
Over 35 lessons and 8 hours of video!
Learn important BI concepts with thorough discusses.
Walk through the Try It sections in each lesson to learn on your own.
4 Lectures
7 Lectures
10 Lectures
10 Lectures
4 Lectures
6 Lectures
Founded in 1807, Wiley, In has long been a valued source of information and understanding for more than 200 years, helping people around the world meet their needs and fulfill their aspirations. Wiley and its acquired companies have published the works of more than 450 Nobel laureates in all categories: Literature, Economics, Physiology or Medicine, Physics, Chemistry, and Peace.    Wiley...
It's good if you already know the SSxS and just want to refresh things in your mind. The instructor quickly does some tasks without proper explanation. For instance "If you see an error just click on that button then press ok" without mentioning what the error is about and why we have to press other buttons. Also, questions are never answered.
Great course.
All things were awesome
could be a bit more elaborate
Some sections are better than others. Overall good demo of sql server analysis strategy
Simple and clear conceptual.
The instructor does not explain what he is doing and why he is doing properly. too straightforward. And also he doesn't reply to questions asked on the Q&A section
1. There are errors in the code which are not explained, hence it's very frustrating experience.
2. There is no explanation of syntax and information flow / processing.
3. Example is the expression in lesson 7 try it, the exercise can't be completed, as the procedure shown is stuck at the step requiring typing an expression. The system does not accept the expression! The expression is not available as mentioned in the lecture, there is just no clue to what is being achieved in this step.
like
Your email address will not be published. Required fields are marked *
Uppaluri H. K. M.
Very clear, now i have a basic idea of how to use Analysis servers