Courses of Business Analytics
Basic Excel
This module gives a basic understanding of Excel toolbars, buttons, functions, cursors, charts, and an introduction to the use of formulas.
- What is a Spreadsheet Package?
- Editing Cell entries using format options
- Working with Functions & formula
- Concept of Cell Referencing
- Sorting & Filtering data
- Working with Charts
Advance Excel
The module covers many complex functions such as cell formatting, dashboards, power queries, financial formulas, logical complex formulas, and uses of advanced filters enabling the student to utilize the advanced features in an office environment with maximum efficiency.
- Lookup and Reference Functions
- Logical Function
- Financial Functions
- Complex Formula
- Pivot Tables
- Sparklines
- Dashboards
- Power query and Power Pivot
Power BI
PowerBI lets you easily connect to your various data sources, visualize and discover what’s important and share that with anyone or everyone you want for effective decision-making.
- PowerBI installation
- PowerBI data modelling
- PowerBI Dashboards
- PowerBI Visualization Options
- PowerBI Excel Integration
- PowerBI Report Sharing
- DAX Basics in PowerBI
Tableau
Tableau is one of the most powerful and fastest-growing data visualization tools used in the business Intelligence industry. The data created using Tableau can be understood by professionals at any level in an organization for ease of decision-making.
- Environment setup
- Tableau Data Sources
- Tableau Worksheets
- Tableau Calculations
- Tableau Sort and Filter
- Tableau Charts
- Tableau Dashboards
VBA Macros with Excel
Excel VBA is very widely used to automate repetitive tasks in Excel. Typical examples include creating charts from a standard data input or creating and formatting reports from a raw unformatted set of data. This module aims to give advanced Excel users a thorough knowledge of Excel VBA programming for handling complex repetitive tasks.
- Basic Excel VBA
- Sub Procedure and User-Defined Function
- Developer tab - Essential Buttons
- Macros - Record and Run
- Ways to Run a Macro
- Customize Macro code
MySQL
As a business analyst, you will be constantly engaging with the database of the organization, and many a time you will be expected to generate data from the database to create reports or feed into some other reports. As a business analyst, you have to be an expert in SQL to be able to query the database and generate information. In this course, you will learn MySQL database to apply business analytics concepts.
- Introduction to databases, SQL, MySQL
- Installing & getting acquainted with Interface
- SQL basics
- Using Select & Insert Queries
- MySQL constraints & Best Practices
- Connecting database to external sources
MIS Reporting
This module helps achieve business competitive advantage through informed decision-making as well as Analyzing and synthesizing business information.
- Database management system
- Creating Dashboards using Excel data
- Graphical representation of data using charts and sparklines
- Use of power pivots for data analysis
- Use of power queries
- Importing and exporting data from Excel to other formats
- Creating reports in Excel for MIS
Don't hesitate to contact us
8655231215
info@s-tek.co.in
9:00 to 7:00