Category Archives for Power BI
Power BI MCSA Certification Training Tips – Part 6: Merge Queries (Table.NestedJoin)
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
Continue readingPower BI MCSA Certification Tips – Part 5: Fill Down
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
Continue readingPower BI MCSA Certification Tips – Part 4: Unpivot Columns and Unpivot Other Columns
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
Continue readingPower BI MCSA Certification Tips – Part 3 : Table.SelectColumns and Table.RemoveColumns
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
Continue readingPower BI MCSA Certification Tips – Part 2 : Connecting to Folders
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
Continue readingPower BI MCSA Certification Tips – Part 1 : M Language Overview
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
Continue readingG Com Solutions Running Scheduled Courses in Central London
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
Continue readingFree Power BI Books
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
Continue readingRemoving Unnecessary Rows in Power Query
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
Continue readingUsing Power BI Dataflows to Centralize Data Preparation
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
Continue reading