BIG DATA ANALYSIS AND DASHBOARD WITH MICROSOFT EXCEL FOR BUSINESS ANALYSTS
Live-Online Training: N155,000
Classroom Training: N 195,000
3 - 4 participants: 5% discount
5 or more participants: 10% discount
(Available also for Customised Training by Duration, Venue & Fee)
(PARTICIPANTS MUST BE WITH THEIR COMPUTERS)
Course Contents
DAY ONE
Subtotal Application
Pivot Table
- Default Pivot Table
- Tabular Pivot Table
- Pivot Table Filtering
- Making a very dynamic regular table from Pivot Table
- Calculations and Formula use with Pivot Table
- Sensitivity Analysis
DAY TWO
Advanced Pivot Table tricks.
- PowerPivot for Data Mining (Excel 2013 and above with PowerPivot Addin)
- Working with data of over 2 million rows
- Connecting with multiple sources of data
- DAX formulas
- Most popular PowerPivot Analysis.
PowerQuery
- Understanding what PowerQuery is
- Simple practical uses
- Using it to connect to third party data sources (your ERP or Database).
PowerView
- Understanding what PowerView is
- Simple practical uses.
Power Map
- Plotting your data on a live map that can be zoomed and rotated
- Special amazing use of the Power Map.
DAY THREE
Charting Large Data
- Understanding the principles that guide visualizing large data
- Making charts that bring insights to a large data
- Building a large data dashboard.
Making Professional Reports in Excel and Dashboards
- Linking sheets
- Duplicating sheets (better than copy and paste)
- Inserting sheets, labeling and coloring the professional way
- Freezing Panes and splitting windows
- Conditional formatting
- To identify patterns
- Using formulae
- To make extremely intelligent reports
Absolute and Relative Cell addressing to make effective formulas
Dashboards
Having the audience/recipient in mind.
DAY FOUR
E-mails and Excel reports
Excel to PowerPoint
- Linking PowerPoint Charts to Excel
- Embedding Excel sheets in PowerPoint
- Making a Powerful PowerPoint Presentation
Excel to Word
- Mail Merge: Sending a personalized mail to a list of people
- Linking PowerPoint Charts to Excel
- Embedding Excel sheets in Word
- Copying tables and content from Excel to Word, the right way.