appsconsultant.com

appsconsultant.com

  • Home
  • About
      • About us

        Flexibility is the biggest selling point that we have over our larger rivals. We give our clients the freedom needed to thrive in today’s fast-paced business world, organisations say to us that they often see higher quality work from independent consultants like us, this reason is the primary motivator when choosing us over a big firm. This means that we have the same skills and experience as the big firms, with added freedom and flexibility to let us focus and resolve client requirements.

      • Latest news
        Will AI replace jobs

        The AI language model, has to be viewed as the internet in the 1990s and the mobile in the 2000s but I can tell you that AI has the potential to automate some of the work that is currently done by people. It's crucial to remember nevertheless that not all jobs are equally vulnerable to automation. Most jobs will have it as an assistant.

        There are some jobs that are less likely to be mechanised in the near future, such as those that demand creativity, critical thinking, emotional intelligence, and interpersonal skills.Yet, positions that require manual work, data processing, and repetitive operations are more likely to be mechanised.

        It's also crucial to remember that while AI can automate some tasks, it cannot take the place of human abilities and traits like empathy, adaptability, and decision-making that are crucial in many professions. Jobs in complex decision-making, problem-solving, and communication skills are required for these positions, which are challenging for computers to mimic and wont be able to be automated. For most the answer is NO, AI wont replace your job.

        2023 - 5 trends with financial institutions

         

        In 2023, if i had a crystal ball, I believe the following trends will become main themes within north american financial institutions:

        1. Increase mobile banking capabilities: Banks should continue to invest in technologies to improve the customer experience on mobile devices. This could include new payment systems, improved security measures and customised experiences for each customer.

        2. Develop AI-driven solutions: Banks can use artificial intelligence to automate mundane tasks and provide more personalised customer service. AI can also be used to detect fraud, improve customer experience, and even predict customer behaviour.

        3. Leverage blockchain technology: Blockchain technology can help banks reduce costs, increase efficiency, and improve security. Banks can use it to develop new services, such as digital asset management, and establish distributed networks to streamline processes.

        4. Introduce open banking: Open banking allows customers to securely share their financial data with third-party providers, such as financial advisors, lenders, and insurers. Banks should look to partner with these organisations to provide more personalised services to their customers.

        5. Utilise digital currencies: Digital currencies are becoming increasingly popular, and banks should look to leverage this technology to offer a more convenient way to send and receive payments. Banks should also look to develop their own digital currencies, and explore the potential of using them to facilitate international payments.

        This will be my last post of the year, Merry Christmas to all and wish everyone a 2023 filled with happiness, health and success.

        7 habits to transform your life

        On this friday evening, sharing some habits that have helped me improve in 2022:

        1.Get up the same time every day

        2.Set realistic goals for the day

        3. No caffeine , coffee or tea past lunch

        4.Plan by writing things with pen and paper

        5.Evening brain dump use your phone voice recorder (Time box it to 1-2 min)

        6. Challenge yourself to do something new 

        7.Time block your activites

         

         

      • What we offer

        Business & Technology Consulting

        We offer clients specialised consulting in areas that we deeply understand. Our services include:

        • - Skills To Envision, Design And Develop Enterprise Apps
        • - Talent For SaaS/PaaS/IaaS In The Cloud
        • - API Architecture
        • - Data Science Talent
        • - ALM deployments – Agile/Devops
        Read more
  • Services
  • Blog
  • Contact
  • Home | 
  • Blog | 
  • Business Intelligence should not be Hype, use it to answer these 4 golden rules, I included an explanation of the OBIEE Design Architecture with step by step approach to building Reports.

Business Intelligence should not be Hype, use it to answer these 4 golden rules, I included an explanation of the OBIEE Design Architecture with step by step approach to building Reports.

by Alex Antonatos
on 19 October 2018

BI should provide users the data and tools to answer questions that are important to running the part of the business you are responsible for

  1. Determine if the business is on track
  2. Identify where things are going wrong
  3. Take and monitor corrective actions
  4. Spot trends

Below is the OBIEE Standalone Architecture and an overview of its components

 OBIEE Architecture

  • Data Source --Contain the business data, users want to analyze. OBI supports Relational Database, OLAP databases, Flat Files, Spreadsheets, XML files etc .
  • OBI Web Server-- Provides the processing to visualize the information for client consumption.
  • Clients
    • Answers--Provides a self-service analysis platform for analytical needs.
    • Dashboards—Provides a way to organize related information for easy access.
    • Delivers---Used to create Ibots. Delivers alerts to subscribed users. It is integrated with dashboards and answers.
    • BI Analytical Server--- Provides efficient processing , generates dynamic SQL to query data base iin the data sources, structures results to satisfy requests.
    • BI Scheduler---Manages and executes jobs requesting data analytics. Schedules reports to be delivered to users at specified times.

Last week received the following support email

From: **********************************
Sent: March 25, 2013 2:29 PM
To: Alex Antonatos
Subject: OBIEE reports with Answers

Hi Alex,

I am a regular reader of your blog, great website and thank you for sharing your experiences.

We have installed OBIEE and new to BI Answers trying to understand how to create reports with Answers. Can you help us understand the steps required in deploying procurement spent report with Oracle Answers.                                                    

Sincerely,

*******************

*******************

Step by Step approach in building BI reports using Answers

Oracle BI Answers is the Oracle BI interface used to query the organization’s data. They provide answers to business questions. It allows you to explore and interact with information, and present and visualize information using different views.

Answers can be accessed by using URL default area http://OBIServer/analytics/saw.dll?Answers

Step 1: Arrow mark indicates the subject areas accessed by the current user. In my current example I am using Purchasing to respond to the support email above.

 Step 1- BI Answers

Step 2: Once click on the subject area displays the related tables and columns in left side pane

 Step 2- Bi Answers

Step 3: Select the columns from the left side pane.

Step 3- Bi Answers

Step 4: Select the columns from the left side pane.

 Step 4- Bi Answers

Step 5: Save the results in the required folders

 Step 5 - Bi Answers

Then you can view reports in various formats. By selecting the type of report from the drop down, then it will generate the report in that view.

 Sample BI Output

Like always, don’t hesitate to share your experiences/tips with me and the website readers on OBIEE

Categories
  • Blogue (Francais)
  • Enterprise applications
2305 Rockland Rd Mount Royal, QC H3P 3E9
514-240-40907 Days a week from 9:00 am to 7:00 pm
alex@appsconsultant.com
appsconsultant.com © 2023. Privacy Policy
Login
 Facebook  Google

username / password