FAQ
You’re curious. We like that.
Power BI, Power Query, dashboards, DAX - what do they all mean? What are the trainings like, and are they suitable for me? What will I learn? How will I learn? Is there a Starbucks close by? What’s for lunch?
Deep breaths - we’ve got answers.
Our training
-
Our courses are designed for data analysts and professionals who work daily with data.
If you’re spending a lot of time cleaning and manipulating data in Excel or Power BI, you may be keen to find out how you can do it differently. Our trainings will help you to see your business problems from a data perspective, so you know what and how to get the insights you need from your data.
You can also learn more from our articles and explainers on our blog. If you find them useful, you may wish to sign up for a course.
-
You can learn on your own, and we love self-driven learners like you! But if you’ve spent hours going through pages of Google results each time you have a data question, we can help.
It’s not a general showcase of how great Excel or Power BI is; we tailor our trainings to be relevant to your work. The idea is to help you develop an intuitive sense of what your business questions are, and how to shape and transform your data to answer them, as easily and quickly as you (and your managers) want it.
Read more about our training approach, or find out more about our courses. You can also get a feel of what we have to offer with our articles.
-
Here are some aspects of our training that we think really stand out from other providers:
we reach out to you prior to your training to understand your particular work challenges, to make sure we address it in the training session
we keep our classes small (maximum of 9 people) and highly interactive
we work on sharpening your problem-solving skills and conceptual understanding, in addition to know-hows
we offer a personalized 60-minute coaching session to support you in applying what you’ve learned
For more details on what is covered in each course and upcoming sessions, please check out our course pages.
-
We use Power BI and Excel.
Power BI includes Power Query, Power Pivot, and visualizations, all in one software.
Excel includes Power Query as “Get and Transform” within the Data tab since 2016. It also has Power Pivot as a free add-in. Watch this to install Power Query and Power Pivot in your Excel.
If you’re interested in the courses on Power Query or Power Pivot, and have either Power BI or Excel on your computer, you’re good to go. Otherwise, you can read our post that guides you through installing Power Query and Power Pivot in your Excel.
Our course on data visualization requires Power BI, which you can download here.
On Power BI
-
You can think of Power BI as a data preparation, calculation, and visualisation tool made up of a family of Microsoft tools.
Its family members include Power Query and Power Pivot, each having its unique functions to support one purpose: to help users like yourself manage data to generate insights quickly and easily.
-
Power Query is a tool within the Power BI platform that automates your data cleaning and preparation work. Say goodbye to mind-numbing yet critical work such as:
Tedious copying and pasting of updated data to your reports;
Painful merging of many tables into a huge one that slows down your laptop (because too many VLOOKUP()s; and
Manual filtering and deletion of unnecessary columns and spacing.
Once you learn Power Query, you’ll be floored by how much time, energy, and hair-pulling you could have saved if only you had learnt it earlier (This is a common refrain we hear during trainings)!
-
You’ve probably heard of Pivot Table. Power Pivot is like Pivot Table, but way more powerful. With Power Pivot, you can:
Import data from multiple sources;
Relate them simply using drag-and-drop;
Write efficient and flexible metrics that
Work delightfully well with slicers for on-the-fly slice-and-dice
Analyze virtually unlimited rows of data.
It is available both in Power BI and as an add-in in Excel.