Project Data Analytics

Course Takeaway

• learn the most advanced and easy method of P6 and power BI integration.
• Learn how to seamlessly convert project data into visuals and trends.
• Learn Primavera P6 from a data warehouse perspective.
• Learn DAX and Power Query to modify KPIs as per the need.
• Detailed understanding of P6 schemas and Tables
• Control Project data and shape your reports and dashboard in a way that delivers for stakeholders.
• Learn Data flow and filter context for your data.
• Integrate project drawings with earned value for project cost and programme visibility to identify pinch points.
• Spend less time on data handling and more time analysing your KPI data.
• Learn to interpret project data and extract useful information out of it
• Data driven solution and enhanced the strategic decision making.
• Be the Master of Project Data analytics

Course Description

This course presents a gentle introduction into the concepts of project data analysis, the role of a Data Analyst, and the tools that are used to perform daily functions (P6 and Power Business Intelligence PBI). You will gain an understanding of the data ecosystem and the fundamentals of data analysis, such as data gathering or data mining. You will then learn the soft skills that are required to effectively communicate your data to stakeholders, and how mastering these skills can give you the option to become a data driven decision maker.

This course will help you to differentiate between the roles of a Data Analyst, Data Scientist, and Data Engineer. You will learn the responsibilities of a Data Analyst and exactly what data analysis entails. You will be able to summarize the data ecosystem, such as databases and data warehouses. You will then uncover the major vendors within the data ecosystem and explore the various tools on-premise and in the cloud. Continue this exciting journey and discover Big Data platforms such as Hadoop, Hive, and Spark. By the end of this course you will be able to visualize the daily life of a Data Analyst, understand the different career paths that are available for data analytics, and identify the many resources available for mastering this profession. Throughout this course you will learn the key aspects to data analysis. You will begin to explore the fundamentals of gathering data, and learning how to identify your data sources. You will then learn how to clean, analyze, and share your data with the use of visualizations and dashboard tools. This course does not require any prior data analysis, spreadsheet, or computer science experience. All you need to get started is Primavera P6 literacy, access to PBI plus access to a modern web browser such as Chrome or Firefox.

Main skillsets to be developed

During the entire training you will learn several new skills to automate your reports and dashboards in PBI, how to visualize data, how to drill down to root cause of slippage, bottle necks operations delivery delays and convert data into information that will strengthen your decision-making skills. In our training we will teach

• How to take data out from P6 in simplest and quickest way
• How to import data directly into P6, without any modification in excel.
• How to clean the data
• How to structure the data and develop tables with our unique M.Code scripting
• How to standardize the names of tables to later use them in DAX.
• How to develop schema relative to time scale which will enable you to generate trends.
• How to write DAX codes to generate automated earned value KPIs, Project Elapsed and Remaining Durations and Forecasted Delays.
• How to create industry based standard performance reports and dashboard in highly interactive way.
• How to Integrate earned value with project drawings
• How to perform analytics on Project data and convert your data into useful visuals and information.