1 / 13

PowerPivot with NASA Data: Excel Add-in Insights

Explore the power of PowerPivot, an Excel add-in by Microsoft SQL team, to integrate NASA data. Learn to build robust models and visualize data in Excel using Time Intelligence and DAX. Discover features in version 2, from Date table to relationships, perspectives, and KPIs. Gain insights on developing in Excel vs. Visual Studio. Presented by Mark Stacey, founder of Pragmatic Works South Africa.

jonesjessica
Download Presentation

PowerPivot with NASA Data: Excel Add-in Insights

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BI from space: PowerPivot with NASA data PowerPivot, while being an Excel add-in, was built by the SQL team, and is one of the most powerful data integration tools in the Microsoft stack. In this session, you will learn how to combine data from web services, tables and cubes to build a powerful model, and visualise it in Excel. An introduction to Time Intelligence using DAX will lead us on to the new features in version 2, and we will move from the Date table to relationships, perspectives and KPIs.You will also see the difference between developing in the Excel addinvs Visual Studio.

  2. Mark Stacey • Founded Pragmatic Works South Africa • Just launched second office • Started BIDN Johannesburg chapter • Author of “Sharepoint 2010 BI” • Visual Intelligence Upcoming • …. Wishes the flight from Johannesburg was shorter • Should fall off MTBs less

  3. Agenda

  4. Space Science • National Space Science Data Center http://nssdc.gsfc.nasa.gov/ • All Space missions • Includes non US space missions The National Space Science Data Center (NSSDC) provides multidiscipline data and information services, including a large digital data archive from past NASA space science missions along with directories, catalogs, and access to widely distributed science data resources.

  5. Earth Observing System • http://eospso.gsfc.nasa.gov • Global Change Master directory • 25 000 datasets • http://gcmd.nasa.gov/ The Earth Observing System (EOS) is a coordinated series of polar-orbiting and low inclination satellites for long-term global observations of the land surface, biosphere, solid Earth, atmosphere, and oceans.

  6. Earth Based Telescopes • Optical • Radio, Gamma Ray, UV, Infrared, Microwave, Particle • Difficult to get time (think Mainframes) • How to find specific data? Datasets from space based telescopes also fall into this general class of datasets.

  7. Keck in Hawaii Largest ground based optical telescope 10m mirrors Kepler NASA's first mission capable of finding Earth-size planets around other stars0.95m mirror WMAP Wilkinson Microwave Anisotropy Probe – used to measure temperature differences in Cosmic Microwave background 3 highlights

  8. Finding Data • Sloane Digital Sky Surveyhttp://cas.sdss.org/dr7/en/ • Index for finding objects • Can issue SQL Queries • Bigger queries scheduled to run as batch • 500 MB limit Sloan Digital Sky Survey (SDSS) consists of a series of three interlocking imaging and spectroscopic surveys, carried out over an eight-year period with a dedicated 2.5m telescope located at Apache Point Observatory in Southern New Mexico. This seventh data release (DR7) from the SDSS represents the completion of this project.

  9. Practical

  10. Some characteristics Exoplanets

  11. mstacey@pragmaticworks.com @MarkGStacey

More Related