Duration: 8 Hours | Mode : On-line instructor led classes |  Tools: Excel 2013, Microsoft BI Power Maps & Power Pivot | Project: 3 Hours |   Assessment: Yes |  Certification : Yes

Next Batch

Starts Timings (IST) Price
4th, 5th and 11th October(Tentative)  4th: 11:00  a.m.- 2 p.m.

5th: 11:00  a.m.- 2 p.m.

11th October: 11:00 am to 1 p.m.  
Enroll now

Corporate Instructors

Amit Upadhyay Passport Photo Education:Computer Engineer and MBA from SCMHRD Experience: Ex – VP, HR, Citibank Advanced Analytics division, Worked at Amazon.com and GE
 
 Microsoft Excel and Power BI tools
– Excel SOP’s the right way to store and handle data, insert tables
– Compiling cross tab data in one minute
– Error checking and Handling
– 25 functions and 15 short-cuts like lookups, flash fill
– Reporting & Analytics using Advanced Excel & MSBI Surface charts, Sparkline’s, Power of Layered shortcuts and more
– MSBI Power Pivot & Power View: Creating drag and drop Databases in Excel, Management Dashboarding using Data slicers, without Vlookup
– MSBI Power Maps: Powerful Data Visualizations in Excel, create Data
– Stories in Excel with Videos and Audios.
– Solver: Finding an optimal (maximum or minimum) value for solving a mathematical problem
– What-If Scenario: Changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet
– Analysis Tool Pak: Linear Regression & ANOVA
 Visual Analytics Basics using Tableau
– Introduction to Tableau
– Connecting Tableau to a Data file
– Navigating Tableau
– Creating Calculated fields
– Adding Colors
– Adding Labels and formatting
– Exporting your worksheet
 Maps, Scatterplots and Dashboards
– Joining Data in Tableau
– Creating a Map, Working in Hierarchies
– Creating a scatterplot, applying filters to multiple worksheets
– Creating Dashboard
– Adding an interactive action- filter
– Adding an interactive action – Highlighting
 Table Calculations, Advanced Dashboards, Storytelling
– How to set Geographical roles
– Creating Table Calculations
– Creating Bins and distributions for Age
– Leveraging the power of Parameters
– How to create a Tree map chart
– Creating a Customer Segmentation Dashboard
– Advanced Dashboard interactivity
– Creating a Storyline