Integrity Training – Business Intelligence with Microsoft Excel
Description
Excel 2013 is a game changer for any Excel user. Excel 2013 provides new technologies and tools for the business user to easily analyze data to create powerful reports and dashboards in a fraction of the time of traditional spreadsheets.
This course is for all business users who want to learn how to create management reports, analyze data and create interactive dashboards using Excel 2013.
In this course we learn the following:
Power Query
- Cleaning up Data
- Merging Data
- Appending Data
- Grouping Data
- Loading data to PowerPivot
Power Pivot
- Create relationships between Tables
- Manage millions of rows of data
- Custom Calculations, Key Metrics and KPIs
- Analyzing Data with Pivot Tables
- Analyzing Date data
Power View
- Creating Tables and Cards
- Visualizing data with Graphs
- Creating Interactive dashboards
- Filter and Ask Questions of your Data
- Powerful data analysis with ScatterPlots and BubblePlots
- Visualize Geographical data and maps
Power Map
- Mapping Data with Power Map
- Changing the Method of Visualization
- Changing the Method of Aggregation
- Mapping Data over Time
- Creating Tours
This course will provide you with an easy to follow step by step approach to using the new Business Intelligence technology in Excel 2013.
We guarantee that all our online courses will meet or exceed your expectations. If you are not 100% satisfied with a course – for any reason at all – simply request a full refund.
That’s our promise to you. We hate games, gimmicks and tricks as much as you do. We guarantee no hassles if you want a refund, so ahead and order with confidence. You have absolutely nothing to lose.
Course Curriculum
- Start
Introduction to Excel Business Intelligence Technologies (2:58)
- Start
Activating Addins (2:20)
- Start
Introduction to Power Query
- Start
Power Query Interface (8:39)
- Start
HR Master
- Start
Cleaning and Transforming Data with Power Query (14:39)
- Start
Download the Append Data Files
- Start
Appending Data with Power Query (9:22)
- Start
Download Merge Data Files
- Start
Merge Data with Power Query (8:53)
- Start
Sales Data
- Start
Using the Group By Feature (8:06)
- Start
Load Data to Power Pivot (10:14)
- Start
Introduction to Power Pivot
- Start
Introduction to Power Pivot (1:49)
- Start
Download the Employee Master Training File
- Start
Loading Data into PowerPivot (7:28)
- Start
Creating Relationships (3:41)
- Start
Analyzing Data with Pivot Tables (8:56)
- Start
Calculated Columns (12:11)
- Start
Calculated Fields (11:33)
- Start
Pivot Tables and Pivot Charts (14:29)
- Start
Creating Interactive Dashboards (14:31)
Lord –
This is Digital Download service, the course is available at Coursecui.com and Email download delivery.