Microsoft Power BI 2 Days Training in Philadelphia, PA

Certificate: Course Completion Certificate

Language: English

Duration: 2 Days

Credits: 16

Refreshments: Snacks, Beverages and Lunch included in classroom session

Course Delivery: Classroom

Course Overview:

Power BI is the newest Analytics & Business Intelligence tool developed by Microsoft. Power BI is one of the most robust business Intelligence platforms available for data modeling.

In this module we will learn the basics of this Power BI, and all the five components of the tool (Visualizations, Dashboards, Reports, Apps and Datasets).

There will be demos and introduction about Power BI desktop, Power BI website, Mobile Apps and Office 365 Power BI Subscription. You will also learn the easy methods of using Power BI in some scenarios.

Learning Objectives:

• Understand primary features of a self-service Power BI solution
• Utilize Power BI and its data sources
• Combine, analyze, model, shape, and visualize data
• Report data using rich dashboards

Target Audience:

This Microsoft Power BI Course is for all the professionals who want to understand how to use the tools and create customized reports. Who are passionate about Business Intelligence are also welcomed. Some of Job roles include:

• Product Managers
• Data Engineers
• Business Analysts
• Data Analysts
• Business Intelligence Manager
• Data Scientists
• Project Managers
• Program Managers
• Professionals Working with Data

Examination:

No Exam

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)

eBook download and activation instructions

Prerequisites:

There are no prerequisites for this course.

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Certification:

Once after the training you receive course completion certificate from Academy for Pros.

Power BI Dashboard and Data Analysis Training:- Create stunning interactive reports and share amazing insights! Power BI gives Excel users the power to extract data from multiple sources, link it together, perform calculations and create powerful visualizations.

Power BI is an AMAZING cloud-based business analytics service provided by Microsoft that allows users to transform data into rich, interactive visual reports that present a 360-degree business view and improve business decision making.

Power BI Desktop is a development platform from Microsoft that allows users to connect to a huge range of data sources, clean and transform messy data, create relationships between data sets, perform calculations and prepare stunning interactive reports.

Power BI.com allows users to publish their interactive reports and share certain features of those reports with others. Reports published to PowerBI.com can be set to refresh automatically and can be interacted with online using any browser or mobile device.

Big Data Overview Training:- This is an awareness course designed to provide you with an understanding of Big Data, the potential sources of Big Data that can be used for solving real business problems. The course also introduces Big Data technologies, such as Hadoop and MongoDB, and provides the overview of data mining and the tools used in it.

Excel Super User Training:- Take a leap forward in the way you use Excel. Learn from experts who have years of practical experience and are still developing high quality Excel based applications for clients throughout the region.

Have you looked at all the “Advanced” Excel courses and thought “They’re not advanced”? Well, we have just the course for you!

Power BI for Business Users Training:- Learn Microsoft Power BI with our comprehensive training courses. Our courses range from the basics of Power BI to complex data modelling using DAX and creating live dashboards for reporting. These courses are for anyone interested in business intelligence, reporting and complex data modelling.

Power BI for Report Developers Training:- Learn Microsoft Power BI with our comprehensive training courses. Our courses range from the basics of Power BI to complex data modelling using DAX and creating live dashboards for reporting. These courses are for anyone interested in business intelligence, reporting and complex data modelling.

Power Query (Get & Transform) for Excel and Power BI Desktop Training:- Power BI (including Power Query & Power Pivot) are the biggest Excel news items in the last 10 years. They give Excel users the power to draw information out of multiple sources, link it together then perform calculations on it that can then be sliced & diced any way you want.

This hands-on course is focused on real-world techniques utilising the amazing capabilities of Power Query.

This 1-day course covers the core elements needed to get an understanding of what Power Query can do. You will use Power Query to extract and shape data from a variety of sources and data layouts. You will learn to consolidate 50 csv files instantly, “un-pivot” data and replace VLOOKUPS with merged queries.

This focused course delves deeper into Power Query and how to get the most from this amazing tool. You will learn how to amend the “M”code generated by the Power Query interface, create reusable custom functions and set up dynamic parameters for your queries.

Big Data Bootcamp:- This big data training course will provide a technical overview of Apache Hadoop for project managers, business managers and data analysts. Students will understand the overall big data space, technologies involved and will get a detailed overview of Apache Hadoop. The course will expose students to real world use cases to comprehend the capabilities of Apache Hadoop. Students will also learn about YARN and HDFS and how to develop applications and analyze Big Data stored in Apache Hadoop using Apache Pig and Apache Hive. Each topic will provide hands on experience to the students.

Power Query and Power Pivot for Excel Training:- Power BI (including Power Query & Power Pivot) are the biggest Excel news items in the last 10 years. They give Excel users the power to draw information out of multiple sources, link it together then perform calculations on it that can then be sliced & diced any way you want.

This hands-on course is focused on real-world techniques utilising the amazing capabilities of Power Query, Power Pivot and Power BI.

The course covers the core elements needed to get an understanding of what Power BI, Power Pivot and Power Query can do. You will use Power Query to extract and shape data and then load it into Power Pivot. You will build a complex Power Pivot Model from scratch, write DAX formulas and set up interactive reports.

The second day delves deeper into all of the topic areas demonstrating how to get the most from these amazing tools. You will learn extra advanced Power BI features and get a more in-depth understanding of Power Query and Power Pivot reporting techniques

Project Integration Management Training:- This power session offers new ways of managing and dealing with projects. The focus is more on communications, understanding stakeholders’ needs and managing expectations. Participants will also learn about organizational politics and culture, and performing value-adding activities.

Aligned with the Project Management Institute (PMI®) Guide to the Project Management Body of Knowledge (PMBOK® Guide 5th Edition), this course provides a practical approach to focusing on those things that matter most for project success. Namely – communication, managing stakeholder expectations, risk, change and quality, so that the scope, schedule, cost and project goals are met as planned. In short, the course provides the context and meaning behind the words Project Integration. Participants will discover the approaches and techniques that will deliver project success through topics that deal with: The importance of proper stakeholder analysis and robust communication planning in building the foundation for a successful project. Utilizing best practices, concepts and methodologies and leveraging them in the context of organizational challenges and project realities.

Illustrating the link between effective management of back office aspects (e.g., quality, risk, communication and change) and delivering value and project success. Realizing the importance of assessing and prioritizing project readiness and complexity in the context of the organizational bigger picture to ensure alignment with organizational objectives. The delivery format will combine lecture with practical real-life examples. There will be mini exercises “on the go” to apply individual learning.

This course is designed after the book Managing Stakeholder Expectations for Project Success (Ori Schibi, 2013).

Project Management Basics Training:- With this Course you will gain a basic understanding of Project Management based on the Guide to the Project Management Body of Knowledge® – 5th Edition. The Course covers information on project Management theory, Principles, techniques, and methods.

During the Course, exercises are made based upon a case study. The case study may be one of three pre-defined case studies or a customized case study from the participant’s organization (see below: customization).