Wednesday, September 6, 2023

Quick Start with Power BI - No prerequisites

    I have been in the IT space for almost 15 years now and out of all available analytical tools like         
Oracle Analytics, Tableau, Google Analytics, Cognos and Power BI , I would easily pick Power BI to fulfill all my needs. And the reason is Microsoft.

     Power BI is widely used in businesses and organizations to gain insights from their data and make data-driven decisions. 

I would like to suggest the below path and libraries for learning the Power BI in a fast paced learning path.
  1. Download the Power BI Desktop from the Microsoft store, it is free for all windows users.(No luck for mac users yet). Make sure you only download the Desktop application.
  2. This is the best in detail learning course you can get in the Udemy for references and I had great time in learning through this course.
  3. Learning Power BI will unlock lot of opportunities in the Business Analytics vertical and having good knowledge inn SQL and MS-Excel is obviously a plus.
  4. Learning power query in transforming the source data is a key factor in flourishing in Power BI as that is where most of your brain work goes into. (Data Modelling).
  5. I would segregate Power BI into 2 categories as Easy part and Hard part.
    • Easy part
      • Get Data from data sources as Microsoft has good integration with almost all available technologies including Snowflake.
      • Check the data quality and transform the data to fulfill basic needs in generating the insights.
      • Power BI Service where you can see the published workspace and managing the data of your organisation with corporate license from Microsoft.
      • Power Query which can be generated with usual navigational features available in the Power BI desktop tool.
      • Security management of your reports and data with in Power BI cloud.
      • Refreshing your data online using gateway connections and scheduled refreshes.
    • Hard part
      • Writing DAX queries to fulfill advanced requirements using custom measures and attributes.
      • Power BI report builder which is used to generate pixel perfect reports also known as Paginated Reports.
      • Transforming the data by massaging the source data to the actual requirement of the report and insights which are to be fulfilled.
  6. As Microsoft is already a most trusted vendor across all formats of IT market, the integration with different systems are made easy and new preview features are released very frequently for the developers to explore and leverage most of out of Power BI platform.
  7. There are so many free resources online for Power BI and you can see mainstream developers in youtube with many tutorials.
  8. These day with so many visual changes and preview features Microsoft has stepped up into the nextGen reporting as Microsoft Fabrics.

Note:- Remember that Power BI can be a powerful tool, but it may take some time to become proficient. Start with simple projects and gradually work your way up to more complex ones as you gain confidence and experience.

References :-

Published by K@run@

Saturday, August 26, 2023

DigiLocker - An App from Indian Govt.

DigiLocker was an initiative which would be used as a one stop solution for all your authentic ID proofs with verified bar codes.

But now it has achieved its feat more than expected where millions of users are getting benefitted with the features of DigiLocker.

Personally I have been using the below which have been playing a major role in my life everytime some govt offical asks me for an ID.

But that's not the only benefit we get out of it. I have seen slowly the IT has introduced number of options by collaborating with individual state govt's across the nation.

I am using the below as an example which is very helpful for my daily routines.

1. Aadhar Card virtual
2. Driving licence
3. EPFO card for Provident Fund
4. Vehicle Registration
5. Vehicle Insurance
6. Term Insurance from HDFC life
7. SBI - ulip policy
8. ABHA card
9. COVID vaccination certificate.

If you are the genZ , then you can even retrieve your marks list from multiple universities these days.

So I would really suggest everyone to use Digilocker for their own benefits.

Friday, July 14, 2023

Chandrayaan 3 Mission from Sriharikota is a Success

With all the phases behavior in Normal state , ISRO once again launched a successful mission into the Space that's The Chandrayaan 3.

The graph has retraced the path of the projection as expected and hopefully all the phases for the moon lander will be successful in near future.