The Techie Crunch

Posts

Getting Start With Data Analysis Using SSAS Tabular Modeling In Excel - Part Two

- December 21, 2020

In this article, we are going to see how business users can utilize the tabular model for data analysis and visualization in Excel. This article depends on Part I. So, it would be great if you first go through this: Getting started with data analysis using SSAS Tabular Modeling in Excel - Part I We will see how we can create SSAS tabular model and setup measure, roles, calculated columns, hierarchies in tabular modeling. Now, we created a Tabular Model and deployed it on the analysis server. Let’s open Excel. Go to Data Tab, click on Get Data Option from a ribbon. Go to From Database, Analysis services. It will open Data connection wizard, enter server & credential details. Click on next. Select Tabular Model Database. Click on next. Now, Save Data Connection and Click on finish. Go to Insert Tab, Click on Pivot Table option from the ribbon. Select External Data Source. Click on choose connection. We can see our saved data connection

Send Email With SharePoint Lookup Columns Data Using Power Automate

- August 10, 2020

Introduction In this article, we are going to send an email with SharePoint Lookup Column data using Power Automate. We will create a flow that’s run weekly that fetches data from a SharePoint list which contains lookup columns. We will use the “Apply each” action to get lookup records. SharePoint Parent List - "ProductSales" Columns Type Title Text ExpiryDate DateTime SalePersonName LookUp (SalePerson List) SharePoinChild List - "SalePerson" Columns Type Title Text In the above lists we have SalePersonName column which is actually the Title column from SalePerson List. When we “Parse Json” data in the above type of data we get two title fields in the dynamic column section. And sometimes workflow fails due to a null record in lookup column. Let’s see the data in the list as below, Log in to Office.com with Office 365 credentials. Go to the “Power Automate” tile and click on it. It will be redirected to the Power Automate Page. Click on the Create

Send an Email Reminder Notification Based on an Expiration Date using Power Automate

- February 19, 2020

Introduction In this article, we are going to create an email reminder notification based on an expiration date using Power Automate. We will create a flow that’s run daily that reads & filters data from a SharePoint list that has list items that expire in the next 5 days. Then it will send an expiration notification email to a particular user. SharePoint List - "ProductSales" Columns Type Title Text ExpiryDate DateTime Let’s log in to Office.com with office 365 credentials. Go to the “Power Automate” tile and click on it. It will be redirected to Power Automate Page. Click on Create button from left navigation. Click on the scheduled flow tile. It will open the popup. Create Recurrence Flow Enter the flow name and select a specific time when we want to schedule this workflow. Then, click on the create button. It will open the Edit Flow page where we can see a Recurring Action. Now we are f

How To Overcome Mediocre Thoughts Of Software Developer's Daily Life

- January 20, 2020

Many software developers dreamt of working and writing software for top companies like Microsoft, Google, Apple, or Facebook. Most of the software developers want to become experts in their respective fields and they are doing their best to achieve it but magic cannot happen overnight. It will require time. And, once it is done, no further discussion is required. So, in a journey between nowhere to everywhere, each software developer has a struggle and a cyclone of mediocre thoughts in daily life. Even if they are on the right path, as a common human behavior, they got confused with self-doubts and questions. Let's see the real-world mindset of a software developer. Do I have the right job? Am I not learning enough and stuck on the same project/job for so long? I'm frustrated with working on the same old technologies and not learning new technology. I've no idea what is new out there? I do not have enough time to learn new technologies and develop new ideas

Contact application - Upgrade Asp.net Core 2.0 to 2.1

- October 01, 2019

In this article, we will look into steps for contact application - upgrade Asp.net Core 2.0 to 2.1, please see my previous articles about how we developed contact application: ContactApplication using ASP.NET Core Web API, Angular 6.0, and Visual Studio CodePart One: In the article, we will set up ASP.NET Core Web API project, and develop the Web API for contact CRUD operations. ContactApplication using ASP.NET Core Web API, Angular 6.0, and Visual Studio CodePart Two: In the article, we will setup Angular 6 within ASP.NET Core Web API Project, and develop the contact form & list component using Angular Material UI that will consume Web API which we have created in Part One. ContactApplication Azure Deployment: In this article, we are going to deploy/host a contact application with Visual Studio code to Azure web apps. Please note: Previously we have used Asp.net Core 2.0.3 for contact application, now upgrade to Asp.net Core 2.1.5. This is download link for Dot

Search This Blog