Power BI Dashboard and Data Analysis 2 Days Training in Los Angeles, CA

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:

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 visualisations.

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.

Target Audience:

• Excel users & analysts that focus on extracting, re-organizing and analyzing data
• Anyone involved in creating visualizations & data modelling
• Anyone interested in saving huge amounts of time in automating the work involved in creating recurring reports and dashboards.

Learning Objectives:

• Easily connect to multiple data sources, including Excel files, SQL Databases, Google Analytics, SharePoint, CSVs, ODBC and many more
• Quickly prepare raw data for analysis by recording data transformations
• Simply drag and drop to easily create relationships between different data sources. NO VLOOKUP REQUIRED!
• Create custom report calculations for measuring profitability, margins, KPIs and any other desired areas using the powerful DAX formula language
• Easily prepare interactive data visualisations colour-coordinated with corporate colours using built-in or custom templates
• Quickly publish reports to Power BI.com for users to interact with using any browser, mobile phone or tablet
• Customize user data views with

Prerequisites:

This is an intermediate course and users should already be comfortable with Excel Pivot Tables or Database development to get the most from this course.

Course Materials:

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

Examination:

There is no exam for this course.

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

Certification:

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

Microsoft Power BI Training:- Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A).

You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.

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).