Database Querying, Administration and Warehousing, on Microsoft SQL Server 2012: Microsoft Certified Solutions Expert (MCSE) Data Platform Compliant, Diploma â€“ Postgraduate â€“ 5-Credit, Accumulating to Postgraduate Diploma, Progressing to a Mas...More Info
As of SQL Server 2012, you can now create tabular models in Analysis Services, rather than building cubes in legacy multidimensional models. For anyone who is familiar with relational databases, tabular models are easier to create and use than cub...More Info
Excel can do so much more than simple pivot tables! This two-day course will show you how to; create simple, elegant data models in PowerPivot; use these data models to create pivot tables based on multiple tables; use Power Query to build queries...More Info
Apply the key Excel functions to prepare data for analysis using Pivot tables
Create and customize pivot tables to reconcile and analyze accounts efficiently
Utilize pivot tables functions and calculations to generate a set of management a...
Pivot Table using Microsoft Excel
What is Pivot Table?
Microsoft Excel 2010 is rich of features and one most important feature is PivotTable management, development and deployment. In simple words, a pivot table allows you to...More Info
Microsoft Business Intelligence (BI) solutions can leverage your existing technology investments in SQL Server, Microsoft Office, and SharePoint Server to develop rich, integrated reporting and analytical experiences. This empowers users to gain a...More Info
With the huge amount of data available to us every day, a well-built and designed dashboard reports is one of the best ways to interpret and communicate large quantities of information. Learn how to synthesise information into a logical framework,...More Info
This five day course provides students with the knowledge and skills to develop Microsoft End to-End business solutions using SQL Server 2008 R2 in an integrated environment with SharePoint 2010 and Office 2010. The course introduces the students ...More Info
This five day course provides students with the knowledge and skills to develop Microsoft End to-End business solutions using SQL Server 2008 R2 in an integrated environment with Sql 2010 and Office 2010. The course introduces the students to Micr...More Info