Business Intelligence with Excel 2013
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1 Hour 49M | 1.15 GB
Genre: eLearning | Language: English

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 ScatterDescriptions and BubbleDescriptions 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.