Analyzing and Visualizing Data with Excel

Dany Hoter, Jonathan Sanito, Microsoft

Develop your skills with Excel, one of the common tools that data scientists depend on to gather, transform, analyze, and visualize data.

Excel is one of the most widely used solutions for analyzing and visualizing data. It now includes tools that enable the analysis of more data, with improved visualizations and more sophisticated business logics. In this data science course, you will get an introduction to the latest versions of these new tools in Excel 2016 from an expert on the Excel Product Team at Microsoft.

Learn how to import data from different sources, create mashups between data sources, and prepare data for analysis. After preparing the data, find out how business calculations can be expressed using the DAX calculation engine. See how the data can be visualized and shared to the Power BI cloud service, after which it can be used in dashboards, queried using plain English sentences, and even consumed on mobile devices.

Do you feel that the contents of this course is a bit too advanced for you and you need to fill some gaps in your Excel knowledge? Do you need a better understanding of how pivot tables, pivot charts and slicers work together, and help in creating dashboards? If so, check out DAT205x: Introduction to Data Analysis using Excel.

edX offers financial assistance for learners who want to earn Verified Certificates but who may not be able to pay the fee. To apply for financial assistance, enroll in the course, then follow this link to complete an application for assistance.

What will you learn

  • Gather and transform data from multiple sources
  • Discover and combine data in mashups
  • Learn about data model creation
  • Explore, analyze, and visualize data

Dates:
  • 1 October 2019
Course properties:
  • Free:
  • Paid:
  • Certificate:
  • MOOC:
  • Video:
  • Audio:
  • Email-course:
  • Language: English Gb

Reviews

No reviews yet. Want to be the first?

Register to leave a review

Show?id=n3eliycplgk&bids=695438
NVIDIA
More on this topic:
Matthiae_ebla Recovering the Humankind's Past and Saving the Universal Heritage
Archaeology has as its objective the recovery and revival of humankind's past...
Socialnetwork Social Network Analysis
This course will use social network analysis, both its theory and computational...
Images_course_image HRP258: Statistics in Medicine
Provides a firm grounding in the foundations of probability and statistics,...
134256_ff3b_6 Excel Beginner to Intermediate by ATI - Analytics Training Institute
Journey of Raw data to a Dashboard Microsoft Excel is by far the most widely...
53600_553c_3 Useful Excel for Beginners by ind zara
Learn the basics of Microsoft Excel and become an effective user Welcome to...
More from 'Mathematics, Statistics and Data Analysis':
F4ce8928-2ca9-47f0-bc53-804769ffe095-aebda55d0779.small IoT Programming and Big Data
Learn how to apply software solutions for different systems and Big Data needs...
48708e7e-0152-4a4b-ad4c-2dadce29c87f-78359bf75888.small Data Analysis in Social Science-Assessing Your Knowledge
Learn the methods for harnessing and analyzing data to answer questions of cultural...
5c7385bf-01ae-4f77-a628-1586471a91ac-3fc9f3407eac.small Evaluation of Predictive Modelling
Gain an in-depth understanding of evaluation and sampling approaches for...
Ef5dcb87-b65b-46a6-bb2a-c5a3f7807845-7cb915944555.small Engineering Calculus and Differential Equations
Learn fundamental concepts of single-variable calculus and ordinary differential...
2442b53e-d4b6-491a-90fe-6c3bfcbc0159-782d83a9d390.small Data Analysis for Decision Making
Use data analysis to gather critical business insights, identify market...
More from 'edX':
154ba19f-4602-4790-9131-b05c81962f89-7552ade5dc23.small Introduction to Sociology
From feminism to Marxism and functionalism, this course offers a fresh perspective...
Aac3b9a3-15fc-42e8-b2a9-4d9e8b58f2d9-9b7851ffec5a.small Introduction to Running Pipe in Oil and Gas Wells
Learn about the importance of proper preparation and handling of casing and...
199657a8-a0c0-4335-bc6c-1725077feb2c-85d56f5fea16.small Designing and Creating Trousers
Learn the construction and style adaptations of trousers for men and women,...
389d5e5e-7679-467e-b5bb-b21c9c86ca1f-31a7731a68f2.small Introduction to Biology - The Secret of Life
Explore the secret of life through the basics of biochemistry, genetics, molecular...
C9c58e99-326c-46ad-aa60-216c5db5bb8e-27e0ea893a6a.small Supply Chain Management: A Decision-Making Framework
Learn how to make rational and confident supply chain decisions, by understanding...

© 2013-2019