Call Us Today! +91 99907 48956 | info@analyticstraininghub.com
Menu
Data visualization only helps to streamline data and information for a better understanding. Data is a technique through which the users can improve the visual aspects of their data. The visual representation is constructive for a growing organization. Many software related to data analytics uses data visuals for better outcomes and relational studies. Softwares like Excel and VBA use data presentation for an impactful approach.
Excel has risen as the application that helps users to store, record and analyze any form of data. Data management and allocation are the USP for this application. MS Excel has many tools with different functionality based on numerous requirements. Excel holds the key to data visualization.
Instructor-Led Online & Physical Classes
| Batch Start Date | Class Type | Upcoming Slots | Timings |
|---|---|---|---|
| 24th Oct 2020 | Classroom | Sold Out SAT & SUN (10 WEEKS) | 12:30 PM to 2:30 PM (IST) |
| 2nd Nov 2020 | Online | Filling Fast⚡ TUE, WED & THU (6.5 WEEKS) weekday batch | 7:00 PM to 9:00 PM (IST) |
| 7th Nov 2020 | Classroom | SAT & SUN (10 WEEKS) weekend batch | TBD |
Course Price At
INR 50,000/- + GST
INR 43,000/- + GST
15% off expires in
Days
Hrs
Min
Sec
Can’t find a batch you were looking for?
COURSE DETAILS
MICROSOFT EXCEL
- Introduction to Excel 2013/2016/2019/Office 365
- Application Interface and Key Components of Excel
- Navigating Through Excel Ribbon Tabs
- Exploring Important Excel Options*
- Live Session Exercise
- Splitting data of Single Column into multiple
- 10 Examples to use Auto-fill and Flash Fill
- Magics of Go-To Special
- Merge/Unmerge Cells & Wrap Text
- Extracting Unique Values & Important Ribbon, General and Data Entry Keyboard Shortcuts
- Formatting Essentials Introduction
- Custom Cell Number Formats
- Custom Date/Time Formats
- Working with Comments / Notes
- Format Painter – A Quick way to copy ‘Formatting Attribute’
- Paste Special
- Table, Table Styles & Formatting
- Freeze Panes
- Introduction to Excel Functions and Formulas
- Basics of Functions & Formulas
- Working with Cell References Types
- Most Used Basics & Advanced Functions & Formulas
- Working with Array Formulas
- Creating Customize Formulas Step-by-Step with Live examples
- Creating and Working with Dynamic Ranges using Function and Excel Table features
- Formulas Debugging / Formulas Auditing
- Types of Formula Errors / Error Handling Tricks
- Text Functions: – CLEAN, CONCATENATE, LEFT, RIGHT, MID, LEN, FIND, SEARCH, SUBSTITUTE, and TEXT etc.
- Date & Time Functions: – DATE, DAYS, TIME, NOW, WEEKNUM, WORKDAY, and WORKDAY.INTL etc.
- Math & Trig Functions: – INT, MOD, ROUND, ROUNDDOWN, SUMIF, SUMIFS, SUMPRODUCT etc.
- Statistical Functions: – AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MIN, LARGE etc.
- Logical Functions: – IF, IFS, AND, OR, and IFERROR.
- Lookup & Reference Functions: – FORMULATEXT, VLOOKUP, HLOOKUP, INDEX, MATCH, INDIRECT, and OFFSET
- Newly Introduced Functions in Recent Version of Excel*: – CONCAT, TEXTJOIN, IFS, SWITCH, DGET, UNIQUE, FILTER etc.
- Nested Conditions/Customize Formulas*
- Data Sorting
- Data Filtering
- Named Ranges
- 10 different ways to use Conditional Formatting
- 10 different use of Data Validation
- What-If Analysis
- Introduction to Excel Charts
- Exploring most commonly used Charts and Templates
- Basics of Charts
- Selecting Requirement based Charts
- Working with Basic Charts:
- Creating Customized / Advanced Charts
- Creating Dynamic Chart
- Working with Dynamic Interactive Charts in Excel using Drop Down
- Working with Chart Elements, Formatting, Chart Styles, Properties etc.
- Introduction to Pivot Table
- Creating a Pivot Table
- Use of Calculated Fields/Items
- Pivot Table Formatting
- Grouping Items & Summarizing data in Pivot Tables
- Grouping and Bucketing data in Pivot Table
- Changing/Modifying Data Sources
- Working with Pivot Table Designs & Layouts
- Exploring Important Pivot Table Options & Field Settings
- Pivot Table Filters
- Changing Pivot Table Summary Calculation
- Use of Slicers in Pivot Table
- Using Source Data to Convert into Infographic Summary
- Introduction to Pivot Charts
VBA / MACROS
- Quick Recap of Microsoft Excel
- Introduction to Developer Ribbon Tab
- Introduction to VBA
- What is VBA / Macro in Excel?
- Introduction to Visual Basic Editor Window
- Getting Familiar with Visual Basic Editor (VBE)
- Customizing the VBE Environment
- The Macro Recorder
- Executing / Modifying Recorded Macros
- Saving Macro Workbook
- Introduction to Sub and Function Procedures
- Introducing the Excel VBA Object Model (A must know thing to become Pro in VBA)
- Properties and Methods
- Important and Useful Properties of Application Object
- Working with Ranges Objects
- Working with Comments
- Variable, Data Types and Constant
- Finding Last or Next available Row/Column
- Selecting Rows/Columns/Table (Normally & Dynamically)
- Introduction to VBA Loops & Conditional Statements
- Working with Conditional Statements
- Working with Loops
- Working with Message & Inbox Box
- With-End with Constructs
- Controlling Program Flow
- Introduction to Arrays
- Introduction to Excel VBA Functions and Worksheet Functions
- Difference between R1C1 and A1 style referencing
- Difference between Worksheet Functions Vs Active.cell Formula
- Getting started with VBA Excel Functions
- Getting started with WorksheetFunction
- Working with Function Procedures
- Getting started with User Defined Functions (UDF)
- Fixing arguments of Formulas in VBA
- Working and Creating Customize Functions
- Error Handling & Debugging Techniques
- User Form Introduction
- Exploring Form Controls & ActiveX Controls
- Exploring UserForm Controls
- Cycle/Sequence to follow to create UserForm
- Validating User Inputs
- Testing a UserForm
- User Form Tricks
- Understanding User Form Events
- Working with Pivot Tables
- Charts
- Sorting & Filtering
- Add-Inns
- Type of different Excel events
- Starting an application from Excel
- Interacting with Microsoft Office Apps
- Controlling Excel from another application
- Sending Personalized emails via Outlook
- Sending e-mail attachments from Excel
- Working with Files & Folders
- Converting / Saving Excel File into PDF
MySQL
- An Introduction and Overview of MySQL
- Installation and GUI Tools
- An Overview
- Introducing SELECT statement
- Introducing WHERE clause
- Sort result with ORDER BY
- Using FROM to specify the source tables
- Importance of Clause Orders
- Data Modification tricks
- Creating a database
- Creating a table
- Creating Indexes
- Controlling column behavior with constraints
- Using foreign key constraints
- Creating an ID column
- Changing a schema with ALTER
- Introducing NULL and NOT_NULL
- Introduction to MySQL Data Types
- Setting up default values
- MySQL Warnings
- Alerting a table
- Introduction to MySQL Functions
- String Functions – CONCAT, SUBSTRING, REPLACE, REVERSE, LENGTH, UPPER, LCASE etc.
- Aggregate Functions – COUNT, MIN, MAX, SUM, AVG, ROUND etc
- Date/Time Functions – CURDATE, CURTIME, CURRENT_DATE, LOCALTIME etc.
- Control Flow Functions – IF, IFNULL, NULLIF etc.
- Introduction to JOINS
- Different types of JOINS
- JOINS and Aliases
- Multiple Table Joins
- Creating a simple Subselect
- Understanding of Primary keys and Foreign keys
- Transactions & Stored Routines
- Triggers
- Creating a New User Login
- Granting access to new users
- Backup and Restore databases
- Important Keyboard Shortcuts Guide
- Session Study Material
- Situational Case Studies for Best Practice and Getting Ready for Corporate World
- 6 Months Live Support via Phone/Email/Messages
POWER BI
- Get Power BI Tools
- Introduction to Tools and Terminology
- Dashboard in Minutes
- Refreshing Power BI Service Data
- Interacting with your Dashboards
- Sharing Dashboards and Reports
- Recap and What’s Next
- Introduction to Power BI Desktop
- Getting Data: Excel vs Power BI Desktop & Service
- Data Structure for Q&A
- DirectQuery vs Import Data
- Recap and What’s Next
- Introduction to Modeling
- Setup and Manage Relationships
- Cardinality and Cross Filtering
- Default Summarization & Sort by
- Creating Calculated Columns
- Creating Measures & Quick Measures
- Recap and What’s Next
- Creating Visualisations
- Color Formatting
- Setting Sort Order
- Scatter & Bubble Charts & Play Axis
- Tooltips
- Slicers, Timeline Slicers & Sync Slicers
- Cross Filtering and Highlighting
- Visual, Page and Report Level Filters
- Drill Down/Up
- Hierarchies
- Reference/Constant Lines
- Tables, Matrices & Conditional Formatting
- KPI’s, Cards & Gauges
- Map Visualizations
- Custom Visuals
- Managing and Arranging
- Drillthrough
- Custom Report Themes
- Grouping and Binning
- Selection Pane, Bookmarks & Buttons
- Recap and What’s Next
- Introduction
- Standalone Tiles
- Data Driven Alerts
- Quick and Related Insights
- Custom Q&A questions
- Introduction
- Sharing Options Overview
- Publish from Power BI Desktop
- Publish to Web
- Share Dashboard with Power BI Service
- Workspaces and Apps (Power BI Pro)
- Content Packs (Power BI Pro)
- Print or Save as PDF
- Row Level Security (Power BI Pro)
- Export Data from a Visualization
- Publishing for Mobile Apps
- Export to PowerPoint
- Sharing Options Summary
- Understanding Data Refresh
- Personal Gateway (Power BI Pro and 64-bit Windows)
- Replacing a Dataset
- Troubleshooting Refreshing
- Options for Publishing from Excel
- Pin Excel Elements to Power BI
- Connect to Data using Power BI Publisher/Analyze in Excel
- Excel 2016 Publish: Upload and Export to Power BI
- Sharing Published Excel Dashboards
TABLEAU
- What is Tableau? What does the Tableau product suite comprise of? How Does Tableau
Work? - Navigating Through Tableau Ribbon Tabs
- Tableau – Design Flow
- Tableau – File Types
- Tableau – Data Types
- Tableau – Show Me
- Tableau – Data Terminology
- Tableau Data Sources
- Custom Data View
- Extracting Data
- Fields Operations
- Editing Metadata
- Data Joining
- Data Blending
- How to Add Worksheets?
- How to Rename Worksheets?
- How to Save & Delete Worksheets?
- How to Reorder Worksheets?
- How to Paged Workbook?
- Operators
- Tableau Functions
- Numeric Calculations
- String Calculations & Date Calculations
- Table Calculations
- LOD Expression
- Basic Sorting
- Basic Filters
- Quick Filters
- Context Filters
- Condition Filters
- Top Filters
- Filter Operations
- What is a Chart?
- Utilize auto-generated fields, including measure names and values
- Difference between Dual axis and Blended axis
- Use titles, captions and tooltips effectively
- Type of Charts
- What is Geo-Coding and implementation? How to Be Importing External Custom Geo
coding
- Tableau Dashboard
- Tableau Formatting Essentials
- Tableau Forecasting
- Tableau Trend Line
- Sharing Workbook
Data Visualization With Power BI & Tableau Features
Instructor-led Sessions
- 100 Hours / 50 Sessions / 10 Weeks
- Per Session for 2 Hours
- 150 Hours for Assignments
Real-life Case Studies
- We have included unlimited real life examples and case studies in our course
Assignments
- After completing every session you will assignments, study material & real life based case studies
100% Job Assistance
- You will get 100% Job Assistance from us
Why Do You Need Data Visualization With Power BI & Tableau Course?
Skills in Demand
Data Visualization skills give you the ability to design professional-level Dashboards. You can build complex reports if you have knowledge of Power BI. However, with the knowledge of Power BI , you can do more.
Employability Increases
Now a days companies are preferring those candidates for data management profile who has good skills of Microsoft Excel, VBA, My SQL & Power BI. Many companies heavily depend on these programs for Data Analysis along with visualization.
Job opportunities on the rise
Now, every brand & company has presence at social media that it why Data Analyst demand is increasing everyday. This makes it is a wise career move that has a future in business.
Student Reviews
Assistant Manager at ITC Limited Read More
"It was exactly what I was looking for. I was looking for a trainer who can help me in understanding the concepts rather than mugging them up. The course structure is good and Anil is always there to clear your doubts. Read More....
Chartered Accountant Read More
"The teaching methodology is very good.The class timings are also flexible. The exercises and case studies given after every session are very helpful in understanding the concepts and using them in real life scenarios. Read More....
Regional Account Manager at Expeditors International Read More
"Excellent stuff. I was amazed to learn the such important techniques which would definitely going to help in my managerial role and the way it was delivered by the trainer, Mr. Anil Dhawan made it more simpler and easy. Read More....
Read More
If you are looking for the best, surely you were seeking for this place. Anil Dhawan Sir is one of the best mentors you would want to be associated with. His experience and relevance with industry is remarkable. Read More....
Read More
Analytics training hub is the best place to learn the excel,VBA SQL etc, Mr. Anil explain every concepts and easy to understand all the concept. In this institute provide the every class case study to learn the concept very good manner. Read More....
Read More
I have enrolled in Excel to Power Bi Course. It is very good experience in here. Brilliant method, case studies and classes to get trained on course. I would highly recommend Analytics training hub. Read More....
Read More
The best Excel and Analytics training centre in town. The practical approach followed by the trainer gives immense clarity on the concepts taught. Read More....
Read More
I have opt for the Excel to Power BI course. I have completed the excel course and learned lot of new features of excel and now I am jumping on VBA. The way Anil Sir teach excel is very helpful in understanding the concepts. Read More....
Read More
Excellent learning experience . I have gone through the excel training and currently in between of VBA training. Session were interactive and based on realtime scenario. Flexible timings which is one of the biggest advantage. Read More....
Read More
Would like to say the best place to learn excel. Anil sir have complete knowledge and he teaches in a very simple and interesting way. The modules are well designed and study material is very helpful. Read More....
Read More
Nice place to nice excel and become expert for the same. Good practice classes they are providing along with good material which is very helpful for the students to grow. Sir and mam both are supportive. Read More....
Read More
Amazing experience. He is an awesome teacher as well as a great personality.He has really helped me catch up well with the basic & understand the concepts properly. Always available to help. Thankx alot!!
I would like to recommend others. Read More....
Read More
Mr.Anil is an amazing teacher. As a fresher, and very new to MS Excel, he has really helped me catch up well with the basics and understand the concepts properly. His patience and understanding is something which is making me more confident. Read More....
Read More
Anil Sir is very patient and humble teacher. He has sound knowledge in the subject he teaches. I have done Ms-Excel course and had a great learning experience from him. Read More....
Read More
It was a great learning experience. Although I am experienced professional but the advance excel course helped me and I learnt many new functions and formulas. Thanks to sir. Read More....
Read More
An excellent place to learn analytics in professional way under the guidance of respectable Mr Anil Dhawan along with Mrs Nisha. They are very supportive and their case studies of every session are very helpful. Read More....
Read More
Anil Sir is a patient and vastly knowledge person. I can’t thank him enough for all the help that he give me, with he’s help I was able to take my work to a next level. Read More....
Read More
Anil Dhawan sir is really experienced and knowledgeable and focuses on each students weakness. A very good learning environment. Analytics Training Hub is highly recommended. Read More....
General Manager at Urban Company Read More
Anil have been a great teacher. His basics are very strong, which is very necessary to understand any concept. Best part are the tutorials and examples which tests the concepts thoroughly and helps apply the learnings well. Read More....
Previous
Next
FAQ's
If you are asking why you should do this program then don’t do it.
As we can see Data profile demand is increasing every day because data is the new oil for every business. And these skills are very basic now so every company prefer their every employee should have at least these basic skills, for more detail you can connect with one of our team members at #919650308956
Of course. This course will give you a head start toward a brilliant professional life.
Though we have so many reasons to join us, let us highlight main points:-
- After completing the course you will 3 months of support time period extra to revise the sessions which are not cleared to you, any problem you are not able to solve that you can take our team’s help
- We provide video recordings if any of the reason you skip your session
- We have well-experienced trainers to teach our students
- Project-based training / unlimited examples to make you understand about the subject / Case Studies after every session / Job Support and many more
Yes, of course, you will be getting “Completion Certificate”
Anyone can learn this program, as these are the basic tools now so everyone should have knowledge of these tools, for more detail please call us @ 9650308956
Obviously career opportunities are going to be increased after completing this course for both Data Management professionals or Non-Data Management professionals.
But yes who all are into Data Management profile they have to learn many more applications to compete in their domain, please have a look