LIVRES JEUNESSEBÉBÉJEUX, JOUETSPAPETERIECADEAUXDIVERTISSEMENT


Message Important
Le site sera temporairement en maintenance, pour une mise à jour. Ceci afin de mieux vous servir.
Heure de maintenance prévue : 10:30 pm

Important message
The site will be busy updating the store for you and will be back shortly.
Scheduled maintenance : 10:30 pm
LIVRES NUMÉRIQUES
Data Mashup with Microsoft Excel Using Power Query and M - ADAM ASPIN

Data Mashup with Microsoft Excel Using Power Query and M

Titre de l'éditeur : Data Mashup with Microsoft Excel Using Power Query and M

ADAM ASPIN

 
58,13 $
Feuilleter Feuilleter
Ajouter à ma liste de souhaits
EN SAVOIR PLUS Résumé

Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel’s Get and Transform feature set, showing you how to connect to a range of external databases and other data sources to find data and pull that data into your local spreadsheet for further analysis. Leading databases are covered, including Microsoft Azure data sources and web sources, and you will learn how to access those sources from your Microsoft Excel spreadsheets.

Getting data into Excel is a prerequisite for using Excel's analytics capabilities. This book takes you beyond copying and pasting by showing you how to connect to your corporate databases that are hosted in the Azure cloud, and how to pull data from Oracle Database and SQL Server, and other sources.

Accessing data is only half the problem, and the other half involves cleansing and rearranging your data to make it useful in spreadsheet form. Author Adam Aspin shows you how to create datasets and transformations. For advanced problems, there is help on the M language that is built into Excel, specifically to support mashing up data in support of business intelligence and analysis. If you are an Excel user, you won't want to be without this book that teaches you to extract and prepare external data ready for use in what is arguably the world’s leading analytics tool.


What You Will Learn
  • Connect to a range of external data, from databases to Azure sources
  • Ingest data directly into your spreadsheets, or into PowerPivot data models
  • Cleanse and prepare external data so it can be used inside Excel
  • Refresh data quickly and easily to always have the latest information
  • Transform data into ready-to-use structures that fit the spreadsheet format
  • Execute M language functions for complex data transformations

Who This Book Is For

Excel users who want to access data from external sources—including the Microsoft Azure platform—in order to create business intelligence reporting, dashboards, and visualizations. For Excel users needing to cleanse and rearrange such data to meet their own, specific needs. 


Détails
Prix : 58,13 $
Catégorie :
Auteur :  ADAM ASPIN
Titre : Data Mashup with Microsoft Excel Using Power Query and M
Date de parution : juillet 2020
Éditeur : LIVRES NUMÉRIQUES DIVERS
Sujet : NUL DIVERS
ISBN : 9781484260180 (148426018X)
Référence Renaud-Bray : 3222533
No de produit : 3222533
Droits numériques
Format : PDF
Disponibilité : Canada, consultez la liste des pays autorisés.
Gestion des droits numériques : Adobe DRM
Entrepôt numérique : NUMILOG
Nombre d'appareils autorisés : 3
Nombre de copier/coller : 0
Impression : 0

SUGGESTIONS
Suggestions
ALLUME-CIGARETTE DE LA CHRYSLER NOIRE(l') BOUCHARD, SERGE
18,99 $
ALLUME-CIGARETTE DE LA CHRYSLER NOIRE(l') BOUCHARD, SERGE
18,99 $
Détresse et l'enchantement(La) 3e Ed. ROY, GABRIELLE
14,99 $
Data Mashup with Microsoft Excel Using Power Query and M , ASPIN , ADAM
© LIVRES NUMÉRIQUES DIVERS 2020