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.
cover
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 content–files 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
