SQLSA

Helping you get the most out of your data.

About SQLSA

SQLSA is a Business Intelligence and Analytics company based in Johannesburg, South Africa, where we specialise in the design and implementation of solutions based on the Microsoft suite of products.

SERVICES

What we offer


Training

Our trainers provide cutting edge, Real world training to empower your staff to do more.

Architecture

SQLSA can help you design and build robust solutions

Consulting

SQLSA's consultants can work with your teams to deliver real value to your business.



Our Clients


Training

Choose a course that best meets your training needs.

Introduction to Power BI

Preparing your data

Import, cleanse and transform your data using Power Query, Microsoft’s Excel-like data import tool. Power Query supports connections to a large number of data sources and a large collection of transformations to clean and shape the data just the way you need it.

Modelling your data

Create relationships, the ability to create relationships between tables is one the key differences between Excel and Power BI enabling you to interact with data in new and exciting ways. Introduction to DAX, a powerful calculation language used by Power BI unleashing a wealth of reporting options.

Visualising your data

Power BI’s rich set of built-in visuals supported by a growing set of custom visuals allowing users to create stunning interactive visuals that help drive deeper insights into their data.

Publishing your report

Not only does the Power BI service allow you to share your report with your peers but also includes an amazing set of machine learning tools such as Q&A and quick insights that allow you to interact with your data in ways that you could not have imagined

Details
View schedule

Advanced data modelling and DAX

Data modelling

A good data model is crucial to support more advanced reporting scenarios. You will learn to create a model using a star schema as well as how to implement advanced relationships using Bidirectional relationships to support Many-to-Many scenarios as well as inactive relationships.

DAX

Dax is the language used in Power BI, SSAS tabular and Power Pivot and a good understanding is essential to creating valid and performant queries. You will learn how to write queries to solve a variety of business scenarios. Some of the advanced functionality that you will learn about include aggregation and filter functions, Evaluation context and context transition using the CALCULATE and CALCULATETABLE functions as well as time intelligence.

Coming soon

CONTACT

Contact us and we'll get back to you within 24 hours.

Johannesburg, South Africa

+27 83 4152081

[email protected]