Business Analytics Training

With a 22 year pedigree in software training, SQL Star is an organization that understands the stringent requirements of business and is committed to meet those exacting standards. This course will train participants on Microsoft BI tools that includes Excel based BI for business and to end users. Excel is a powerful Data Analysis and Reporting tool.

You could use Excel to gain new insights into the information and data that you work with in your job. Excel is a powerful Data Analysis and Reporting tool. With Excel you can improve the report formats and analyze your business critical data more effectively.

This course  is targeted for business users like accounts, sales & marketing personnel, finance managers etc who constantly need to gain insights into their business and make informed decisions or present reports to their management to take stock of their organizational health.

The topics covered under this training are given below:

1) Balance Scorecard Methodology
2) Productivity and Organizational KPIs
3) Reporting needs of organizations
4) Excel Functions
5) Introduction to database and import of data from external sources to excel
6) Building impressive reports and charts
7) Building single view dashboards
8) Using Pivot for data analysis and flexible reporting
9) “What-If” analysis using Excel two-variable data table
10) Macro and VBA
11) Lab exercises
The training outcomes are well defined and at the end of the training the participants are able to apply what they learn at their work and able to Create Formulas, Date and Time Functions, Financial Functions, Logical Functions, Lookup and Reference Functions Mathematical Functions, Statistical Functions, Text Functions that are inherently important to their daily work.