About Kromer Big Data

I’ve been focused on business customer solutions in business intelligence, Big Data and data warehouse designs for the past 20 years. In this blog, we’ll focus on Big Data Analtyics. My hope is that everyone will benefit from these discussions and through our community. Enjoy! Best, Mark Kromer http://www.linkedin.com/in/markkromer


2 Responses to “About Kromer Big Data”

  1. sujit basu November 24, 2014 at 10:25 am #

    Hi Mark,

    Recently came across some of your blogs on converting SSAS AdventureWorks model to Mondrian. Great set of details.

    I recently started dabbling on Mondrian/Pentaho, and would like to explore – if you could share any converted Mondrian Schema (XML), for the Adventureworks SSAS model.

    I have been able to convert the database using SQLExpress to MySQL (my choice of database(, however I don’t have an immediate access to a SQL Server standard version, which I need to convert the schema using your command line utility.

    Even an incomplete/starting model would be great. I’m trying to setup a POC on how to work with Mondrian/Pentaho replacing existing SSAS capability.

    Will look forward to hear from you.


    – Sujit

    • kromerbigdata November 25, 2014 at 12:10 pm #

      Hi Sujit – If you have the AdventureWorks DW database converted to MySQL, then the easiest way to get started using Mondrian for OLAP analysis is to auto-generate a new Mondrian model using Pentaho Analytics.

      Download the Pentaho 5.2 BA Suite and use the Data Source Wizard to auto-generate a new model from your MySQL database. You can look up the instructions for doing this at http://help.pentaho.com or try one of my tutorials here or here.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Microsoft SQL/BI and other bits and pieces


Current & Breaking News | National & World Updates

Tech Ramblings

My Thoughts on Software

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Insight Extractor - Blog

Paras Doshi's Blog on Analytics, Data Science & Business Intelligence.

The SQL Herald

Databases et al...

Chris Webb's BI Blog

Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI

Bill on BI

Info about Business Analytics and Pentaho

Big Data Analytics

Occasional observations from a vet of many database, Big Data and BI battles

Blog Home for MSSQLDUDE

The life of a data geek

%d bloggers like this: