Posts

Showing posts from 2021

Free Data Visualization Tools

Here's an incomplete list of free data visualization tools in no particular order. More tools to be added as and when known. Some of the tools are more than a data visualization tool.  Microsoft Excel Google Sheets MicroStrategy Workstation PowerBI Desktop Tableau Public Google Data Studio

Business Intelligence Demystified is bestseller # 1

Image
Thanks to everyone who has trusted and ordered the book. Happy (and a bit scared actually) to notice that the book Business Intelligence Demystified is currently in the bestseller No 1 in its category. I hope everyone who has bought it get its full worth. After you have read please share your honest feedback as it will help me to improve, all feedback welcome.

Business Intelligence Demystified published and is now available

Image
Finally after almost two years of starting the work of writing the book, Business Intelligence Demystified , it's published and available in Amazon and BPB websites. I very much underestimated the work that it involved. I have invested over 800 hours in writing this book, and don't forget the hours and effort spent by all of the reviewers and the publishing team. While I have based this book mostly on own experience of last 15 years in BI projects, where required, I have done quite a bit of research too. Therefore I am sure quite a lot of people will find it useful for starting/restarting their BI journeys irrespective of the current role/profession and also for clarifying all of their doubts about BI.  For whom is this? Simply put, if you want to know BI, you could read this book. If you think you know BI, you should read this book. If you don’t know whether you know BI or not, you must read this book. Irrespective of where you are at your career, or which stage your business

Trigger Python script from Windows Task Scheduler

Image
When we schedule Python jobs through Windows Task Scheduler, there is one tab in which we have to specify the script name which we want to trigger with the location of the script, location of the Python program and arguments. If we don't supply the right values in the right fields, the script will not be triggered. This simple post is limited to provide information about what to provide in each of those fields in that tab (Start a Program).   Once you have opened Windows Task Scheduler and progress through the options in Create Basic Task, the fields that you can see in the "Start a Program" are Program/Script , Add arguments and Start in as shown in the image below.  Program/Script : python Add arguments : provide the path and the python script such as C:\NSE\code\abc.py Start in : Provide the location of the Python folder such as  C:\Users\Win10\AppData\Local\Programs\Python\Python38 as shown in the image below. That's it. Now the python script will be triggered a

Which BI tool should I learn?

Image
Many BI aspirants have these questions "Which BI tool/s should I learn?" , "Learning which BI tools will improve my chances of getting a job sooner?", etc. When such questions are asked in online Q&A forums, most of the answers are biased for one or the other reasons. Therefore, I would like to provide  a way using which you can figure out the answer on your own based on facts.   A random set of of BI tools - not comprehensive Search for current BI job openings either in sites such as LinkedIn, XING, job portals or directly on the website of various companies.  Go through the job specification in detail and exclude those job specs that do not have specific tool requirements. Also exclude those job ads by agencies. Focus on those BI job specs that are directly from the companies that wants to hire for their own needs rather than for their clients.  If you have constraints such as location, industry (domain), or role constraint, then search BI job openings applyin

Book on Business Intelligence

Image
For all those who are looking forward to my book on BI, here's an update. After 14+ months, 700+ hours, lots of sacrifices, a lot of support from my wife, and multiple revisions based on reviews by the publishing house, the book on BI (10 chapters, 270 pages) is now complete and ready for technical review. 

Popular posts from this blog

ETL developer vs Data engineer

BI Architect course and BI Tool question

Corona Virus Analytics