How to memorize how to use a Software [Microsoft Power BI]

Hello guys,

I need to ask you a question besides using a lot one piece of software how else can you memorize it? Where a certain function is where a certain button is how to create a certain thing in it. I want to learn how to use POWER BI but it’s far more complex than excel and even though there are a lot of tutorials on it I still can`t do it all like a pro. SO how can I use powerful memorization techniques to better cement in my brain the use of this software?
Thanks

2 Likes

Some ideas:

Keyboard Shortcuts

I’m not familiar with Power BI, but one technique I use when using new programs is to learn the keyboard shortcuts as early as possible. It really speeds things up, especially once you get the information stored in muscle memory.

Many keyboard shortcuts have mnemonics built-in, like “p” for “paste” or “r” for “rectangualar selection box”.

If they don’t have easy names like that, I’ll learn them in pairs or small groups.

Example: one of the graphics programs I use has two arrow tools — one selects and moves things (v), and the other one manipulates nodes on vector images (a).

I didn’t use a specific mnemonic for those but only took a minute to focus on the difference between them and to consciously feel what it’s like to press each key to switch the tools.

If I had needed a mnemonic, I would have visualized the letters “V” and “A” as looking like pointing tools, because both tool-icons look kind of like arrows:

Whenever I have to do something with the software, I stop to hover over a tool to find out its keyboard shortcut, and I try to use those instead of clicking on things. I feel like it speeds up the learning process a lot, and make me much faster at operating the program than I would have been without the keyboard shortcuts.

Cheatsheets on Wall

There’s a text editor called Vim that I learned about 15 years ago. It’s like Notepad but with a user manual hundreds of pages long, and there are no buttons or mouse controls, so you have to store a lot of keyboard shortcuts in your mind and muscle memory. It’s almost like learning a language that you can use to “speak” with the text editor.

I printed up a few cheatsheets and taped them to the wall next to my desk. Whenever I needed to do something in Vim, I would force myself to not use the mouse but would look up the keybinding on the cheatsheets.

Here’s an example cheatsheet:
https://vim.rtorr.com/

Forcing myself to do that helped me get through the initial learning curve.

Learning by Task

Some things don’t have keyboard shortcuts, but they can be learned as steps in a task. If you can define a common task, like “remove background from image”, then you can make a list of the steps and practice a few times to get it in muscle memory and/or put the list into a memory palace or peg list.

There are some common tasks listed on this page:

  • Connect to data
  • Shape and combine data
  • Group rows
  • Pivot columns
  • Create custom columns
  • Query formulas

If I were going to learn the program, I’d probably start by putting the keybinding cheatsheet on the wall next to my computer, and making sure I could do all of the tasks in that list without looking up the answers. Then I’d find another list of tasks and start learning those. If the goal is a certification, then I’d look up what is required for the certification and make sure I could walk through all of those tasks.

Edit: here’s another list of common tasks: Free Power BI exercises

1 Like

Hello Josh,

Thanks but that wasn’t the kind of info I was looking for. I thought there was a way to memorize the path and steps of how to create or do a certain task. I wasn’t looking for some way to learn shortcuts I don`t think your idea is bad it’s just not the kind of answer I was looking for. But thank you very much, especially for the FREE POWER BI EXERCISES I will definitely do them.
Again thank you and GOD BLESS

1 Like

You could use memory palaces or peg lists to memorize the steps of tasks, if it helps.

I don’t know anything about this course, but by coincidence I got an email about a sale on it today for USD $10:
https://www.udemy.com/course/15-days-of-power-bi/?couponCode=BEST_DEAL_JUNE

It looks like the sale ends today.

They always have these sales that end each 3 -4 days it`s just a marketing stunt to get you to buy now. Josh, I have some other questions one with how to memorize courses from COURSERA can you take a look at that and tell me how I can do that?
Thanks

Sure, I’ll take a look.

They often go down to $12.99 to $14.99, but only a few go down to $9.99 except a couple of times per year.