• ABOUT

  • HIGHLIGHTS

  • BOOKS

  • CAREER

    • PMOTTO.ai
  • BLOG

  • CONTACT

  • More

    Use tab to navigate through the menu items.
    • White YouTube Icon
    • White LinkedIn Icon
    • White Twitter Icon
    • White Facebook Icon
    0
    How to enable preview features in Power BI?
    Allan Rocha
    • Oct 31, 2016
    • 1 min
    GEEK

    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
    00
    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
    00
    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
    00
    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
    00
    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
    00
    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
    00
    Comparing 2 Excel Files
    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
    00
    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
    10
    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
    00
    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
    00
    Power BI Designer May Update
    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
    00
    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
    00
    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
    10
    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
    00
    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
    30
    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
    00
    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
    10
    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
    10
    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
    00

    © 2017 by Allan Rocha.