CODING & ANALYTICS by Gbenga Oridupa

In 2019, Microsoft announced the preview of the connector for Azure Cost Management + Billing, which allows customers to analyze their Azure and AWS spend from a single pane of glass in the Azure Portal.  Guess what?.... the feature is now generally available. This new connector simplifies handling different cost models and numerous billing cycles so you can visualize and always stay up-to-date with your spend across clouds.   Let's get started. Setting up the connector in a few quick steps: Setup and configure an AWS cost and usage report in the AWS portal. Create a role and policy in AWS, which provides Azure Cost Management with access as well as permissions proving organization API access and cost explorer API access. Lastly, set up the AWS connector in Azure Cost Management + Billing. You can view your AWS costs within Cost Analysis in the following scopes: AWS Linked accounts under a management Group. AWS Linked account costs. AWS Consolidated account costs. You ca...

Since the inception of Relational Databases in the 70’s, schema on write has be the defacto procedure for storing data to be analyzed. However recently there has been a shift to use a schema on read approach, which has led to the exploding popularity of Big Data platforms and NoSQL databases. Any data management system belongs to one of two types: Schema-on-write: Probably a lot of you have already worked with relational databases and you understand that once we have configured the schemas, created the tables, we can begin to ingest the data. Remember just because the data is structured doesn’t mean it starts out that way. It is likely to be something like bulk upload data from a text or csv file whose structure we know in advance because it somehow matches the schema of the tables, and once the data is loaded into the table, we can begin to execute analytical queries on our tables. This ...

Got your data in Google Sheets? You can connect directly to your data in Tableau using it's web data connector. This feature has been around for a while now. If you are new to it, this could be a plus for you. Select the option under “More Servers…” on the Connect menu. After entering your Google Sheets credentials, you will see the list of available sheets. You can Select from the list or use the search bar to be specific, and click “connect.” What's cool about it is that If you aren’t sure if this is exactly the sheet you are looking for, you can easily open it in a web browser by selecting the “open in Google Drive”. Once the sheet has been loaded into Tableau, you can drag out the individual sheets from your Google Sheet and join or union them together. Additionally, you can also union and join Google Sheets with other data sources.Sounds cool right?. In Tableau, you can see all th...

This is just an overview of DAX language . We will begin calculations and extensive analysis on my next post.Enjoy. What is DAX?: Data Analysis Expression(DAX) is a Functional Language currently used in Power BI Desktop ,Analysis Services Tabular and Power Pivot for Excel. It is a collection of functions that can be used to calculate and return one or more values. In DAX, functions can contain other, nested functions and value references depending on your model and key business questions to be answered. DAX includes some of the functions used in Excel formulas plus other functions designed specifically to work with relational data and perform dynamic aggregations. Why DAX?: The difficult questions raised facing a business or an organization can be simplified using DAX, to shed more light into your data. Learning how to create effective DA...