Power BI in 2 Days
Sep 26-27 // Oct 24-25 // Nov 21-22
The course will provide confidence in best practices for using Power BI to solve solutions to typical business scenarios.
Overview
The first day of the course will cover connecting and transforming data from a variety of data sources, defining business rules and KPIs. It also will cover Power BI report layouts and structure the agile process to creating Power BI data visualizations. It will help attendees to understand the art behind visualizations, the implications behind choosing the right charts, the impact of color, shape, and size, and finally the use of Power BI custom visuals.
The second day of the course will cover using Power BI Desktop to import and shape data from a variety of sources. It will also walk through Power BI capabilities you can use to enhance the data model for your business users. This course also covers key aspects of how to create a great data model to meet your business needs, various features in Power BI used to enhance data models so you can build great reports, and an introduction to DAX to create calculations.
BOOK YOUR COURSE
AUD 750
This cost is for 1 person per day. 2 days will be AUD 1,500.
We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please send us an enquiry.
Key Topics
Within 2 days, you will have a chance to go through 10 important labs below:
Power Query Groups, Parameters, Custom Slicer Sorting, Adding Slicers to the Model and Uni and Bi Directional Relationships
Calculated Tables, Loading Budgets, What if Analysis
Tap into Core M Programming with Ground Up Concepts
Learn how to Tune your DAX measures with the built in Performance Analyzer Tool
Learn Handy DAX Functions that you can add to your Toolkit.
What Is Included
Students will have access to their own desk, chair, and space in a classroom during the course.
Each participant is required to bring his or her own laptop for exercises (Hands-on Lab).
Peter O’Gorman – Head of Training
Peter has over 19 years working with data and business intelligence eco-systems serves as Managing Consultant for Cloudstreet in Darwin. He is a certified Microsoft Certified Trainer, Microsoft Certified Solution Associate, Certified Data Vault 2 Practitioner and Certified Prince 2 Foundation. Having used data-driven & AI ecosystems to solve the repetitive and mundane, he leads Innovation and Learning for Cloudstreet Consulting.
Coffee breaks and a light lunch are included every day. When registering, please communicate any dietary restrictions.
Each participant will receive materials for 2 day training, including printed workbooks and online labs.
Each attendee will receive a PDF certificate by email after completing the course.
Target Audience
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI.
This course is also targeted toward those individuals who develop reports that visualise data from the data platform technologies that exist both in the cloud and on-premises.
Prerequisites
Successful Data Analysts start this role with experience of working with data in the cloud.
Specifically:
- Understanding core data concepts.
- Knowledge of working with relational data in the cloud.
- Knowledge of working with non-relational data in the cloud.
- Knowledge of data analysis and visualization concepts.
Prerequisite Courses (or equivalent knowledge):
- NA
Skills Gained
After completing this course, students will be able to:
- Ingest, clean, and transform data
- Model data for performance and scalability
- Design and create reports for data analysis
- Apply and perform advanced report analytics
- Manage and share report assets
- Create paginated reports in Power BI
NT Dataset
You will connect real public Crocodile Captures data in the Excel file, select the tables you want to use, and import them for transformation. Public and organisational datasets will often require understanding and shaping in order to make for interesting and useful analytics.
Power Query
Skills in Power Query are essential in being able to take charge of the clean-up and perhaps re-organisation of your input datasets. While you wait for the data owner to clean-up the data or provide it in another format, Power Query gives you the power to take this into your own hands and you will be surprised what you can do.
Offering NT’s Leading Microsoft Training Resources
Our trainees say
Your commitment, passion, and delivery were really amazing. We had a great start and the speed as well as intensity with which we rolled out globally over 3 years was unbelievable.
“Joining Cloudstreet Consulting gives me the opportunity and confidence to apply all the knowledge I had gained from school towards the IT industry”.
