Courses
Microsoft Access helps you analyze large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheet applications. Access is a Relational Database Management Software or RDBMS that is used to create tables where data can be stored and related to each other.
DAX, which stands for Data Analysis eXpressions, is the programming language of
Microsoft Power BI, Microsoft Analysis Services, and Microsoft Power Pivot for
Excel. It is a very powerful formula language that can be used in enhancing your BI reports.
Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. Take your analytics to the next level. Use Excel to format, organize and calculate data in your spreadsheets. More
Whether your data is a simple Microsoft Excel workbook, or a collection of cloud-based and on-premises hybrid data warehouses, Power BI lets you easily connect to your data sources, clean, and model your data without affecting the underlying source, visualize (or discover) what’s important, and share that with anyone or everyone you want. More…
Microsoft PowerPoint is a powerful slide show presentation program. It uses graphics, videos, and other features. to make a presentation more interactive and interesting. More..
Microsoft Project is a project management software product designed to assist a project manager in developing a schedule, assigning resources to tasks, tracking progress, managing the budget, and analyzing workloads. MoreÂ
SQL, which stands for Structured Query Language is the sub data language for databases such as SQL Server, Oracle, MySQL, etc.
Microsoft SQL Server Analysis Services (SSAS) is an online analytical processing and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files.
SQL Server Integration Services (SSIS) involves the cleansing and movement of data into a presentable format. The product can extract, transform, and load (ETL) data astonishingly fast. It is easy to use and cost effective. This course is intended for developers, DBAs, and casual users who hope to use SSIS for transforming data, creating a workflow, or maintaining their SQL Server.Â
SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It can help you give your savvy business users the capability to easily visualize important key metrics to see what products are performing well in their sales territories and more. More
Do you want to get the most out of your office 365 suite of applications? VBA could help you to achieve this. This course is designed for users familiar with Office who have little or no knowledge of computer programming, but who would like to learn how to program features and functions to improve the accessibility and usability of their data. Â
Visio is an innovative solution that helps you visualize data-connected business process flows with a host of integrated features. Create professional diagrams easily with ready-made templates and shapes.
