Home
Search results “Office 365 business powerpivot”
Power BI for Office 365
 
01:02:28
A demonstration of Power BI for Office 365, showing you how all the various tools and technlogies work together: Power Query, Power Pivot, Power View, Power Map, Power BI sites, Data Management, Power BI Admin center, Power BI for mobile, Power BI Q&A
Views: 61868 James Serra
Learn Excel 2016 - PowerPivot How-To
 
17:02
Learn how to use the powerful Microsoft Excel 2016 Add In, PowerPivot. This powerful features enables you to import millions of rows of data from multiple data sources into a single Excel worksheet, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts and the further analyze the data so you can make timely business decisions without requiring IT assistance. Outline Introduction To Excel PowerPivot Getting Started with PowerPivot Use Linked Excel Tables in PowerPivot Import Data from Various Data Sources Create a PivotTable from PowerPivot Data Please subscribe to Learn IT's YouTube channel and get the latest in End-User, Professional Development, and Technical Training videos!
Views: 202771 Learn iT! Training
Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468)
 
50:06
Download Excel File #1: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1468.xlsm Download Excel File #2: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1468Finished.xlsm Download Zipped Folder: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1468TextFiles.zip Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm Buy excelisfun products: https://teespring.com/stores/excelisfun-store Learn about how Topics: 1. (00:16) Introduction 2. (00:51) Discussion about the two different Data Ribbon Tabs and Get & Transform groups that you may see in Excel 2016 3. (03:51) Example #1: Clean Data and create Excel PivotTable Report, then add new data and refresh report! 4. (17:06) Example #2: Transform Cross Tabulated Table into Proper Data Set 5. (21:50) Example #3: Import 1.2 Million Rows of Data from Text Files into Power Pivot and create a Data Model PivotTable, then add new data and refresh our report. 6. (22:34) Diagram to understand Data Model and Power Pivot 7. (46:46) Unhanded Exception Error. 8. (48:02) Summary Reference Video: Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model https://www.youtube.com/watch?v=Jzt-I4mt8sQ
Views: 246564 ExcelIsFun
Interactive Excel Dashboards with Power Query and Power Pivot
 
53:30
Download file used in the video with step by step instructions and links to more tutorials: https://www.myonlinetraininghub.com/workbook-downloads In this video you will learn how to create an interactive dashboard from scratch using Excel's Power Query and Power Pivot tools. Applies to Excel 2010 onward for Windows only. Subscribe to my free newsletter and get my 100 Tips & Tricks eBook here: https://www.myonlinetraininghub.com/sign-up-for-100-excel-tips-and-tricks
Views: 166759 MyOnlineTrainingHub
Data Modeling in Excel using Power Pivot
 
54:18
Learn how Power Pivot simplifies data analysis. Topics include: Multiple tables and relationships, editable linked tables, DAX formulas, custom calendars, and measure concepts with a focus on demonstrating each of these capabilities.
Views: 73692 Microsoft Power BI
Power Pivot Step By Step
 
18:28
In this special guest segment from episode 23 of Coffee Talk, Microsoft Collaboration Technology Specialist Brent Whichel walks us through PowerPivot creations step by step. Learn how to take data from different sources, relate it, visualize it in PowerPivot, and finally publish it to SharePoint.
Views: 58361 Michael Gannotti
Power BI , la Business Intelligence Libre-Service - PowerPivot la révolution Excel (1/7)
 
16:32
L'idée de Microsoft à travers Power BI est de démocratiser la BI, la BI pour tous. Pour la démocratiser, il faut développer son accessibilité par le plus grand nombre, en terme monétaire et en terme technique. En effet, beaucoup de TPE/PME n'ont pas forcément la capacité financière à investir plusieurs dizaines de milliers d'euros dans des licences, n'ont pas forcément de compétences informatique internes, donc il faut une solution économique et simple. Economique ! Les add-ins EXCEL (Power Query, Power Pivot, Power View, Power Map) composant Power BI sont GRATUITS, le seul investissement nécessaire est d'avoir une version Excel 2013. Pour pouvoir publier ses rapports en ligne et les gérer, il faut un abonnement Office 365, quelques dizaines d'euros par utilisateur. Simple ! Power Bi s'appuie sur Excel, l'un des logiciels les plus présents dans l'entreprise avec lequel de nombreux utilisateurs travaillent quotidiennement. Power BI intègre différents compléments qui révolutionnent le tableur (plus particulièrement Power Pivot et Power Query), des niveaux de compétence simple permettent déjà de réaliser des analyses remarquables, et avec un investissement de quelques jours de formation, une nouvelle façon de synthétiser et de consolider les données se fait jour. Que contient Power Bi ? Power Query : Collecte et transformation des données (un ETL en libre-service) Power Pivot : Modélisation, Analyse, Agrégation, Consolidation des données Power View : Visualisation interactive de vos données Power Map : Représentation géographiques et interactive de vos données en 3D Power Q&A : Un langage naturel d'interrogation Sites PowerBi : Publication de vos tableaux Excel en ligne et accessibilité à partir d'un simple navigateur Passerelle (Data Management Gateway) : Cette passerelle crée un lien sécurisé entre vos données stocké sur vos serveurs et les modèles Excel Power Pivot hébergés dans le Cloud Office 365. Elle permet également une mise à jour automatique des tableaux Excel.
Views: 15512 Jean-Pierre Girardot
Power BI for Office 365 Demo
 
11:51
Views: 8357 InecomTV
Unleashing Power BI for Office 365
 
18:58
In this week's show, host Jeremy Chapman is joined by Michael Tejedor from the SQL Server team to discuss Power BI and show it in action. Power BI for Office 365 is a cloud-based business intelligence (BI) solution that lets you gain insights from your data to analyze and visualize it in powerful ways. Michael draws up the self-service approach to Power BI as well as how public data can be queried and combined in a unified view within Excel. Then they walk through an end-to-end demo of the Power BI components - Power Query, Power Pivot, Power View, Power Map and Q&A - as they optimize profitability of a bar and reign in bartenders with data.
Views: 10037 Microsoft Mechanics
Collab365 - Leverage Big Data and HDInsights to create Business Intelligence
 
01:21
Companies have huge amounts of data waiting to be explored. With Azure HDInsights you can realize the value of your data. With Microsoft Excel 2013 and Office 365, you have a complete platform for BI solutions and services. Power BI allows companies to manipulate and study a variety of data points, gain actionable insights and share their insights. PowerPivot, Power View, Power Query, Power Map and Power BI Sites let users analyze and make decisions using structured and unstructured data. You will learn : - Learn to setup and configure HDInsights on Microsoft Azure. - Build a BI Dashboard in Office365. - Understand the pros and cons for the different Excel BI capabilities. - How to create Excel PowerView Charts Features Covered: Azure HDInsightsBig DataOffice 365Excel PowerView
Views: 32 Brian Culver
Introduction To Power Pivot
 
04:55
http://bicg.com.au/index.php/introduction-to-power-pivot-in-excel-2013/ Power Pivot add-in for Excel 2010/2013 is used to perform powerful data analysis, self-service business intelligence within the familiar framework of Excel on your desktop. Using Power Pivot you can import data from different source like RDBMS, data feeds, spread-sheets, files. It also support BIG Data and Hadoop. Data is imported into PowerPivot for Excels as Tables which is shown as sheets in the Power Pivot window. How Data is Stored The data that you work on in Excel and in the Power Pivot window is stored in an analytical database inside the Excel workbook, and a powerful local engine loads, queries, and updates the data in that database. Because the data is in Excel, it is immediately available to PivotTables, PivotCharts, Power View, and other features in Excel that you use to aggregate and interact with data. All data presentation and interactivity are provided by Excel; and the data and Excel presentation objects are contained within the same workbook file. Power Pivot supports files up to 2GB in size and enables you to work with up to 4GB of data in memory. Power Pivot BI Architecture in Excel 2013 Please note that PowerPivot BI Architecture in Excel 2013 is different from Excel 2010. Earlier X-velocity engine was part of add-in however with Excel 2013, it is built-in. Image source: http://www.powerpivotpro.com/ Note: Power Pivot for Excel and Power Pivot in SharePoint has different architecture. Power Pivot Limitation 1. Power Pivot for Excel has 2 GB file limitation. 2. Because the size of file can be upto 2GB, it’s difficult to share across mails. 3. In order to share the reports created using Power Pivot Data Model, SharePoint Server 2010/13 with SQL 2012/14 is required which again is the added cost. 4. Another option to share Power Pivot Data Model reports is to use Power BI for Office 365 but has a limitation of 250 MB file size limit. 5. Without using On-premise SharePoint, you cannot connect with existing Power Pivot Model Workbook and create a report in another workbook. Data Model connection to create report is only available through SharePoint (Not Office 365) Power Pivot OR Tabular Model In a nutshell both Power Pivot and Tabular uses xVelocity Engine and have same concepts. So what is the difference and which one is better? Actually Tabular model is for IT professional while Power Pivot is for Business Users. And that is the reason 2GB size limitation is acceptable in most of the business users scenario and quick data analysis. But in case of enterprise wide requirement like scalability, manageability, securability and professional development, tabular model has an edge over power pivot. Since Power Pivot model can be imported into Tabular Model, a business user might create a solution using Power Pivot and then IT can add features that are not supported in Power Pivot to the tabular model like security and maintainability etc. View Training from here http://bicg.com.au/index.php/how-to-enable-power-pivot-power-view-in-excel-2013/
Views: 253 AI Australia
Basic Excel Business Analytics #41: Excel 2016: Introduction to PowerPivot & Data Model
 
10:53
Download file from “Highline BI 348 Class” section: https://people.highline.edu/mgirvin/excelisfun.htm Learn about PowerPivot & Data Model in Excel 2016. 1) (00:11) Intro to what we will do in this video 2) (00:30) Step 1 for Building Data Model: Get Data into PowerPivot. For our example we convert Proper Data Sets in Excel to a Table and use “Add to Data Model” button in PowerPivot Ribbon Tab 3) (01:00) Excel 2016: New PowerPivot Ribbon Tab. They have renamed “Calculated Field” Button (Excel 2013) to “Measure” button (Excel 2016). We can build DAX Measures (Calculated Fields) with this new button. 4) (02:24) Step 2 for Building Data Model: Create Relationships between related tables using the “Diagram View” button in the “Manage Data Model” window. 5) (02:47) Excel 2016: New one-to-many visual presentation in the Diagram View window. We can see a line with the number one ( 1 ) next to the primary key field in the lookup table (dimension table) and an asterisk next to the Foreign Key in the Fact table. 6) (03:34) Step 3 for Building Data Model: Build DAX Calculated Column formulas. In this example we calculate Net Revenue for each transaction using the RELATED DAX function and the ROUND DAX function and a number of columns from the Fact Table. We also learn about the convention for adding columns to DAX formulas: ALWAYS use the Table Name and the Field Name (Column Name) with square brackets around it. 7) (05:56) Discussion of Implicit vs. Explicit formulas. 8) (05:56) Step 3 for Building Data Model: Build DAX Measures (Calculated Fields) formulas. In this example we will calculate Total Net Revenue using the DAX SUM function and the Calculated Column from our Fact Table. This is an explicit formula that can work efficiently with the Columnar database on big data sets. 9) (07:17) Add Number Formatting to Measure (Calculated Field) 10) (07:32) Discussion of Filter Context: The ability of the Measure (Calculate Field) to respect criteria in the PivotTable and filter the underlying table to result in a range that is smaller than the full table size and will contribute to faster formula calculation time; in essence the DAX formula and the Columnar Database work together efficiently – and much more efficiently than normal PivotTable calculations or normal spreadsheet Excel formulas. 11) (08:00) Build PivotTable from Data Model 12) (08:30) Excel 2016: New “F of X” Function Icon for Measures (Calculated Fields) in the PivotTable Field List. 13) (09:23) More discussion of Filter Context and why DAX Measures (Calculated Fields) can calculate efficiently on Big Data. 14) (09:59) Summary and Conclusion Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video. Introduction to PowerPivot and Data Model in Excel 2016, What is PowerPivot Excel 2016? What is Data Model Excel 2016? What is New in Excel 2016 PowerPivot? What is new in Excel 2016 Data Model?
Views: 72204 ExcelIsFun
Dynamics 365 Business Central: Microsoft Stack Explained, Excel & Power BI
 
06:53
Follow iNECTA University on Twitter: @inectaU Follow Johannes Gudmundsson: @nav_viking Learn more about Microsoft D365 Business Central: http://www.inecta.com/businesscentral Visit http://www.inecta.com for more info and please subscribe to our videos. They're published every Tuesday and Thursday. We welcome your comments and suggestions for future videos. Thanks!
Views: 271 iNECTA University
Cómo Instalar PowerBI, Power Pivot para excel 2010, 2013 o 2016
 
08:45
En este video verás como Instalar Power BI, o el complemento Power Pivot para excel 2010, 2013 o 2016. https://powerbi.microsoft.com/es-es/downloads/
Views: 25086 David Ortega Mazzini
Introduction to Power Pivot for Excel
 
23:31
http://chandoo.org/wp/2013/01/21/introduction-to-power-pivot/ A brief over view of Power Pivot for Excel & why it is the most awesome way to analyze data.
Views: 312036 Learn Excel from Chandoo
Excel 2013 PowerPivot Basics #01: Introduction To PowerPivot for Excel 2013
 
38:33
Download file: http://people.highline.edu/mgirvin/excelisfun.htm Scroll to down to PowerPivot Section. Basics of PowerPivot: Why PowerPivot?, Add to Data Model, Relationships, Calculated Column, Calculated Field, Build report with PivotTable based on Data Model: 1. (00:22 min mark) Smartest People with PowerPivot 2. (01:31 min mark) Which Versions of Excel 2013 contain PowerPivot 3. (01:46 min mark) Install PowerPivot for Excel 2013 4. (02:14 min mark) What aspects of PowerPivot is so amazing 5. (06:46 min mark) When not to use PowerPivot 6. (07:28 min mark) Amazing PowerPivot Columnar Database, also known as Data Model or PowerPivot xVelocity engine 7. (09:46 min mark) Example of Multiple tables when you don’t want to use PowerPivot, but instead would want to use Helper Columns and VLOOKUP functions. In essences, PowerPivot will not permanently replace all VLOOKUPs. When you have multiple tables, sometimes PowerPivot will be the perfect solution, other times VLOOKUP will be the perfect solution. 8. (14:19 min mark) Start of PowerPivot Example 9. (14:48 min mark) Convert Proper Data Sets to Excel Tables BEFORE importing into PowerPivot, Create Table Keyboard = Ctrl + T, Name Table Keyboard = Alt, J, T, A 10. (15:43 min mark) Why Excel Import must be Excel Table. 11. (15:55 min mark) “Fact Tables and Dimension Tables” = Database terms, and, “Transaction Tables and Lookup Tables” = Excel Terms” 12. (16:22 min mark) Import Excel Tables into “Manage Data Model” window using “Add to Data Model”, Keyboard = Alt, B, Y 13. (16:44 min mark) Manage Data Model window 14. (17:56 min mark) We start to build the “Data Model” by bringing the Tables into the “Manage Data Model” window. 15. (18:11 min mark) Building Relationships between Tables using the “Diagram View” 16. (18:25 min mark) Arranging Tables in “Star Schema” view or “Criteria/Filters Flow Downward” view. 17. (19:05 min mark) Continuing to build the Data Model by adding Relationships between Tables. Relationships replace VLOOKUPs. 18. (20:26 min mark) One To Many Relationship 19. (22:16 min mark) PivotTable mistake if you don’t create correct Relationships 20. (22:25 min mark) Multiple Tables appear in PivotTable Field list. 21. (23:26 min mark) Correct PivotTable with correct Relationships: Units by Region PivotTable. This means we can drag and drop fields into the PivotTable from Multiple Tables. 22. (24:21 min mark) Format Tables in “Manage Data Model” window. 23. (25:20 min mark) Sort columns in Tables in “Manage Data Model” window. 24. (25:35 min mark) Adjust view of Measure Grid below Tables. 25. (25:44 min mark) Create Calculated Column in in “Manage Data Model” window. 26. (26:22 min mark) RELATED function replaces VLOOKUP 27. (26:39 min mark) We must use Formula Bar to create formulas. 28. (27:11 min mark) Table Names and Field Names are similar to Excel Table Formula Nomenclature (Structured References): Tables Names are followed by Field Names in square brackets. 29. (27:39 min mark) Row Context for Calculated Columns: No more Cell References like in normal Excel formulas. 30. (28:58 min mark) Formula for Net Revenue given price, discount and units. 31. (29:04 min mark) Formula Convention for Table Names and Field Names: Tables Names are followed by Field Names in square brackets. From Russo and Ferrari. 32. (30:36 min mark) Functions in PowerPivot are called DAX functions. DAX = Data Analysis Expressions. 33. (30:58 min mark) Number Formatting From Calculated Column Formula appears in PivotTable!!!! 34. (32:23 min mark) Implicit vs. Explicit Formulas. Explicit is better because you can use them in any other PivotTable or Calculated Column or Calculated Field (Measure) 35. ( min mark) Create Calculated Field (Measure) in the Measure Grid below the Table. These are Explicit Formulas. 36. (33:56 min mark) Conventions for created Calculated Fields. 37. (34:52 min mark) Add Number Formatting to Calculated Field. 38. (36:00 min mark) Filter Context: Calculated Fields (Measures) resect the Criteria dropped into the Row/Column/Filter and Slicer area of PivotTables. The Criteria in the PivotTable actually filters the underlying Data Model.
Views: 513925 ExcelIsFun
Vlookup in PowerPivot and PowerBI
 
07:16
Learn to write Vlookup in PowerPivot and PowerBI. RELATED Function and Relationships are the equivalent of Vlookup in Excel Read the full article and download the files here - https://www.goodly.co.in/vlookup-in-powerpivot-and-powerbi
Views: 1789 Goodly
A tour inside Power BI for Office365
 
17:49
Register for the preview http://www.powerbi.com/ Visit the official Power BI team blog: http://blogs.msdn.com/b/powerbi/ Watch a full explanation of the new natural language query or Q&A: http://www.youtube.com/watch?v=PSczHlIH-ig Follow me on Twitter: https://twitter.com/EscobarMiguel90 Sponsor: http://www.poweredsolutions.co
Views: 1730 The Power User
MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions
 
02:04:00
Download Excel START File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/15Video/015-MSPTDA-ComprehensiveIntroPowerPivot.xlsx Second Excel Start File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/15Video/015-WhyDAXandNotStandardPivotTable.xlsx Download Zipped Folder with Text Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/15Video/015-TextFiles.zip Download Excel FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/015-FinishedDashboard-Finished.xlsx Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/015-MSPTDA-PowerPivotComprehensiveIntroduction.pdf Assigned Homework: Download Excel File with Instructions for Homework: Start Excel File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/015-MSPTDA-Homework-Start.xlsx Zipped Data Folder: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/015-MSPTDA-HomeworkExcelDataFiles.zip Examples of Finished Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/015-MSPTDA-Homework-Finished.xlsx This video teaches everything you need to know about Power Pivot, Data Modeling and building DAX Formulas, including all the gotchas that most Introductory videos do not teach you!!! Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor. Topics: (00:15) Introduction & Overview of Topics in Two Hour Video 1. (04:36) Standard PivotTable or Data Model PivotTable? 2. (05:51) Excel Power Pivot & Power BI Desktop? 3. (12:31) Power Query to Extract, Transform and Load Data to Data Model – Get data from Text Files, Relational Database and Excel File. 4. (25:47) Build Relationships 5. (27:43) Introduction to DAX Formulas: Measures & Calculated Columns 6. (29:15) DAX Calculated Column using the DAX Functions, RELATED and ROUND 7. (31:20) Row Context: How DAX Calculated Columns are Calculated: Row Context 8. (33:49) We do not want to use Calculated Column results in PivotTable using Implicit Measures 9. (34:05) DAX Measure to add results from Calculated Column, using DAX SUM Function. 10. (35:29) Number Formatting for DAX Measures 11. (36:35) Data Model PivotTable 12. (39:31) Explicit DAX Formulas rather than Implicit DAX Formulas 13. (41:50) Show Implicit Measures 14. (45:00) Filter Context (First Look) How DAX Measures are Calculated 15. (50:14) Drag Columns from Fact Table or Dimension Table? 16. (53:30) Hiding Columns and Tables from Client Tool 17. (55:52) Use Power Query to Refine Data Model 18. (57:54) SUMX Function (Iterator Function). DAX Measure for Revenue using the SUMX Function to simulate Calculated Columns in DAX Measures 19. (01:01:00) Compare and Contrast Calculated Columns & Measures 20. (01:04:26) Why We Need a Date Table. Why we do NOT use the Automatic Grouping Feature for a Data Model PivotTable 21. (01:06:46) Build an Automatic Date Table in Excel Power Pivot. And then build Relationship. 22. (01:11:00) Introduction to Time Intelligence DAX Functions. See TOTALYTD DAX Function 23. (01:13:47) Introduction to CALCULATE Function: Function that can “see” Data Model and can change the Filter Context. (01:18:00) Also see the ALL and DIVIDE DAX Functions. Create formula for “% of Grand Total”. Also learn about (01:21:30) Context Transition and the Hidden CALCULATE on all Measures. 24. (01:27:18) DAX Formula Benefits. 25. (01:28:00) Example of DAX Formula that is easier to author than if we tried to do it with a Standard Pivot Table or Array Formulas 26. (01:31:50) AVERAGEX Function (Iterator Function) to calculate Average Daily Revenue. 27. (01:34:00) Filter Context (Second Look) AVERAGEX Iterator Function 28. (01:36:16) Build Dashboard. Create multiple DAX Formulas. Create Multiple Data Model PivotTables and a Data Model Chart. 29. (01:38:38) Create Measures for Gross Profit and Gross Profit % 30. (01:41:27) Continue making more Data Model PivotTables. 31. (01:41:50) Make Data Model Pivot Chart. 32. (01:45:10) Conditional Formatting for Data Model PivotTable. 33. (01:46:22) DAX Text Formula for title of Dashboard 34. (01:47:50) CUBE Function to Convert Data Model PivotTable to Excel Spreadsheet Formulas. 35. (01:50:05) Adding New Data and Refreshing. 36. (01:50:40) Update Excel Power Pivot Automatic Date (Calendar) Table. Clue is the blank in the Dimension Table Filter. 37. (01:52:20) How to Double Check that a DAX Formula is yielding the correct answer? 38. (01:53:22) DAX Table Functions. See CALCULATETABLE DAX Function. 39. (01:55:07) DAX Studio to visualize DAX Table Functions, and to efficiently create DAX Formulas 40. (02:00:12) Existing Connections to import data from Data Model into an Excel Sheet (02:03:15) Summary
Views: 36131 ExcelIsFun
Excel - How to activate power pivot
 
00:42
Microsoft Excel as a spreadsheet application from microsoft office have many limit, especially when working with big data. Excel have a solution (adds-ins) for this, that is Power Pivot. Power Pivot is a very strong tools for transforming and pivoting data in excel. It have a very high speed at processing data than reguler pivot, and it can work with more then one data source. Power pivot also able to handle more than one million rows ( more then 1048576 rows ) in excel using the help of excel data model. Power pivot is not automatically availabe on excel, you need to activate it manually show the power pivot tab can show up. This short video will show you how to activate or show excel Power Pivot Tab ( Ribbon ) Please make sure your microsoft office is one of these version before claiming this not working: All Office 365 Office Professional 2016 Office 2013 Professional Plus Office 2016 Professional Plus (available via volume licensing only) Excel 2013 standalone Excel 2016 standalone In excel 2010, you can download power pivot 1st for free setting the Input Text, error message / Stop Text ( stoping and now allowed user to continue with unmatching data ) or simply let them know ( using a Warning Text and information text )
Views: 370 lordcaocao2025
Power BI Complete Demonstration - Part 5 Publish to Office 365
 
07:10
This is a 5-part series demonstrating a complete BI solution created with the components of Power BI in Excel 2013
Views: 1113 Paul Turley
Power Pivot: Versions & Compatibility
 
03:16
UNLIMITED ACCESS, NOW ONLY $25 (86% off!): http://bit.ly/2xeJoKt Full course includes LIFETIME access to 7+ hours of HD video content, downloadable project files, course quizzes and homework exercises, and 1-on-1 instructor support. ABOUT THE FULL COURSE: This course introduces Microsoft Excel's powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're looking to become a power Excel user and absolutely supercharge your analytics, this course is the A-Z guide that you're looking for. We'll kick things off by introducing the "Power Excel" landscape, and explore what these tools are all about and why they are changing the world of self-service business intelligence. Using sample data from a fictional supermarket chain, we'll get hands-on with Power Query; a tool to extract, transform, and load data from flat files, folders, databases, API services and more. We'll practice shaping, blending and exploring our project files, and create completely automated loading procedures with only a few clicks. From there we'll dive into Data Modeling 101, and cover the fundamentals of database design and normalization (including table relationships, cardinality, hierarchies and more). We'll take a tour through Excel's data model interface, introduce some best practices and pro tips, and then create our own relational database to analyze throughout the course. Next, we'll use Power Pivot and DAX to explore and analyze our data model. Unlike traditional pivots, Power Pivot allows you to analyze hundreds of millions of rows across multiple data tables, and create supercharged calculated fields using a formula language called Data Analysis Expressions (or "DAX" for short). We'll cover basic DAX syntax, then introduce some of the most powerful and commonly-used functions -- CALCULATE, FILTER, SUMX and more. If you're ready to take your Excel game to new heights and join the leading edge of analytics & business intelligence, this course is for you. It's time to stop fighting with tedious, manual tasks and struggling with "old-school" Excel; join me on this journey and emerge a certified NINJA. IMPORTANT: You need a version of Excel that is compatible with Power Pivot (Excel 2010 with plug-in, Excel 2013/2016 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)
Views: 302 Excel Maven
Power BI for Office 365  | Business Intelligence Software from Chabria Infotech , Kolkata - India
 
01:12
http://www.chabria.com for best deals in software .... What is Power BI for Office 365? Power BI is a cloud-based service that works with Excel to provide a complete self-service business intelligence (BI) solution. With both Excel and Power BI for Office 365, you can give everyone in your organization a powerful new way to work with data. In Excel, you can now discover, analyze, and visualize data like never before to find valuable business insights. With Power BI for Office 365 you can easily deploy a cloud-based BI environment for users to share insights, collaborate and access reports, from anywhere on any device. HideWhat do I need to use Power BI for Office 365? Since Power BI is a cloud-based service, you will need Excel 2013 to create reports and models that can be consumed and refreshed with Power BI. Office 365 ProPlus or Microsoft Office Professional Plus 2013 include Excel 2013 that will give you access to Power Query, Power Pivot, Power View and Power Map to discover, analyze and visualize data. With Power BI you will be able to consume these reports created in Excel through your browser or mobile apps and to use cloud-based features such as natural language Q&A, data refresh, data catalog and Power BI sites. The Power BI trial includes Office 365 ProPlus on top of the Power BI service so you can try the full experience end to end.
Views: 134 Hemant Chabria
Power BI Excel and Office 365: Unlocking the Value of your Enterprise Data - BRK3252
 
44:41
In this demo-rich session, learn how to use the unique strength of Microsoft Excel and Power BI to boost your business analytics and insights with Office 365. Learn how to easily collect existing organizational data with Excel and publish to Power BI, create visually rich reports to monitor your business, and securely share it with your colleagues all from within Microsoft Teams. Use the extensive Excel capabilities with Power BI to get valuable business insights and drill down to the last bit of your data.
Views: 661 Microsoft Ignite
Microsoft Office 365 Deployment
 
01:11:42
www.epcgroup.net | [email protected] | Phone: (888) 381-9725 * SharePoint Server 2013, SharePoint Server 2010, and SharePoint 2007: Review, Architecture Development, Planning, Configuration & Implementations, Upgrades, Global Initiatives, Training, and Post Go-live Support with Extensive Knowledge Transfer * Health Check and Assessments (Roadmap Preparation to Upgrade to 2013 or 2010) - Including Custom Code & Solution Review * Enterprise Content Management Systems based on Microsoft SharePoint * Enterprise Metadata Design, Taxonomy | Retention Schedule Development | Disposition Workflow, and Records Management Implementations * Roadmap, Requirements Gathering, Planning, Designing, and Performing the Actual Implementation * Best Practices Consulting on SharePoint 2013, 2010, 2007 | EPC Group has completed over 725+ initiatives * Intranet, Knowledge Management, Internet and Extranet-Facing as Well as Mobility (BYOD Roadmap), Cloud, Hybrid, and Cross-Browser | Cross-Platform Solutions for SharePoint 2013 / 2010 with Proven Past-performance *Upgrades or Migrations of Existing Deployments or Other LOB Systems (Documentum, LiveLink, FileNet, SAP, etc.) using EPC Group's Proven Methodologies (On-Premises, Hybrid, Virtualized, or Cloud-Based Infrastructure Design) * Custom Application, Feature, Master Pages, Web Parts, Security Model, Usability (UI), and Workflow Development (i.e. Visual Studio 2012) * Migration Initiatives to SharePoint 2013 / SharePoint 2010 * Key Performance Indicators, Dashboard & Business Intelligence Reporting Solutions (PerformancePoint 2013, SQL Server 2012, BI, KPIs, PowerPivot, Scorecards, Big Data Experts) * Experts in Global \ Enterprise Infrastructure, Security, Hardware Configuration & Disaster Recovery (Global performance considerations, multilingual, 1mm+ user environment experience) * Tailored SharePoint "in the trenches" Training on SharePoint 2013, 2010, 2007 as well as Project Server and Custom Development Best Practices * Support Contracts (Ongoing Support your Organization's 2013, 2010, or 2007 Implementations) * .NET Development, Custom applications, BizTalk Server experts * Project Server 2013, 2010, and 2007 Implementations and Consulting * SharePoint Roadmap & Governance Development: 6, 12, 18, 24 and 36 months (Steering Committee & Code Review Board Development) * Corporate Change Management & End User Empowerment Strategies * EPC Group's WebpartGallery.com - Customized Web Parts Based off of "in the trenches" Client Needs With over 14 years of experience, EPC Group delivers time tested SharePoint methodologies that ensure success within your organization. Engagement with EPC Group carries unique offerings and knowledge. Currently having implemented over 725+ SharePoint engagements and 75+ Microsoft Project Server implementations, we are the nation's leading SharePoint and Microsoft platform related consulting firm. EPC Group will be releasing our 3rd SharePoint book in August of 2013 by Sams Publishing titled, "SharePoint 2013 Field Guide: Advice from the Consulting Trenches" which will be like having a team of Senior SharePoint 2013 consultants by your side at each turn as you implement this new powerful and game changing software platform within your organization. SharePoint 2013 Field Guide: Advice from the Consulting Trenches will guide you through all areas of a SharePoint initiative from the initial whiteboarding of the overall solutions to accounting for what your organization currently has deployed. It will assist you in developing a roadmap and detailed step-by-step implementation plan and will also cover implementation best practices, content management and records management methodologies, initial SharePoint 2013 development best practices, as well as mobility planning. SharePoint 2013, Microsoft SharePoint 2013, SharePoint Consulting, Microsoft SharePoint consulting, SharePoint Consulting Firm, Top SharePoint Firm, SharePoint 2013 Consulting,SharePoint 2010 Consulting, SharePoint ECM Consulting, SharePoint branding firm, SharePoint, SharePoint branding experts, ECM experts SharePoint, Errin O'Connor, EPC Group, EPC Group.net, BizTalk Consulting, Project Server Consulting, BYOD, SharePoint 2013 book, SharePoint 2013 advice from the trenches
Views: 12101 EPC Group.net
[Office 365] Instalação e Tipos de Licenças (Resposta ao Trovato)
 
06:38
Office 365 Uso Doméstico: https://products.office.com/pt-br/buy/office Office 365 Empresas: https://products.office.com/pt-br/business/compare-more-office-365-for-business-plans Tem outras versões empresariais também que não foram comentadas no vídeo, mas que não semelhantes a ProPlus, com exceção da presença do Power Pivot e View. São essas: https://products.office.com/pt-br/business/compare-office-365-for-business-plans Power BI: https://powerbi.microsoft.com/pt-br/ (Preço: $9,99, aprox.: R$ 30,00) Livros que me ajudaram a aprender Excel e Power BI: - Excel 2016 Passo a Passo: https://goo.gl/nMsNYx - VBA e Macros: https://goo.gl/k5rWSJ - Learn to Write DAX: https://goo.gl/TZwivp - DAX Patterns: https://goo.gl/W8bcoR - Pro Power BI Desktop: https://goo.gl/8LNH9R Livros sobre análise de dados que li e recomendo: - Dados Demais: https://goo.gl/LssQax - Data Science para Negócios: https://goo.gl/z8jd4m Apresentado por: Karine Lago (MVP/MOSE) Aprenda mais: http://www.karinelago.com.br
Views: 9496 Karine Lago
Excel Business Intelligence Part 3: Power Pivot
 
05:58
Power Pivot is an incredibly powerful tool that allows you to analyse more than a million rows of data as well as giving you the ability to link more than one table of data. See how easy it is to use.
Power BI for Office 365 Overview
 
55:13
This video provides an overview of Microsoft Power BI for Office 365 and shows you how to: - find, explore and compile data from multiple sources with Excel and Power Query - build flexible models utilizing Power Pivot's in-memory analytics - use Power View and Power Map to create informative dashboards and interactive visualizations - share your data and collaborate with your team using Power BI Sites - take Power BI on the road with mobile access FMT Consultants is a leading Office 365 partner serving all of the US and Canada. Learn more at http://www.fmtconsultants.com
Views: 1110 FMT Consultants
Power BI
 
02:26
Discover Microsoft's self service data tools. Power BI offers 4 excel add-ins: PowerQuery, PowerPivot, PowerView & PowerMaps that are available now with Office 365 and that allow you to share data with the rest of your company.
Power Map for Excel / Office 365 / Power BI
 
13:39
http://blogs.msdn.com/b/ajmee Here's a quick video of some of the changes with the latest version of the Power Map add-in (September 2013). I'm using some US Census data and including both Power Query and Power Pivot into the mix.
Views: 50493 AJ Mee
Power Business Intelligence for SharePoint Online and Office 365
 
46:59
http://www.Gig-Werks.com - http://www.YouTube.com/GigWerks - http://www.TheSharePointBlog.net ​Join award winning SharePoint solution provider Gig Werks for a webcast on the newest Cloud Business Intelligence offering from Microsoft, Power BI. Microsoft Power BI for Office 365 delivers a cloud based solution that allows your organization to easily deploy advanced tools and feature that provide Reporting, Analysis and Secure Self-Service Business Intelligence for all your users. During the webcast we will discuss all of the features available with Power BI as well as showcase Excel Services and Power View in the cloud. For more information check out http://www.Gig-Werks.com
Office 365 Administration - 02 - Office 365 User Management
 
40:10
www.epcgroup.net | [email protected] | Phone: (888) 381-9725 * SharePoint Server 2013, SharePoint Server 2010, and SharePoint 2007: Review, Architecture Development, Planning, Configuration & Implementations, Upgrades, Global Initiatives, Training, and Post Go-live Support with Extensive Knowledge Transfer * Health Check and Assessments (Roadmap Preparation to Upgrade to 2013 or 2010) - Including Custom Code & Solution Review * Enterprise Content Management Systems based on Microsoft SharePoint * Enterprise Metadata Design, Taxonomy | Retention Schedule Development | Disposition Workflow, and Records Management Implementations * Roadmap, Requirements Gathering, Planning, Designing, and Performing the Actual Implementation * Best Practices Consulting on SharePoint 2013, 2010, 2007 | EPC Group has completed over 725+ initiatives * Intranet, Knowledge Management, Internet and Extranet-Facing as Well as Mobility (BYOD Roadmap), Cloud, Hybrid, and Cross-Browser | Cross-Platform Solutions for SharePoint 2013 / 2010 with Proven Past-performance *Upgrades or Migrations of Existing Deployments or Other LOB Systems (Documentum, LiveLink, FileNet, SAP, etc.) using EPC Group's Proven Methodologies (On-Premises, Hybrid, Virtualized, or Cloud-Based Infrastructure Design) * Custom Application, Feature, Master Pages, Web Parts, Security Model, Usability (UI), and Workflow Development (i.e. Visual Studio 2012) * Migration Initiatives to SharePoint 2013 / SharePoint 2010 * Key Performance Indicators, Dashboard & Business Intelligence Reporting Solutions (PerformancePoint 2013, SQL Server 2012, BI, KPIs, PowerPivot, Scorecards, Big Data Experts) * Experts in Global \ Enterprise Infrastructure, Security, Hardware Configuration & Disaster Recovery (Global performance considerations, multilingual, 1mm+ user environment experience) * Tailored SharePoint "in the trenches" Training on SharePoint 2013, 2010, 2007 as well as Project Server and Custom Development Best Practices * Support Contracts (Ongoing Support your Organization's 2013, 2010, or 2007 Implementations) * .NET Development, Custom applications, BizTalk Server experts * Project Server 2013, 2010, and 2007 Implementations and Consulting * SharePoint Roadmap & Governance Development: 6, 12, 18, 24 and 36 months (Steering Committee & Code Review Board Development) * Corporate Change Management & End User Empowerment Strategies * EPC Group's WebpartGallery.com - Customized Web Parts Based off of "in the trenches" Client Needs With over 14 years of experience, EPC Group delivers time tested SharePoint methodologies that ensure success within your organization. Engagement with EPC Group carries unique offerings and knowledge. Currently having implemented over 725+ SharePoint engagements and 75+ Microsoft Project Server implementations, we are the nation's leading SharePoint and Microsoft platform related consulting firm. EPC Group will be releasing our 3rd SharePoint book in August of 2013 by Sams Publishing titled, "SharePoint 2013 Field Guide: Advice from the Consulting Trenches" which will be like having a team of Senior SharePoint 2013 consultants by your side at each turn as you implement this new powerful and game changing software platform within your organization. SharePoint 2013 Field Guide: Advice from the Consulting Trenches will guide you through all areas of a SharePoint initiative from the initial whiteboarding of the overall solutions to accounting for what your organization currently has deployed. It will assist you in developing a roadmap and detailed step-by-step implementation plan and will also cover implementation best practices, content management and records management methodologies, initial SharePoint 2013 development best practices, as well as mobility planning. SharePoint 2013, Microsoft SharePoint 2013, SharePoint Consulting, Microsoft SharePoint consulting, SharePoint Consulting Firm, Top SharePoint Firm, SharePoint 2013 Consulting,SharePoint 2010 Consulting, SharePoint ECM Consulting, SharePoint branding firm, SharePoint, SharePoint branding experts, ECM experts SharePoint, Errin O'Connor, EPC Group, EPC Group.net, BizTalk Consulting, Project Server Consulting, BYOD, SharePoint 2013 book, SharePoint 2013 advice from the trenches
Views: 36522 EPC Group.net
Introduction to forecasting capabilities in Power View for Office 365
 
03:55
Introduction to forecasting capabilities in Power View for Office 365
Office 365 Administration - 01 - Overview and Infrastructure
 
45:18
www.epcgroup.net | [email protected] | Phone: (888) 381-9725 Note: This video is property of Microsoft and/or was co-produced with Microsoft. * SharePoint Server 2013, SharePoint Server 2010, and SharePoint 2007: Review, Architecture Development, Planning, Configuration & Implementations, Upgrades, Global Initiatives, Training, and Post Go-live Support with Extensive Knowledge Transfer * Health Check and Assessments (Roadmap Preparation to Upgrade to 2013 or 2010) - Including Custom Code & Solution Review * Enterprise Content Management Systems based on Microsoft SharePoint * Enterprise Metadata Design, Taxonomy | Retention Schedule Development | Disposition Workflow, and Records Management Implementations * Roadmap, Requirements Gathering, Planning, Designing, and Performing the Actual Implementation * Best Practices Consulting on SharePoint 2013, 2010, 2007 | EPC Group has completed over 725+ initiatives * Intranet, Knowledge Management, Internet and Extranet-Facing as Well as Mobility (BYOD Roadmap), Cloud, Hybrid, and Cross-Browser | Cross-Platform Solutions for SharePoint 2013 / 2010 with Proven Past-performance *Upgrades or Migrations of Existing Deployments or Other LOB Systems (Documentum, LiveLink, FileNet, SAP, etc.) using EPC Group's Proven Methodologies (On-Premises, Hybrid, Virtualized, or Cloud-Based Infrastructure Design) * Custom Application, Feature, Master Pages, Web Parts, Security Model, Usability (UI), and Workflow Development (i.e. Visual Studio 2012) * Migration Initiatives to SharePoint 2013 / SharePoint 2010 * Key Performance Indicators, Dashboard & Business Intelligence Reporting Solutions (PerformancePoint 2013, SQL Server 2012, BI, KPIs, PowerPivot, Scorecards, Big Data Experts) * Experts in Global \ Enterprise Infrastructure, Security, Hardware Configuration & Disaster Recovery (Global performance considerations, multilingual, 1mm+ user environment experience) * Tailored SharePoint "in the trenches" Training on SharePoint 2013, 2010, 2007 as well as Project Server and Custom Development Best Practices * Support Contracts (Ongoing Support your Organization's 2013, 2010, or 2007 Implementations) * .NET Development, Custom applications, BizTalk Server experts * Project Server 2013, 2010, and 2007 Implementations and Consulting * SharePoint Roadmap & Governance Development: 6, 12, 18, 24 and 36 months (Steering Committee & Code Review Board Development) * Corporate Change Management & End User Empowerment Strategies * EPC Group's WebpartGallery.com - Customized Web Parts Based off of "in the trenches" Client Needs With over 14 years of experience, EPC Group delivers time tested SharePoint methodologies that ensure success within your organization. Engagement with EPC Group carries unique offerings and knowledge. Currently having implemented over 725+ SharePoint engagements and 75+ Microsoft Project Server implementations, we are the nation's leading SharePoint and Microsoft platform related consulting firm. EPC Group will be releasing our 3rd SharePoint book in August of 2013 by Sams Publishing titled, "SharePoint 2013 Field Guide: Advice from the Consulting Trenches" which will be like having a team of Senior SharePoint 2013 consultants by your side at each turn as you implement this new powerful and game changing software platform within your organization. SharePoint 2013 Field Guide: Advice from the Consulting Trenches will guide you through all areas of a SharePoint initiative from the initial whiteboarding of the overall solutions to accounting for what your organization currently has deployed. It will assist you in developing a roadmap and detailed step-by-step implementation plan and will also cover implementation best practices, content management and records management methodologies, initial SharePoint 2013 development best practices, as well as mobility planning. SharePoint 2013, Microsoft SharePoint 2013, SharePoint Consulting, Microsoft SharePoint consulting, SharePoint Consulting Firm, Top SharePoint Firm, SharePoint 2013 Consulting,SharePoint 2010 Consulting, SharePoint ECM Consulting, SharePoint branding firm, SharePoint, SharePoint branding experts, ECM experts SharePoint, Errin O'Connor, EPC Group, EPC Group.net, BizTalk Consulting, Project Server Consulting, BYOD, SharePoint 2013 book, SharePoint 2013 advice from the trenches
Views: 143303 EPC Group.net
Microsoft PowerPivot (video 1)
 
01:34
A world of data on a single screen, in real time! Inviting viewers to discover the power and usability of Microsofts Business Intelligence tools, Vectorform created a fun and engaging animation to announce Microsoft PowerPivot for Excel 2010. http://www.vectorform.com/ http://www.powerpivot.com/
Views: 37693 vectorformSurface
How To Enable Power Pivot & Power View in Excel 2013
 
00:34
http://bicg.com.au/index.php/how-to-enable-power-pivot-power-view-in-excel-2013/ Watch the video demonstration of how to enable Power Pivot and Power View in Excel 2013. Power Pivot in Excel 2013 Add-in enable you to perform powerful data analysis using familiar interface of Excel from virtually any data source. Users can create their own reports, perform analysis and decision making. Power View in Excel 2013 Add-in consumes the data model created using Power Pivot to make pretty and interactive reports in SilverLight (Make sure Silverlight is installed on the client machine with Excel 2013) If you are using Excel 2013 Standalone or Office Professional Plus or Office 365 Professional Plus Edition, Power Pivot is already installed and you just need to enable it from the available list of add-in. For Excel 2010, you need to download the Power Pivot Add-in from http://www.microsoft.com/en-in/download/details.aspx?id=102 View Training from here. https://bicg.com.au/index.php/how-to-enable-power-pivot-power-view-in-excel-2013/.
Views: 12700 AI Australia
Power BI for Office 365 Overview
 
01:36
Web: www.epcgroup.net | E-mail: [email protected] | Phone: (888) 381-9725 * SharePoint Server 2013, Office 365, Windows Azure, Amazon Web Services (AWS), SharePoint Server 2010 & SharePoint 2007: Review, Architecture Development, Planning, Configuration & Implementations, Upgrades, Global Initiatives, Training, and Post Go-live Support with Extensive Knowledge Transfer | Custom Branding and Responsive Web Design (RWD) * Health Check & Assessments (Roadmap Preparation to Upgrade to 2013 or 2010) - Including Custom Code & Solution Review * Enterprise Content Management Systems based on Microsoft SharePoint 2013, Office 365 Hybrid Cloud (Both On-premises and cloud) * Enterprise Metadata Design, Taxonomy | Retention Schedule Dev | Disposition Workflow, and Records Managemen | eDiscovery | Microsoft Exchange 2013 Migration \ Integration | Roadmap, Requirements Gathering, Planning, Designing & Performing the Actual Implementation * Best Practices Consulting on SharePoint 2013, Office 365, SharePoint 2010, 2007 | EPC Group has completed over 900+ initiatives * Intranet, Knowledge Management, Internet & Extranet-Facing as Well as Mobility (BYOD Roadmap), Cloud, Hybrid, and Cross-Browser | Cross-Platform Solutions for SharePoint 2013 with Proven Past-performance *Upgrades or Migrations of Existing Deployments or Other LOB Systems (Documentum, LiveLink, FileNet, SAP, etc.) * Custom Apps,Feature, Master Pages, Web Parts, Security Model, Usability (UI) & Workflow Development (Visual Studio 2012, Visual Studio 2013) * Migration Initiatives to SharePoint 2013 \ Office 365 and those organizations with both on-premises and cloud assets for a SharePoint Hybrid Architecture and Deployment * Key Performance Indicators, Dashboard & Business Intelligence Reporting Solutions (PerformancePoint 2013, SQL Server 2012 R2, SQL Server 2014, BI, KPIs, PowerPivot, Scorecards, Big Data) and Power BI * Experts in Global \ Enterprise Infrastructure, Security, Hardware Configuration & Disaster Recovery (Global performance considerations) * Tailored SharePoint "in the trenches" Training on SharePoint 2013, 2010, 2007 + Office 365 * Support Contracts (Ongoing Support your Organization's 2013, 2010, or 2007 Implementations) * .NET Development, Custom applications, BizTalk Server experts * Project Server 2013, 2010, and 2007 Implementations * SharePoint Roadmap & Governance Development: 6, 12, 18, 24 and 36 months (Steering Committee & Code Review Board Development) * EPC Group's HybridCloudAdvisor.com - Navigating the Ever Changing World of the Hybrid Cloud to include SLA development & consulting services | advisory | best practices around PaaS, IaaS, SaaS, VDI, Windows Azure, AWS as well as security, compliance & and regulatory issues facing cloud and Hybrid Cloud deployments throughout the globe. * Corporate Change Management & End User Empowerment Strategies With over 15 years of experience, EPC Group delivers time tested SharePoint methodologies that ensure success within your organization. Engagement with EPC Group carries unique offerings and knowledge. Currently having implemented over 900+ SharePoint engagements and is an industry recognized expert in Business Intelligence (BI), custom application development, BYOD, Hybrid Cloud Architecture, Information Security (InfoSec) and global infrastructure & governance design. EPC Group will be releasing our 3rd SharePoint book in August of 2013 by SAMS Publishing titled, "SharePoint 2013 Field Guide: Advice from the Consulting Trenches" which is like having a team of Senior SharePoint 2013 \ Office 365 consultants by your side at each turn as you implement this new powerful and game changing software platform within your organization. SharePoint 2013 Field Guide: Advice from the Consulting Trenches will guide you through all areas of a SharePoint 2013 \ Office 365 initiative from the initial whiteboarding of the overall solutions to accounting for what your organization currently has deployed. It will assist you in developing a roadmap & detailed step-by-step implementation plan & will also cover implementation best practices, content management & records management methodologies, initial SharePoint 2013 development best practices, as well as mobility planning. SharePoint 2013, Office 365,, Microsoft SharePoint 2013, SharePoint Consulting, Microsoft SharePoint consulting, Windows Azure, Amazon Web Services (AWS), SharePoint Consulting Firm, Top SharePoint Firm, SharePoint 2013 Consulting, SharePoint 2010 Consulting, Hybrid Cloud Consulting, Hybrid SharePoint, SharePoint ECM Consulting, SharePoint branding firm, SharePoint, Response Web Design (RWD), Hybridcloudadvisor.com, SharePoint branding experts, ECM experts SharePoint, Errin O'Connor, EPC Group, EPC Group.net, Hybrid Cloud Advisor, BizTalk Consulting, Project Server Consulting, BYOD, SharePoint 2013 book, SharePoint 2013 advice from the trenches
Views: 5366 EPC Group.net
Editing Data in Power BI
 
05:52
Power BI for Office 365 is Microsoft's latest Business Intelligence solution. It is cloud-based and works from within Excel and Office 365, to analyse and visualise data quickly and easily. The BI solution is designed to help business users gain insights from their data and, according to Microsoft, includes the following: - Power Query - Power Map - Power Pivot - Power View
Views: 2796 Data Insight Training
Ce este şi cum utilizez PowerBI în Office 2013 şi Office 365?
 
34:57
O scurtă descriere a instrumentelor de Business Intelligence din Office 2013 şi Office 365. - Power Pivot - Power Query - Power View - Power Map - Power BI sites on Power BI for Office 365 - Power BI Windows Store app - Power BI SharePoint Store app - Flash Fill - Timeline - Slicer - Sparklines - Filters - Slicers - KPIs and scorecards - Quick Analysis Tool - PivotChart reports - PivotTable report
Views: 274 Office365Ro
Microsoft Excel - The difference between PivotTable, PowerPivot and Power View
 
02:29
In this video, Cyrus Mohseni, one of New Horizons' Office Applications trainers, explains the differences between PivotTables, PowerPivot and Power View. View our range of excel courses here: http://www.nhaustralia.com.au/excel-training-courses To keep up to date with our trainers, visit our blog: http://www.nhaustralia.com.au/blog Stay connected with New Horizons on LinkedIn: http://www.linkedin.com/company/new-horizons-learning-centres-australia
How to build Power BI Dashboards
 
52:32
Download the completed Power BI Desktop file and data used in the video here: https://www.myonlinetraininghub.com/workbook-downloads In this video you will learn how to create two interactive Power BI dashboards using the free Power BI tools available to everyone. Get Power BI Desktop here: https://powerbi.microsoft.com/en-us/desktop/ Learn Power BI here: https://www.MyOnlineTrainingHub.com/power-bi-course Subscribe to my free newsletter and get my 100 Tips & Tricks eBook here: https://www.myonlinetraininghub.com/sign-up-for-100-excel-tips-and-tricks
Views: 481073 MyOnlineTrainingHub
17-11 Office 365 Akademie News
 
34:21
Einige Neuerungen in den Themenbereich Administration, Delve & My Analytics, Office, OneDrive for Business, Planner, Power BI, SharePoint, Skype for Business und Teams & Groups hat es auch im November wieder gegeben. Einen tiefen Blick gibt es diesesmal auch in Excel PowerQuery und PowerPivot, auch einige Neuerungen in Access werden behandelt. Beim Thema Teams & Groups beschäftigen wir uns mit zwei häufigen Problemen: Gäste können auf das Team zugreifen, nicht aber auf Notizbuch und SharePoint und dem Problem, dass Gast-User als Mitglied anstatt als Gast angezeigt werden. Hier der gesamte Themenüberblick Administration - First Release wird umbenannt in Targeted Release - Tipp: Welche Clouddienste laufen in meinem Unternehmen? - Business Apps auch bei Enterprise freischalten: Bookings, Outlook Cutomer Manager, Invoicing, … Delve & My Analytics - Wurde meine Mail bearbeitet? - My Analytics schlägt To-Dos aus den Mails vor Office - Sway bietet nun auch Export und Druck-Funktion - Aufzeichnung in PowerPoint freischalten - Lebenslaufassistent in Word (LinkedIn) - Pick it & Pexels: Kostenlose Bilder - Excel: CSV (UTF-8) Unterstützung - Excel PowerPivot: Beziehungen bearbeiten - Excel PowerPivot: Beziehungsansicht speichern - Excel PowerQuery: Bedingte Spalten - Excel PowerQuery: Extrahieren von Wochen, Tages und Monatsnamen sowie - Excel PowerQuery: Spaltentypanzeiger in Spaltenüberschriften - Excel PowerQuery: Präfix / Suffix in Textspalten - Excel PowerQuery Konvertieren von Werten - Excel PowerQuery: Abrufen und transformieren - Excel PowerQuery: Connectoren - Excel PowerQuery: Spalte teilen - Excel PowerQuery: Erweiterte Filterfunktionen - Excel PowerQuery: Erweiterte Filterfunktionen - Neue Excel Funktionen: TEXTJOIN, TEXTKETTE, WENNS, SWITCH, MAXWENNS, MINWENNS - Verbessertes AutoVervollständigen - Access: Aktualisiertes Aussehen für Vorlagen - Access: Verknüpfte Datenquellen nach Excel exportieren - Access: Sortierung des Eigenschaftenblatts - Access: Wiederherstellungslogik für ODBC-Verbindung - Access: dBASE Unterstützung wieder da - Access: Unterstützung „Große Zahl“ (bigint) OneDrive for Business - OneDrive ist nicht gleich OneDrive: Übersichtsgrafik Planner - Aufgaben kopieren - Kalender-Ansicht für Planner: Tages / Wochen / Monatsansicht - Aufgaben können per Drag´n´Drop hinzugefügt werden. - Planner per iCal in Outlook einbinden Power BI - Dashboards freigeben für kostenlose Nutzer SharePoint - Ausblick: Neue Webparts für SharePoint - Seitenverwendungsbericht - SharePoint Site eine Group hinzufügen Skype for Business - Skype for Business vs. Teams - Telefonanlage adé: PSTN Calling in Deutschland verfügbar! - Teams & Skype: Messaging Roadmap von Microsoft Teams & Groups - Maximale Anzahl der Teammitglieder steigt auf 2.500 von bisher 999 - Problemlösung: Gäste können auf das Team zugreifen, nicht aber auf Notizbuch und SharePoint - Problemlösung: Gast-User wird als Mitglied anstatt als Gast angezeigt - Teams PowerShell Cmdlets - Meine Aufgaben-Ansicht für Teams - Externe User in Teams zulassen – die Technik - Externe User in Teams zulassen – Einrichtung - SharePoint Sites posten im Teams Newsfeed - SharePoint Seite in Teams integrieren
Views: 532 Office 365 Akademie
Data Lineage using SSIS, SSAS and Power Pivot
 
56:59
Recorded on 30 Oct 2013 at PASS Data Warehousing and Business Intelligence Virtual Chapter (PASS DW/BI VC) Data Lineage is the concept of enabling a client ability to analyze data in a NEW way yet still be able to see the original values, critical in Big Data. Ira Warren Whiteside and Victoria Stasiewicz will demonstrate how to do this in SSIS AND SSAS using Power Pivot, Power BI ,Office 365 and Power Query. We have several case studies for our current clients. Speakers: Ira Warren Whiteside, MDM Architect / BI Architect Ira has over 40 years of IT experience and has extensive knowledge of data warehousing. His roles have included management, Technical Team Lead, Business Analysis, Analytical Application Development, Data Wa rehousing Architecture, Data Modeling, Data Profiling, Data Mining, Text Mining, E-Commerce Implementation, Project Management, Decision Sup port/OLAP, Financial Application Development, E-Commerce, B2C, B2B with primary emphasis in Business Intelligence Applications and Data Warehousing Management. Mr. Whiteside has managed multi-million dollar projects from start to completion. His experience includes the planning, budgeting, project management/technical leadership and product management for large projects and software companies. In addition, Mr. Whiteside has been hands on, in that he has extensively used Microsoft SQL Server 2005/2012 tools, including SSIS, SSAS, SSRS (Microsoft Reporting Services) and Data mining. In addition Ira has authored and published various white papers, articles, provided numerous training seminars and presentations on the methodology required for data-driven application cogeneration in the Microsoft stack. Victoria Stasiewicz, Lead Data profiling Analyst and SSIS developer Victoria is a senior business analyst and data profiling analyst. She has extensive experience in the healthcare industry in analyzing and implementing the Sundial metric decomposition methodology as well as extensive experiencing in developing SSIS packages Join PASS DW/BI Virtual Chapter at http://bi.sqlpass.org Follow us on Twitter @PASSBIVC
Power BI (serviço) - Streaming Dataset (Flow + OneDrive + Excel)
 
19:45
Esta aula não possui material para Download Descrição: Você sabia que pode criar Datasets no Power BI e configurar Streaming de atualização destes dados, variando de Real Time ao intervalo que melhor te atender? Nesta aula, além de aprender a criar Streaming de dados, utilizaremos como fonte uma pasta de trabalho do Excel que está armazenada no OneDrive e para criar essa ROTINA de automação, temos o Microsoft Flow como gerador do novo fluxo. Sobre o assunto e referência técnica: Microsoft Flow: https://us.flow.microsoft.com/pt-br/ Microsoft OneDrive: https://onedrive.live.com/about/pt-BR/business/ Microsoft Office 365: https://products.office.com/pt-br/business/compare-more-office-365-for-business-plans Microsoft Power BI: https://powerbi.microsoft.com/pt-br/ ==============//=============== ....==ATENÇÃO==.... Este material não pode ser copiado, reproduzido, distribuído, comercializado, publicado novamente, exposto, enviado pelo correio ou de qualquer outra forma ou por qualquer outro meio, total ou parcialmente, sem a devida citação (casos públicos) e/ou autorização (comércio). ================== Conheça nossas playlists e bons estudos: = Power BI (desktop e serviço) - https://goo.gl/9VeiZL = Novidades Power BI - https://goo.gl/tX2WXw = Aulas Transmitidas AO VIVO - https://goo.gl/7pSIoh = SSBI - DAX - https://goo.gl/JL4SgI = SSBI - Excel: Powerpivot e Power View - https://goo.gl/DROjTz = SSBI - Excel: Power Query (M Language) - https://goo.gl/3t2utu = BI & Gestão - https://goo.gl/KPAhgd = Excel em 5 minutos - https://goo.gl/n2KHwf = Excel Avançado - https://goo.gl/978rDU = Excel Básico - https://goo.gl/LfxzOV = Gráficos - https://goo.gl/IJKsXb = Curso VBA p/ Iniciantes - https://goo.gl/CQPpDW = Especialistas Convidados - https://goo.gl/8SZ2PA ================== Seguem links dos livros técnicos que SEMPRE SÃO FONTE de consulta de quem precisa aprender, inclusive nós, DAX e M, consequentemente, POWER BI! Literatura Recomendada: Power BI Introducing Microsoft Power BI, Marco Russo / Alberto Ferrari - https://goo.gl/AkwpOs Power Pivot and Power BI, Rob Collie / Avichal Singh - https://goo.gl/x9O4u8 DAX The Definitive Guide to DAX, Marco Russo / Alberto Ferrari - https://goo.gl/rW7z2D Learn to Write DAX, Matt Allington - https://goo.gl/6jC5Sb DAX Formulas for PowerPivot, Rob Collie - https://goo.gl/tCs9wg Linguagem M M Is for (Data) Monkey, Ken Plus / Miguel Escobar - https://goo.gl/pULFtH, Power Query for Power BI and Excel, Chris Webb - https://goo.gl/IYSmRU Powerpivot PowerPivot for the Data Analyst, Bill Jelen - https://goo.gl/Fsu2ss PowerPivot Alchemy, Bill Jelen / Rob Collie - https://goo.gl/80eqCv Excel - Fórmulas Matriciais CTRL+SHIFT+ENTER, Mike Girvin (Canal Excelisfun) - https://goo.gl/DM6exq
Views: 8559 Planilheiros - PBIX
🏆Minimalist, Flat, Corporate, 🧜‍♀️Beautiful Presentation Template Design for Business Presentation
 
14:50
About this Microsoft Office PowerPoint 365 Training Video: 🔥 Minimalist, Flat, Corporate, Beautiful Presentation Template Design for Business Presentation. Please Subscribe to our channel: 👍… https://www.youtube.com/c/CreativeVenus/?sub_confirmation=1 You can download this professional PowerPoint template from the following Gdrive location: 👉… https://drive.google.com/open?id=1khl1d0h9tCtTcGx0-zT1UaTMoaruqhVg I have created the playlist of all the PowerPoint Training Videos. You can visit the URL: 👉… https://www.youtube.com/playlist?list=PLHq0onhvyWme0oqqKUmULNeavFY5q9C8j I hope you like this Microsoft Office 365 PowerPoint Training Video. 👉 Please Like, share, comment and subscribe to watch more such videos. 💙 Follow Us on Twitter: https://twitter.com/creative_venus 💚 Follow Us on Facebook: https://www.facebook.com/creativevenus4u/ 💜 Follow Us on Instagram: https://www.instagram.com/creativevenus7077/ PowerPoint is an enterprise level software and an amazing product of Microsoft Office. It has a great potential and the kind of features it provides are so easy to understand and simple to use that every student, manager, marketing executive or sales guy can easily create brilliant professional presentations. Microsoft Office PowerPoint is often underestimated but it allows us to create presentations, logos, banners, templates, designs, graphics, and most importantly video animations. A PowerPoint Presentation designed appropriately can really convince your target audience. A lot of design thinking needs to be put into a slide to make sure that the message is clearly delivered to the user. I have created all the videos in PowerPoint included in Microsoft Office 365 suite. My idea is to help my audience learn the PowerPoint and get to know how easy it is to create anything in presentation. #creativevenus #microsoftpowerpoint #minimalist
Views: 2438 Creative Venus
Power BI - Power Pivot
 
07:37
Power BI - Power Pivot
SharePoint Power Hour: Episode 2 - Reporting against lists using PowerPivot
 
58:40
In this session we take a look at reporting off of SharePoint lists using PowerPivot and oData feeds. We'll start the video off with a quick overview of "What is PowerPivot", and then jump right into some live demo where we build a PowerPivot workbook from scratch that reports off of SharePoint lists. 06:45 - PowerPivot and oData presentation 43:44 - SSRS Report Builder Links mentioned in the video: http://sharepoint.rackspace.com (Rackspace Training & other info) http://technet.microsoft.com/en-us/library/jj819267.aspx (Office 365 Plan details)
Creating Tables and Reports in Power BI
 
11:11
Power BI for Office 365 is Microsoft's latest Business Intelligence solution. It is cloud-based and works from within Excel and Office 365, to analyse and visualise data quickly and easily. The BI solution is designed to help business users gain insights from their data and, according to Microsoft, includes the following: - Power Query - Power Map - Power Pivot - Power View
Views: 2650 Data Insight Training