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: 60779 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: 164983 Learn iT! Training
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: 66867 Microsoft Power BI
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: 179707 ExcelIsFun
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: 69118 ExcelIsFun
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: 495035 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: 106582 MyOnlineTrainingHub
Education Business Intelligence: PowerPivot
 
06:30
A short demonstration of using PowerPivot visualisation in Excel 2013, using a demonstration education data set. It's a simple example of how you can take a complex data set, containing both central data and a user's own data (in this case, a spreadsheet of their own data) and visualise it together in a number of different ways.
Views: 2026 Ray Fleming
PowerPivot Data Analyst 1 - What is PowerPivot?
 
04:44
Learn about the five benefits of PowerPivot in this introductory video from MrExcel. This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010
Views: 209987 MrExcel.com
Manage Many to Many Relationships in Power Pivot
 
17:27
Download the workbook to go along with this video http://theexcelclub.com/power-pivot-many-to-many-relationships/ Our blog is now powered by #steem - if you have any questions or comments on this video please do post the on the original blog post and not here on Youtube #excel #powerpivot #powerbi Relationship connect two or more tables of data together. To connect each table, both tables must have something in common. There are two types of relationship, a one to many which works very well in Power Pivot and DAX. Then there is a Many to Many relationship, which can cause problems. In this video we will look at three many to many relationship problems in Excels Power Pivot and how you can easily overcome them. The approach we will take is very systematic. We will build up our data model table by table. This way we can see how additional tables of data, that contain many to many relationships, can effect our pivot table formula. Then we will look at how the problems can be solved. Check out our YouTube play list https://www.youtube.com/playlist?list=PLJ35EHVzCuiFFpjWeK7CE3AEXy_IRZp4y
Views: 65659 Paula Guilfoyle
BI Tools: PowerPivot in SharePoint (Tutorial)
 
14:10
In this demo, Tavis Lovell (a member of the Business Solutions team at Rackspace) covers the basics of PowerPivot in SharePoint 2013. For more information on our Business Solutions and Business Intelligence offerings, visit http://sharepoint.rackspace.com/business-intelligence-services If you'd like more training from Tavis and others, go to http://SharePoint.Rackspace.com/Training Don't forget to 'like' us on Facebook: http://Facebook.com/SharePointAtRackspace
Microsoft Dynamics NAV 2013 BI PowerPivot
 
04:39
Analyse your data in Dynamics NAV and Excel PowerPivot
Views: 2064 DataComfort
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
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: 9958 Microsoft Mechanics
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: 1100 FMT Consultants
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: 251 BICG Australia
O'Reilly Webcast: Self-Service Business Intelligence with Microsoft PowerPivot
 
01:12:43
Presented by Andrew Brust. Ever wonder why there's no "light" version of SQL Server Analysis Services (SSAS)? Find yourself wishing that SSAS offered an in-memory operation model akin to some of its competitors? And why are OLAP cubes nearly impossible for end-users to build while comparable capabilities have existed for relational databases for at least 15 years? Enter PowerPivot, a feature of SQL Server 2008 R2 that joins together SSAS, Excel and SharePoint to make end-user analytics feasible, fun, publishable and discoverable by IT. Andrew Brust will show you how it all works in this not-to-be-missed online session.
Views: 4927 O'Reilly
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: 37654 vectorformSurface
Excel 2016 Tutorial Starting Power Pivot Microsoft Training Lesson
 
02:09
Learn about Starting Power Pivot in Microsoft Excel at www.teachUcomp.com. A clip from Mastering Excel Made Easy v. 2016. Get the complete tutorial FREE at http://www.teachucomp.com/free - the most comprehensive Excel tutorial available. Visit us today!
Views: 19280 TeachUComp
FIRST LOOK: Microsoft Business Intelligence "Power Pivot" tool for looking at Tweet data
 
05:01
Bruno Aziza of Microsoft's Microsoft's Business Intelligence group recently filmed me for BI TV at http://www.microsoft.com/bi/en-us/Community/Pages/BITV.aspx Here I turned the camera on him and he is showing off a free tool for looking at data from Tweets and business meetings inside Excel. Get it at http://www.powerpivot.com/
Views: 4654 Robert Scoble
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: 268 Office365Ro
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: 302338 Learn Excel from Chandoo
Power Pivot For Excel | Power Pivot Tutorial | Hindi
 
08:07
Power Pivot For Excel | Power Pivot Tutorial | Hindi Stop Using Vlookup If u Know About Power Pivot Power Pivot is an Excel add-in to perform data analysis & Data models. you can use large volumes of data from a different source in PowerPivot and perform information analysis rapidly and share insights. Learn How to use Power Pivot Add-in Excel in Hindi PowerPivot Dashboard PowerPoint Relationships PowerPivot DAX PowerPivot introductions Power Query Power Pivot Charts Power Pivot KPI To watch more videos visit: https://www.excelsuperstar.org/ To Buy an Excel Course Pen drive visit: https://www.excelsuperstar.org/excel-training-hindi-english-mix/ Like us on Facebook: https://www.facebook.com/Excelsuperstar/ Subscribe to the Channel: https://www.youtube.com/c/Excelsuperstar
Views: 16418 Excel Superstar
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: 15083 Jean-Pierre Girardot
Excel PowerPivot Dashboard Tutorial with WaterFall Chart
 
07:49
This video describes how to create an interactive reporting Excel tool with PowerPivot and provides a basic overview of DAX features. Here's also you can find how to create a connection to the SQL Server and dynamically using datasets by cube functions in Excel.
Views: 26 mister tunta
How to: Install The PowerPivot Add-In For Excel
 
03:38
Instructions for installing the PowerPivot Add-in for Excel.
Views: 31544 MicrosoftBI
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: 1094 Paul Turley
The Power of Personal BI with Microsoft Dynamics AX 2012: PowerPivot and Power View
 
43:28
The real value of business intelligence (BI) comes from crafting a story based on an organization's data. For the manager, analyst, or individual contributor, BI typically begins with desktop tools like Microsoft Excel. With the right skills and know-how, personal BI can become the gateway to a robust BI initiative at any organization. In this webcast, Microsoft Dynamics AX MVP and BI expert Brandon George of Sunrise Technologies examines Microsoft PowerPivot & Power View with Dynamics AX 2012 R2. The webcast will look at how these tools can empower both functional and technical resources at the individual level to discover new insights and improve operational outcomes. Learn how to put data to work and further build towards organizational BI needs from personal BI artifacts.
Views: 11443 MSDynamicsWorld
Business Intelligence Demo at Office 2010 Launch Event
 
05:39
Watch Chris Capossela demo new BI capabilities in Excel 2010, PowerPivot, and the Excel web application for data visualization, collaboration, and manipulation of large amounts of data.
Views: 8415 wowmsft
Using PowerPivot to combine cube (SSAS) data with manual data
 
09:26
With the release of PowerPivot CPT3 you can connect to a SSAS cube This video shows the sales of the current year from the cube compared to the forecast of this year from Excel. Read more at my blog http://business-intelligence.kdejonge.net
Views: 20083 kjonge
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: 512 Office 365 Akademie
IMGROUP - Microsoft Power BI Demo
 
09:43
18m rows of UK Land Registry Data processed and analysed with Microsoft Office 365 Power BI tools: @nariusp / @IMGROUPonline
Views: 2251 Narius Patel
IMDb Analysis with Microsoft Power BI
 
07:18
This is an analysis of the top 250 rated movies on IMDb using Microsoft Power BI - Excel, Power Query, Power Pivot, Power View, Office 365, Power BI, and Q&A. Please vote here - http://j.mp/1bCzTpQ (vote once per day from Jan 20 to Jan 30) Thnx!
Views: 2920 Dan English
Forecasting in Power View and Power BI
 
13:50
See accompanying article for details: http://www.powerpivotpro.com/2014/05/forecasting-in-power-view-and-power-bi/ Video shows the newly released feature of Forecasting in Power BI again real data sets including Climate data and Stock Market data FREE Power BI Step-by-Step Tutorial http://www.learnpowerbi.com/bonus 👉 Download Lesson PBIX Files at http://www.learnpowerbi.com/bonus-download ✅ Subscribe to always get my latest videos: https://goo.gl/P79Hcr 👪 Join our Facebook Group https://www.facebook.com/groups/talkpowerbi ===Most Popular Playlists=== • Power BI Beginner Tutorial: https://goo.gl/KRRkPG • Ultimate Calendar: https://goo.gl/pyki4K • Power BI Data Modeling and more: https://goo.gl/WNtJFv ⚡Power On!⚡ -Avi Singh http://www.LearnPowerBI.com http://www.AviSing.com
Views: 12336 Avi Singh - PowerBIPro
PowerPivot Data Analyst 7 - Compact vs Flattened
 
02:41
I hate the compact view for pivot tables. The PowerPivot team gives us Flattened pivot tables. This video is designed to accompany the book, PowerPivot for the Data Analyst: Microsoft Excel 2010
Views: 31195 MrExcel.com
Excel PowerPivot Tutorial with Power Map. 3D Geospatial Data and Heat Maps
 
07:00
Excel PowerPivot was a game changer, and now there are more tools being added in Excel 2013. This tutorial shows how Power Map uses a PowerPivot data model as an OLAP back end to a 3D animated view of your data on a variety of customizable maps. Astonishing analytics in seconds.
Views: 24254 Edward Kench
PowerPivot in Microsoft Excel 2010
 
12:58
PowerPivot for Excel is an Excel 2010 add-in that allows users to pull data from multiple sources, mash them up, and then build reports using regular pivot tables.
Views: 25221 Office2010HK
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: 5108 EPC Group.net
Excel 2013 Power BI Tools Part 1 - An Overview of the Power BI Tools
 
13:02
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! Link to download files on this page https://www.wiseowl.co.uk/blog/s443/tutorial-links.htm By Andy Brown https://www.wiseowl.co.uk - An introductory look at the Excel 2013 Power Business Intelligence tools: PowerPivot, Power Query, Power View and Power Map, with a discussion about the advantages and disadvantages of each. This is not a tutorial, simply a video to explain what each tool does, so viewers can decide which subsequent tutorials to watch. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, PowerPivot, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, VBA macros, SQL and Microsoft Access.
Views: 47201 WiseOwlTutorials
Skype for Business  Step by step guide for new users
 
14:52
Web: www.epcgroup.net | E-mail: [email protected] | Phone: (888) 381-9725 | Blog: blog.epcgroup.net: Twitter: @epcgroup Note: This video is property of Microsoft and/or was co-produced with Microsoft. * SharePoint Server 2013 Consulting, Office 365 Consulting, Hybrid Office 365, Hybrid SharePoint 2013,Windows Azure, Amazon Web Services (AWS), SharePoint Server 2010 & SharePoint 2007: Review, Architecture Development, Planning, Configuration & Implementations, Upgrades, Global Initiatives, Training, 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 Management | 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) * 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 \ Office 365 Hybrid engagements and is an industry recognized expert in Business Intelligence (BI), custom application development, BYOD, Hybrid Cloud Architecture, Information Security 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, SharePoint 2010 Consulting, Hybrid Cloud Consulting, Hybrid SharePoint, SharePoint ECM Consulting, SharePoint branding firm, SharePoint, Response Web Design (RWD), SharePoint branding experts, ECM experts, Errin O'Connor, EPC Group, EPC Group.net, Hybrid Cloud Advisor, Project Server Consulting, BYOD, SharePoint 2013 Field Guide
Views: 14223 EPC Group.net
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: 11336 EPC Group.net
Demo Army: Power BI and MYOB Customer Demo
 
04:01
This is an example demo showing the power of PowerBI when combined with a common SMB line of business application like MYOB. It showcases how tools like PowerQuery, PowerPivot, PowerView, PowerMaps and PowerBI for Office 365 can be used to analyse live data from MYOB in an easy, visual manner. PLEASE NOTE: PowerBI will be available in Australia from April 2nd 2014. You can preview by trialling at www.powerbi.com.
Visualization Capabilities of the Microsoft Platform Part Three: Power BI with Q&A
 
08:21
The final video in the three part ProHealth series and covers Power BI with Q&A. Power BI is an enabling technology that allows you to take on-premises Power Pivot and Power View reports and push them into SharePoint Online and utilize Office 365. Once in SharePoint Online, there is a new feature called Q&A, which is a natural language query processing technology allowing you to type out English sentences against the data model you've built inside Excel to produce results and visualizations on the fly. Please note: The virtualization demo has been built entirely with out-of-the-box technologies and no third party tools have been used. Videos have been created on a de-identified set of patient data from the Epic Cogito data warehouse platform. Because a test instance of data was used, some data points may be skewed and do not represent accurate numbers. Part One: Power View and Power Pivot https://www.youtube.com/watch?v=1aZh0aT8Ask Part Two: Power Map https://www.youtube.com/watch?v=fgt-F3MUh7I
Views: 1233 Perficient, Inc.
How To Design Beautiful Business Data Report Dashboard Charts in Microsoft Office 365 PowerPoint PPT
 
34:32
CHECK OUT ONE OF THE MOST POPULAR PRESENTATION TEMPLATE DESIGN: https://www.youtube.com/watch?v=yApp85FOFsU https://www.youtube.com/watch?v=0ozq83VuoY0 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. 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=1MNt2TEk7104BRReVlhth49QPMGetFnaS I have created the playlist of all the PowerPoint Training Videos. You can visit the URL: https://www.youtube.com/playlist?list=PLHq0onhvyWme0oqqKUmULNeavFY5q9C8j About this Microsoft Office PowerPoint 365 Training Video: How To Design Beautiful Business Data Report Dashboard Charts in Microsoft Office 365 PowerPoint. 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 Google Plus: https://plus.google.com/u/0/109609798992670836043 Follow Us on Twitter: https://twitter.com/creative_venus Follow Us on Facebook: https://www.facebook.com/creativevenus4u/
Views: 15666 Creative Venus
Excel PowerPivot Tutorial Dashboards with Power Query, Power View and Power Map BI
 
14:16
Learn to extract data with Power Query in Excel 2013. Then create visualizations from your data with Power Map, Power Pivot, and Power View. This video will teach you the end-to-end process of building a business intelligence dashboard with Power BI. Featured on Microsoft's Power BI Twitter Feed!
Views: 11416 Edward Kench
Cloud Office Hours   Power BI   April 14, 2015
 
26:50
Learn how Power Query, Power View, Power Pivot, and Power Map bring powerful self service BI capabilities to your Office 365 ProPlus customers.
Views: 61 MicrosoftTS2
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
Office 365 Business Intelligence (Power BI)
 
13:24
Business intelligence is one of the greatest benefits you can achieve when using SharePoint online for Office 365. Power BI for Office 365 is the newest business intelligence component coming to SharePoint Online for Office 365. In this video I demo the Power BI Preview and its functionality. Primarily Power BI is composed of excel services and Power BI Admin Centre to broker data refresh and keeping your business intelligence data updated.
Views: 2726 Kevin Powell
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: 136629 EPC Group.net