This course is a overview of Data Warehousing and Business Intelligence. We start by looking about terms and concepts in Data Warehousing and Business Intelligence. We finish with high level examples of the tools used to create nd fill a Data Warehouse and then analyze and report on that data.
This course covers the current state of Business Intelligence in the cloud, as well as goes into functional examples using Google Big Query and Tableau Online. This is a beginner course, but it is assumed you are familiar with the basics of databases and business intelligence concepts.
SharePoint has many Business Intelligence (BI) tools to help you make informed business decisions quickly and accurately, but getting them all to work properly can be an intimidating task. With this course, you will chart your way through the treacherous waters of SharePoint BI and reach the other side intact. SharePoint BI has many moving parts, many of which involve manipulating SQL Server, which is never an easy thing. This course explores not only SharePoint, but SQL Server as well. You will learn to configure Excel Services, which is the backbone of so many of the BI tools, and install SQL Server Analysis Services to work with SharePoint. Beyond that, we cover PowerPivot, Power View, SQL Server Reporting Services, and many other BI tools of SharePoint. This is a must-view course if you need to prepare your SharePoint farm for Business Intelligence.
By keeping all of their products beautifully simple and yet incredibly robust Tableau is quickly becoming the Business Intelligence platform of choice for anyone wanting to compete in today's markets. Tableau Server is the enterprise platform for modern companies looking to see and understand their data like never before. This course covers everything you need to get up and running with Tableau Server in your enterprise.
Are you confused by the fact, that there is not one End-User Tool for BI, but there are many from Microsoft? In spite of the fact that Microsoft decided in 2009 not to build further reporting-tools (but to consolidate the actual portfolio instead) a whole bunch of tools are available and are leading to some confusion through the users: Excel, PowerPivot, Report Builder & Report Designer (Reporting Services), Dashboard Designer (PerformancePoint Services) and Power View. You will take a lap around all of these tools and you will learn when to use which. In this demo-heavy course, the very same report will be built with each of these tools so you can see the strengths and weaknesses of each of them with your own eyes. After finishing the modules, you will be armed with the knowledge to decide which of the tools fits your end-users the best.