Data Analytics, Business Intelligence, Data Integration using Oracle BI, QlikView, Tableau, Informatica, R, Shiny, Python, and Big Data technologies in Life-sciences industry. noreply@blogger.com (Manohar Rana)Wed, 3 Jun 2026 08:43:41 -0400Blogger http://www.blogger.com41125http://businessintelligencedw.blogspot.com/en-usnoData Analytics, Business Intelligence, Data Integration using Oracle BI, QlikView, Tableau, Informatica, R, Shiny, Python, and Big Data technologies in Life-sciences industry. Data Analytics, Business Intelligence, Data Integration using Oracle BI, QlikView, Tableau, Informatica, R, Shiny, Python, and Big Data technologies in Life-sciences industry. noreply@blogger.comhttp://businessintelligencedw.blogspot.com/2022/11/docker-container-setup-for-aws-glue-dev.htmlawsdockergluenoreply@blogger.com (Manohar Rana)Thu, 10 Nov 2022 00:05:00 -0500tag:blogger.com,1999:blog-1064044751256228024.post-6744198752584556494I was working to configure a local development environment to run AWS Glue jobs locally first before I run them on AWS cloud. There is already a Docker image created by Amazon on Docker hub. below are my notes to configure it on a Mac.Docker hub:https://hub.docker.com/r/amazon/aws-glue-libs/tags1. Pull Docker Image locally:docker pull amazon/aws-glue-libs:glue_libs_3.0.0_image_012. One time 0http://businessintelligencedw.blogspot.com/2020/03/sponsor-key-performance-indicators.htmlClinical Intelligence AnalyticsR Programmingnoreply@blogger.com (Manohar Rana)Thu, 5 Mar 2020 12:25:00 -0500tag:blogger.com,1999:blog-1064044751256228024.post-425018263406082950 Sponsor Performance KPI - Collaboration In part 1 of the sponsor KPI's, we learned that the number of studies completed and number of studies for which the results were posted are two important indicators to gauge the performance of a sponsor. In this series we will see other metrics related to lead times and collaboration, and also try to dig deeper into why collaboration is important. 1http://businessintelligencedw.blogspot.com/2019/12/data-preparation-using-r.htmlClinical Intelligence AnalyticsR Programmingnoreply@blogger.com (Manohar Rana)Wed, 18 Dec 2019 15:09:00 -0500tag:blogger.com,1999:blog-1064044751256228024.post-2494405636905582648 Data Analytics - Data Preparation using R Data preparation is an important step in data science. Before you can start analysis, we need to ingest the required data and then clean and transform it so that it becomes more easy to perform analytics. R is an open source and powerful software having reliable packages and libraries to perform data manipulation tasks. I have downloaded the clinical1http://businessintelligencedw.blogspot.com/2019/12/sponsor-key-performance-indicators-part.htmlClinical Intelligence Analyticsclinical trialsnoreply@blogger.com (Manohar Rana)Fri, 6 Dec 2019 14:25:00 -0500tag:blogger.com,1999:blog-1064044751256228024.post-5806918479458733664 Sponsor Performance KPI - Part 1 Sponsors are the key stakeholders in clinical trials. It is important to measure the performance of sponsors to understand the trends in the industry and market. Metrics such as studies registered, studies completed, study results posted, collaboration and study completion duration can be key performance indicators from study conduct perspective. We can gain 1http://businessintelligencedw.blogspot.com/2019/12/simple-linear-regression.htmlClinical Intelligence AnalyticspythonR ProgrammingRegressionStatisticsnoreply@blogger.com (Manohar Rana)Thu, 5 Dec 2019 09:54:00 -0500tag:blogger.com,1999:blog-1064044751256228024.post-2419499301225831165 R and Python There are times when we not only look at the descriptive analysis but also want to make future predictions based on the past trends. We will look at techniques that we can use to predict the number of studies submitted or registered in future years. We will see how we can use some of the libraries like pandas, statsmodels and  matplotlib in python. the python code is 1http://businessintelligencedw.blogspot.com/2019/11/clinical-study-activity-per-capita.htmlClinical Intelligence Analyticsclinical trialsQlikviewnoreply@blogger.com (Manohar Rana)Fri, 15 Nov 2019 17:42:00 -0500tag:blogger.com,1999:blog-1064044751256228024.post-3409216208203769865 Study Activity Dashboard In this post, we will try to understand the clinical study activities across the globe. We will gather some inputs like population, GDP and health spending as % of GDP. Then we compare different countries by their involvement in clinical studies. The clinical study activity is based on the clinical site in that country for a particular study. It is important to 0http://businessintelligencedw.blogspot.com/2019/09/clinical-initelligence-analytics.htmlBusiness IntelligenceClinical Intelligence Analyticsclinical trialsQlikviewnoreply@blogger.com (Manohar Rana)Wed, 11 Sep 2019 16:26:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-5187516181630848317 Sponsor Trends Dashboard In the last post here, we gained some insights into top performing sponsors and overall trend. In this post, we will look further deep into how the sponsor participation has changed in last few years. The Sponsor Trends Dashboard (figure 6.1) can answer some interesting questions and see what's going on in the clinical trials industry. Figure 6.1 Here, we will try 0http://businessintelligencedw.blogspot.com/2019/09/clinical-intelligence-analytics-primary.htmlBusiness IntelligenceClinical Intelligence Analyticsclinical trialsQlikviewnoreply@blogger.com (Manohar Rana)Sat, 7 Sep 2019 22:41:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-7444003751537023531 Primary Sponsor Dashboard Primary Sponsor dashboard (Figure 5.1) provides us insights into the study activities by primary or lead study sponsors. Primary sponsor is an important stakeholder in the clinical trials that has the primary responsibility of initiating, study design and study conduct. In simple terms, we can say that the primary sponsor is the owner of the clinical study. The sponsor 0http://businessintelligencedw.blogspot.com/2019/08/clinical-intelligence-analytics-study_28.htmlClinical Intelligence Analyticsclinical trialsQlikviewnoreply@blogger.com (Manohar Rana)Wed, 28 Aug 2019 10:18:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-739805266500783101 Study Trends Study Trends dashboard (Figure 4.1) gives us insights into the tends in recruiting country, average registration to enrollment duration and average study duration over the past 2 decades. Figure 4.1 The data legends are shared between the charts on the first row. Similarly, the legend is same for the 2 charts on the bottom row. The data is aggregated on a study level and0http://businessintelligencedw.blogspot.com/2019/08/clinical-intelligence-analytics-study.htmlBusiness IntelligenceClinical Intelligence Analyticsclinical trialsQlikviewnoreply@blogger.com (Manohar Rana)Fri, 23 Aug 2019 22:59:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-2512739139542916074 Study Dashboard In study dashboard (Figure 3.1), we will look at certain aspects of study at aggregated level as well as at a study level.  Figure 3.1 The study dashboard will try to answer following questions: 1. What is the average study completion duration for sponsors from Industry and non-Industry? For all types of studies (All), the sponsors from Industry 0http://businessintelligencedw.blogspot.com/2019/08/clinical-intelligence-analytics-trends.htmlBusiness IntelligenceClinical Intelligence Analyticsclinical trialsQlikviewnoreply@blogger.com (Manohar Rana)Sun, 11 Aug 2019 23:41:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-6460355744311964571In the last post, we looked at the growth trends of studies registered, initiated, completed and posted results over the period of last 20 years. We looked at yearly trends and then drilled down at quarterly and monthly trends and compared the growth in current year with the previous year. In this post, we will see the growth trends of registered studies by study attributes like study type, study0http://businessintelligencedw.blogspot.com/2019/08/clinical-intelligence-analytics-growth.htmlClinical Intelligence Analyticsclinical trialsQlikviewnoreply@blogger.com (Manohar Rana)Sat, 10 Aug 2019 12:25:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-6036593874719733008 Trial Growth Trends Dashboard Growth Trends Dashboard provides insights into the growth trends of clinical trials over a period of time. This helps us gauge how the industry is growing.  Below (Figure 2.1) is a snapshot of the dashboard without any data filters. Figure 2.2 is another representation to view the Year over Year growth. Year 2019 is the current year and hence the decline0http://businessintelligencedw.blogspot.com/2019/08/clinical-intelligence-analytics-summary.htmlClinical Intelligence Analyticsclinical trialsQlikviewnoreply@blogger.com (Manohar Rana)Fri, 9 Aug 2019 15:26:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-1008744493371052901 Clinical Summary Dashboard Summary Dashboard gives an overall picture of clinical trials in a summarized form at a high level.  Below (Figure 1.1) is a picture of the dashboard without any data filters. If I make any selection or filter, I will call it out and mention it. Figure 1.1 The Dashboard tries to answer some basic questions to start with, and then we start looking0http://businessintelligencedw.blogspot.com/2019/08/clinical-intelligence-analytics-insights.htmlBusiness IntelligenceClinical Intelligence Analyticsclinical trialsnoreply@blogger.com (Manohar Rana)Fri, 9 Aug 2019 13:14:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-429935974457799101Clinical Trial studies a new drug or device before it is brought to the market. The new therapy is tested on human subjects to evaluate its safety and efficacy. Sponsors or investigators of certain clinical trials are required by U.S. law to register their trials on and submit summary results to ClinicalTrials.gov website.  While working for a CRO as a Business Intelligence and Data 2http://businessintelligencedw.blogspot.com/2018/04/blockchain-for-healthcare-and-clinical.htmlBlockchainclinical trialshealthcarehyperledgernoreply@blogger.com (Manohar Rana)Fri, 6 Apr 2018 16:40:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-2769949311770758905Blockchain for Healthcare and Clinical Trials by Manohar Rana The article is based on our 3rd place winner's proof of concept presented at Generation Blockchain Challenge.           In general, healthcare and clinical trials are complex business environments mainly due to its direct impact on the human lives and various regulations built around them. There are 6http://businessintelligencedw.blogspot.com/2016/12/tableau-implementation-challenges-and.htmlBIBusiness IntelligenceTableauTableau Best PracticesTableau Implementationnoreply@blogger.com (Manohar Rana)Thu, 1 Dec 2016 15:15:00 -0500tag:blogger.com,1999:blog-1064044751256228024.post-4689719815447443229Hi All, I thought of sharing my leanings and experiences with Tableau so far. This post will describe some of the challenges you could face while implementing Tableau BI in your enterprise from architectural standpoint. If you are evaluating BI tools or planning to start implementation, you will definitely benefit from this post. I would be highlighting some of the best practices that you can 0http://businessintelligencedw.blogspot.com/2011/05/qlikview-is-now-leader.htmlMagic QuadrantQlikviewQlikview Vs Othersnoreply@blogger.com (Manohar Rana)Sat, 28 May 2011 02:56:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-4767720798889982568Hi, As I was expecting, Qlikview joined the leaders quadrant in Gartner's magic quadrant for BI 2011. Qlikview is cited as a self contained BI Platform and the strengths being interactive, great visualization and end user friendliness and satisfaction. I am very happy about it. But I am more focused on seeing the challenges ahead. It will be interesting to see how Qlikview maintain that position6http://businessintelligencedw.blogspot.com/2011/04/enhance-business-intelligence.htmlinterview questionsOracleBI OBIEEPerformanceQlikviewnoreply@blogger.com (Manohar Rana)Sat, 16 Apr 2011 00:42:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-2355268595632572609Hi All, In any Business Intelligence Implementation, the key factor is the performance. Performance factor always plays a key role in User accepting or liking the application. We should do everything possible to enhance the performance and here are some tips some of which are very generic and can be used in any BI Implementation. From a solution perspective: 1. Use of Datawarehouse: 0http://businessintelligencedw.blogspot.com/2010/03/bi-project-implementation-life-cycle.htmlProject Implementation Life CycleProject ManagementQlikview Vs Othersnoreply@blogger.com (Manohar Rana)Sat, 13 Mar 2010 11:50:00 -0500tag:blogger.com,1999:blog-1064044751256228024.post-9032716500240404798Hi, Recently I went through the website of Qliktech and read where it says "And unlike traditional BI, QlikView delivers immediate value with payback measured in days or weeks rather than months, years, or not at all.". It made me think for a while. what are they referring to ? Do they mean Qlikview as a BI solution can be implemented in weeks? Are they talking only about small department level 23http://businessintelligencedw.blogspot.com/2009/07/hyperion-essbase-book.htmlEssbase 9.3.1Learn Essbasenoreply@blogger.com (Manohar Rana)Thu, 30 Jul 2009 10:42:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-1075136468236955591Hi,One good news for people who wants to learn Hyperion Essbase on their own.There are not many books available on Essbase and I know only one book which is available 'Look smarter than you are with Hyperion Essbase' by Edward Roske.Sarma and Joseph have written a 444 page book on Hyperion Essbase 9 with the title'Oracle Essbase 9 Implementation Guide'.The book covers Installation, Essbase cube 14http://businessintelligencedw.blogspot.com/2009/07/qlikview-personal-edition.htmlLearn QlikviewQlikviewQlikview Vs Othersnoreply@blogger.com (Manohar Rana)Fri, 24 Jul 2009 15:32:00 -0400tag:blogger.com,1999:blog-1064044751256228024.post-1837495592178790792Hi,Qlikview is the emerging name in the Business Intelligence world and becoming very popular among the user community due to its easy to use interface, fast deployment and very strong visualisation.Qliktech released its version 9 recently with a new Edition called Qlikview 9Personal Edition having all the developer features.Earlier Qlikview use to provide only 15 days of evaluation period for 2noHi,Qlikview is the emerging name in the Business Intelligence world and becoming very popular among the user community due to its easy to use interface, fast deployment and very strong visualisation.Qliktech released its version 9 recently with a new Edition called Qlikview 9Personal Edition having all the developer features.Earlier Qlikview use to provide only 15 days of evaluation period fornoreply@blogger.com (Manohar Rana)Hi,Qlikview is the emerging name in the Business Intelligence world and becoming very popular among the user community due to its easy to use interface, fast deployment and very strong visualisation.Qliktech released its version 9 recently with a new Edition called Qlikview 9Personal Edition having all the developer features.Earlier Qlikview use to provide only 15 days of evaluation period forLearn Qlikview, Qlikview, Qlikview Vs Othershttp://businessintelligencedw.blogspot.com/2009/01/pentaho-open-source-bi.htmlOpen Source BIPentahonoreply@blogger.com (Manohar Rana)Sat, 24 Jan 2009 13:58:00 -0500tag:blogger.com,1999:blog-1064044751256228024.post-3695151127630809206Hi,From past few days I was really very anxious to try my hands on Pentaho.I heard a lot about the open source Business Intelligence Tools and two names that comes to my mind are Pentaho and Jaspersoft.So I simply logged on to the Pentaho Website and looked for some demos. Then I looked at the hosted environment. The website is bit confusing and a new visitor like me found it really difficult to 7http://businessintelligencedw.blogspot.com/2009/01/gartner-bi-magic-quadrant-2009.htmlBusiness IntelligenceQlikview Vs Othersnoreply@blogger.com (Manohar Rana)Thu, 22 Jan 2009 00:45:00 -0500tag:blogger.com,1999:blog-1064044751256228024.post-330382668460897688Yesterday just got a chance to look at Gartner's Magic Quadrant for Business Intelligence 2009.I am really happy to see Qlikview almost touching the Leaders Quadrant Boundary and may be by next year Qlikview will join the leaders club.So that's a good news for people who have invested in this technology.This would be really interesting to watch how Qlikview will compete with the leaders. The 3http://businessintelligencedw.blogspot.com/2008/12/essbase-interview-questions.htmlinterview questionsnoreply@blogger.com (Manohar Rana)Mon, 15 Dec 2008 00:20:00 -0500tag:blogger.com,1999:blog-1064044751256228024.post-4751712152606587233Hi,You may like to read my earlier post Hyperion Essbase Interview Questions.Today I will be posting few more questions on Hyperion Essbase more from an Administrative perspective.The questions and answers have been designed by me and are not copied from anywhere.Que:1 What are LRO's( Linked Reporting Objects)?Answer: They are specific objects like files, cell notes or URL's associated with 12