What do you guys do?

Lightdotlab is powered by a small team of Excel enthusiasts driven by our big love for data. We believe in enabling people to get the most out of data through personalised Excel training and tailored consulting services. Our versatile Excel solutions have been adopted by companies from varied industries such as aviation, fintech and travel.

With Lightdotlab’s interactive Power Query and Power Pivot trainings, you will learn how to use Excel tools hidden in plain sight to solve complex problems. Discover new ways to tackle and manage data more efficiently with these little-known but powerful tools. They are especially helpful if you often crunch data in Excel or regularly deal with reporting. Recently, we used these same tools to help a customer reduce a 5,000-step reporting process to just 5 steps. Master Power Query and Power Pivot with us to cut down your slog time!

What are dashboards?

Play with one interactive dashboard here

How are you different from other training and consulting firms?

We begin with the end in mind. Instead of just telling you the steps to navigate the functions of Power Query and Power Pivot, we guide you in framing your business questions, before we get into the steps of the game. We believe that understanding what you want out of your dashboard or report really is the crux in creating a useful one.

Other than setting the big questions right, we relentlessly focus on sharpening your critical thinking and problem-solving skills. We’re not just about the how-to steps. For that, you could easily show up at our training, collect your high-quality full-colour step-by-step course booklet, and leave. Instead, we dedicate much effort to coach you to break down concepts into key fundamental principles, so you can masterfully apply what you learn to problems of all shapes and sizes when you walk out of the classroom.

One more thing, we also incorporate the element of design and business practicality in all our dashboard creations, ensuring that you can benefit from easy implementation and use.

What is Power Query?

Power Query 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).

Find out how Power Query can help you right-click your way to data cleaning happiness.

What is Power Pivot?

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; and

  • Analyse virtually unlimited rows of data.

Best thing is, Power PIvot is free!

This is what will help keep your calm and poise when you’re in the board room being bombarded by the barrage of questions that you’re expected to handle. It is also a major time-saver even in the backroom when you explore and analyse your data to tease out crucial business insights.

Find out why Power Pivot can change your working life.

What is Power BI?

You can think of Power BI as a data 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 while keeping any hair-tearing frustrations to the minimum.

While we are still some time away from launching our Power BI training course, our flagship Power Query and Power Pivot training courses will provide you with a solid foundation which you can apply across both Excel and Power BI.

What kind of software do you use?

Just Excel!

Power Query is integrated in Excel as “Get & Transform” within the Data tab since Office 2016. These are the various Office versions that contain Power Query:

One-time purchase products: Office 2019, Office Professional 2016, Office 2016 Professional Plus, Excel 2016 standalone.

Subscription products: Office 365 (All versions that include desktop versions of Excel for Windows)

Excel 2010, Excel 2013, Office 2013 Professional Plus: Power Query add-in available as a free download.

Power Pivot is a free add-in in Excel. It sits in Excel but runs a separate Data Model. These are the various Office versions that contain Power Pivot:

One-time purchase products: Office Professional 2019, Office Home & Business 2019, Office Home & Student 2019, Office 2016 Professional Plus, Office 2013 Professional Plus, Excel 2016 standalone, Excel 2013 standalone.

Subscription products: Office 365 (All versions that include desktop versions of Excel for Windows)

Excel 2010: Power Pivot add-in available as a free download.

Check out Microsoft’s website for the latest updates.

Find out which version of Office you're using.

Watch this to install Power Query and Power Pivot in your Excel.