• Home
  • About Us
    • About Us
    • Careers
    • Partners
    • Case Studies
      • Google Play Marcomms
      • Data Overload
      • Facet Wealth Case Study
      • Modern Data Platform Case Study
    • Use Cases
      • OAC/Snowflake
    • Contact
  • Services
    • The Architect Room
    • Elastic Delivery
    • Jump Programs
      • Analytics Engine
      • The Avalanche Initiative
      • The Glimpse Initiative
    • Implementations
    • Accelerators
      • ETL Converter
    • Support
  • Community
    • Blog
    • Events
    • Red Pill Library
    • Home
    • About Us
      • About Us
      • Careers
      • Partners
      • Case Studies
        • Google Play Marcomms
        • Data Overload
        • Facet Wealth Case Study
        • Modern Data Platform Case Study
      • Use Cases
        • OAC/Snowflake
      • Contact
    • Services
      • The Architect Room
      • Elastic Delivery
      • Jump Programs
        • Analytics Engine
        • The Avalanche Initiative
        • The Glimpse Initiative
      • Implementations
      • Accelerators
        • ETL Converter
      • Support
    • Community
      • Blog
      • Events
      • Red Pill Library

    Recent Posts

    • Congratulations to our Oracle ACE Director, Deiby Gómez!
    • Snowpark’s Main Features and its Support for Python
    • Securing your Data in Snowflake with Row Level Access and Multiple Conditions
    • Taking in the View at the Data Lakehouse
    • Configuring Row Access and Column Masking Policies on the Same Column in Snowflake

    Tags

    How to get BI with Excel

    September 30, 2016

    |

    by: GregSuk

    |

    Categories: Analytics, BICS, Business Intelligence, Cloud, Coding, Data Visualization, Excel, Oracle, Tips, VBA

    How to get BI with Excel

    I know it sounds like I am writing about 1980s technology, and I am, but the fact remains that Excel is still a widely used tool in the business world. Besides, what else would you put your data dumps into? Often Excel reports get used for management reporting, which comes with a number of issues. […]

    Preparing Excel Data For Analysis

    September 28, 2016

    |

    by: GregSuk

    |

    Categories: Big Data, Business Intelligence, Excel, Red Pill Analytics' Tips, Tips, VBA

    Preparing Excel Data For Analysis

    Whether you are using Excel as a data source for your Business Intelligence (BI) platform, or you are doing the actual analysis within Excel, your data will need to be in a format that is queryable. Often though, the data is formatted to be read visually, whether an export from a system, or manually entered. […]

    About Red Pill Analytics


    Red Pill Analytics combines the best elements of cloud, agile development-as-a-service, and continuous delivery to form a unique analytics services company. We continuously evaluate, modernize, and automate to deliver a more valuable, less expensive model.

    Latest Tweets


    Tweets by RedPillA

    Latest Posts


    • Congratulations to our Oracle ACE Director, Deiby Gómez!
    • Snowpark’s Main Features and its Support for Python
    • Securing your Data in Snowflake with Row Level Access and Multiple Conditions
    • Taking in the View at the Data Lakehouse
    • Configuring Row Access and Column Masking Policies on the Same Column in Snowflake

    Contact Us