Excel Power BI Course
In this three day course, attendees will learn the fundamentals of creating their own rich interactive reports and sharing their insights with others.
Power BI uses Excel technologies we are familiar with like Power Query and PowerPivot. It combines these awesome tools, and adds an incredible charting and visualization layer on top. This provides a beautiful interactive experience for the end user to discover new insights about our data.
You will learn how to create relationships between data sets, which allow us to create charts and visualizations that compare data from multiple sources. We analyze trends in weather data, Facebook activity, and sales performance for Mammoth, to gain some pretty interesting insights about their data.
We will cover An introduction to Power BI Importing and cleansing data for use in the model Modelling your data with DAX Creating interactive reports Sharing your reports with others
It is intended for use by non-IT staff, including both Line and Senior Managers, Personal Assistants, Business Analysts, BI Specialists, and Knowledge Workers
No prior experience with Power BI or other BI tools is required, some experience with excel is desirable but not mandatory
Hours are 08:30 to 16:00 unless specified otherwise
Lesson 1: Getting Started
Lesson 2: Working with Data
Lesson 3: Working with Reports and Visualizations
Lesson 4: A Closer Look at Visualizations
Lesson 5: Introduction to the Power BI Web App
Would you prefer to take a private Excel course with one of our certified trainers?
We offer Excel training:
From 1 to 100 delegates, On-site at your offices.
Group rates, Flexible dates, Customised courses & Ongoing support for Adobe Excel
Live, Online instructor-led Excel training. Flexible dates and times to suit. All taught in real time wherever you are to individuals or groups.
If you would like to see our Excel Testimonials, please either contact us directly or view our client list and their experiences with our company.
Power BI is an analytics tool developed by Microsoft that turns your bits of unstructured data into a visually compelling story. It consists of the Power BI Desktop, the SaaS Power BI Service, and a range of mobile apps (iOS and Android compatible). These tools take big data and help your business or organization ask the right questions and receive actionable insights. Power BI takes information from disparate data sources and turns them into custom visuals designed to help an organization not only read the info but get a clear idea of what to do. The right data visualization can be the difference between having unstructured data that disappears and using that data to make critical (and more importantly, correct) decisions.
Share rich data visualizations that help everyone make decisions based on facts, not instinct.
Distribute findings to team members inside and outside your organization, adjusting permissions as needed
Access visualizations on the go using the Power BI Mobile app to make data-driven decisions from anywhere.
Enhance collaboration by using team commenting and stay current with content subscriptions and update alerts.
Wherever your office is located, we can come to you and deliver a private custom Excel Power BI course. The larger the group the bigger the discount. However we also offer Excel training for individuals, either at your offices or your home.
For on-site courses, you will need to have a computer with Excel and if there are 3 or more delegates, a projection system is required for our Excel instructor.
Currently we offer Public Excel Power BI courses in the Johannesburg, Cape Town, Durban, Gqeberha and Bloemfontein areas. We can however provide a private onsite course or of course an online Excel course is also available
If you are unable to attend a public Excel course, or simply prefer the convenience of an online course, these are regularly offered. For online Excel courses you will need Excel installed, an internet connection of 5MB/s or faster and a headset with a mic or use your laptop's built in mic and speakers. All Excel course materials are provided digitally. The course is of course, live and fully interactive with engaging teaching.
Excel users tend to use the product for specific purposes. We can tailor a course to meet your specific goals.
Power BI is the future of how we will analyze, present, and share data. It's a revolutionary new tool that provides us with a lot of opportunity.
Bring data together from multiple sources including Excel, databases (SQL, Oracle, SAP, Salesforce, Dynamics, Facebook, etc.), the web, and more. Clean and transform the data to create relationships between data tables. Create interactive reports and dashboards that are accessible on any device including computers, phones, tablets, and even Apple Watch.
All delegates receive digital materials which are the official Microsoft training manuals. Our instructors may provide addtional training lessons and information especially for custom courses
These Excel courses are the perfect preparation to become a Microsoft Office Specialist
Excel is used by almost every computer user. Simply put if you want to be employed or run your own business, knowledge of Excel is imperative. We cannot show you all our clients and their reviews on our site, and you can view a sample by using this link, however if you contact us directly, we will be happy to put in you in touch with some of our students who have taken our Excel courses.
You can rely on the expertise of our instructors who have been teaching courses over 15 years. Our trainers are developers too. It’s essential to learn from professionals.
When you attend our courses, all delegates receive course materials, a certificate on completion and 3 months support from our certified instructors.
We guarantee your course and offer a full refund if you are not satisfied with your training experience. Just let us know within the first 2 hours of your course.
