Analyzing and Visualizing records with Excel

About this course

Excel is one of the maximum broadly used solutions for analyzing and visualizing records. It now includes tools that allow the analysis of more facts, with progressed visualizations and more state-of-the-art business logics. on this records science route, you may get an introduction to the cutting-edge versions of those new gear in Excel 2016 from an expert at the Excel Product team at Microsoft.

learn how to import statistics from special sources, create mashups between records resources, and put together records for analysis. After preparing the statistics, discover how commercial enterprise calculations may be expressed the use of the DAX calculation engine. See how the facts may be visualized and shared to the electricity BI cloud service, and then it may be used in dashboards, queried the usage of undeniable English sentences, or even ate up on mobile gadgets.

What you will learn

accumulate and remodel statistics from a couple of resources
discover and combine data in mashups
study statistics version introduction
discover, examine, and visualize facts

View course Syllabus
path Syllabus

Week 1

Setup the lab surroundings by way of installing workplace applications. learn how to perform data analysis in Excel the use of classic tools, consisting of pivot tables, pivot charts, and slicers, on statistics this is already in a worksheet / grid statistics. discover an Excel records model, its content, and its structure, the usage of the power Pivot upload-in. Create your first DAX expressions for calculated columns and measures.

Week 2

learn about queries (power question add-in in Excel 2013 and Excel 2010), and build an Excel statistics model from a single flat table. learn how to import a couple of tables from a square database, and create an Excel statistics model from the imported information. Create a mash-up among information from textual contentfiles and records from a square database.

Week three

Get the info on how to create measures to calculate for each cell, clear out context for calculation, and discover numerous superior DAX capabilities. discover a way to use advanced text query to import information from a formatted Excel document. carry out queries beyond the standard user interface.

Week four

discover approaches to create lovely visualizations in Excel. Use the dice functions to perform 12 months-over-year comparisons. Create timelines, hierarchies, and slicers to beautify your visualizations. find out how Excel can work together with energy BI. add an Excel workbook to the power BI provider. explore using Excel at the mobile platform.
Meet the instructor

bio for Dany Hoter

Dany Hoter

Senior application manager Excel crew

Pursue a established certificate to highlight the expertise and abilities you advantage ($49)
View a PDF of a pattern edX certificates

authentic and confirmed

get hold of an instructor-signed certificates with the group‘s logo to affirm your success and growth your task possibilities
effortlessly Shareable

add the certificate for your CV or resume, or publish it at once on LinkedIn
demonstrated Motivator

deliver your self an extra incentive to finish the path
aid our mission

EdX, a non-income, is predicated on proven certificates to assist fund free schooling for everybody globally