Saturday, September 30, 2023

CRED Garage - One stop solution to manage everything about your Vehicle

CRED our famous app that was initially introduced as a credit card payment gateway app, has been flourishing in many other features over the years. 

And it is worth mentioning that every new feature that the CRED team has introduced has been a gem in the making as their app features and navigation are second to none.

Now with the latest CRED Garage introduced for personalized and private experience to manage all your vehicle needs and maintenance. This has been carefully considered by the company with the interest of security and privacy as the utmost importance.

You can manage your insurance renewals, fast tag recharges, pollution check documents, traffic violation challans and vehicle details all at one place. The good thing is we can manage multiple 2 wheelers and 4 wheelers in one profile.

The look and feel of the virtual vehicle is so cool with the 360 degree view, and this shows how serious the IT team is working for the CRED board. (That's an amazing feat to pull).

You can manage all your spends and  in a way can forecasts about your fuel charges for the upcoming months.

Another good thing to worth considering is the integration of the CRED app to the world class DigiLocker from our Indian govt. That's a nice glovebox for your garage where you can maintain all your personal documents in one go.

Good going CRED , keep up the good work and the customers will sure appreciate your efforts for the seamless experience you are providing.

CRED App :- Link
DigiLocker :- Post


Saturday, September 9, 2023

Migration of Traditional Reports to Power BI - Quick Guide

Moving reports from traditional analytical tools to Power BI represents a significant stride in harnessing advanced visualization and data analysis capabilities. Below is an initial guide to assist you in the process.

Evaluation and Strategy:
  1. Ascertain which reports to transfer, prioritizing them based on their business significance and complexity.
  2. Gain insight into the data sources utilized in current reports. Determine if they are compatible with Power BI or proceed with prerequisites and pre-processing to achieve the state.
  3. Clearly outline the migration's scope and objectives. Consider whether you're merely relocating reports or if there are opportunities to enhance them using Power BI's functionalities.
Data Readiness:
  1. Ensure that your data sources possess appropriate structure and have been thoroughly cleansed. Power BI performs optimally with well-organized, clean data.
  2. If your data resides in a database, confirm that you possess the requisite credentials and permissions to access it via Power BI.
Power BI Desktop:
  1. Download and install Power BI Desktop if you haven't already. This is the tool you'll employ to design and craft your reports.
  2. Launch Power BI Desktop and acquaint yourself with its interface and capabilities.
Establishing Data Connections:
  1. Within Power BI Desktop, navigate to the "Home" tab and select "Get Data." Choose the relevant data source (e.g., Excel, SQL Server).
  2. Connect to your data source by supplying the necessary connection particulars.
  3. Opt for data import or establish a direct connection, depending on your data source and specific requirements.
Data Transformation:
  1. Utilize Power Query Editor (accessible from the "Home" tab) to modify and structure your data as required.
  2. Undertake data cleansing, establish calculated columns, and implement any necessary transformations.
Report Development:
  1. Construct your reports by dragging and dropping visuals onto the canvas.
  2. Customize the visuals using the formatting choices found in the "Format" and "Visualizations" panels.
  3. Establish relationships between tables if your data necessitates such connections.
DAX Formulas:
  1. Familiarize yourself with Data Analysis Expressions (DAX), Power BI's formula language used for crafting custom calculations.
  2. Compose DAX calculations to derive insights that may not be readily accessible within your data source.
Report Design:
  1. Concentrate on creating reports that are visually captivating and easily comprehensible.
  2. Exploit Power BI's array of visualization options to effectively convey insights.
Interactive Elements:
  1. Leverage Power BI's interactive capabilities, including drill-through functionality, slicers, and bookmarks, to augment user engagement.
  1. After finalizing your report, save it as a Power BI Desktop (.pbix) file.
  2. Log in to your Power BI account (or sign up for a free account if you don't have one).
  3. Select the "Publish" button to upload your report to the Power BI service.
Sharing and Collaboration:
  1. Configure suitable permissions to govern report access. Use AD groups to provide access to the workspaces and any published App for the business.
  2. Disseminate the report to colleagues and stakeholders via direct links, embedded reports, or dashboards. 
Maintenance and Oversight:
  1. Make sure the scheduled refreshes are working fine and the data quality checks are in place.
  2. Monitor report usage and gather feedback to facilitate continuous enhancement.

Bear in mind that transitioning reports to Power BI might entail a learning curve, especially for newcomers to the platform. Exercise patience and make the most of the abundant online resources, encompassing tutorials, forums, and documentation, to aid in your journey.

For starting the Power BI journey as a Novice , refer to my previous post on training/learning library