Helping you get the most out of your data.
Our trainers provide cutting edge, Real world training to empower your staff to do more.
SQLSA can help you design and build robust solutions
SQLSA's consultants can work with your teams to deliver real value to your business.
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.
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.
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.
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
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 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.
Contact us and we'll get back to you within 24 hours.
Johannesburg, South Africa
+27 83 4152081