To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap between the two exams resulting from the common BI features found in both Power BI and Excel: namely data modelling using…
G Com Solutions Limited is proud to announce the launching of our new central London training centre. The location is at Tower Bridge Business Centre, 46-48 East Smithfield, close to Tower Hill and Fenchurch Street stations, which is quite easy to find. From this location, we will be running comprehensive courses on Microsoft Power BI…
Once you have configured your Power BI tenant, the next major aspect of Power BI which you need to address is the configuration of app workspaces. But what exactly are app workspaces and how do they differ from MyWorkspace, apps and template apps. Let’s start with workspaces. (If you are looking to learn Power BI,…
Power BI enables business users to interact with corporate information and to extract the reports and intel they need. Power BI allows users to access reports and dashboards using familiar tools and devices. Self-service BI has never been so user-friendly! If you are looking to learn Power BI, then our series of Power BI…
One of the most common data cleansing operations performed in Power Query is the removal of unwanted rows. And this is a topic which we cover in almost all of our Power BI training courses. In this blog post, we will look at the key M function used to suppress unwanted rows. Table.Skip The first…
Power BI’s new dataflows allow the centralization of data cleansing and transformation operations, greatly reducing inconsistencies and duplication of effort across organizations. Instead of connecting to data sources from within a Power BI Desktop PBIX file, organizations will now be able to carry out all of their Power Query data connection and transformation centrally in…
(In this blog post/tutorial, we will use a database called “Event Sales”, which you can download here. If you wish to follow along, you will need to download and UnZip the .BAK file, then use it to restore the EventSales database on an instance of SQL Server.) When connecting to a relational database from Power…
To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). I took the 70-778 last year; and was surprised, when the 70-779 exam was announced, at how much of an overlap there was between the two exams….
Microsoft Excel is an essential tool for most modern businesses, providing a dazzling array of features for manipulating and analysing organisational data. The concept of power training for Excel users is not new; and the traditional route to becoming an Excel power user has been to develop a fairly large repertoire of advanced techniques; such…
If you are considering Power BI training, one of your first decisions is choosing between sending your staff on a scheduled training course and arranging in-house Power BI training. There are pros and cons to both approaches. Booking a place on a public Power BI training course One of the main benefits of booking a…