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.

*Note: *This course will retire at the end of October. Please enroll only if you are able to finish your coursework in time.

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 April 2020
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:
17ef5deb-91c0-4765-acba-b94b4503062e-94e3b11b6f05.small Business Analytics Fundamentals for Leaders
Master the principles and practical applications of business analytics. Analyzing...
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...
More from 'Mathematics, Statistics and Data Analysis':
D6fd079b-e8c1-476c-97d9-d7e4bbb1ecc4-49754ce235f3.small Predictive Analytics Final Project
Apply your predictive modelling acumen in a business case setting. The final...
C5a80d47-db96-407b-8034-2df8629a5dc3-5fc4c90a5aad.small LAFF – On Programming for Correctness
Learn to apply formal methods to systematically develop correct, loop-based...
Cae5395c-5179-4e6c-9e6c-873eb8f77d21-307674076932.small Advanced Linear Algebra: Foundations to Frontiers
Learn advanced linear algebra for computing. Linear algebra is one of the fundamental...
48708e7e-0152-4a4b-ad4c-2dadce29c87f-1b12f52e380e.small Data Analysis in Social Science—Assessing Your Knowledge
Learn the methods for harnessing and analyzing data to answer questions of cultural...
1cac89b9-58b6-4f8b-8cee-0a2f7feded60-9ed0da58fa14.small FA20: Introduction to Analytics Modeling
Learn essential analytics models and methods and how to appropriately apply...
More from 'edX':
D9d9cb21-b9b8-4d1a-8483-6c809aa711f8-06e936823ba3.small Visualizing the Birth of Modern Tokyo
See Tokyo’s modernization through the “100 views” tradition, from the gas-lit...
E906f10c-60b7-487d-a3c5-6e0799972bf9-e75f0ad42562.small Advanced Database Queries
Learn the fundamentals of interacting with relational database management systems...
2f110fb2-7ebf-47aa-b81f-c4b6fbf9c2e6-0e0979b0a362.small Solar Resource Assessment in Desert Climates
Learn how to use the components of solar radiation,solar spectrum, forecasting...
9a34e882-ef4a-4950-85be-ed0017c336d2-0fe2e9336746.small Using Photovoltaic (PV) Technology in Desert Climates
Learn how to mitigate the challenges related to PV technology and enhance the...
C34bc1e3-858b-4b4f-84c6-0a1d5a51d48d-1cc485f6a05f.small Fundamentals of Technical Analysis
Learn how to apply technical analysis as a standalone trading methodology or...

© 2013-2019