Power Query and Power Pivot for Excel Workshop in Sydney on 11 -12th Jun

Certificate: Course Completion Certificate

Language: English

Duration: 2 Days

Credits: 16

Course Delivery: Classroom/ Virtual Live/ On-Site

Offers: Groups of 5 - 10 people 10% Discount | Groups of 11 - 20 people 15% Discount

Course Overview

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 utilizing the amazing capabilities of Power Query, Power Pivot and Power BI.

The course covers the core elements needed to understand what Power BI, Power Pivot and Power Query can do. You will use Power Query to extract and shape data and 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

Target Audience:

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

Learning Objectives:

• Understand how Power BI builds on the functionality of Excel’s native tools, such as Pivot Tables, slicers, and key analytical functions
• Be able to import data from a variety of electronic sources and relate them quickly to deliver key information in minutes not weeks
• Utilise best practice database design, realizing the power of the Data Model by using LOOKUP lists and efficient database design
• Provides an introduction to Power BI Data Analysis Expressions (DAX) language
• Prerequisites:
• This is an intermediate course and users should already be comfortable with Excel to get the most from this course.
• Participants should be familiar with functions & concepts such as VLOOKUP and SUMIFS.
• The focus of the course on Power BI in Excel 2013/2016 and is also applicable to Power BI Desktop.

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

We also offer a variety of other courses :

Lean Six Sigma Green Belt Training:- The Certified Lean Six Sigma Green Belt (ICGB) is a professional who is well versed in the Lean Six Sigma Methodology who both leads or supports improvement projects, typically as a part-time role. A Lean Six Sigma Green Belt possesses a thorough understanding of all aspects within the phases of D-M-A-I-C. They understand how to perform and interpret Six Sigma tools and how to use standard principles of Lean.

The Lean Six Sigma Green Belt operates in support or under the supervision of a Six Sigma Black Belt, analyzes and solves business problems, and is involved in process and quality improvement projects. Lean Six Sigma Green Belt drives process improvement initiatives to develop robust systems for the business and deliver consistent output to customers. Green Belt training equips individuals with a logical and objective way to identify, measure, and eliminate problems / issues with process within an organization. The training also enhances the way employees approach their day-to-day work and strategically positioned to support each other in the workplace, the improvement potential expands.

Business Etiquette Workshop:- These Business Etiquette training have been developed to help ensure the people in your organisation are aware of the importance of meeting common workplace standards. You may not be aware how certain behaviours affect others within the organisation, and indeed how that affects the business as a whole. Alternatively, it might be that people need to have honest conversations with each other to ensure they work together collaboratively.

The session will help you to build self-awareness and will highlight the important parts of business etiquette and why it’s such an important topic.

Organizational Skills Training:- Developing good Organizational Skill is an investment that will provide benefits for years. To be successful means to be organized. These skills will filter through all aspects of your participants professional and personal lives. Throughout this workshop your participants will be given the tools necessary in developing better Organizational Skills.

Through Organizational Skills your participants will encounter improved productivity, better management, and an overall increase in professional growth. Every day people waste numerous amounts of time looking for items. So stop looking for those important items, and start knowing where they are by getting organized.

Time Management Workshop:- Personal time management skills are essential for professional success in any workplace. Those who are able to successfully implement time management strategies are able to control their workload rather than spend each day in a frenzy of activity reacting to crisis after crisis – stress declines and personal productivity soars! These highly effective individuals are able to focus on the tasks with the greatest impact on them and their organization.

The Time Management workshop will cover strategies to help participants learn these crucial strategies. Your participants will be given a skill set that includes personal motivation, delegation skills, organization tools, and crisis management. We’ll cover all this and more during this workshop.

Manager Management Workshop:- With this course, you will be able to provide the skills, guidance, and empowerment to your team of managers. They will then be better suited in leading and motivating their team and thus produce fantastic results. To be a successful manager means having a wide range of skills. Through this workshop, you will be able to disperse your knowledge and experience throughout your leadership team.

Manager Management takes a special type of leader. This workshop will expand your participant's knowledge and provide a way for them to teach and lead new and experienced managers. As every manager knows that learning never stops, this workshop will have something for everyone.

Personal Branding Workshop:- Personal Branding is identifying your assets, characteristics, strengths, and skills as an individual. Understanding Personal Branding will provide advantages in your participant’s personal and professional lives. Branding is a mix of how you present yourself and how others see you. It is important to be aware of how you are viewed.

With our Personal Branding course your participants will be able to share their vision and passions with others in your company. Utilize this knowledge through Social Media to define and influence how others see you. You are your brand so protect it. Live it.

Leading Effective Teams Workshop:- These training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.

Training course contents:

Having an effective team around you is crucial. However, it is an area that is often left to chance, which can lead to de-motivated individuals that do not feel part of the business and consequently do not perform. This course looks at what it takes to lead an effective team and how you can get the best out of the people in it by understanding the role of leader, both personally and from the point of view of the team.

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 predefined case studies or a customized case study from the participant's organization.

Communication Strategies Training:- For the better part of every day, we are communicating to and with others. Whether it”s the speech you deliver in the boardroom, the level of attention you give your spouse when they are talking to you, or the look you give the cat, it all means something.

The Communication Strategies workshop will help participants understand the different methods of communication and how to make the most of each of them. These strategies will provide a great benefit for any organization and its employees. They will trickle down throughout the organization and positively impact everyone involved.

Time Management Workshop:- Personal time management skills are essential for professional success in any workplace. Those able to successfully implement time management strategies are able to control their workload rather than spend each day in a frenzy of activity reacting to crisis after crisis - stress declines and personal productivity soars! These highly effective individuals are able to focus on the tasks with the greatest impact to them and their organization.

The Time Management workshop will cover strategies to help participants learn these crucial strategies. Your participants will be given a skill set that includes personal motivation, delegation skills, organization tools, and crisis management. We"ll cover all this and more during this workshop.