Learn Microsoft Power BI Desktop: The Basics Год выпуска: 03/2016 Производитель: Lynda Сайт производителя: lynda.com/Power-BI-tutorials/Up-Running-Microsoft-Power-BI-Desktop/445425-2.html Автор: Gini Courter Продолжительность: 2:55 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: Get more insights from your data, whether it's stored on your computer or the cloud. Learn how to connect to and merge data with Microsoft Power BI Desktop, the powerful data analysis and visualization software. In this course, you'll learn how to connect various data sources, including Excel, Access, and web data sources (including Facebook), and search and transform the data with simple queries. Gini Courter also shows how to create relationships between data sources, merge data, and build and share reports. Получить больше понимания от ваших данных, будь то хранимые на вашем компьютере или в облаке. Узнайте, как подключить и слить данные с Microsoft Bi питания настольный, мощный анализ данных и визуализация программного обеспечения. В этом курсе вы узнаете, как подключать различные источники данных, включая Excel, Access и веб-источники данных (включая Facebook), и поиск и преобразование данных с помощью простых запросов. Джини Courter также показано, как создавать отношения между источниками данных, слияние данных, и создавать и распространять отчеты.
Содержание
Introduction Welcome What you need for this course How to use the exercise files 1. Get Started Understanding Power BI What are Power BI Desktop and Desktop Pro? Installing Power BI Desktop Launching Power BI Desktop 2. Get Data Understanding Power BI data sources Connecting to a file: Excel Connecting to a file: CSV Connecting to a database: Access Connecting to a web data source Connecting to Facebook Importing Excel data models 3. Model Data: Shaping, Combining, and Merging Data Reducing data with the Query Editor Transforming data Inserting custom columns Appending data to a query Adding an index column Cleaning up data Creating relationships between tables Merging data Using lookup tables in a dataset 4. Create Visualizations and Reports Creating and arranging visualizations Creating text visuals: Cards, table, matrix Creating and formatting chart visuals Using a slicer to filter visuals Creating a map visualization 5. Share Your Work Publishing to the Power BI service Republishing a dataset to the Power BI service Refreshing and removing datasets and reports Sharing and unsharing reports Conclusion Next steps
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}