Blogs and How-To Topics

Rishi Sapra

0

Learn How to build an enterprise scale architecture with Synapse (Delta lakehouse) and Power BI working with 2.4 Billion rows of NYC Taxi Data! This is part 1 of the Blog Post Series.

Rishi Sapra

0

Power BI How-To: Combine data from Multiple Files One of the key benefits of using Power BI is that you can mash different data sources together. For example, you can bring in sales transactions and combine it with data on customers from your CRM system in order to analyse which customer segments are buying the… Continue reading Combine or Select from multiple files

Rishi Sapra

0

Power BI How to: Use the query editor The query editor is the area to connect to data and shape/transform it before it is loaded into the data model. A query within the editor is a table of data, from source or created with code/ with reference to another query, with zero or more transformation… Continue reading Work with queries in the query editor

Rishi Sapra

0

Power BI How to build a star schema. This topic looks at how to understand what structure of data tables you need, and how to model them using a star schema When data is imported into Power BI, the resulting data model sits at its heart. It drives the kind of analysis that can be… Continue reading Design a Data Model

Rishi Sapra

0

Power BI How-to Manage Table Relationships Once we have created our fact and dimension tables in the query editor, we then define the table relationships in the relationships pane of Power BI, either by dragging a field in one table over the top of another one or by selecting ‘Manage Relationships’ in the modelling tab:… Continue reading Manage Table Relationships

Rishi Sapra

0

Power BI How-to: DAX | Use CALCULATE and FILTER to write Filter-based Measures The easiest way to understand the role of DAX Measures in Power BI is to think of them as advanced pivot table formulas that work in a slightly different way compared to standard formulas in the Excel grid. Power BI How-to: DAX… Continue reading Write Filter-based Measures

Rishi Sapra

0

Power BI Example Reports | Visual Best practice design This report was the winner of the Complex Data Preparation Challenge for the 2017 Data Insight Summit in Seattle. The challenge involved taking a number of disparate data sets from the Hawaii Tourism Authority (on visitor numbers to Hawaii) and turning them into a visualization which… Continue reading Example Reports

Rishi Sapra

0

Cell formatting is all about how your data in cells is displayed – in terms of the number format (e.g. currency, percentage), the font/background fill colour of cells and how the text in cells is aligned. This is crucial for ensuring that your workbooks are usable and intuitive in terms of how it should be used and is particularly important for complex workbooks which will be used by different people. Not every cell will contain the same type of data or is intended to be used in the same way, so every cell shouldn’t be formatted in the same way! Moreover, number formats are important for ensuring formulas work correctly – for example text values are ignored in a SUM function, so if some of the numbers in a range are formatted as text these won’t be included in a SUM function that is based on that range.

Rishi Sapra

0

stat

Rishi Sapra

0

We have already seen that detecting missing values and filling them are important steps in the data cleaning process. Just as important is correcting certain data points by replacing them with correct values. With Pandas a user can use different techniques to replaces certain values. We will highlight a few of them in this section.… Continue reading Pandas – Replacing Values