#GEEK

How to enable preview features in Power BI?

Allan Rocha

Oct 31, 2016
1 min

How to enable preview features in Power BI?

The post today is going to be: Quick and short; but exciting and useful! Look how easy it’s to enable preview features in Power BI Desktop! Credits to Marc Reguera, Principal Program Manager at Microsoft, who shared an update on LinkedIn few hours ago… #GEEK #PowerBI

Creating a Gantt Chart of your Projects Tasks and Resources in Power BI

Allan Rocha

Mar 10, 2016
2 min

GEEK

Creating a Gantt Chart of your Projects Tasks and Resources in Power BI

Today we will make an AMAZING REPORT with the brand new Power BI Gantt Custom Visual. Gantt Published by Microsoft A Gantt chart is a type of bar chart which illustrates a project timeline or schedule. The Gantt Chart visual shows the Tasks, Start Dates, Durations, % Complete, and Resources for a project. The Gantt Chart visual can be used to show current schedule status using percent-complete shadings and a vertical “TODAY” line. The Legend may be used to group or filter ta

How to Create a Resource Demand Dashboard using Project Online, Excel and Power BI

Allan Rocha

Jan 21, 2016
2 min

Excel

How to Create a Resource Demand Dashboard using Project Online, Excel and Power BI

Let’s create and access a simple but effective Resource Demand Dashboard using: Project Online Engagements data; Power Query Office Apps Pivot Tables in Excel Power BI First of all, you must have a Project Online account and some Engagements data. Engagement is the new feature in Project Online to support a full Resource Management capability. I’m talking about a model and giving a full demo in the video below. Let’s get started then! Make sure you have Resource Engagements

How to Update my Microsoft Project Pro for Office 365

Allan Rocha

Jan 19, 2016
1 min

GEEK

How to Update my Microsoft Project Pro for Office 365

Microsoft created a new way of purchase, download, install, activate and update software that is MUCH EASIER for everyone! J The purchase model is now based on subscriptions, like NETFLIX. The download is a tiny file that connects you to a Microsoft Office 365 account The installation is using the new technology Click-to-Run, which allow you to start using the product without even finish the download! The activation, like any subscription model, is based on yearly or monthly

Office 365 Roadmap using Excel, Power Query and Power BI

Allan Rocha

Jan 14, 2016
1 min

Excel

Office 365 Roadmap using Excel, Power Query and Power BI

Hi All! This post is just to show how cool are Excel, Power Query and Power BI! J If you need to know what is going on in the Office 365 world, this is the place: http://fasttrack.office.com/roadmap But I never like it too much… it’s a little bit confusing, I cannot track what is has been added or removed and didn’t like the filtering… So then I decided to create my own way to get this information and at the same time have some fun with Power Query and Power BI. Basically I

PROJECT VIRTUAL CONFERENCE 2015 (I’m speaking)

Allan Rocha

Sep 9, 2015
1 min

BUSINESS

PROJECT VIRTUAL CONFERENCE 2015 (I’m speaking)

Hi All, I hereby share that I’m speaking at the PROJECT VIRTUAL CONFERENCE 2015 ! uhu! WHEN: 2015-10-22 WHERE: Your favorite browser/device WHAT: Power BI and Project Online: Business Intelligence is necessary, but can also be fun Yes! It’s true… a conference, about Microsoft Project and PPM, totally virtual and super awesome! J According to the founder, main organizer and friend Prasanna Adavi: “Here are some of the best speakers and experts on Microsoft Project, Project Ser

Allan Rocha

Sep 2, 2015
1 min

Excel

Comparing 2 Excel Files

Believe it or not, this is a standard feature in Excel 2013. It allow you to compare 2 excel files showing EVERY difference between then… Including: How to use it: Open the 2 files you want to compare Access the Inquire tab and select Compare Files. In case you cannot see the Inquire tab, add it from Options – Advanced – COM add-ins. Then enjoy the results: #Excel #GEEK

Are you a SharePoint master and understand about project management?

Allan Rocha

Jun 22, 2015
1 min

BUSINESS

Are you a SharePoint master and understand about project management?

… then you might be one of the talents we are looking for our offices in Aarhus and Værløse. Are you not experienced but very skilled on IT and finds PPM (Project & Portfolio Management) world interesting? You might be one of our new junior profiles. Projectum has just be named the world’s best Microsoft PPM partner, and we are experiencing a continued growing demand for our services, both in Denmark and abroad. Currently we are looking for the following profiles: Project Man

What is coming to Power BI Designer is really Exciting

Allan Rocha

Jun 20, 2015
2 min

BUSINESS

What is coming to Power BI Designer is really Exciting

I have to confess that I never use Power BI Designer too much mostly because I think the design of the charts are terrible! And even worse, I’m not allowed to change anything… I SAID, ANYTHING! But this situation is just about to change! BREAKING NEWS: Design is the priority 1 next goal for Power BI Designer Here are the next Microsoft goals for Power BI Designer: Design – we want the Power BI Designer to be the tool that unifies all Power BI client experiences. Users – we

How to Install Office 2016 & Project 2016 using the Click to Run Technology

Allan Rocha

Jun 18, 2015
1 min

Preview

How to Install Office 2016 & Project 2016 using the Click to Run Technology

Hi All, If you have an Office 365 subscription and want to try the NEW and EXCITING Office 2016 and Project 2016 just follow these instructions: REMEMBER: IT’S STILL IN PREVIEW AND YOU CAN FACE SOME BUGS Access your Office 365 Portal https://portal.office.com/ Type your username and password Click on the WHEEL Select “Office 365 Settings“ Click on “Software“ Click on “Office” or “Project“ Scroll all way down to the page Click on “Install“ A toast window will be presented to y

Allan Rocha

Jun 2, 2015
4 min

GEEK

Power BI Designer May Update

Today we’re announcing a new update to the Power BI Designer Preview. This month’s update is packed with lots of new features across the Data Modeling, Analytics, Get Data & Transformations areas of the product: Data Modeling & Analytics Calculated Columns Data Categorization Sort by Another Column Improved DAX Formula Editor: Function Help and Prototype Get Data & Transformations New “ODBC Tables” connector (Beta) Improvements to the “Excel Workbook” connector: Better Column

How long takes to refresh a huge amount of data using OData Feed in Project Online

Allan Rocha

May 28, 2015
1 min

GEEK

How long takes to refresh a huge amount of data using OData Feed in Project Online

I just did a refreshing test of the most heavy tables in Project Online to see if the recently announced OData Performance improvements were really good as we thought… And the result are YES!!! They were really good… take a look at the test I have made today, 28th May 2015. TABLEROWSCOLUMNSAssignments 3.269 88AssignmentsTimephasedDatset 42.080 33TimeSet 60.631 8Resources 182 37Projects 266 110ResourceTimesphasedDataset 169.684 5TOTAL 276.112 281 Took me only 4 minutes and 33

How to Remove a PWA Instance from Office 365 without blocking it for 30 days

Allan Rocha

May 27, 2015
1 min

GEEK

How to Remove a PWA Instance from Office 365 without blocking it for 30 days

Recently Microsoft has introduced a new limit of PWA (Project Web App) instances of 7 (seven) instances per Tenant. But what happen when you delete a PWA instance using the Delete button? You actually send this site collection to your recycle bin and will block that instance for 30 days… In most of the cases we delete PWA instances when they are DEV or TEST environments… and I don’t want to wait for 30 days to create a new environment… (and start crashing it again…) Here it

Project Online & Office 365 Requirements

Allan Rocha

May 25, 2015
2 min

GEEK

Project Online & Office 365 Requirements

Project portfolio management options The following table lists the PPM options that are available. OptionDescriptionProject OnlineA monthly subscription service that is offered as a standalone service or as an add-on for Office 365 customers in the Enterprise, Education, or Government service families. Project Online cannot be added to Office 365 Business plans. To learn more about Project Online, see Getting Started with Project Online. To buy Project Online, see Project Onl

Watch my Presentation at Microsoft Ignite 2015

Allan Rocha

May 25, 2015
1 min

GEEK

Watch my Presentation at Microsoft Ignite 2015

Real World Reports: Business Intelligence in Microsoft Project Online and Project Server 2013 Project Online and Project Server 2013 provide easy, yet powerful, reporting options to create a variety of projects, resources, and portfolio reports. Learn how you can create real-time reports and dashboards using tools such as Microsoft Excel 2013, Excel Services, Microsoft PowerPivot, Power View, and OData. CLICK HERE TO WATCH If you didn’t attend the Microsoft Ignite here it is

Power BI Preview app for Windows Store is out!

Allan Rocha

May 25, 2015
1 min

Apps

Power BI Preview app for Windows Store is out!

Click here to open the app inside the Windows Sore Feel free to watch my presentation at Microsoft Ignite 2015: Real World Reports: Business Intelligence in Microsoft Project Online and Project Server 2013 Project Online and Project Server 2013 provide easy, yet powerful, reporting options to create a variety of projects, resources, and portfolio reports. Learn how you can create real-time reports and dashboards using tools such as Microsoft Excel 2013, Excel Services, Micros

New Power BI features available for preview

Allan Rocha

May 25, 2015
2 min

BUSINESS

New Power BI features available for preview

Hi All, Today I’m sharing few of the amazing features coming with the new Microsoft Power BI. It’s a public preview, that means you can just sign up and start using… Link for the public preview: Click here So, I will start our tour by showing the new Microsoft Power BI Designer. You can download it here. This tool will provide your analysts to discover, combine and visualize data. It has several built in connectors to help you out on getting data from anywhere. It is a combin

Microsoft Project 2013: Standard, Professional & Pro for Office 365

Allan Rocha

May 24, 2015
3 min

Books

Microsoft Project 2013: Standard, Professional & Pro for Office 365

. Ricardo Vargas presents, together with Allan Rocha, Microsoft Valuable Professional (MVP), the book that will help you achieve success in your projects using Microsoft Project 2013. Preface by Chris Crane, director, Project e Visio Marketing, Microsoft Corporation. Technical data 1st edition – 2013 500 pages ISBN13: 978-85-7452-623-2 Format: 21 x 28 cm Introduction This book and the content below are published in Brazilian Portuguese. O Microsoft Project por vários anos é u

Creating a Dynamic Link or Linked Fields in Project

Allan Rocha

May 24, 2015
1 min

GEEK

Creating a Dynamic Link or Linked Fields in Project

Creating a Dynamic Link or Linked Fields in Project 2013. Copy a normal cell (Ctrl+C) Right click on the cell you want to paste the copied information Select Paste Special Select Paste Link and then OK Change the value of the source cell, in my case I just changed the duration to 5 days, which changed the finish date as well you will see the value of the dynamic cell changing automatically magic!!! 🙂 #GEEK