Analytics with MS Excel, Power BI and Tableau

Three of the widely used data analytics tools: MS Excel, Power BI and Tableau - All in one training program!

Our advanced MS Excel program rechristened as Analytics with MS Excel, Power BI and Tableau is focused on boosting productivity and analytical capability of professionals across discipline.

In this program, you will learn how to convert large amount of raw data into meaningful insights and deliver with powerful and effective visuals. You will learn everything starting from cleaning those messy bunch of cells in MS Excel to conveying stories through great visual in Power BI and Tableau. You will also learn to write DAX queries in Power BI and apply formula in Tableau. 

Whether you are in finance, marketing, production or HR, our wide variety of practical case studies will help you directly relate this to your work and help you improve your productivity and your capability to handle data. This program does not just cover formulas and functionalities but our proprietary module on reverse flow charting technique will also enable you to develop your own solutions to problems in hand.

With over 60 practical case studies including three full fledged analytical case studies all inspired from real life corporate situations, we are sure that you would be able to immediately make a difference in your work.

The program is up to date and covers all the latest functions and functionalities including XLOOKUP, XMATCH and Dynamic Arrays.

Duration: 40 hours (36 hours in case of virtual training sessions)

Course outline

• Best practices in storing data
• Cleaning unclean data
• Advanced MS Excel functions 
• Working with date and text
• Reverse flow charting technique to develop algorithms and solutions
• Working with tables and arrays
• Dash boarding in MS Excel
• Working with power query and power Pivot
• Fundamentals of working with Power BI
• Introduction to DAX functions
• Introduction to VBA